Hello ALL We are planning to introduce Starrocks internally StarRocks #questions-and-troubleshooting

Hello. ALL. We are planning to introduce Starrock...

박훈 (Karrot, 데이터허브팀)

10/11/2025, 4:32 AM

Hello. ALL. We are planning to introduce Starrocks internally. Currently, we are using Trino as main query engine. While there are no issues with using Starrocks immediately, we want to support querying Starrocks' own data (default_catalog) via Trino during a smooth transition or hybrid period. However, Starrocks'
DATETIME
columns cannot be queried through Trino's MySQL connector. • It appears the column size of Starrocks' DATETIME columns is not being recognized by Trino. Q. If this is the cause, could it be addressed in the next patch? - (Similar issue) https://github.com/trinodb/trino/issues/16575 - (Error message)

Caused by: java.lang.IllegalStateException: column size not present...

io.trino.plugin.mysql.MySqlClient.mysqlDateTimeToTrinoTimestamp(MySqlClient.java:647)

박훈 (Karrot, 데이터허브팀)

10/11/2025, 4:34 AM

Here is Starrocks DDL statement for test

Copy code

CREATE TABLE rt_dataplatform_play.orders (
  order_id  BIGINT NOT NULL,
  customer  VARCHAR(64),
  amount    DECIMAL(10,2),
  status    VARCHAR(16),
  order_time DATETIME
)
PRIMARY KEY (order_id)
DISTRIBUTED BY HASH(order_id) BUCKETS 10
ORDER BY (order_time)
PROPERTIES (
  "replication_num" = "1"
);

DATETIME

column is included in a table, Trino fails to retrieve data.

Copy code

SELECT * FROM sr_operation.rt_dataplatform_play.orders3 LIMIT 10

SELECT *
FROM sr_operation.information_schema.columns
WHERE table_schema = 'rt_dataplatform_play' AND table_name = 'orders'

Open in Slack

Previous Next