| --! qt:dataset:src |
| |
| create external table external1 (key string, value string) stored as textfile; |
| load data local inpath '../../data/files/kv1.txt' into table external1; |
| select count(*) from external1; |
| truncate table external1 force; |
| select count(*) from external1; |
| |
| |
| -- Partitioned table |
| create external table external2 (key string, value string) partitioned by (p1 string) stored as textfile; |
| load data local inpath '../../data/files/kv1.txt' into table external2 partition (p1='abc'); |
| select count(*) from external2; |
| truncate table external2 partition (p1='abc') force; |
| select count(*) from external2; |
| |