Error from Hive: '403' Message: 'Error while processing statement: null'
I have created a table in Hive and loaded it with data.
Whenever I try to get data from the table via ODBC I get the following error:
“Open Database Connectivity (ODBC) error occurred. state: ‘HY000′. Native Error Code: 35. [Hortonworks][Hardy] (35) Error from Hive: error code: ‘403’ error message: ‘Error while processing statement: null’.”
The table has four columns:
type – string
date – string
entries – int
value – string
When checking for null values in Hive, nothing is returned.
– SELECT COUNT(*) FROM tablename WHERE type IS NULL;
– SELECT COUNT(*) FROM tablename WHERE date IS NULL;
– SELECT COUNT(*) FROM tablename WHERE entries IS NULL;
– SELECT COUNT(*) FROM tablename WHERE value IS NULL;
All queries returns “0”, so zero NULL values here.
I can do SELECT statements via command line directly in Hive without any problems (SELECT * FROM tablename;).
But as soon as I’m trying to access the data via the ODBC connector, the above happens.
The response I get comes almost instantly, which leads me to believe that it is an issue with the driver as the data in the table is 17GB, naturally this takes some time processing.
My setup is a cluster of three CentOS 6.4 nodes with HDP 1.3.2 in Hyper-V on Windows 8 Pro.
Any ideas what could be happening?