Hi, I am trying to execute a query using an ODBC connection to Hive within R (using the RODBC library). My connection to Hive seems to work fine, I have followed the instructions as mentioned in the ODBC driver installation documents. I also know it works fine because I have executed the following queries successfully:
– show tables
– describe table1
– select * from table1
The problem occurs when I try to retrieve a specific column from the table. In other words the query “select col1 from table1″ fails with the following error:
HY000 35 [Hortonworks][Hardy] (35) Error from Hive: error code: ‘1’ error message: ‘Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask’.”
 “[RODBC] ERROR: Could not SQLExecDirect ‘SELECT col1 FROM table1 LIMIT 10’
Now I’m not sure if the problem lies with Hive, the ODBC driver or with R. Any thoughts?