
create temporary table hive_test_temp ( col1 string ) partitioned by ( pcol1 string , pcol2 string) stored as textfile;
load data local inpath '../../data/files/test.dat' overwrite into table hive_test_temp partition (pcol1='part1',pcol2='part1') ;
load data local inpath '../../data/files/test.dat' overwrite into table hive_test_temp partition (pcol2='part2',pcol1='part2') ;
select * from hive_test_temp where pcol1='part1' and pcol2='part1';
select * from hive_test_temp where pcol1='part2' and pcol2='part2';