Dynamic partition strict mode requires at least one static partition

Anonymous — Sat, 16 Nov 2024 11:13:43 GMT

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'".

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

Anonymous — Wed, 06 May 2015 15:23:21 GMT

Here is screenshot

topic Re: Dynamic partition strict mode requires at least one static partition in Talend Studio

Dynamic partition strict mode requires at least one static partition

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