Hi Pat.. I have hive.exec.dynamic.partition.mode=nonstrict and hive.exec.dynamic.partition=true. That let hive accept the dynamic partitions, but it still fails.
Khaled > Check that you have hive.exec.dynamic.partition.mode set to false. That > or have a static partition column first in your partitioning clause. > > Pat > > > > -- Sent from my Palm Pre