cassandracqlpelops

Why can't I insert this composite column name as Bytes into a CQL blob?


I have a CQL 3 CF

CREATE TABLE entries (
  id text,
  va text,
  ts bigint,
  idxc blob,
  PRIMARY KEY (id, va, ts)
);

And with pelops I get for an insert of Bytes( [0, 4, 0, 0, 0, 4, 0, 0, 8, 0, 0, 1, 55, -56, -41, 6, 14, 0, 0, 16, 65, 50, 82, 97, 84, 85, 95, 82, 72, 71, 115, 69, 89, 115, 100, 49, 0, 0, 8, 0, 4, -63, -24, -121, -16, 35, -80, 0, 0, 2, 105, 103, 0]) this Exception:

org.scale7.cassandra.pelops.exceptions.InvalidRequestException: (String didn't validate.)[ks][entries][aKey:1339104364078000:idxc] failed validation
    at org.scale7.cassandra.pelops.exceptions.IExceptionTranslator$ExceptionTranslator.translate(IExceptionTranslator.java:47)

I can insert other byte arrays with the same method.


Solution

  • Let's close this: Conclusion: CQL 3 is still beta, do not expect it to be glitch-free.

    I am using the old style schema definitions now without problems.