topic Re: Unable to get data from HIVE Table QVX_UNEXPECTED_END_OF_DATA in Connectivity & Data Prep

Unable to get data from HIVE Table QVX_UNEXPECTED_END_OF_DATA

abeer786 — Tue, 16 Apr 2024 08:10:16 GMT

I'm getting below error while trying to read data from a HIVE table

20240415T105556.712-0500 Error: QVX_UNEXPECTED_END_OF_DATA: SQL##f - SqlState: 08S01, ErrorCode: 115, ErrorMsg: [Microsoft][Hardy] (115) Connection failed with error: SSL_read: error code: 0

I'm getting this error only while fetching data from a particular table, for rest of the other tables it works fine with same connection.

Can anybody give any pointers to how to debug this? I ran the same query via Hue SQL interface which HIVE provides, the query works fine and I'm able to export whole dataset

Re: Unable to get data from HIVE Table QVX_UNEXPECTED_END_OF_DATA

Mario_De_Felipe — Wed, 24 Apr 2024 06:10:31 GMT

Have you tried using an ODBC connector? I use this: https://www.cloudera.com/downloads/connectors/hive/odbc/2-6-1.html

Re: Unable to get data from HIVE Table QVX_UNEXPECTED_END_OF_DATA

VesaLukka — Wed, 24 Apr 2024 10:22:05 GMT

I think problem is in database. Does the error happen in beginning of reading or in same row each time? I would try to find out the row where error happens. Try to read only few rows at time (like 10 or so).

You probably need to contact database admin and ask to fix the issue.

Re: Unable to get data from HIVE Table QVX_UNEXPECTED_END_OF_DATA

abeer786 — Wed, 24 Apr 2024 10:48:30 GMT

Hey @Mario_De_Felipe Thanks so much for replying. Anyway it was determined the table itself has some performance issues as it has too many partitions in it. When we created a copy of table with single partition it is able to reload fine.