[
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
