본문 바로가기

언어 꿀Tip/Hadoop Hive

[Impala] 03. 테이블 Create 생성 + partition 추가

create table Schema.tablename (
col1 string,
col2 decimal(38,2)
) partitioned by (partition_col col_type) stored as parquet;
insert into Schema.tablename partition(partition_col)
select col1
      ,col2
      ,partition_col
from table
;