Our Community is getting an upgrade! To get everything ready for the relaunch, we’ll be placing the site in read-only mode starting September 21st.
We really appreciate your understanding while we get things set up behind the scenes. Catch up on all the exciting details about the move here.
Need help or have questions? Drop us a line at [email protected]
Created 05-13-2025 11:45 AM
Dear Community,
I've faced with an issue when i try to send the following query to Apache Hive using ODBC driver:
"-- Request ID: 4b9a2e0a-e250-45b7-b9cc-0915f20f848f
SELECT *
FROM (-- Request ID: 4b9a2e0a-e250-45b7-b9cc-0915f20f848f
select version()) AS Subquery__9
LIMIT 1"
then i get an empty response.
However, if i remove the commented out fragments with Request Id and its uuid then it starts working as expected by returning the version.
What am i missing here or is it an ODBC driver bug?
PS: it's not reproducible when i do the same using JDBC.
Created 05-16-2025 11:25 AM
@AlexDriver could you share the ODBC driver version you are using, so that we can test this?
Created 05-19-2025 08:56 AM
2.7.0
Created 05-17-2025 04:34 PM
@AlexDriver I tried this with latest ODBC driver 2.8.2. Used it with pyodbc, and I can reproduce the issue.
The error I get is :
Traceback (most recent call last):
File "/hive/pyodbc_test.py", line 13, in <module>
for row in cursor.fetchall():
^^^^^^^^^^^^^^^^^
pyodbc.ProgrammingError: No results. Previous SQL was not a query.I have raised an enhancement request with the driver team.