It is failing with an error that is not very descriptive when a query like SELECT * FROM sys_connection_hierarchy is executed in Python
The same query works fine in JDBC. Can you please advise?
Best answer by Ethem Q
View original
Userlevel 3
This system table is an internal CData table and there is not much information available for this to the public. That said, is there a reason why you need to query the sys_connection_hierarchy system table? Are you using it for retrieving connection information? If that is what you are looking for, note that you can also make use of the sys_connection_props table.
On a side note, a similar issue is reproducible on our end so a ticket has been opened with the development team. Thank you for reporting this.
You will be notified as soon as there is an update.
Userlevel 3
The engineering team has implemented a fix for the issue that was reported here.
If you want to get an updated version of the Python Connector for GoogleDrive with the hotfix feel free to reach our support team out at support@cdata.com or submit a support ticket here https://www.cdata.com/support/submit.aspx
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Data Connectors
ETL/ ELT Solutions
Cloud & API Connectivity
OEM & Custom Drivers