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