question Re: Hive - ODBC driver - Error_State when querying with condition in Archives of Support Questions (Read Only)

Hive - ODBC driver - Error_State when querying with condition

wooo — Fri, 16 Sep 2022 11:07:04 GMT

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

Re: Hive - ODBC driver - Error_State when querying with condition

mbigelow — Tue, 21 Feb 2017 08:38:51 GMT

Can you run this query in Hive w/o the driver?

I believe the first two queries do not require MR job(s) and it is possible for it to work w/o proper user setup.

The last query will require MR and that requires that the users exist.

What user are you on when using the ODBC driver? Does that user exist in the docker quickstart container?

Re: Hive - ODBC driver - Error_State when querying with condition

wooo — Wed, 22 Feb 2017 09:52:39 GMT

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