-
Notifications
You must be signed in to change notification settings - Fork 10
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
How to define number of shards and replicas? #75
Comments
CrateDB supports some specific table options e.g. for configuring sharding, partitioned tables or number of replicas. Passing this configurations via DBAL `$options` is now possible. Relates #75.
@nook24 Thanks for reporting the missing support for custom CrateDB table options. We'll look into the PK issue next. |
CrateDB supports some specific table options e.g. for configuring sharding, partitioned tables or number of replicas. Passing this configurations via DBAL `$options` is now possible. Relates #75.
CrateDB supports some specific table options e.g. for configuring sharding, partitioned tables or number of replicas. Passing this configurations via DBAL `$options` is now possible. Relates #75.
@nook24 We cannot reproduce the PK issue on Could you please paste us your used table schema? |
Hi @seut, many thanks for looking into this. This is the schema I used: https://github.com/statusengine/worker/blob/master/lib/crateDB.sql Maybe this issue is caused by the multi field primary keys |
CrateDB supports some specific table options e.g. for configuring sharding, partitioned tables or number of replicas. Passing this configurations via DBAL `$options` is now possible. Relates #75.
@nook24 Thanks for the information. We've figured out that the issue is not related to tables with primary key constraints but related to tables without any. |
The SchemaManager raised an exception while reading tables *without* any PRIMARY KEY constraints and ignored them when existing. NOT NULL constraints were ignored completely. Relates #75.
The SchemaManager raised an exception while reading tables *without* any PRIMARY KEY constraints and ignored them when existing. Relates #75.
@nook24 We've fixed the issue which will be part of the next release. |
@nook24 We've released v2.1.0 including the PK fix and table options support. |
Many thanks for your fast fix! I will test it :) |
Hi,
I want to use DBAL to manage schema updates.
Unfortunately I don't know how pass shards and replicas.
In addition, when I run this:
I get:
Looks like there is a bug with primary keys.
I'm using version crate-dbal 2.0.0 and CrateDB 4.0.4
The text was updated successfully, but these errors were encountered: