search

ydb-platform / ydb

YDB is an open source Distributed SQL Database that combines high availability and scalability with strong consistency and ACID transactions
https://ydb.tech
Apache License 2.0
4.02k stars 581 forks source link

Implement OLAP scheme operations within query service #11778

Open rekby opened 1 day ago

rekby commented 1 day ago

Query with query service:

ydb -e grpc://localhost:2136 -d /local sql -s "CREATE TABLE t (
      timestamp Timestamp NOT NULL,
      PRIMARY KEY ( timestamp),
      PARTITION BY (timestamp)
  ) WITH(STORE=COLUMN,AUTO_PARTITIONING_MIN_PARTITIONS_COUNT=32);"
Status: PRECONDITION_FAILED
Issues:
<main>: Error: OLAP schema operations are not supported, code: 2029

Error:

PRECONDITION_FAILED (code = 400120, address = localhost:2136, nodeID = 1, issues = [{#2029 'OLAP schema operations are not supported'}]

Expected result: table created without errors