Q&A BY TAG 'Python'

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

Executing multiple queries separated by semicolon through python
answered 08-06-2022 00:13:05 -0400

Hi, Is there any way of executing multiple queries separated by semicolon through jdbc connection via python? Thanks, Aashutosh

Answers: 1

jdbc Python

Timestamp error when using Dask
answered 11-04-2022 09:14:30 -0400

Hi there, I am trying to use the python library dask to work on a large dataframe. Dask requires an index column to chunk or batch the data being pulled into memory and it's best practice to use an int or timestamp type field to split the data. When ...

Answers: 1

python dask timestamp

How to connect using JDBC driver in Python?
answered 08-03-2022 06:08:14 -0500

###Connection using JDBC import jaydebeapi hostname = 'server name' port = '####' driver = 'com.denodo.vdp.jdbc.Driver' user = '####' password = '#####' path = '/C:/Users/abc/Desktop/Projects/denodo-vdp-jdbcdriver.jar' url = 'jdbc:vdb://'+hostname+':'+...

Answers: 6

Access Denodo #Denodo Access Denodo Express Python

How to Use python to Call solution Manager APJ to deploy Revision
answered 06-01-2022 03:58:09 -0500

Hi team, We try to use python to call solution manager API to deploy revision, we now have prepare the vql revision file done, can we use python to call the solution manager API to do the deployment?

Answers: 1

Solution Manager API Deploy Python revision

How to fetch execution time for Denodo query by python
answered 16-06-2021 08:24:13 -0400

Hi team, Do we have some way about how to fetch execution time for Denodo query by python script? Or do we have some pre-defined store procedure can be used for this property, we have the requirement to auto-collect the query running time. Thanks.

Answers: 1

Denodo python query execution time

Denodo dialect for python
answered 28-04-2021 11:54:21 -0400

Hi, I downloaded the denodo dialect for python connexion to use with sqlAlchemy on the support site. (Denodo Dialect for SQLAlchemy). I tried to add the dialect like I was told in this article : https://community.denodo.com/docs/html/document/denodoco...

Answers: 3

python dialect

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

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

VQL Parser for Python
answered 19-02-2021 07:17:32 -0500

Hi, I would like to parse a VQL in Python in order to retrieve all elements of a VQL in a correct AST. Could you please tell me if such kind of parser already exists or if there is a way to get the VQL grammar somewhere ? I already found some fragment...

Answers: 3

VQL parsing Python

How to connect denodo from airflow
answered 28-12-2020 06:50:53 -0500

I would like to connect to denodo views to read the created views from airflow. Pls advice

Answers: 1

DENODO JDBC Python