apache / apache/paimon

[Bug] Trino cannot create tables

Open
#4,369 0 comments 0 reactions 0 assignees View on GitHub
bug
Dominant language
Java
Stars
3.4k
Forks
1.4k
Avg merge
1d 11h
Merged PRs (30d)
396

Description

### Search before asking

- [X] I searched in the [issues](https://github.com/apache/paimon/issues) and found nothing similar.

### Paimon version

paimon-trino-427-0.8-20241024.000602-178-plugin.tar.gz

### Compute Engine

trino-server-462

### Minimal reproduce step

1. trino paimo catalog
```
connector.name=paimon
warehouse=file:/opt/sr/current/local_wh
```

2. create table by following https://paimon.apache.org/docs/0.8/engines/trino/
```
CREATE SCHEMA paimon.test_db;

CREATE TABLE paimon.test_db.orders (
order_key bigint,
orders_tatus varchar,
total_price decimal(18,4),
order_date date
)
WITH (
file_format = 'ORC',
primary_key = ARRAY['order_key','order_date'],
partitioned_by = ARRAY['order_date'],
bucket = '2',
bucket_key = 'order_key',
changelog_producer = 'input'
);
```

3. error
```
Query failed (#20241024_030059_00002_t4536): This connector does not support creating tables io.trino.spi.TrinoException: This connector does not support creating tables
```

### What doesn't meet your expectations?

Paimon docs https://paimon.apache.org/docs/0.8/engines/trino/ says could use Trino to create table, but it cannot.

### Anything else?

_No response_

### Are you willing to submit a PR?

- [ ] I'm willing to submit a PR!

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by reproducing the CREATE SCHEMA and CREATE TABLE statements using the paimon-trino-427-0.8-20241024.000602-178 plugin with trino-server-462 and the shown catalog configuration. Compare the behavior with the linked Paimon Trino documentation; done means table creation works as documented or the documentation clearly reflects the supported behavior.

Written by the indexing model from the issue text.

Assessment

Tech stack
java
Domain
database
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.