You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Radim Kolar (Created) (JIRA)" <ji...@apache.org> on 2011/10/04 14:53:34 UTC

[jira] [Created] (CASSANDRA-3304) Missing fields in show schema output

Missing fields in show schema output
------------------------------------

                 Key: CASSANDRA-3304
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-3304
             Project: Cassandra
          Issue Type: Bug
          Components: Core
    Affects Versions: 1.0.0
            Reporter: Radim Kolar
            Priority: Minor


if you compare output of these 2 commands:

*show keyspaces*
Keyspace: test:
  Replication Strategy: org.apache.cassandra.locator.SimpleStrategy
  Durable Writes: true
    Options: [replication_factor:1]
  Column Families:
    ColumnFamily: sipdb
    "phone calls routing information"
      Key Validation Class: org.apache.cassandra.db.marshal.IntegerType
      Default column value validator: org.apache.cassandra.db.marshal.BytesType
      Columns sorted by: org.apache.cassandra.db.marshal.AsciiType
      Row cache size / save period in seconds / keys to save : 0.0/0/all
      Key cache size / save period in seconds: 0.0/0
      GC grace seconds: 0
      Compaction min/max thresholds: 4/32
      Read repair chance: 0.0
      Replicate on write: false
      Built indexes: []
      Column Metadata:
        Column Name: kam
          Validation Class: org.apache.cassandra.db.marshal.AsciiType
      *Compaction Strategy: org.apache.cassandra.db.compaction.SizeTieredCompacti*

*show schema*
create column family sipdb
  with column_type = 'Standard'
  and comparator = 'AsciiType'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'IntegerType'
  and rows_cached = 0.0
  and row_cache_save_period = 0
  and keys_cached = 0.0
  and key_cache_save_period = 0
  and read_repair_chance = 0.0
  and gc_grace = 0
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = false
  and row_cache_provider = 'ConcurrentLinkedHashCacheProvider'
  and comment = 'phone calls routing information'
  and column_metadata = [
    {column_name : 'kam',
    validation_class : AsciiType}];

You will discover that show schema is missing: 1. compaction strategy. 2. how many keys to save

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Updated] (CASSANDRA-3304) Missing fields in show schema output

Posted by "Jonathan Ellis (Updated) (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/CASSANDRA-3304?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jonathan Ellis updated CASSANDRA-3304:
--------------------------------------

      Component/s:     (was: Core)
                   Tools
    Fix Version/s: 1.0.0
         Assignee: Pavel Yaskevich

also durable writes
                
> Missing fields in show schema output
> ------------------------------------
>
>                 Key: CASSANDRA-3304
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-3304
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Tools
>    Affects Versions: 1.0.0
>            Reporter: Radim Kolar
>            Assignee: Pavel Yaskevich
>            Priority: Minor
>             Fix For: 1.0.0
>
>
> if you compare output of these 2 commands:
> *show keyspaces*
> Keyspace: test:
>   Replication Strategy: org.apache.cassandra.locator.SimpleStrategy
>   Durable Writes: true
>     Options: [replication_factor:1]
>   Column Families:
>     ColumnFamily: sipdb
>     "phone calls routing information"
>       Key Validation Class: org.apache.cassandra.db.marshal.IntegerType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.AsciiType
>       Row cache size / save period in seconds / keys to save : 0.0/0/all
>       Key cache size / save period in seconds: 0.0/0
>       GC grace seconds: 0
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 0.0
>       Replicate on write: false
>       Built indexes: []
>       Column Metadata:
>         Column Name: kam
>           Validation Class: org.apache.cassandra.db.marshal.AsciiType
>       *Compaction Strategy: org.apache.cassandra.db.compaction.SizeTieredCompacti*
> *show schema*
> create column family sipdb
>   with column_type = 'Standard'
>   and comparator = 'AsciiType'
>   and default_validation_class = 'BytesType'
>   and key_validation_class = 'IntegerType'
>   and rows_cached = 0.0
>   and row_cache_save_period = 0
>   and keys_cached = 0.0
>   and key_cache_save_period = 0
>   and read_repair_chance = 0.0
>   and gc_grace = 0
>   and min_compaction_threshold = 4
>   and max_compaction_threshold = 32
>   and replicate_on_write = false
>   and row_cache_provider = 'ConcurrentLinkedHashCacheProvider'
>   and comment = 'phone calls routing information'
>   and column_metadata = [
>     {column_name : 'kam',
>     validation_class : AsciiType}];
> You will discover that show schema is missing: 1. compaction strategy. 2. how many keys to save

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Commented] (CASSANDRA-3304) Missing fields in show schema output

