You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@spark.apache.org by vinay Bajaj <vb...@gmail.com> on 2014/03/26 15:57:29 UTC

Shark drop table partitions

Hi

Is there any way to drop all or subset of partitions of table in one run??

In hive we have


To drop a partition from a Hive table, this works:

ALTER TABLE foo DROP PARTITION(ds = 'date')

...but it should also work to drop all partitions prior to date.

ALTER TABLE foo DROP PARTITION(ds < 'date')

This task is to implement ALTER TABLE DROP PARTITION for all of the
comparators, < > <= >= <> = != instead of just for =.

But in shark this is not working.

So Is there any way to do that ??

Thanks

Vinay Bajaj