hadoop - hive :动态分区

Question

尝试在 hive 中执行以下代码进行动态分区时，出现以下错误。

hive 查询:

CREATE EXTERNAL TABLE VODPARTITION(EVENT_ID string, EVENT_TYPE string, DATE string) 
PARTITIONED BY (IPADDRESS string) 
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n' stored as sequencefile;

 INSERT OVERWRITE TABLE VODPARTITION
 PARTITION(ipaddress) 
 SELECT EVENT_ID, EVENT_TYPE, DATE, t.IP_ADDRESS as ipaddress FROM VOD t; 

错误:

FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask 

map task 和70％的reduce任务完成后出现此错误。
在这种情况下如何进行任何帮助...？

问候

Answer 1

请尝试以下设置:

设置hive.exec.dynamic.partition = true

如果该表仅包含动态分区列，则应将配置设置hive.exec.dynamic.partition.mode设置为非严格模式:

SET hive.exec.dynamic.partition.mode =非严格;