Support Questions

Find answers, ask questions, and share your expertise

Hive ODBC Driver issue

avatar
Explorer

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.

12 REPLIES 12

avatar
Master Collaborator

@AlexDriver could you share the ODBC driver version you are using, so that we can test this?

avatar
Explorer

2.7.0

avatar
Master Collaborator

@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.