Latest Activity

code

python cur.execute result is not the same as the query result from VDP

Hi team, I used jdbc connect VDP on linux server, I am execute below query in my python script: select * from view_a limit 3; Its result is below: [('2021-03-27', '1970-01-19 10:39:21.600000', '', 'EF\x01\x01', None, None, None, None, None, None, None,...

python VDP cur.result not correct

code

GetSession not working outside of the VDP

I had the following script and then various views based off this script working in the VDP but then when I tried to run a dervied view from a tool like DBeaver everything is coming up blank because the GETSESSION function is not returning a value. Is...

select query vdp getsession dbeaver

code

query return different value in VDP and python script connect denodo via JDBC driver

Hi Team, I ran below two command in VDP and python script (via JDBC driver), thry show different value, why? I want to have the python script running have the same return result as the VDP return result. DESC VIEW view_1 VDP result: include name, expre...

python VDP return result different

code

How to convert a date in string format to interval date

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,

Date Conversion VDP DENODO

code

Plans for "insert into select"?

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...

vdp select

code

Denodo VDP Client software version compatibility (version 6.0 20180216) inquiry for VDP server 7.0

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...

VDP VDP 7.0 VDP client

code

Connecting to Denodo on AWS using VDP Error

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...

VDP

code

Can we build/deletion DV objects in VDP through access the RestFul API?

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

VDP build views RestFul API

code

Query impala not working when run over VQL vdp client.

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=...

vdp impala

code

Create a view using 'List Roles;' Denodo Virtual DataPort datasource

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...

VDP Roles