Big Data, Data Analytics and Data Science | BI-BIGDATA.com

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

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

2. DESC VQL VIEW

Use it to get fields names and its data types

3. MAP (,’$.Parent1.ChildElementName’)

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

4. Use CTE’s or TEMP tables for intermediate data processing
5. Escape character in Denodo is $. Useful when we search data with functions with REGEX
6. Denodo Documentation: Select appropriate version. http://help.denodo.com/platform-docs/5.5/
7. Support.Denodo.com : For Denodo customers to create case/ticket for questions/issues.
8. 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.