Denodo | Big Data, Data Analytics and Data Science

Denodo useful Developer Commands/Info

July 28, 2017 Umesh M Patil Leave a comment

In this area I will be posting Denodo useful commands/tricks. Below are few,

context (‘querytimeout’ = )

Example:

context ('querytimeout' = '10800000')

Use above syntax at the end of SELECT statement to avoid default timeout which happens usually after 15 minutes.

DESC VQL VIEW

Use it to get fields names and its data types

MAP (,’$.Parent1.ChildElementName’)

Useful in SELECT or WHERE clause to get info from JSON column

Use CTE’s or TEMP tables for intermediate data processing
Escape character in Denodo is $. Useful when we search data with functions with REGEX
Denodo Documentation: Select appropriate version. http://help.denodo.com/platform-docs/5.5/
Support.Denodo.com : For Denodo customers to create case/ticket for questions/issues.
DBeaver : I like this client tool because you will get to open multiple query windows and in each window you can run multiple commands at same time.

Categories: Data Visualization, Denodo Tags: Data Visualization, Denodo

avoid time-out for Denodo ADO Net Source in SSIS

July 18, 2017 Umesh M Patil Leave a comment

In SSIS, I was executing sql command in ADO Net Source of one of the Data Flow and was getting Time-out error after approximately 15 minutes. I used below clause after select statement.

context (‘querytimeout’ = ‘9000000’)

Here time is in milliseconds (in our case, ‘9000000’ is approx 2.5 hr).

For more info read “CONTEXT CLAUSE” in Denodo documentation in “Advanced VQL Guide”