Q&A

How to read field value from an array using VQL without flattening it.
answered 01-06-2021 20:24:58 -0400

Hi, I want to write a VQL to get any field value from an array without flattening it. How i can do it? I know how to get a field value from register. example for register: SELECT (REGISTER_NAME).FIELD_NAME from VIEW_NAME If there is a way get field ...

Answers: 1

VQL to show all cached sources and when it was last refreshed?
answered 01-06-2021 17:37:03 -0400

Is there a way to get a result set that has the view, number of rows and the last cache refresh date? I want to make this a data set availbe easily to end-users to see when the cache was last updated. I have scoured the user documentation but do not ...

Answers: 1

vql query LASTCACHEREFRESH Cache

MEDIAN gives an error
answered 01-06-2021 15:28:15 -0400

While calculating median. I am receiving the following error. [GROUPBY] [ERROR] java.lang.reflect.InvocationTargetException Received exception with message 'java.lang.reflect.InvocationTargetException' The logs are as follows: *ERROR 2021-05-31T09:38...

Answers: 1

Denodo 8.0 Error data aggregation

Error calculating the capacity
answered 01-06-2021 13:27:39 -0400

Good morning, Using Denodo express to test out several possibilities for generating base views for an IBM i we are looking at generating the VQL for parts of the base view and replacing those particular portions in the Denodo generating base view. Thi...

Answers: 4

VQL Base view

Connect timeout server returned: null
answered 01-06-2021 07:40:10 -0400

Hi Community, I try to create the data source from Google cloud through OAuth Credentials. At the final step, While obtaining the OAuth 2.0 Credential, I get the connection time out error. Default value is 120000 msec. I attempted with 200000 and 3...

Answers: 1

#Source Data google cloud storage Web Service OAuth 2.0 Refresh Token

JSON HTTP Client
answered 01-06-2021 05:28:36 -0400

I have tested a call with a cursor url parameter in Postman without any issues. But, when I add the cursor url in Denodo, I receive an error. URL: https://api.mypurecloud.com/api/v2/analytics/conversations/details/jobs/##################/results?curso...

Answers: 5

JSON Data Source API HTTP client

AWS EC2 / Azure VM charges for Denedo in cloud platform
answered 01-06-2021 05:18:58 -0400

Hi Denedo team, 1) As Denedo platform (solution manager , vdp client ) required on cloud env (AWS or Azure) , what are the instance / virtual charges 2) Does Denedo support team provides any help to installed Denedo Platform/software on Amazon EC2 ...

Answers: 1

Price

Custom wrapper results
answered 01-06-2021 05:16:20 -0400

Hi Team, I have developed a custom wrapper created data source and base view on that custom wrapper. When I execute the query previous query results are also appending to next query results. Cache mode is also off. What can be the issue here.

Answers: 1

custom wrapper

Does Denodo supports Data presentation through charts and reports
answered 01-06-2021 04:30:56 -0400

Hi, Am doing POC on Denodo express. Just worried if Denodo supports a graphical presentation though graphs or charts, filtering etc on Data Catalogs? I am comparing the features with Kibana (from ELK stack) where it does virtualization as well as prese...

Answers: 3

presentation VDPs' Reports chart

case insensitive for querying view purpose
answered 01-06-2021 03:49:41 -0400

Hi Team, Can Denodo support this function, to make the view name case insensitive, eg. I have one exact view like : DERIVED_VIEW_A, and when query the view, I may write the query like: select from "derived_view_a", or select from "Derived_View_a", an...

Answers: 1

view name query case insensitive