hive动态分区

hive动态分区

set hive.exec.dynamic.partition=true;
set hive.exec.dynamic.partition.mode=nonstrict;
插入报错:

Hive Runtime Error: Unable to deserialize reduce input key from x1x49x0x1x49x0x1x104x116x116x112x58x47x47x98x106x46x53x105x53x106x46x99x111x109x47x0x1x128x19x65x105x255 with properties {columns=reducesinkkey0,reducesinkkey1,reducesinkkey2,reducesinkkey3, serialization.lib=org.apache.hadoop.hive.serde2.binarysortable.BinarySortableSerDe, serialization.sort.order=++++, columns.types=string,string,string,string}
增加

set hive.optimize.sort.dynamic.partition = false;
解决