| |
| create table load_overwrite (key string, value string) stored as textfile location 'file:${system:test.tmp.dir}/load_overwrite'; |
| create table load_overwrite2 (key string, value string) stored as textfile location 'file:${system:test.tmp.dir}/load2_overwrite2'; |
| |
| load data local inpath '../../data/files/kv1.txt' into table load_overwrite; |
| load data local inpath '../../data/files/kv2.txt' into table load_overwrite; |
| load data local inpath '../../data/files/kv3.txt' into table load_overwrite; |
| |
| show table extended like load_overwrite; |
| desc extended load_overwrite; |
| select count(*) from load_overwrite; |
| |
| load data inpath '${system:test.tmp.dir}/load_overwrite/kv*.txt' overwrite into table load_overwrite2; |
| |
| show table extended like load_overwrite2; |
| desc extended load_overwrite2; |
| select count(*) from load_overwrite2; |
| |
| load data inpath '${system:test.tmp.dir}/load2_*' overwrite into table load_overwrite; |
| show table extended like load_overwrite; |
| select count(*) from load_overwrite; |