Support Questions

Find answers, ask questions, and share your expertise

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

avatar
Contributor
 
1 ACCEPTED SOLUTION

avatar
Master Collaborator
3 REPLIES 3

avatar
Master Collaborator

avatar
Contributor

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)

avatar
New Contributor

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)