hive load txt to table
2018-07-02 本文已影响0人
e237262360d2
hive -e "
USE jkgj_log;
DROP TABLE IF EXISTS recsys_consult_keyword_drug_prob_new;
CREATE TABLE recsys_consult_keyword_drug_prob_new (
combile_key string,
word string,
values string
)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '\t'
STORED AS TEXTFILE;
LOAD DATA LOCAL INPATH 'recsys_consult_keyword_drug_prob_new.txt' OVERWRITE INTO TABLE jkgj_log.recsys_consult_keyword_drug_prob_new;"