Q&A

Listagg distinct
answered 20-05-2021 13:37:54 -0400

Hi, Denodo 8.0 supports listagg function, but can distinct clause can be used inside the listagg?

Answers: 1

Listagg

Querying a Rest API through post request with application/x-www-form-urlencoded content-type
answered 20-05-2021 08:42:33 -0400

Hello, I need to connect to a REST API whit a POST requests which returns a json file. In this Post request, I need to put in the body, that must be an application/x-www-form-urlencoded content-type, two parameters. So I created a Json data source c...

Answers: 3

Denodo to Azure Data Lake Gen2
answered 20-05-2021 08:10:40 -0400

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...

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

Custom Data Sources

Collate functionality with Like operator
answered 20-05-2021 07:21:40 -0400

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...

Answers: 1

snowflake denodo like operator collate with like

I think that "doubledecimalseparator=2" is an error
answered 20-05-2021 01:50:56 -0400

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

Answers: 1
Related to: Custom internationalization configuration for Denodo Scheduler

Regex Pattern Not Working Consistently
answered 19-05-2021 16:45:45 -0400

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...

Answers: 1

create a view that only shows user access and query activity from the logs
answered 19-05-2021 07:59:50 -0400

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?

Answers: 1

view document query logs id logs

Trying to create base view with Union All query but getting "The statement did not return a result set."
answered 18-05-2021 19:31:28 -0400

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...

Answers: 1

How to connect DeltaLake Tables from Denodo when cluster is down
answered 18-05-2021 17:42:41 -0400

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 ...

Answers: 1

deltalake databricks

TO_TIME Convert
answered 18-05-2021 12:50:13 -0400

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

Answers: 1