Advertisements
Home > Data Visualization, Denodo > Denodo useful Developer Commands/Info

Denodo useful Developer Commands/Info

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.

  1. DESC VQL VIEW

Use it to get fields names and its data types

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

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

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: