When I add partition to the table : PARTITION BY RANGE_N(ORDR_OPN_DT between ADD_MONTHS((DATE - EXTRACT(DAY FROM DATE)+1), -46) and Add_Months (current_date, 23) EACH INTERVAL '1' MONTH ) ;
It gives an internal error : Please donot submit the last request.
Any thoughts . When I remove the partition from the table, a simle query ike select * where ordr opn dt = '2016-11-16' runs fine. But with the partition a date filter gives out an error.
Remove the analytical functions from the partition and give exact dates....