Q&A

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

multiple parallel branches of Selection plans
answered 08-03-2021 07:32:12 -0500

Hi Team, I am facing slow performance issue for 1 our interface. we are querying the interface with three columns in where clause where we passing values given below : select * from i_my_interface where col1 = '001' and col2 in (2,2,3,4,5,4,6,7,8,8,3...

Answers: 1

selection plan

query return different value in VDP and python script connect denodo via JDBC driver
answered 08-03-2021 07:10:09 -0500

Hi Team, I ran below two command in VDP and python script (via JDBC driver), thry show different value, why? I want to have the python script running have the same return result as the VDP return result. DESC VIEW view_1 VDP result: include name, expre...

Answers: 1

python VDP return result different

Issue while configuring Kerberos Authentication
answered 05-03-2021 08:06:16 -0500

Hi Team, We are in process of enabling Kerberos authentication at server level. We have created the global user, SPN and the Keytab file and enabled the Kerberos at the server level giving all the required details. When we restart the vdp server, it s...

Answers: 1

#kerberos #authentication

18 digit timestamp LDAP timestamp conversion
answered 05-03-2021 07:08:17 -0500

I have a timestamp field in the following 18 digit format from our LDAP 132332110839739771 Is there any easy way to convert this to a standard date format? based on converter online this is the value: Epoch/Unix time: 1588737483 GMT: Wednesday, Ma...

Answers: 1

chrome timestamp

Where Condition on Analytical Function Output
answered 05-03-2021 05:53:47 -0500

Denodo 6.0 20201123 I created a new field from the RANK analytical function in one of my datasets. In order to do so, I had to use the workaround of sending the data from a view down to a temporary table on a SQL server. This was because part of the d...

Answers: 3

condition Analytical RANK WHERE

Error while inserting data with bulk load activated on Oracle Data source
answered 05-03-2021 03:27:34 -0500

Hi, I’m making tests on data file load using Denodo Express 8.0 for Windows 64 bits. I have an Oracle instance running on the same computer. I run catldr.sql as sysdba on the Oracle database. I created a data source (dstrcr) and activated "Use Bulk D...

Answers: 3

Bulk Data Load Oracle

Apply update option not available
answered 05-03-2021 01:08:38 -0500

Hi, When I open Environments > Configuration, I cannot see the operations section as shown in the video. I only see 'Actions' where I can either diable the environment or open Diagnostic and monitoring tool. I am using the Denodo 8 solution manager...

Answers: 1
Related to: Automatic installation of Updates

Timestamp From 24 Hours Ago of Current Timestamp
answered 05-03-2021 00:47:13 -0500

Hello, I know that I can get the current timestamp using the currenttimestamp function. I wanted to know what is the right way to subtract 24 hours from the timestamp returned from that function, in order to find the timestamp of exactly 24 hours befo...

Answers: 1

local timestamp Date time function WHERE CONDITIONS timestamp

Virtual dataport
answered 05-03-2021 00:35:32 -0500

Virtual DataPort identifies the return structure of a web service containing polymorphic/recursive data types and anyType by the

Answers: 1

JDBC Data Sources
answered 04-03-2021 23:45:41 -0500

In JDBC data sources, when should you create a base view from query

Answers: 1