==== | |
---- 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 | |
==== |