load data local inpath ‘/home/csqinwj/test/huoke/0514/dws_dwtb_getguest_market/dal_bdcsc_mdn_id_d/data/dws_wdtb_cdr_mix_msk_d1.txt‘ overwrite into table csqinwj.dws_wdtb_cdr_mix_msk_d partition (provinceid=‘851‘,day=‘20180419‘);
/home/csqinwj/test/huoke/0821/V1.1.0/dal_bdcsc_mdn_id_d_1.1.0/dws_wdtb_uid_id_maping_all_d.txt
load data local inpath ‘/home/csqinwj/test/huoke/0821/V1.1.0/dal_bdcsc_mdn_id_d_1.1.0/dws_wdtb_uid_id_maping_all_d.txt‘ into table csqinwj.dws_wdtb_uid_id_maping_all_d partition (prov_id=‘851‘,day_id=‘20180723‘);
load data local inpath
‘/home/csqinwj/test/huoke/0822/V1.1.0/dal_bdcsc_mdn_id_d_1.1.0/1‘ overwrite into table dal_bdcsc.dal_bdcsc_mdn_id_d
load data inpath ‘/daas/subtl/dal/bdcsc/dal_bdcsc_mdn_sha_md5_mapping/day_id=20180828/199.txt‘ overwrite into table use dal_bdcsc.dal_bdcsc_mdn_sha_md5_mapping partition (day=‘20180829‘);
hive导数的常用样例
原文：https://www.cnblogs.com/jie-2019/p/10369649.html
