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