Unable to create iceberg table using Trino

Asked Jan 04 '23 at 14:01

Active Jan 04 '23 at 14:01

Viewed 270 times

I am trying to create iceberg table using trino but ddl is not executing stating that sort_order not find .below sample ddl

Create table <tableschema>.test ( C1 datetime,
C2 double ,
C3 double 
) 
With ( format='parquet',
       Location='S3a:// location of file',
        Partitioning=ARRAY['day(C1)'],
        Sort_order=ARRAY['C2','C3']
)

DDL not executing when I am defining the sort_order for table . Without sort_order table getting created

Can you please help with this is anything I need to modify in DDL . I am using trino-jdbc380.jar for driver to connect

asked Jan 04 '23 at 14:01

vikram bhati

1

I dont think trino iceberg connector supports sort clause. I cant find it in docs https://trino.io/docs/current/connector/iceberg.html – Atif Jan 05 '23 at 15:38
Yes Trino iceberg connectors doesn't support sort order clause . In order to change table properties i used spark – vikram bhati Jan 26 '23 at 10:46
Could you please share how you changed sort order haing tblproperties ? – Atif Jan 27 '23 at 11:08
spark.sql("ALTER TABLE .. WRITE ORDERED BY C2,C3") – vikram bhati Mar 13 '23 at 15:21

Unable to create iceberg table using Trino

0 Answers0