Q&A BY TAG 'delegate'

You must sign in to ask a question. If you do not have an account, you can register here

Convert CSV into rows without the use of SPLIT function
answered 07-01-2021 02:08:55 -0500

Hi experts, Looking for alternative ways of converting comma separated values into rows without using the SPLIT/FLATTEN function as we want to delegate this completely to an oracle source. Please let me know if any ideas. Thanks.

Answers: 1

Delegate FLATTEN Split

Base view records deletion
answered 24-02-2020 04:58:03 -0500

We have two base views base view 1 : temp_del Name , age base view 2 : temp_del_2 Name , age I want to delete some records in base view 2 (MSSQL) using the below query. delete from temp_del_2 where name not in (select name from temp_del) It res...

Answers: 1

Delegate deletion

row_number not working with the get_view_columns
answered 14-02-2020 21:44:17 -0500

Hello Denodo gurus! Why does row_number not work with the get_view_columns? select database_name, view_name, column_name as denodo_column_name, ROW_NUMBER() OVER ( PARTITION BY view_name ORDER BY database_name ) row_number_with_partition from get_vi...

Answers: 1

row number Delegate get_view_columns

Query not getting delegated to hive
answered 28-05-2019 20:20:33 -0400

Hi, We have a report view that is run monthly and is critical from the end user perspective. This view is cached on a regular schedule. When we run the view in vdp and it does not have any functions like current date() or get quarter(), I see that the...

Answers: 1

Function Query Delegate

NEST() aggregation function ERROR when (Snowflake) source configuration has "Delegate aggregate functions list" checkbox is "unchecked"
answered 24-01-2019 14:33:34 -0500

Dear Denodo Support Team, I am encountering below error while delegating the aggregate functions setting is unchecked. Error: Finished with error: Error executing query. Total time 0.117 seconds. QUERY [VIRTUAL] [ERROR] QUERY [JDBC WRAPPER] ...

Answers: 1

Denodo 6.0 Delegate nesting delegation data aggregation

Function LASTDAYOFMONTH not delegated to Teradata
answered 22-01-2019 06:26:53 -0500

Hallo Denodo Team, Investigating the reasons why a query is not delegated to the Teradata data source, we have read this explanation: The function 'lastdayofmonth' cannot be delegated to this database Teradata has a corresponding function, namely LA...

Answers: 2

delegate lastdayofmonth teradata delegation

Denodo functions that are not delegated to source
answered 09-08-2017 09:09:45 -0400

Hi team! Is there a list of those functions/queries/process that are not pushed down to the source? I mean like sub selects, truncates, casts, etc. We need a detailed list of that stuff in order to optimize our views. Thanks in advance! EDIT: The s...

Answers: 1

Function Delegate

Delegate LIMIT to Spark through JDBC
answered 17-05-2016 15:34:45 -0400

Hi, We use denodo on top of Spark through JDBC. We have some derived views built on top of some big tables. We would like to limit the number of records a user can query based off of this view automatically rather than user specifying LIMIT clause. ...

Answers: 1

Delegate JDBC Spark