Dynamic partition strict mode requires at least one static partition

One Star

Dynamic partition strict mode requires at least one static partition

connecting to socket on port 4029
connected
Error while compiling statement: FAILED: SemanticException : Dynamic partition strict mode requires at least one static partition column. To turn this off set hive.exec.dynamic.partition.mode=nonstrict
disconnected
thiverow_1
query: "Set hive.exec.dynamic.partition=true"
thiverow_2
query: "Set hive.exec.dynamic.partition.mode=nonstrict"
**DUE TO ABOVE ERROR:  I am not sure if I am properly setting the nonstrict can anybody advise.
Also Question: I have defined a partition as date timestamp. In thiveload I want to do historical load.  Is there a way not to set the partition.  Also if i set the partition I can not filter on date meaning "partition_key > '2015-05-04 00:00:00'".
One Star

Re: Dynamic partition strict mode requires at least one static partition

Here is screenshot