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

Russell Bradberry updated CASSANDRA-5246:
-----------------------------------------

    Description: 
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}


  was:
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.0 | 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}


    
> 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

Reply via email to