Reply
Highlighted
New Contributor
Posts: 5
Registered: ‎02-09-2017
Accepted Solution

You can't drop a kudu partition?!

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

New Contributor
Posts: 5
Registered: ‎02-09-2017

Re: You can't drop a kudu partition?!

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

Announcements