Q&A BY TAG 'vdp'

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

Number formatting - equivalent to to_char?
answered 12-05-2021 05:12:49 -0400

I need to format a number as 9,999.00 (ex: 2,324.22). In Oracle I would use the to_char function. Do you have any built-in functions that would do anything similar?

Answers: 3

VDp mask

VDP v7 Not able to pull from Gitlab
answered 15-04-2021 08:27:33 -0400

Hi - when pulling the latest code from remote, it succedes. We can see the correct files on the Denodo server. But when pulling inside the VDP client, not all changes appear, but no error is reported. We are running version v7.0.2x We can also push...

Answers: 1

VDP GIT

python cur.execute result is not the same as the query result from VDP
answered 29-03-2021 08:20:44 -0400

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

Answers: 1

python VDP cur.result not correct

GetSession not working outside of the VDP
answered 11-03-2021 07:55:36 -0500

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

Answers: 1

select query vdp getsession dbeaver

query return different value in VDP and python script connect denodo via JDBC driver
answered 08-03-2021 07:10:09 -0500

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

Answers: 1

python VDP return result different

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