question Acid is enabled in HDP 3.0. How can I turn it off? in Archives of Support Questions (Read Only)

Acid is enabled in HDP 3.0. How can I turn it off?

yamingdong666 — Thu, 27 Dec 2018 09:20:13 GMT

Re: Acid is enabled in HDP 3.0. How can I turn it off?

Scharan — Thu, 27 Dec 2018 09:46:36 GMT

@jack Refer this https://community.hortonworks.com/articles/92363/enable-disable-acid.html

Re: Acid is enabled in HDP 3.0. How can I turn it off?

yamingdong666 — Thu, 27 Dec 2018 10:36:57 GMT

After configuring those parameters, I made an error report. The error message is as follows:

Error: Error while compiling statement: FAILED: SemanticException [Error 10265]: This command is not allowed on an ACID table default.ddd with a non-ACID transaction manager. Failed command: create table ddd (id int) (state=42000,code=10265)

Re: Acid is enabled in HDP 3.0. How can I turn it off?

dcostamagna — Thu, 17 Jan 2019 22:49:34 GMT

Hi, i'm having the same problem as the one reported by @jack. I followed this guide https://community.hortonworks.com/articles/92363/enable-disable-acid.html but i'm having this error too:

Error: Error while compiling statement: FAILED: SemanticException [Error 10265]: This command is not allowed on an ACID table default.test with a non-ACID transaction manager. Failed command: create table test (a string) (state=42000,code=10265)