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