1. 下载

https://sqoop.apache.org/

nearby mirror

hive -e “load data local inpath ‘id_all.txt’ overwrite into table nlp.temporary_id”;

hive -e “load data local inpath ‘/data1/nlp/liukuo/jd_data/jd_34levelcity/title’ into table nlp_dev.jd_title_0”

CREATE TABLE nlp.test_dbs (
DB_ID bigint,
DESC string ,
DB_LOCATION_URI string,
NAME string ,
OWNER_NAME string ,
OWNER_TYPE string
) ROW FORMAT DELIMITED FIELDS TERMINATED BY ‘\t’ LINES TERMINATED BY ‘\n’ STORED AS TEXTFILE

hive -e “load data local inpath ‘/home/zhangquanquan/hive_dbs_table_data.txt’ into table nlp.test_dbs”