--! qt:dataset:part
set hive.mapred.mode=nonstrict;
set hive.typecheck.on.insert = true;

-- begin part(string, string) pass(string, int)
CREATE TABLE tab1_n3 (id1 int,id2 string) PARTITIONED BY(month string,day string) stored as textfile;
LOAD DATA LOCAL INPATH '../../data/files/T1.txt' overwrite into table tab1_n3 PARTITION(month='June', day=2);

select * from tab1_n3;
drop table tab1_n3;

-- begin part(string, int) pass(string, string)
CREATE TABLE tab1_n3 (id1 int,id2 string) PARTITIONED BY(month string,day int) stored as textfile;
LOAD DATA LOCAL INPATH '../../data/files/T1.txt' overwrite into table tab1_n3 PARTITION(month='June', day='2');

select * from tab1_n3;
drop table tab1_n3;

-- begin part(string, date) pass(string, date)
create table tab1_n3 (id1 int, id2 string) PARTITIONED BY(month string,day date) stored as textfile;
alter table tab1_n3 add partition (month='June', day='2008-01-01');
LOAD DATA LOCAL INPATH '../../data/files/T1.txt' overwrite into table tab1_n3 PARTITION(month='June', day='2008-01-01');

select id1, id2, day from tab1_n3 where day='2008-01-01';
drop table tab1_n3;