twitter project output


1 Answer(s)


Hi Swetha,

Try both below properties

SET hive.exec.dynamic.partition = true;
SET hive.exec.dynamic.partition.mode = nonstrict;

And while writing insert statement for a partitioned table make sure that you specify the partition columns at the last in select clause.

Hope this helps.

Thanks.