While following hello world in tutorial I made few changes in create table. Table has composite primary key with two columns (one is partition column). Rest of the tutorial has same code for procedures and DDL.
create table dictionary (
language varchar(50) not null,
primary key(word, language)
partition table dictionary on column language;
CREATE PROCEDURE FROM CLASS Insert;
CREATE PROCEDURE FROM CLASS Select;
PARTITION PROCEDURE Insert ON TABLE dictionary COLUMN language;
PARTITION PROCEDURE Select ON TABLE dictionary COLUMN language;
While inserting following data
client.callProcedure("Insert", "One", "1", "English");
client.callProcedure("Insert", "One", "1", "Roman");
I get fllowing error:
Exception in thread "main" org.voltdb.client.ProcCallException: VOLTDB ERROR: CONSTRAINT VIOLATION
Mispartitioned tuple in single-partition insert statement.
Constraint Type PARTITIONING, Table CatalogId DICTIONARY
header size: 37
status code: -128 column count: 3
cols (WORD:STRING), (MEANING:STRING), (LANGUAGE:STRING),
How to correct this partition? Is it like with this composite primary key which includes partition column will not work as multi partitioned table and need to be replicated table?