0

I need to delete the hive table data ,older than 4 years Table is partitioned by year , month and date

Can you please help me on this ?

Thanks in advance,

Srinivas
  • 1
  • 3
  • 1
    Check this https://stackoverflow.com/questions/45543396/dropping-multiple-partitions-in-impala-hive – yammanuruarun Jan 02 '20 at 20:51
  • Does this answer your question? [Dropping multiple partitions in Impala/Hive](https://stackoverflow.com/questions/45543396/dropping-multiple-partitions-in-impala-hive) – Harsh Bafna Jan 03 '20 at 04:40
  • I need a insert overwrite HQL , Since table partitioned at day level , its very difficult to found and delete those partions , Please help on insert overwrite HQL, Table had timestamp column – Srinivas Jan 03 '20 at 08:34
  • Nothing difficult, read this answer please: https://stackoverflow.com/a/56646879/2700344 – leftjoin Jan 03 '20 at 11:36

0 Answers0