Q&A BY TAG 'VDP'

You must sign in to ask a question. If you do not have an account, you can register here

How to convert a date in string format to interval date
answered 18-01-2021 05:54:50 -0500

Hi community I need to convert a date in string format to interval. Does anyone knows how ? Example : I need to convert this '1974873205059' to interval Thank you,

Answers: 1

Date Conversion VDP DENODO

Plans for "insert into select"?
answered 06-01-2021 15:06:08 -0500

Just curious if you have plans to evaluate and implement the "insert into select" syntax that is standard on all RDBMS platforms these days? Often the insert into values() syntax is not enough since you need to select from another table. The above sy...

Answers: 5

vdp select

Denodo VDP Client software version compatibility (version 6.0 20180216) inquiry for VDP server 7.0
answered 23-11-2020 04:12:13 -0500

I would like to know the client software version compatibility of Denodo VDP server version 6.0 20180216. I would like to upgrade my local Denodo VDP client of version 6.0 20180216 up to 7.0 in order to obtain advanced feature in data catalog (meta da...

Answers: 1

VDP VDP 7.0 VDP client

Connecting to Denodo on AWS using VDP Error
answered 11-11-2020 04:47:36 -0500

Trying to connect to Denodo data platform server which was launched using marketplace AMI in AWS, trying to connect to that server using the passwd as 'instance id' and server URL //public-up-of-server:9999/admin Getting the following error: Could n...

Answers: 1

VDP

Can we build/deletion DV objects in VDP through access the RestFul API?
answered 24-09-2020 06:34:23 -0400

Hi team, Do we have ways to created DV base views, derived views, delete existing views in VDP side through access REST API?

Answers: 3

VDP build views RestFul API

Query impala not working when run over VQL vdp client.
answered 14-09-2020 07:54:58 -0400

i have query VQL like this: select nmtkp, FORMATDATE('yyyyMM',cast(tglapprove as timestamp)) as blnlApprove, COUNT(distinct(sku)) as JlhBarang,SUM(price) as HargaTotal from dbmart.facttrans a where GETYEAR(cast(tgltrans as date))=2020 and jnsklaimreg=...

Answers: 2

vdp impala

Create a view using 'List Roles;' Denodo Virtual DataPort datasource
answered 19-06-2020 07:16:36 -0400

Created new JDBC type data source and select Denodo Virtual DataPort as the Database adaptor. I was trying to create a view using 'List Roles;' using ‘Create from query’ but got the following error when executing the view. Finished with error: Error...

Answers: 3

VDP Roles

How to get data from different sources, without errors.
answered 16-06-2020 02:32:27 -0400

I have an selected view that uses like input an excel file, and I have another selected view that uses a CSV file like input. I want to have an union with those selected views, but if one file is missing I get an error. How can I avoid this error? I...

Answers: 4

VDP Denodo view

test connection but not able to connect successfully
answered 19-05-2020 06:28:18 -0400

after the setup of denodo express, I tried to connect to JDBC but always gets connection issue what should the login credentials be? Is this the sql server access credential

Answers: 1

vdp Denodo Express

View statistics questions
answered 06-02-2020 00:08:36 -0500

I recently inherited Denodo admin duties and am investigating a scheduled job which is failing. The job gathers a list of all base tables in Denodo, then runs the following VQL: CALL GENERATE_SMART_STATS_FOR_FIELDS('SMART_THEN_ATSOURCE_THROUGH_VDP','B...

Answers: 5

generate_stats search methods VDP resultset Statistics timeout