Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ClickHouse connector doesn't show table properties #11027

Closed
ebyhr opened this issue Feb 12, 2022 · 0 comments · Fixed by #11029
Closed

ClickHouse connector doesn't show table properties #11027

ebyhr opened this issue Feb 12, 2022 · 0 comments · Fixed by #11029
Assignees
Labels
bug Something isn't working

Comments

@ebyhr
Copy link
Member

ebyhr commented Feb 12, 2022

trino> CREATE TABLE clickhouse.default.trino_ck (
    ->   id int NOT NULL,
    ->   birthday DATE NOT NULL,
    ->   name VARCHAR,
    ->   age BIGINT,
    ->   logdate DATE NOT NULL
    -> )
    -> WITH (
    ->   engine = 'MergeTree',
    ->   order_by = ARRAY['id', 'birthday'],
    ->   partition_by = ARRAY['toYYYYMM(logdate)'],
    ->   primary_key = ARRAY['id'],
    ->   sample_by = 'id'
    -> );
CREATE TABLE

trino> SHOW CREATE TABLE clickhouse.default.trino_ck;
                Create Table
--------------------------------------------
 CREATE TABLE clickhouse.default.trino_ck (
    id integer NOT NULL,
    birthday date NOT NULL,
    name varbinary,
    age bigint,
    logdate date NOT NULL
 )
(1 row)
@ebyhr ebyhr added the bug Something isn't working label Feb 12, 2022
@ebyhr ebyhr self-assigned this Feb 12, 2022
@ebyhr ebyhr closed this as completed Feb 14, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Development

Successfully merging a pull request may close this issue.

1 participant