获取此错误
hive> insert overwrite table employees_partition partition (country ='IND', State='HR') select * from employees_data where state = 'Haryana';
FAILED: Error in semantic analysis: Line 1:117 Invalid table alias or column reference state
我的分区表结构是
CREATE TABLE employees_partition (
name STRING,
salary FLOAT,
subordinates ARRAY<STRING>,
deductions MAP<STRING, FLOAT>,
address STRUCT<street:STRING, city:STRING, state:STRING, zip:INT>) PARTITIONED BY (country STRING, state STRING)
row format delimited fields terminated by ','
collection items terminated by '$'
map keys terminated by '#';
1条答案
按热度按时间66bbxpm51#
要删除此错误,必须在配置单元外壳上执行以下命令:
此错误的原因:
默认情况下
hive.exec.dynamic.partition
配置属性设置为“false”,并且hive.exec.dynamic.partition.mode
设置为“严格”,因为配置单元版本<0.9.0无法执行动态分区。