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]

Support Questions

Find answers, ask questions, and share your expertise
Announcements
Share your experience with Cloudera on G2 and get a $25 Amazon Gift card.
Hi, I'm CLEO! Something exciting is coming to the Community. Stay Tuned!

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.