Q&A

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

QUERY [VIRTUAL] [ERROR] when i group by some columns in the baseview.
answered 14-10-2020 06:31:32 -0400

I am getting QUERY [VIRTUAL] [ERROR] when i group by some columns in the baseview. Please let me know why do i face the issue only when adding some specific columns. At times this error occurs even for all the column.

Answers: 1

#VirtualError #Groupby #projectionError

Snowflake connection - change warehouse based on e.g. a particular role
answered 13-10-2020 09:04:54 -0400

Hi, With Snowflake as our backend, we keep track of the compute consumption per departement. Users are assigned a "department role" and each departement role uses a dedicated warehouse. How can I do something similar in Denodo? I want to give users acc...

Answers: 3

snowflake

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