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

Reply via email to