Q&A

Programmatic IN Operator
answered 13-10-2020 08:36:09 -0400

I am trying to pass in a set of selection criteria for an IN operator but I can't seem to find any way for Denodo to accept it. Example: User enters A,B,C into a text box, and I would like to have that become SELECT * FROM <view> WHERE <column...

Answers: 1

VC++2013 redistributable dependency
answered 13-10-2020 06:53:08 -0400

Hi there, We've noticed that ODBC connectivity with Denodo's ODBC driver is dependant on an older PostGres driver which in turn requires the VC++ 2013 redistributable. As this isn't supported on Windows Server 2016, are there plans for this to be upgr...

Answers: 1

ODBC support Windows Server 2016

Denodo AWS Free-Trial BYOL
answered 12-10-2020 21:26:51 -0400

Is is possible to automate the process of initiating an EC2 instance of Denodo Free-Trial BYOL ? May be using ansible? I'm kind of new so I'm not certain where and how to start with. Any help is appreciated.

Answers: 2

free-trial

Denodo Platform license file
answered 11-10-2020 22:58:54 -0400

Hello there, I'm new to Denodo and I'm trying out the free-trial. https://community.denodo.com/docs/html/document/7.0/Denodo%20Platform%20for%20AWS%207.0%20Free%20Trial%20BYOL%20Quick%20Start%20Guide Four Step instructions: -Register for Denodo Platfo...

Answers: 2

free-trial

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