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'".
1 REPLY
One Star

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

Here is screenshot