Support Questions

Find answers, ask questions, and share your expertise

You can't drop a kudu partition?!

avatar
Explorer

When trying to drop a range partition of a Kudu table via Impala's ALTER TABLE, we got

 

Server version: impalad version 2.8.0-cdh5.11.0 RELEASE (build e09660de6b503a15f07e84b99b63e8e745854c34)

Query: alter TABLE vis.ss7gsm_fact_kudu DROP PARTITION (unix_timestamp('2017-03-21 00:00:00') <= sql_interval < unix_timestamp('2017-03-21 02:00:00'))

ERROR: AnalysisException: ALTER TABLE DROP PARTITION is not supported for Kudu tables: PARTITION (unix_timestamp('2017-03-21 00:00:00') <= sql_interval < unix_timestamp('2017-03-21 02:00:00'))

 

Is this an Impala/Kudu integration issue or the way it is with Kudu?

 

Thanks,

Brian

1 ACCEPTED SOLUTION

avatar
Explorer

I see my mistake. The statement is supposed to say DROP RANGE PARTITION...

View solution in original post

1 REPLY 1

avatar
Explorer

I see my mistake. The statement is supposed to say DROP RANGE PARTITION...