Posted by "Hudson (Commented) (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/CASSANDRA-3304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13121450#comment-13121450 ] 

Hudson commented on CASSANDRA-3304:
-----------------------------------

Integrated in Cassandra-0.8 #365 (See [https://builds.apache.org/job/Cassandra-0.8/365/])
    Fix missing fields in CLI `show schema` output
patch by Pavel Yaskevich; reviewed by Jonathan Ellis for CASSANDRA-3304

xedin : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1179395
Files : 
* /cassandra/branches/cassandra-0.8/src/java/org/apache/cassandra/cli/CliClient.java

                
> Missing fields in show schema output
> ------------------------------------
>
>                 Key: CASSANDRA-3304
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-3304
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Tools
>    Affects Versions: 1.0.0
>            Reporter: Radim Kolar
>            Assignee: Pavel Yaskevich
>            Priority: Minor
>             Fix For: 1.0.0
>
>         Attachments: CASSANDRA-3304.patch
>
>
> if you compare output of these 2 commands:
> *show keyspaces*
> Keyspace: test:
>   Replication Strategy: org.apache.cassandra.locator.SimpleStrategy
>   Durable Writes: true
>     Options: [replication_factor:1]
>   Column Families:
>     ColumnFamily: sipdb
>     "phone calls routing information"
>       Key Validation Class: org.apache.cassandra.db.marshal.IntegerType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.AsciiType
>       Row cache size / save period in seconds / keys to save : 0.0/0/all
>       Key cache size / save period in seconds: 0.0/0
>       GC grace seconds: 0
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 0.0
>       Replicate on write: false
>       Built indexes: []
>       Column Metadata:
>         Column Name: kam
>           Validation Class: org.apache.cassandra.db.marshal.AsciiType
>       *Compaction Strategy: org.apache.cassandra.db.compaction.SizeTieredCompacti*
> *show schema*
> create column family sipdb
>   with column_type = 'Standard'
>   and comparator = 'AsciiType'
>   and default_validation_class = 'BytesType'
>   and key_validation_class = 'IntegerType'
>   and rows_cached = 0.0
>   and row_cache_save_period = 0
>   and keys_cached = 0.0
>   and key_cache_save_period = 0
>   and read_repair_chance = 0.0
>   and gc_grace = 0
>   and min_compaction_threshold = 4
>   and max_compaction_threshold = 32
>   and replicate_on_write = false
>   and row_cache_provider = 'ConcurrentLinkedHashCacheProvider'
>   and comment = 'phone calls routing information'
>   and column_metadata = [
>     {column_name : 'kam',
>     validation_class : AsciiType}];
> You will discover that show schema is missing: 1. compaction strategy. 2. how many keys to save

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Commented] (CASSANDRA-3304) Missing fields in show schema output

Posted by "Jonathan Ellis (Commented) (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/CASSANDRA-3304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13120224#comment-13120224 ] 

Jonathan Ellis commented on CASSANDRA-3304:
-------------------------------------------

+1
                
