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