在配置单元分区表中从选择查询插入时查询失败

Question

创建了一个类似-的表

create table data_load(
data_4 bigint,
data_4 string
)
partitioned by (data_1 bigint, data_2 bigint, data_3 bigint)
stored as paquet TBLPROPERTIES("parquet.compression"="gzip")`

将数据插入表时失败-使用查询作为-

set hive.exec.dynamic.partition.mode = nonstrict; insert into table data_load partition (data_1, data_2, data_3)  select data_4, data_5, data_1, data_2, data_3 from test_table

错误-

Error: Error while compiling statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask. partition hdfs://nameservice1/user/hive/warehouse/data_load/.hive-staging_hive_2021-04-26_01-39-63_441_251873045434332599-117/-ext-10000/tmpstats-0_FS_3 is not a directory! (state=08S01,code=1)

我在这里做错了什么？

Answer 1

试着看看这是否适用于

set hive.exec.dynamic.partition.mode = nonstrict; 
CREATE TABLE data_load( data_4 bigint, data_4 string ) partitioned by (data_1 bigint, data_2 bigint, data_3 bigint) stored as paquet TBLPROPERTIES("parquet.compression"="gzip") as
select data_4, data_5, data_1, data_2, data_3 from test_table