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.