本文共 324 字,大约阅读时间需要 1 分钟。
$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 delimitedfields terminated by '\t';
插入分区字段名必须跟创建表分区字段名相同
转载地址:http://nsazi.baihongyu.com/