Q&A BY TAG 'VDP'
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
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
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
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
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
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
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
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
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
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