| |
| 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'; |
| |
| |
| |