Cloudera Community
wooo
user rank
New Contributor
My Accepted Solutions
Show All

Re: Hive - ODBC driver - Error_State when querying...

by New Contributor in Support Questions
‎02-22-2017 01:52 AM
‎02-22-2017 01:52 AM
Hi,   Thanks for your answer. Yes, that is what I'm thinking. I have used the hdfs and hive users.   Since that time, I have solved the problem by executing the commands below (from the top of https://www.cloudera.com/documentation/enterprise/5-6-x/topics/sg_sentry_service_config.html) :   $ sudo -u hdfs hdfs dfs -chmod -R 777 /user/hive/warehouse $ sudo -u hdfs hdfs dfs -chown -R hive:hive /user/hive/warehouse ... View more

Hive - ODBC driver - Error_State when querying wit...

by New Contributor in Support Questions
‎02-20-2017 02:04 AM
‎02-20-2017 02:04 AM
Hi,   I'm working on the cloudera quickstart docker et have the hive odbc installed (version 2.5.21) with unixodbc (version 2.3.4).   I can perfom queries like : select a from my_table; select a from my_table where true;   However when I try to execute queries like select a from my_table where b=value; I get the following error   [Cloudera][Hardy] (35) Error from server: error code: '0' error message: 'ExecuteStatement finished with operation state: ERROR_STATE'      Any ideas on what the problem could be?   Regards   ... View more
Labels:
Contact Me
Community Statistics
Member Since ‎02-20-2017 01:47 AM
Last Visited
Posts 2