apache / apache/paimon-trino

can not order by timestamp column in trino version 447/448 #72

Open
#74 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
Java
Stars
47
Forks
55
PR merge metrics
No merged PRs in 30d

Description

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)

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.