INSERT OVERWRITE LOCAL DIRECTORY '/script/dirk.zhang/test' ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' select... ...;
insert overwrite [local] directory '/data/movielens/100k/output/item_release_date_10' select release_date from item limit 10;
insert overwrite table data2 partition(dt='1997-12') select * from data where from_unixtime(timestamp, 'yyyy-MM') = '1997-12';
导入到hive
load data local inpath '${OUTPUT}/hive_subscribe_biz.*.${FILE_DATE}' overwrite into table subscribe_biz partition(logday='$LOG_DATE');
load data inpath '${hive_path2}/part*' overwrite into table orig_subscribe_monitor_company partition(logday='$LOG_DATE');
resource:http://blackproof.iteye.com/blog/2124052