Q&A

to_date function from denodo cannot be delegated to HIVE
answered 09-10-2020 19:21:03 -0400

Hi, I am getting warning as to_date cannot be delegated while trying to find the difference between two dates in denodo with source as HIVE The logic I have used in denodo as: getdaysbetween(to_date('yyyy-MM-dd', table1.start_dt), to_date('yyyy-MM-dd...

Answers: 3

Denodo and Hive

Poor performance for jdbc and json array type join
answered 09-10-2020 08:19:14 -0400

Hi, I observered a poor performance for a join between a jdbc type view and json array. individually when queried they are running fast but when we do a join it's performance degrades. Can you suggest how to improve performance ? Also i see 347 subp...

Answers: 1

performance JSON join

Open Denodo Data Catalog using Internet
answered 08-10-2020 05:54:41 -0400

Please let me know which firewall port need to be opened to access Denodo Data Catalog via internet

Answers: 1

#PORTS

Incremental cache for deleted rows
answered 07-10-2020 08:29:44 -0400

Hello, the following link https://community.denodo.com/docs/html/document/denodoconnects/7.0/Denodo%20Incremental%20Cache%20Load%20Stored%20Procedure%20-%20User%20Manual specifies that Notice that this Stored Procedure can only be used with views where...

Answers: 1

Cache

Properties of ODBC driver
answered 06-10-2020 08:28:10 -0400

We are developing a project where we have to connect to our Denodo server from a Python script. We basically load the ODBC driver dynamically, connect to the server and then send the query. Very standard process. Here is the snippent of code where we d...

Answers: 1

C# ODBC Python

XSLT Mapper tool
answered 06-10-2020 08:26:02 -0400

Hello, I want to use XSLT mapper for my api that is returing data. Do that require a valid contract to use XSLT mapper I cant even see a proper installation guide on the help page. One of the question was answered and it said to go on support site ...

Answers: 1

XML XSLT XSLT MApper

Select Distinct records based on a particular value in another column
answered 06-10-2020 08:23:23 -0400

I have a result of employees with "employee id" that has duplicates. I have another column called "leader level" i want to keep unique records of the employee id that has the lowest value of leader level (i.e. if the same employee id is in row 1 and 2 ...

Answers: 1

Distinct order by

How can I execute VQL in a text file on Job Sucheduler?
answered 05-10-2020 08:41:08 -0400

I want to execute DML that changes from time to time for a view. Is it possible to place the created a text file(VQL) on the Server and execute it on the scheduler?

Answers: 1

Exception parsing near query 'CREATE'
answered 05-10-2020 08:34:32 -0400

While I am creating the remote table for the ms sql server 2016, I copies the vql query of my dataset and paste in the VQL Query space in remote table option, but it is showing error . I am using Denodo 7.0 express version. Kindly get me through it as ...

Answers: 3

Syntax error

Different Denodo versions
answered 05-10-2020 08:31:44 -0400

Hi, Is it possible to have different versions of Denodo (e.g. version 7 & version 8) running on the same machine? They don't have to be running simultaneously. With kind regards, Phil

Answers: 2

Denodo Installation