[Hive] Create table

CREATE EXTERNAL TABLE db.table (
    id INT,     
    name STRING,     
    type STRING
)
PARTITIONED BY (type STRING)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '|'
LINES TERMINATED BY '\n'
STORED AS TEXTFILE;


ALTER TABLE `db`.`table` ADD PARTITION (detail_type='a');
ALTER TABLE `db`.`table` ADD PARTITION (detail_type='b');
ALTER TABLE `db`.`table` ADD PARTITION (detail_type='c');

[출처]

https://118k.tistory.com/m/444?category=583325

https://stackoverflow.com/questions/22220837/how-to-add-partition-using-hive-by-a-specific-date