Community Articles

Find and share helpful community-sourced technical articles.
Announcements
Celebrating as our community reaches 100,000 members! Thank you!
Labels (1)
avatar
Contributor

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.

1,395 Views