You can translate the question and the replies:

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, None, ' ', ' ', ' ', ' ', ' ', ' ', 'USD', 'JPY', ' ', ' ', ' ', ' ', '415673392', '1840839309', '3863315.13546168502253822203633997862354', '17108967.04307820995399414470932664157256', '', '', '', 'COMN', ' ', '415673392', 0, None, None, None, 14, None, None, None, None, None, None, None, None, None, None, None, None, None, None, '-319459847582', '20200701', ' ', 13, None), (None, None, None, None, None, None, None, None, None, None, None, None, None, ' ', ' ', None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None), (None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None)] but when I exe in VDP, there is no None in the VDP result, I confirm there is no non item in my db? Can I understand why the DV python result cannot show correctly. How can I make it? I need this process for some data validation which is automated by python. Thanks.
user
27-03-2021 08:15:21 -0400

1 Answer

Hi, I was able to query a view in the Virtual DataPort and display only the first 3 results using Python script successfully. Additionally, If I wish to see the way the query is being executed by the Virtual DataPort server, I would enable the **“vdp-requests.log”** file by executing the [LOGCONTROLLER](https://community.denodo.com/docs/html/browse/latest/en//vdp/vql/stored_procedures/predefined_stored_procedures/logcontroller) stored procedure in VQL Shell of the Virtual DataPort Administration Tool: `CALL LOGCONTROLLER('com.denodo.vdp.requests', 'INFO');` After configuring the logging level, you can check the **“vdp-requests.log”** located in the** “<DENODO_HOME>/logs/vdp”** folder to view all of the requests sent to Virtual DataPort server. Hope this helps!
Denodo Team
29-03-2021 08:20:44 -0400
You must sign in to add an answer. If you do not have an account, you can register here