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