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

What’s New for Talend Spring ’19

Join us live for a sneak peek!

Sign up now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads