$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';
插入分区字段名必须跟创建表分区字段名相同