Latest Activity

code

Denodo to Azure Data Lake Gen2

Hi team, I am trying to connect Denodo 7.0 to connect with Azure Data Lake through Custom wrapper. I am trying to connect using shared key authentication method. So I have saved the key in core-site.xml file. the format is like Shared Key: using the s...

Related to: How to connect to Azure Data Lake Storage from Denodo Platform

code

Collate functionality with Like operator

As denodo does not have collate functionality, i have written a custom function that delegates collate to snowflake server and I am trying to use like operator in denodo vdp client with collate as shown below, SELECT * FROM <myview> where colla...

code

I think that "doubledecimalseparator=2" is an error

I think that "doubledecimalseparator=2" is an error, isn't it ? Something like doubledecimalseparator='.' sounds better, no ?

Related to: Custom internationalization configuration for Denodo Scheduler

code

Regex Pattern Not Working Consistently

Hi, I need your help -- i am so confused at the behavior of regexp. As you can see in the 1st image below, the regexp works in that the numbers are getting comma separated. But when i used the same regex patter on the second image, it just fails. Woul...

code

create a view that only shows user access and query activity from the logs

I am working with a data source that someone set up that is tapping into the vdp logs. is there a way to filter for only records in that data source that show who, what and when a particular data source/view was accessed?

code

Trying to create base view with Union All query but getting "The statement did not return a result set."

Hi, Trying to create a baseview from the below query and I'm getting the following error message: Error executing sentence: com.denodo.util.exceptions.InternalErrorException: The statement did not return a result set. -- data 1 SELECT L...

code

How to connect DeltaLake Tables from Denodo when cluster is down

I need help on Denodo connector to DeltaLake of DataBricks. I am using Simba Connector and able to connect Tables in DeltaLake. But when my DataBricks (cluster) goes down my VSQL query fails to access. So, It always need to start the cluster. which is ...

code

TO_TIME Convert

Hi, How i convert in VDP DENODO 7 a decimal to time? Thanks

code

Idocs Getting Missed through Listener

Hello, We are using listener to consume the idocs. The volume in cache is approximately 60K Idocs. Sometimes, some of the idocs are getting dropped while consuming. Please let us know what is the issue behind this?

code

Error retrieving data from csv file using SFTP

Hi, I am getting below exception while retrieving data from csv file using SFTP. I got partial results. out of 30 csv files ... got partial results from 5 files. can you please help me on this? Incomplete results Incomplete results Incomplete results ...