FAILED: SemanticException [Error 10122]: Bucketized tables do not support INSERT INTO: Table: XXXX
Customer has a ACID enabled Cluster. Customer created a Table for which the TBLPROPERTIES ('transactional'='true') was not set. Customer's table has 50 Billion records in it.
For a table to be transactional, we need to set TBLPROPERTIES ('transactional'='true')
We can convert a table to Transactional Table using the Alter Table Command, assuming the table satisfies acid requirements
Logically alter table to set transactional=true is supported.