| -- Load data can't work with table with stored as directories | |
| CREATE TABLE if not exists stored_as_dirs_multiple (col1 STRING, col2 int, col3 STRING) | |
| SKEWED BY (col1, col2) ON (('s1',1), ('s3',3), ('s13',13), ('s78',78)) stored as DIRECTORIES; | |
| LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' INTO TABLE stored_as_dirs_multiple; |