유용한 hive query 모음

임시테이블 (raw data 저장)테이블 생성

CREATE EXTERNAL TABLE test.eaxmple_table
(date string, data string)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
LOCATION '/test/db/eaxmple_table'
TBLPROPERTIES ('skip.header.line.count'='1');

Continue reading

Pagination


© 2020. by berrrrr

Powered by berrrrr