Community Articles
Find and share helpful community-sourced technical articles
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.
Labels (1)
New 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.

757 Views
Don't have an account?
Coming from Hortonworks? Activate your account here
Version history
Revision #:
1 of 1
Last update:
‎06-30-2017 11:31 PM
Updated by:
 
Contributors
Top Kudoed Authors