hive插入分区报错SemanticException Partition speccontains non-partition columns

mac2025-03-16  12

$HIVE_HOME/bin/hive -e "load data local inpath '$path/$filename.txt' overwrite into table bigtrouble.accountregister partition (year='$var1',month='$var2');" hive> create table stud01( id string, name string, age int ) partitioned by (year string,month string) row format delimited fields terminated by '\t';

插入分区字段名必须跟创建表分区字段名相同

最新回复(0)