cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jonathan Ellis (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (CASSANDRA-5246) Tables Created via CQL Not Visible in CLI
Date Tue, 12 Feb 2013 22:09:14 GMT

     [ https://issues.apache.org/jira/browse/CASSANDRA-5246?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Jonathan Ellis resolved CASSANDRA-5246.
---------------------------------------

    Resolution: Not A Problem

This is by design.  CLI and Thrift-based consumers in general do not know how to understand
CQL3 metadata, and would do the Wrong Thing without realizing it.
                
> Tables Created via CQL Not Visible in CLI
> -----------------------------------------
>
>                 Key: CASSANDRA-5246
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-5246
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Core
>    Affects Versions: 1.2.1
>            Reporter: Russell Bradberry
>
> When creating tables in CQL, the tables do not show up in the `show schema` command in
the cli.
> To recreate:
> {code}
> $ cqlsh -3
> Connected to Test Cluster at localhost:9160.
> [cqlsh 2.3.0 | Cassandra 1.2.1 | CQL spec 3.0.0 | Thrift protocol 19.35.0]
> Use HELP for help.
> cqlsh> CREATE KEYSPACE my_test WITH replication = { 'class': 'NetworkTopologyStrategy',
 'datacenter1': '1' };
> cqlsh> USE my_test;
> cqlsh:my_test> CREATE TABLE lolwut ( col1 text, col2 text, col3 text, PRIMARY KEY
(col1));
> cqlsh:my_test> DESCRIBE TABLES;
> lolwut
> cqlsh:my_test> exit
> $ cassandra-cli -k my_test;
> Connected to: "Test Cluster" on 127.0.0.1/9160
> Welcome to Cassandra CLI version 1.2.1
> Type 'help;' or '?' for help.
> Type 'quit;' or 'exit;' to quit.
> [default@my_test] show schema;
> create keyspace my_test
>   with placement_strategy = 'NetworkTopologyStrategy'
>   and strategy_options = {datacenter1 : 1}
>   and durable_writes = true;
> use my_test;
> [default@my_test] list lolwut;
> Using default limit of 100
> Using default column limit of 100
> 0 Row Returned.
> Elapsed time: 21 msec(s).
> [default@my_test] describe lolwut;
>     ColumnFamily: lolwut
>       Key Validation Class: org.apache.cassandra.db.marshal.UTF8Type
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.CompositeType(org.apache.cassandra.db.marshal.UTF8Type)
>       GC grace seconds: 0
>       Compaction min/max thresholds: 0/0
>       Read repair chance: 0.0
>       DC Local Read repair chance: 0.0
>       Replicate on write: false
>       Caching: keys_only
>       Bloom Filter FP chance: default
>       Built indexes: []
>       Compaction Strategy: null
> {code}

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message