diqiu50 commented on code in PR #4925: URL: https://github.com/apache/gravitino/pull/4925#discussion_r1774579129
########## trino-connector/integration-test/src/test/resources/trino-ci-testset/testsets/lakehouse-iceberg/00005_partition_sort_order.sql: ########## @@ -0,0 +1,63 @@ +CREATE SCHEMA gt_db2; + +USE gt_db2; + +CREATE TABLE lineitem( + orderkey bigint, + partkey bigint, + suppkey bigint, + linenumber integer, + quantity decimal(12, 2), + extendedprice decimal(12, 2), + discount decimal(12, 2), + tax decimal(12, 2), + returnflag varchar, + linestatus varchar, + shipdate date, + commitdate date, + receiptdate date, + shipinstruct varchar, + shipmode varchar, + comment varchar +) +WITH ( + partitioning = ARRAY['year(commitdate)'], + sorted_by = ARRAY['partkey', 'extendedprice desc'] +); + +show create table lineitem; + +insert into lineitem select * from tpch.tiny.lineitem; + +select * from lineitem order by orderkey, partkey limit 5; + +CREATE TABLE tb01( + orderkey bigint, + partkey bigint, + suppkey bigint, + linenumber integer, + quantity decimal(12, 2), + extendedprice decimal(12, 2), + discount decimal(12, 2), + tax decimal(12, 2), + returnflag varchar, + linestatus varchar, + shipdate date, + commitdate date, + receiptdate date, + shipinstruct varchar, + shipmode varchar, + comment varchar +) +WITH ( Review Comment: In the Trino , we can sue the command `SHOW CREATE TABLE` to check it. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
