hive sql 分区

drop table if EXISTS t1;
create table t1(
    id      int
   ,name    string
   ,hobby   string
   ,add     string
)
partitioned by (pt_d string)
;

drop table if EXISTS t2;
create table t2(
    id      int
   ,name    string
   ,hobby   string
   ,add     string
);
INSERT into t2 values(1, 'lang','hh', 'sdfd');

INSERT overwrite TABLE t1 PARTITION(pt_d = '2018-10-27') SELECT * FROM t2;