| -- SORT_QUERY_RESULTS |
| |
| create table tmp_insert_test (key string, value string) stored as textfile; |
| load data local inpath '../../data/files/kv1.txt' into table tmp_insert_test; |
| select * from tmp_insert_test; |
| |
| create table tmp_insert_test_p (key string, value string) partitioned by (ds string) stored as textfile; |
| |
| load data local inpath '../../data/files/kv1.txt' into table tmp_insert_test_p partition (ds = '2009-08-01'); |
| select * from tmp_insert_test_p where ds= '2009-08-01'; |
| |
| load data local inpath '../../data/files/kv2.txt' into table tmp_insert_test_p partition (ds = '2009-08-01'); |
| select * from tmp_insert_test_p where ds= '2009-08-01'; |