| ==== | |
| ---- QUERY | |
| # Test adding sort.columns and sort.zorder when creating a table from a select query. | |
| create table zsortbytest sort by zorder (int_col, bool_col) as | |
| select * from functional.alltypessmall; | |
| describe formatted zsortbytest; | |
| ---- RESULTS: VERIFY_IS_SUBSET | |
| '','sort.columns ','int_col,bool_col ' | |
| '','sort.order ','ZORDER ' | |
| ---- TYPES | |
| STRING,STRING,STRING | |
| ==== |