hive导数的常用样例

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');

转载于:https://www.cnblogs.com/jie-2019/p/10369649.html