[Bug] Trino cannot create tables
- 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