Q&A

Denodo time issue
answered 02-06-2021 14:54:56 -0400

Hi ALL, i am facing one issue , in one of the postgres table , i have data in datetime , when i am creating Base view and accesing data , the date is showing as '1970-01-01 12:11:11.000' but the date present in soure is '2020-01-01 10:11:00' Any help...

Answers: 1

Installation of Denedo platform on Local laptop
answered 02-06-2021 04:58:11 -0400

HI Denedo SME, I need help in installing Denedo platform on on premise / Local computer . (windows 64 bit ) machine. 1) I have laptop with windows64 bit , and 8 GB ram . 2) What are the Denedo tools / platform are required to installed on local com...

Answers: 1

Denodo Installation

Incorrect script generated by DESC for i18
answered 02-06-2021 03:04:59 -0400

-- doubledecimalseparator should be '.' instead of '' DESC VQL MAP i18n us_pst Generated with Denodo Platform 8.0. DROP MAP i18n IF EXISTS us_pst CASCADE; CREATE MAP i18n us_pst ( 'country' = 'US' 'datepattern' = 'MMM d, yyyy h:mm:ss a' 'datesubtype...

Answers: 1
Related to: Number of decimal places using i18n map

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