Skip to content

Can't use 'SET' in ALTER TABLE or 'WITH' in CREATE TABLE #22

Open
@Lt-Flash

Description

@Lt-Flash

Hi,
I've deployed a test cluster as per documentation, consisting of 3 nodes and 3 hdds each. 3 static nodes and 3 dynamic nodes to serve a test DB.
Now, according to manual I should be able to create a table like this:

CREATE TABLE my_table (
    id Uint64,
    title Utf8,
    PRIMARY KEY (id)
)
WITH (
    AUTO_PARTITIONING_BY_SIZE = ENABLED,
    AUTO_PARTITIONING_PARTITION_SIZE_MB = 512
);

To set AUTO_PARTITIONING values, or be able to modify existing table this way:

ALTER TABLE series SET (AUTO_PARTITIONING_BY_SIZE = DISABLED);

Neither of these two examples are working, when I try to run ALTER query I'm getting
'Unexpected token SET: cannot match to any predicted input.

When I'm trying to create the table, I'm getting:
Unexpected token 'WITH' : syntax error...

What's the correct syntax to use? The only way to change these parameters I found was to dump the table scheme, update parameters manually in the dump file and load them back into DB.

Thanks.

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions