Cheat Code
INSERT OVERWRITE TABLE apac.amazing_report partition (yyyymm=’2019-12-01′)
SELECT year, month, partnerid, cost, revenue
FROM apac.amazing_csv
WHERE yyyymm=’2019-12-01′
I have hive partitioned table and I need to load/reload this partition from raw source which is CSV in my case.
Just run the cheat code above (don’t forget to adjust the table, partition, and source to your environment.
ONE MORE THING! remember to exclude the partition key column from your select statement 😀
My IT Cheat Code 