02-20-2017 02:04 AM
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?
02-21-2017 12:38 AM
02-22-2017 01:52 AM
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