How to convert a Table to Transactional in an ACID Database

[#1]

SYMPTOM:

FAILED: SemanticException [Error 10122]: Bucketized tables do not support INSERT INTO: Table: XXXX

ROOT CAUSE:

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.

WORKAROUND: 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 --Bucketed,

--Using ORC

--Not sorted.

RESOLUTION:

Logically alter table to set transactional=true is supported.