xazrv58C

1CREATE TABLE X IF NOT EXISTS ... USING PARQUET PARTITIONED BY (Year, Month,Day)
2LOCATION '...'
3	
4INSERT OVERWRITE TABLE ... PARTITION (Year, Month, Day)
5SELECT ... FROM Y
6	
7INSERT OVERWRITE TABLE ... PARTITION (Year, Month, Day)
8SELECT ... FROM Y WHERE Year = YEAR(CURRENT_DATE())