Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE X IF NOT EXISTS ... USING PARQUET PARTITIONED BY (Year, Month,Day)
- LOCATION '...'
- INSERT OVERWRITE TABLE ... PARTITION (Year, Month, Day)
- SELECT ... FROM Y
- INSERT OVERWRITE TABLE ... PARTITION (Year, Month, Day)
- SELECT ... FROM Y WHERE Year = YEAR(CURRENT_DATE())
Add Comment
Please, Sign In to add comment