Hive insert query : giving error of Dynamic partition strict mode requires at least one static partition column. -
i want know why hive insert query giving error turn off set hive.exec.dynamic.partition.mode=nonstrict, when set set hive.exec.dynamic.partition.mode=nonstrict; works me. reason behind ?
hive.exec.dynamic.partition.mode strict in strict mode, user must specify @ least 1 static partition in case user accidentally overwrites partitions, in nonstrict mode partitions allowed dynamic. refer : https://cwiki.apache.org/confluence/display/hive/languagemanual+dml
Comments
Post a Comment