In the partition field the left value is the column so you do not change this. The right value is the partition you want to load into. I.e. INSERT ... partition( TRAN_DATE= your date ) My tip: change the partition field from Date to Integer. Then it would work. Alternatively you could cast the right side to a date. partition ( TRAN_DATE = to_date(${day},'YYYY-MM-DD')) but honestly a partition column of string or integer is most likely less headache. I never used a Date so not sure if this would work.
... View more