> Missing fields in show schema output
> ------------------------------------
>
>                 Key: CASSANDRA-3304
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-3304
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Tools
>    Affects Versions: 1.0.0
>            Reporter: Radim Kolar
>            Assignee: Pavel Yaskevich
>            Priority: Minor
>             Fix For: 1.0.0
>
>         Attachments: CASSANDRA-3304.patch
>
>
> if you compare output of these 2 commands:
> *show keyspaces*
> Keyspace: test:
>   Replication Strategy: org.apache.cassandra.locator.SimpleStrategy
>   Durable Writes: true
>     Options: [replication_factor:1]
>   Column Families:
>     ColumnFamily: sipdb
>     "phone calls routing information"
>       Key Validation Class: org.apache.cassandra.db.marshal.IntegerType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.AsciiType
>       Row cache size / save period in seconds / keys to save : 0.0/0/all
>       Key cache size / save period in seconds: 0.0/0
>       GC grace seconds: 0
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 0.0
>       Replicate on write: false
>       Built indexes: []
>       Column Metadata:
>         Column Name: kam
>           Validation Class: org.apache.cassandra.db.marshal.AsciiType
>       *Compaction Strategy: org.apache.cassandra.db.compaction.SizeTieredCompacti*
> *show schema*
> create column family sipdb
>   with column_type = 'Standard'
>   and comparator = 'AsciiType'
>   and default_validation_class = 'BytesType'
>   and key_validation_class = 'IntegerType'
>   and rows_cached = 0.0
>   and row_cache_save_period = 0
>   and keys_cached = 0.0
>   and key_cache_save_period = 0
>   and read_repair_chance = 0.0
>   and gc_grace = 0
>   and min_compaction_threshold = 4
>   and max_compaction_threshold = 32
>   and replicate_on_write = false
>   and row_cache_provider = 'ConcurrentLinkedHashCacheProvider'
>   and comment = 'phone calls routing information'
>   and column_metadata = [
>     {column_name : 'kam',
>     validation_class : AsciiType}];
> You will discover that show schema is missing: 1. compaction strategy. 2. how many keys to save

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Commented] (CASSANDRA-3304) Missing fields in show schema output

Posted by "Pavel Yaskevich (Commented) (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/CASSANDRA-3304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13121387#comment-13121387 ] 

Pavel Yaskevich commented on CASSANDRA-3304:
--------------------------------------------

Done, that was only "durable_writes".
                
> Missing fields in show schema output
> ------------------------------------
>
>                 Key: CASSANDRA-3304
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-3304
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Tools
>    Affects Versions: 1.0.0
>            Reporter: Radim Kolar
>            Assignee: Pavel Yaskevich
>            Priority: Minor
>             Fix For: 1.0.0
>
>         Attachments: CASSANDRA-3304.patch
>
>
> if you compare output of these 2 commands:
> *show keyspaces*
> Keyspace: test:
>   Replication Strategy: org.apache.cassandra.locator.SimpleStrategy
>   Durable Writes: true
>     Options: [replication_factor:1]
>   Column Families:
>     ColumnFamily: sipdb
>     "phone calls routing information"
>       Key Validation Class: org.apache.cassandra.db.marshal.IntegerType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.AsciiType
>       Row cache size / save period in seconds / keys to save : 0.0/0/all
>       Key cache size / save period in seconds: 0.0/0
>       GC grace seconds: 0
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 0.0
>       Replicate on write: false
>       Built indexes: []
>       Column Metadata:
>         Column Name: kam
>           Validation Class: org.apache.cassandra.db.marshal.AsciiType
>       *Compaction Strategy: org.apache.cassandra.db.compaction.SizeTieredCompacti*
> *show schema*
> create column family sipdb
>   with column_type = 'Standard'
>   and comparator = 'AsciiType'
>   and default_validation_class = 'BytesType'
>   and key_validation_class = 'IntegerType'
>   and rows_cached = 0.0
>   and row_cache_save_period = 0
>   and keys_cached = 0.0
>   and key_cache_save_period = 0
>   and read_repair_chance = 0.0
>   and gc_grace = 0
>   and min_compaction_threshold = 4
>   and max_compaction_threshold = 32
>   and replicate_on_write = false
>   and row_cache_provider = 'ConcurrentLinkedHashCacheProvider'
>   and comment = 'phone calls routing information'
>   and column_metadata = [
>     {column_name : 'kam',
>     validation_class : AsciiType}];
> You will discover that show schema is missing: 1. compaction strategy. 2. how many keys to save

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Commented] (CASSANDRA-3304) Missing fields in show schema output

Posted by "Jonathan Ellis (Commented) (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/CASSANDRA-3304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13121375#comment-13121375 ] 

Jonathan Ellis commented on CASSANDRA-3304:
-------------------------------------------

Pavel, can you commit the relevant parts to 0.8 as well?  (My fault for not tagging this 0.8.7 originally.)
                
