Support Questions

Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

Adding column to a partition table in hIVE

Explorer

hive> ALTER TABLE test.xyz columns (xxxx boolean) cascade; FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Unable to alter table. The table must be bucketed and stored using an ACID compliant $ ve> $

My table was created with transactional'='true' in the table properties

1 REPLY 1

Guru

You must also set

hive.enforce.bucketing=true

34433-screen-shot-2017-08-23-at-94801-pm.png

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.