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?
Solved
Python connector for google drive errors out when selecting from one of the system tables
Best answer by Ethem Q
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 [email protected] or submit a support ticket here https://www.cdata.com/support/submit.aspx
This topic has been closed for replies.
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.
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 [email protected] or submit a support ticket here https://www.cdata.com/support/submit.aspx
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