> Missing fields in show schema output
> ------------------------------------
>
>                 Key: CASSANDRA-3304
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-3304
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Tools
>    Affects Versions: 1.0.0
>            Reporter: Radim Kolar
>            Assignee: Pavel Yaskevich
>            Priority: Minor
>             Fix For: 1.0.0
>
>         Attachments: CASSANDRA-3304.patch
>
>
> if you compare output of these 2 commands:
> *show keyspaces*
> Keyspace: test:
>   Replication Strategy: org.apache.cassandra.locator.SimpleStrategy
>   Durable Writes: true
>     Options: [replication_factor:1]
>   Column Families:
>     ColumnFamily: sipdb
>     "phone calls routing information"
>       Key Validation Class: org.apache.cassandra.db.marshal.IntegerType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.AsciiType
>       Row cache size / save period in seconds / keys to save : 0.0/0/all
>       Key cache size / save period in seconds: 0.0/0
>       GC grace seconds: 0
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 0.0
>       Replicate on write: false
>       Built indexes: []
>       Column Metadata:
>         Column Name: kam
>           Validation Class: org.apache.cassandra.db.marshal.AsciiType
>       *Compaction Strategy: org.apache.cassandra.db.compaction.SizeTieredCompacti*
> *show schema*
> create column family sipdb
>   with column_type = 'Standard'
>   and comparator = 'AsciiType'
>   and default_validation_class = 'BytesType'
>   and key_validation_class = 'IntegerType'
>   and rows_cached = 0.0
>   and row_cache_save_period = 0
>   and keys_cached = 0.0
>   and key_cache_save_period = 0
>   and read_repair_chance = 0.0
>   and gc_grace = 0
>   and min_compaction_threshold = 4
>   and max_compaction_threshold = 32
>   and replicate_on_write = false
>   and row_cache_provider = 'ConcurrentLinkedHashCacheProvider'
>   and comment = 'phone calls routing information'
>   and column_metadata = [
>     {column_name : 'kam',
>     validation_class : AsciiType}];
> You will discover that show schema is missing: 1. compaction strategy. 2. how many keys to save

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Updated] (CASSANDRA-3304) Missing fields in show schema output

Posted by "Pavel Yaskevich (Updated) (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/CASSANDRA-3304?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Pavel Yaskevich updated CASSANDRA-3304:
---------------------------------------

    Attachment: CASSANDRA-3304.patch
    
> Missing fields in show schema output
> ------------------------------------
>
>                 Key: CASSANDRA-3304
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-3304
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Tools
>    Affects Versions: 1.0.0
>            Reporter: Radim Kolar
>            Assignee: Pavel Yaskevich
>            Priority: Minor
>             Fix For: 1.0.0
>
>         Attachments: CASSANDRA-3304.patch
>
>
> if you compare output of these 2 commands:
> *show keyspaces*
> Keyspace: test:
>   Replication Strategy: org.apache.cassandra.locator.SimpleStrategy
>   Durable Writes: true
>     Options: [replication_factor:1]
>   Column Families:
>     ColumnFamily: sipdb
>     "phone calls routing information"
>       Key Validation Class: org.apache.cassandra.db.marshal.IntegerType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.AsciiType
>       Row cache size / save period in seconds / keys to save : 0.0/0/all
>       Key cache size / save period in seconds: 0.0/0
>       GC grace seconds: 0
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 0.0
>       Replicate on write: false
>       Built indexes: []
>       Column Metadata:
>         Column Name: kam
>           Validation Class: org.apache.cassandra.db.marshal.AsciiType
>       *Compaction Strategy: org.apache.cassandra.db.compaction.SizeTieredCompacti*
> *show schema*
> create column family sipdb
>   with column_type = 'Standard'
>   and comparator = 'AsciiType'
>   and default_validation_class = 'BytesType'
>   and key_validation_class = 'IntegerType'
>   and rows_cached = 0.0
>   and row_cache_save_period = 0
>   and keys_cached = 0.0
>   and key_cache_save_period = 0
>   and read_repair_chance = 0.0
>   and gc_grace = 0
>   and min_compaction_threshold = 4
>   and max_compaction_threshold = 32
>   and replicate_on_write = false
>   and row_cache_provider = 'ConcurrentLinkedHashCacheProvider'
>   and comment = 'phone calls routing information'
>   and column_metadata = [
>     {column_name : 'kam',
>     validation_class : AsciiType}];
> You will discover that show schema is missing: 1. compaction strategy. 2. how many keys to save

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira