question Re: Hive get exception when try to do insert/create operation in Archives of Support Questions (Read Only)

Hive get exception when try to do insert/create operation

luckyxu_ — Mon, 06 Aug 2018 15:17:18 GMT

I was upgrade the HDP to 3.0 and it is not finilized yet. When I try to run hive command, it get such message: 'while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask. Unable to alter table. java.lang.IllegalStateException: Invalid attempt to overwrite a read-only parameter: DB_NOTIFICATION_EVENT_ID_KEY_NAME (state=08S01,code=1)'

The operation seems done. but always get this exception.

Any suggestion.

Re: Hive get exception when try to do insert/create operation

vmurakami — Tue, 07 Aug 2018 05:11:47 GMT

Hey @X M!
What do you get when you try to connect through beeline?

Re: Hive get exception when try to do insert/create operation

luckyxu_ — Tue, 07 Aug 2018 09:06:34 GMT

Seems it related with hcatalog event lister. I removed setting for 'hive.metastore.event.listeners' and the exception gone. Three are no any issue when I try to connect through beeline. Not sure if there are any misconfiguration.

Re: Hive get exception when try to do insert/create operation

vmurakami — Tue, 07 Aug 2018 22:19:17 GMT

Hello @X M!
Yeah, makes sense.
It seems you're hitting this issue:
https://github.com/apache/hive/blob/e867d1c693e966706d3b7c6fe18e039a85928f51/standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/events/ListenerEvent.java#L164

To figure out if there's any misconfiguration you can check on both (hiveCLI and beeline) configs. Would be like this:

hive -e "set;" > /tmp/hivecli.properties
beeline -u 'jdbc:hive2:<HS2>:10000/default' -e "set;" > /tmp/beeline.properties

And if the issue got solved, I'd kindly ask to you to accept as an answer, this will engage other HCC users to keep doing a good job. And will facilitate the search for the best answer. 🙂

Hope this helps!