Monday, 15 March 2010

cassandra - CREATE TABLE failing (wrong CQL version) -


Build unsuccessful tables with inset, multiple primary keys, and packages. The syntax was correct.

The error message does not mean with the primary key (unmatched parens). Remove it, I have found that in some cases the interrupt will not work.

Anything I am doing wrong, or about using CQL3 (Interface or Syntax) I can not understand?

  Create a table session ('user_id' bigint, 'admin_id' bigint, 'session_id' varchar, 'cache' text, 'created' timestamp, 'hit' list & gt; timestamp & Gt;, 'ip' inet, primary key ('session_id', 'user_id'));   

The following also fails

  create table 'session' ('user_id' bigint, 'session_id' varchar, primary key ('session_id' 'User_id'));   

This works

  create table 'session' ('user_id' bigint, 'session_id' varchar primary key);   

leads

  & gt; Support type cqlsh recognized by this version of CCL type: ascii bigint blob boolean counter decimal double float int timestamp uuid varchar varint   

dse 3.0.x

[Edit] - It is known that the Kendra 1.1.x is installed near DSE.

TL; DR: The collection (part of the QQ3) is not yet available in DSE 3.0.x

This is also noteworthy, but is not related to my problem: < P> Even in datastacks community edition - one needs to activate CQL3. The documentation says that it should be active in cqlsh by default. Activate CQL 3 You enable CQL mode in one of these ways:

  • Use the Datacax Java Driver to activate the CQL through the Basic / Binary Protocol. Start Cqlsh, a Python-based command-line client.
  • set_sql_version Use the Thief method. Specify the desired cql mode in the
  • Python Driver Connect () call: * connection = cql.connect ('localhost: 9160', cql_version = '3.0') * < / Ul>

    The document was also wrong there, should be

      con = cql.connect ('localhost', cql_version = '3.0.0')   

    In addition, the enterprise upstarter does not yet support CQL 3 in DSE.

      cqlsh - cqlversion = 3    

No comments:

Post a Comment