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;"

上一篇 下一篇

猜你喜欢

热点阅读