chore: how to load external file(.csv) for using as a driving table in Hive

Happyprg

·

Follow

Mar 26, 2021

--

Listen

Share

• 파일 upload to HDFS
• hdfs dfs -copyFromLocal
• 테이블 생성

CREATE EXTERNAL TABLE onetime.issue_1081_v1
(
    sid            string,
    category      string,
    pv string,
    nnb         string
)   ROW FORMAT DELIMITED FIELDS TERMINATED BY '\054'
    STORED AS TEXTFILE
    LOCATION 'hdfs:///onetime/kr/issue/1081';

• 생성된 External Table에 Load, Load되면 파일 사라짐

LOAD Data  INPATH '/zeppelin/issue_1081_SID.csv' OVERWRITE INTO TABLE onetime.issue_1081_v1;