[I] can not order by timestamp column in trino version 447/448 #72 [paimon-trino]

["macdoor (via GitHub)" <gi...@apache.org>]

macdoor opened a new issue, #74:
URL: https://github.com/apache/paimon-trino/issues/74

   Paimon Version
   `paimon-trino-432-0.8-SNAPSHOT-plugin.tar.gz`
   
   Trino Verion
   ```
   Trino 447/448
   java version "22.0.1" 2024-04-16
   Java(TM) SE Runtime Environment Oracle GraalVM 22.0.1+8.1 (build 22.0.1+8-jvmci-b01)
   Java HotSpot(TM) 64-Bit Server VM Oracle GraalVM 22.0.1+8.1 (build 22.0.1+8-jvmci-b01, mixed mode, sharing)
   ```
   
   schema
   ```
   CREATE TABLE apisix_log (
     id               string,
     upstream         string,
     start_time       timestamp(3),
     client_ip        string,
     service_id       string,
     route_id         string,
     request          row<
       url            string,
       headers        string,
       body           string,
       size           bigint,
       querystring    string,
       uri            string,
       `method`       string
     >,
     response         row<
       status         bigint,
       headers        string,
       body           string,
       size           bigint
     >,
     server           row<
       hostname       string,
       version        string
     >,
     latency          double,
     apisix_latency   double,
     upstream_latency double,
     dt               string,
     WATERMARK FOR start_time AS start_time
   )  comment 'APISIX kafka-logger 原始日志数据' PARTITIONED BY (dt) with (
     'bucket' = '6'
   );
   ```
   
   query with order by returns exception
   ```
   SELECT t.*
   FROM raw_log.apisix_log t
   WHERE dt='2024-05-21'
   ORDER BY start_time
   
   ```
   client exception
   ```
   [2024-05-17 20:35:22] [65536] Query failed (#20240521_045409_01038_3pyv6): readNanos is negative (-9275621)
   [2024-05-17 20:35:22] java.lang.IllegalArgumentException: readNanos is negative (-9275621)
   
   ```
   
   sever log
   [server-448.log](https://github.com/apache/paimon-trino/files/15384680/server-448.log)
   


-- 
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: issues-unsubscribe@paimon.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [I] can not order by timestamp column in trino version 447/448 #72 [paimon-trino]

["macdoor (via GitHub)" <gi...@apache.org>]

macdoor commented on issue #74:
URL: https://github.com/apache/paimon-trino/issues/74#issuecomment-2300771303

   This exception occurs when the file format is orc, and there is no exception in the parquet file


-- 
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: issues-unsubscribe@paimon.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org