配置单元插入查询失败,返回错误代码-101

snz8szmq  于 2021-06-01  发布在  Hadoop
关注(0)|答案(1)|浏览(360)

我正在尝试运行一个简单的insert语句,如下所示:

insert into table `bwc_test` partition(call_date)
select * from
`bwc_master`;

然后失败,错误如下:
信息:正在从/apps/hive/warehouse/dtc.db/bwc\u test/.hive-staging\u hive\2018-11-13\u 19-10-37\u 084\u 8697431764330812894-1/-ext-10000将数据加载到表dtc.bwc\u test partition(call\u date=null)

Error: Error while processing statement: FAILED: Execution Error, return code -101 from org.apache.hadoop.hive.ql.exec.MoveTask. HIVE_LOAD_DYNAMIC_PARTITIONS_THREAD_COUNT (state=08S01,code=-101)

bwc\ U主机的表定义:

CREATE TABLE `bwc_master`(                                   
unique_id bigint,                                           
customer_id string,                                         
direction string,                                           
call_date_time timestamp,                                   
duration int,                                               
billed_duration int,                                        
retail_rate decimal(9,7),                                   
retail_cost decimal(19,7),                                  
billed_tier smallint,                                       
call_type tinyint,                                          
record_status tinyint,                                      
aggregate_id bigint,                                        
originating_ipaddress string,                               
originating_number string,                                  
destination_number string,                                  
lrn string,                                                 
ocn string,                                                 
destination_rate_center string,                             
destination_lata int,                                       
billed_prefix string,                                       
rate_id string,                                             
wholesale_rate decimal(9,7),                                
wholesale_cost decimal(19,7),                               
cnam_dipped boolean,                                        
billed_number_type tinyint,                                 
source_lata int,                                            
source_ocn string,                                          
location_id string,                                         
sippeer_id int,                                             
rate_attempts tinyint,                                      
source_state string,                                        
source_rc string,                                           
destination_country string,                                 
destination_state string,                                   
destination_ip string,                                      
carrier_id string,                                          
rated_date_time timestamp,                                  
partition_id smallint,                                      
encryption_rate decimal(9,7),                               
encryption_cost decimal(19,7),                              
trans_coding_rate decimal(9,7),                             
trans_coding_cost decimal(19,7),                            
file_name string,                                           
call_id string,                                             
from_tag string,                                            
to_tag string,                                              
unique_record_id string)                                    

PARTITIONED BY (                                                
`call_date` date)  

CLUSTERED BY (                                                  
customer_id)                                                  
INTO 10 BUCKETS 

ROW FORMAT SERDE                                                
 'org.apache.hadoop.hive.ql.io.orc.OrcSerde'  

STORED AS INPUTFORMAT                                           
'org.apache.hadoop.hive.ql.io.orc.OrcInputFormat'

OUTPUTFORMAT                                                    
'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat'    

LOCATION                                                        
'hdfs://*****/apps/hive/warehouse/dtc.db/bwc_master'

有人能帮我调试一下吗?我在日志里什么也没找到。

qcuzuvrc

qcuzuvrc1#

你错过了“table”吗 bwc_test ```
insert into table bwc_test partition(call_date)
select * from
bwc_master;

相关问题