You can translate the question and the replies:

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, expression, fields, query method, and so on python retrun result: just have below things for each items: ('run_date', 'DATE', '91', None, None, None, False, False, False), ('reporting_date', 'TIMESTAMP', '93', '0', '0', None, False, False, False), ('entity_code', 'VARCHAR', '12', '5', None, '10', False, False, False), ... How to make the python can also return the exact vql for a view? seems above result just some datatype for a view, I want the vql in VDP (no need for dependency view vql, just this view's vql is enough for me). Thank you. Can you please reply it ASAP? thanks
VDP python return result different
user
06-03-2021 06:44:15 -0500
code

1 Answer

Hi, In general, **DESC** statements like **DESC VIEW** would return the information about the view in a tabular form when executed using an **external client tool**. As for getting the VQL generated while creating a view, I would use the following command in the **Virtual DataPort Administration Tool**: `DESC VQL VIEW <view_name>` Please refer to this similar community question [Python to run VQL](https://community.denodo.com/answers/question/details?questionId=9064u000000CeoxAAC&title=python+to+run+vql+shell+%28select+%2C+create+view%2C+desc+view%29) for more information. Hope this helps!
Denodo Team
08-03-2021 07:10:09 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here