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
user
06-03-2021 06:44:15 -0500

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
You must sign in to add an answer. If you do not have an account, you can register here