Support Questions
Find answers, ask questions, and share your expertise

can we change transactional'='false' from transactional'='true' in TBLPROPERTIES hive

can we change transactional'='false' from transactional'='true' in TBLPROPERTIES hive

Guru

I am not able to perform any hive operation like select count on one table and getting following error.

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

When I check table properties then I saw transactional'='true' set to true so can someone please help me to resolve it.

1 REPLY 1
Highlighted

Re: can we change transactional'='false' from transactional'='true' in TBLPROPERTIES hive

New Contributor

According to the documentation the Hive table property "transactional" cannot be set to 'false' once you set it to 'true'.

https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions#HiveTransactions-TableProperties

The solution I found is to re-create the table without that property.

Before re-creating the table be aware that "DROP TABLE <table_name>" will erase both Hive metadata and HDFS data, so you have to back up your data first.