| ==== | |
| ---- QUERY | |
| # Test adding sort.columns and sort.zorder when creating a table like a parquet file. | |
| create table $DATABASE.decimal_file like parquet | |
| '$FILESYSTEM_PREFIX/test-warehouse/schemas/decimal.parquet' | |
| sort by zorder (d32, d11) stored as textfile; | |
| describe formatted $DATABASE.decimal_file; | |
| ---- RESULTS: VERIFY_IS_SUBSET | |
| '','sort.columns ','d32,d11 ' | |
| '','sort.order ','ZORDER ' | |
| ---- TYPES | |
| STRING,STRING,STRING | |
| ==== |