描写叙述：

Hive表pms.cross_sale_path建立以日期作为分区，将hdfs文件夹/user/pms/workspace/ouyangyewei/testUsertrack/job1Output/crossSale上的数据，写入该表的$yesterday分区上

表结构：

hive -e "

set mapred.job.queue.name=pms;

drop table if exists pms.cross_sale_path;

create external table pms.cross_sale_path

(

track_id string,

track_time string,

session_id string,

gu_id string,

end_user_id string,

page_category_id bigint,

algorithm_id int,

is_add_cart int,

rcmd_product_id bigint,

product_id bigint,

category_id bigint,

path_id string,

path_type int,

path_length int,

path_list string,

order_code string

)

PARTITIONED BY (ds string)

ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'

LINES TERMINATED BY '\n'

STORED AS TEXTFILE;"

写法：

yesterday=`date -d -1days +%Y-%m-%d`

hive -e "load data inpath '/user/pms/workspace/ouyangyewei/testUsertrack/job1Output/crossSale' into table pms.cross_sale_path partition(ds='$yesterday');"