Shark drop table partitions

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Shark drop table partitions

vinay Bajaj
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