You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Silvère Lestang (JIRA)" <ji...@apache.org> on 2011/06/22 14:54:54 UTC

[jira] [Created] (CASSANDRA-2809) In the Cli, update column family with comparator; create Column metadata

In the Cli, update column family <cf> with comparator; create Column metadata
-----------------------------------------------------------------------------

                 Key: CASSANDRA-2809
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-2809
             Project: Cassandra
          Issue Type: Bug
          Components: Tools
    Affects Versions: 0.8.1
         Environment: Ubuntu 10.10, 32bit
java version "1.6.0_24"
installed from Debian packages of Brisk-beta2
            Reporter: Silvère Lestang


Using cassandra-cli, I can't update the comparator of a column family with the type I want and when I did it with BytesType, Column metadata appear for each of my existing columns.
Step to reproduce:
{code}
[default@unknown] create keyspace Test
    with placement_strategy = 'org.apache.cassandra.locator.SimpleStrategy'
    and strategy_options = [{replication_factor:1}];

[default@unknown] use Test;
Authenticated to keyspace: Test

[default@Test] create column family test;

[default@Test] describe keyspace;
...
    ColumnFamily: test
      Key Validation Class: org.apache.cassandra.db.marshal.BytesType
      Default column value validator: org.apache.cassandra.db.marshal.BytesType
      Columns sorted by: org.apache.cassandra.db.marshal.BytesType
      Row cache size / save period in seconds: 0.0/0
      Key cache size / save period in seconds: 200000.0/14400
      Memtable thresholds: 0.571875/122/1440 (millions of ops/MB/minutes)
      GC grace seconds: 864000
      Compaction min/max thresholds: 4/32
      Read repair chance: 1.0
      Replicate on write: false
      Built indexes: []
...

[default@Test] update column family test with comparator = 'LongType';
comparators do not match.
{code}
why?? the CF is empty
{code}
[default@Test] update column family test with comparator = 'BytesType';
f8e4dcb0-9cca-11e0-0000-d0583497e7ff
Waiting for schema agreement...
... schemas agree across the cluster

[default@Test] describe keyspace;
...
    ColumnFamily: test
      Key Validation Class: org.apache.cassandra.db.marshal.BytesType
      Default column value validator: org.apache.cassandra.db.marshal.BytesType
      Columns sorted by: org.apache.cassandra.db.marshal.BytesType
      Row cache size / save period in seconds: 0.0/0
      Key cache size / save period in seconds: 200000.0/14400
      Memtable thresholds: 0.571875/122/1440 (millions of ops/MB/minutes)
      GC grace seconds: 864000
      Compaction min/max thresholds: 4/32
      Read repair chance: 1.0
      Replicate on write: false
      Built indexes: []
...

[default@Test] set test[ascii('row1')][long(1)]=integer(35);
set test[ascii('row1')][long(2)]=integer(36);
set test[ascii('row1')][long(3)]=integer(38);
set test[ascii('row2')][long(1)]=integer(45);
set test[ascii('row2')][long(2)]=integer(42);
set test[ascii('row2')][long(3)]=integer(33);

[default@Test] list test;
Using default limit of 100
-------------------
RowKey: 726f7731
=> (column=0000000000000001, value=35, timestamp=1308744931122000)
=> (column=0000000000000002, value=36, timestamp=1308744931124000)
=> (column=0000000000000003, value=38, timestamp=1308744931125000)
-------------------
RowKey: 726f7732
=> (column=0000000000000001, value=45, timestamp=1308744931127000)
=> (column=0000000000000002, value=42, timestamp=1308744931128000)
=> (column=0000000000000003, value=33, timestamp=1308744932722000)

2 Rows Returned.

[default@Test] update column family test with comparator = 'LongType';
comparators do not match.
{code}
same question than before, my columns contains only long, why I can't?

{code}
[default@Test] update column family test with comparator = 'BytesType';

[default@Test] describe keyspace;                                      
Keyspace: Test:
  Replication Strategy: org.apache.cassandra.locator.SimpleStrategy
    Options: [replication_factor:1]
  Column Families:
    ColumnFamily: test
      Key Validation Class: org.apache.cassandra.db.marshal.BytesType
      Default column value validator: org.apache.cassandra.db.marshal.BytesType
      Columns sorted by: org.apache.cassandra.db.marshal.BytesType
      Row cache size / save period in seconds: 0.0/0
      Key cache size / save period in seconds: 200000.0/14400
      Memtable thresholds: 0.571875/122/1440 (millions of ops/MB/minutes)
      GC grace seconds: 864000
      Compaction min/max thresholds: 4/32
      Read repair chance: 1.0
      Replicate on write: false
      Built indexes: []
      Column Metadata:
        Column Name:  (0000000000000001)
          Validation Class: org.apache.cassandra.db.marshal.IntegerType
        Column Name:  (0000000000000003)
          Validation Class: org.apache.cassandra.db.marshal.IntegerType
        Column Name:  (0000000000000002)
          Validation Class: org.apache.cassandra.db.marshal.IntegerType
{code}
Column Metadata appear from nowhere. I don't think that it's expected.


--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

[jira] [Commented] (CASSANDRA-2809) In the Cli, update column family with comparator; create Column metadata

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

Jonathan Ellis commented on CASSANDRA-2809:
-------------------------------------------

To make sure we're on the same page, here's what I'm talking about:

{noformat}
      Column Metadata:
        Column Name:  (0000000000000001)
          Validation Class: org.apache.cassandra.db.marshal.IntegerType
        Column Name:  (0000000000000003)
{noformat}

We shouldn't be persisting that or showing it to the user as part of describe keyspace.

> In the Cli, update column family <cf> with comparator; create Column metadata
> -----------------------------------------------------------------------------
>
>                 Key: CASSANDRA-2809
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-2809
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Tools
>         Environment: Ubuntu 10.10, 32bit
> java version "1.6.0_24"
> installed from Debian packages of Brisk-beta2
>            Reporter: Silvère Lestang
>            Assignee: Pavel Yaskevich
>            Priority: Minor
>             Fix For: 0.8.2
>
>         Attachments: 2809-validate.txt
>
>
> Using cassandra-cli, I can't update the comparator of a column family with the type I want and when I did it with BytesType, Column metadata appear for each of my existing columns.
> Step to reproduce:
> {code}
> [default@unknown] create keyspace Test
>     with placement_strategy = 'org.apache.cassandra.locator.SimpleStrategy'
>     and strategy_options = [{replication_factor:1}];
> [default@unknown] use Test;
> Authenticated to keyspace: Test
> [default@Test] create column family test;
> [default@Test] describe keyspace;
> ...
>     ColumnFamily: test
>       Key Validation Class: org.apache.cassandra.db.marshal.BytesType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.BytesType
>       Row cache size / save period in seconds: 0.0/0
>       Key cache size / save period in seconds: 200000.0/14400
>       Memtable thresholds: 0.571875/122/1440 (millions of ops/MB/minutes)
>       GC grace seconds: 864000
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 1.0
>       Replicate on write: false
>       Built indexes: []
> ...
> [default@Test] update column family test with comparator = 'LongType';
> comparators do not match.
> {code}
> why?? the CF is empty
> {code}
> [default@Test] update column family test with comparator = 'BytesType';
> f8e4dcb0-9cca-11e0-0000-d0583497e7ff
> Waiting for schema agreement...
> ... schemas agree across the cluster
> [default@Test] describe keyspace;
> ...
>     ColumnFamily: test
>       Key Validation Class: org.apache.cassandra.db.marshal.BytesType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.BytesType
>       Row cache size / save period in seconds: 0.0/0
>       Key cache size / save period in seconds: 200000.0/14400
>       Memtable thresholds: 0.571875/122/1440 (millions of ops/MB/minutes)
>       GC grace seconds: 864000
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 1.0
>       Replicate on write: false
>       Built indexes: []
> ...
> [default@Test] set test[ascii('row1')][long(1)]=integer(35);
> set test[ascii('row1')][long(2)]=integer(36);
> set test[ascii('row1')][long(3)]=integer(38);
> set test[ascii('row2')][long(1)]=integer(45);
> set test[ascii('row2')][long(2)]=integer(42);
> set test[ascii('row2')][long(3)]=integer(33);
> [default@Test] list test;
> Using default limit of 100
> -------------------
> RowKey: 726f7731
> => (column=0000000000000001, value=35, timestamp=1308744931122000)
> => (column=0000000000000002, value=36, timestamp=1308744931124000)
> => (column=0000000000000003, value=38, timestamp=1308744931125000)
> -------------------
> RowKey: 726f7732
> => (column=0000000000000001, value=45, timestamp=1308744931127000)
> => (column=0000000000000002, value=42, timestamp=1308744931128000)
> => (column=0000000000000003, value=33, timestamp=1308744932722000)
> 2 Rows Returned.
> [default@Test] update column family test with comparator = 'LongType';
> comparators do not match.
> {code}
> same question than before, my columns contains only long, why I can't?
> {code}
> [default@Test] update column family test with comparator = 'BytesType';
> [default@Test] describe keyspace;                                      
> Keyspace: Test:
>   Replication Strategy: org.apache.cassandra.locator.SimpleStrategy
>     Options: [replication_factor:1]
>   Column Families:
>     ColumnFamily: test
>       Key Validation Class: org.apache.cassandra.db.marshal.BytesType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.BytesType
>       Row cache size / save period in seconds: 0.0/0
>       Key cache size / save period in seconds: 200000.0/14400
>       Memtable thresholds: 0.571875/122/1440 (millions of ops/MB/minutes)
>       GC grace seconds: 864000
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 1.0
>       Replicate on write: false
>       Built indexes: []
>       Column Metadata:
>         Column Name:  (0000000000000001)
>           Validation Class: org.apache.cassandra.db.marshal.IntegerType
>         Column Name:  (0000000000000003)
>           Validation Class: org.apache.cassandra.db.marshal.IntegerType
>         Column Name:  (0000000000000002)
>           Validation Class: org.apache.cassandra.db.marshal.IntegerType
> {code}
> Column Metadata appear from nowhere. I don't think that it's expected.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

[jira] [Updated] (CASSANDRA-2809) In the Cli, update column family with comparator; create Column metadata

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

Jonathan Ellis updated CASSANDRA-2809:
--------------------------------------

    Attachment: 2809-validate.txt

Noticed that update_cf doesn't validate the given CFMetaData.  patch to add this.  (Does not address the column_metadata problem.)

> In the Cli, update column family <cf> with comparator; create Column metadata
> -----------------------------------------------------------------------------
>
>                 Key: CASSANDRA-2809
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-2809
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Tools
>         Environment: Ubuntu 10.10, 32bit
> java version "1.6.0_24"
> installed from Debian packages of Brisk-beta2
>            Reporter: Silvère Lestang
>            Assignee: Pavel Yaskevich
>            Priority: Minor
>             Fix For: 0.8.2
>
>         Attachments: 2809-validate.txt
>
>
> Using cassandra-cli, I can't update the comparator of a column family with the type I want and when I did it with BytesType, Column metadata appear for each of my existing columns.
> Step to reproduce:
> {code}
> [default@unknown] create keyspace Test
>     with placement_strategy = 'org.apache.cassandra.locator.SimpleStrategy'
>     and strategy_options = [{replication_factor:1}];
> [default@unknown] use Test;
> Authenticated to keyspace: Test
> [default@Test] create column family test;
> [default@Test] describe keyspace;
> ...
>     ColumnFamily: test
>       Key Validation Class: org.apache.cassandra.db.marshal.BytesType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.BytesType
>       Row cache size / save period in seconds: 0.0/0
>       Key cache size / save period in seconds: 200000.0/14400
>       Memtable thresholds: 0.571875/122/1440 (millions of ops/MB/minutes)
>       GC grace seconds: 864000
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 1.0
>       Replicate on write: false
>       Built indexes: []
> ...
> [default@Test] update column family test with comparator = 'LongType';
> comparators do not match.
> {code}
> why?? the CF is empty
> {code}
> [default@Test] update column family test with comparator = 'BytesType';
> f8e4dcb0-9cca-11e0-0000-d0583497e7ff
> Waiting for schema agreement...
> ... schemas agree across the cluster
> [default@Test] describe keyspace;
> ...
>     ColumnFamily: test
>       Key Validation Class: org.apache.cassandra.db.marshal.BytesType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.BytesType
>       Row cache size / save period in seconds: 0.0/0
>       Key cache size / save period in seconds: 200000.0/14400
>       Memtable thresholds: 0.571875/122/1440 (millions of ops/MB/minutes)
>       GC grace seconds: 864000
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 1.0
>       Replicate on write: false
>       Built indexes: []
> ...
> [default@Test] set test[ascii('row1')][long(1)]=integer(35);
> set test[ascii('row1')][long(2)]=integer(36);
> set test[ascii('row1')][long(3)]=integer(38);
> set test[ascii('row2')][long(1)]=integer(45);
> set test[ascii('row2')][long(2)]=integer(42);
> set test[ascii('row2')][long(3)]=integer(33);
> [default@Test] list test;
> Using default limit of 100
> -------------------
> RowKey: 726f7731
> => (column=0000000000000001, value=35, timestamp=1308744931122000)
> => (column=0000000000000002, value=36, timestamp=1308744931124000)
> => (column=0000000000000003, value=38, timestamp=1308744931125000)
> -------------------
> RowKey: 726f7732
> => (column=0000000000000001, value=45, timestamp=1308744931127000)
> => (column=0000000000000002, value=42, timestamp=1308744931128000)
> => (column=0000000000000003, value=33, timestamp=1308744932722000)
> 2 Rows Returned.
> [default@Test] update column family test with comparator = 'LongType';
> comparators do not match.
> {code}
> same question than before, my columns contains only long, why I can't?
> {code}
> [default@Test] update column family test with comparator = 'BytesType';
> [default@Test] describe keyspace;                                      
> Keyspace: Test:
>   Replication Strategy: org.apache.cassandra.locator.SimpleStrategy
>     Options: [replication_factor:1]
>   Column Families:
>     ColumnFamily: test
>       Key Validation Class: org.apache.cassandra.db.marshal.BytesType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.BytesType
>       Row cache size / save period in seconds: 0.0/0
>       Key cache size / save period in seconds: 200000.0/14400
>       Memtable thresholds: 0.571875/122/1440 (millions of ops/MB/minutes)
>       GC grace seconds: 864000
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 1.0
>       Replicate on write: false
>       Built indexes: []
>       Column Metadata:
>         Column Name:  (0000000000000001)
>           Validation Class: org.apache.cassandra.db.marshal.IntegerType
>         Column Name:  (0000000000000003)
>           Validation Class: org.apache.cassandra.db.marshal.IntegerType
>         Column Name:  (0000000000000002)
>           Validation Class: org.apache.cassandra.db.marshal.IntegerType
> {code}
> Column Metadata appear from nowhere. I don't think that it's expected.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

[jira] [Commented] (CASSANDRA-2809) In the Cli, update column family with comparator; create Column metadata

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

Pavel Yaskevich commented on CASSANDRA-2809:
--------------------------------------------

Describe too.

> In the Cli, update column family <cf> with comparator; create Column metadata
> -----------------------------------------------------------------------------
>
>                 Key: CASSANDRA-2809
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-2809
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Tools
>    Affects Versions: 0.7.6
>         Environment: Ubuntu 10.10, 32bit
> java version "1.6.0_24"
> installed from Debian packages of Brisk-beta2
>            Reporter: Silvère Lestang
>            Assignee: Pavel Yaskevich
>            Priority: Minor
>             Fix For: 0.7.8, 0.8.2
>
>         Attachments: 2809-validate.txt, CASSANDRA-2809.patch
>
>
> Using cassandra-cli, I can't update the comparator of a column family with the type I want and when I did it with BytesType, Column metadata appear for each of my existing columns.
> Step to reproduce:
> {code}
> [default@unknown] create keyspace Test
>     with placement_strategy = 'org.apache.cassandra.locator.SimpleStrategy'
>     and strategy_options = [{replication_factor:1}];
> [default@unknown] use Test;
> Authenticated to keyspace: Test
> [default@Test] create column family test;
> [default@Test] describe keyspace;
> ...
>     ColumnFamily: test
>       Key Validation Class: org.apache.cassandra.db.marshal.BytesType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.BytesType
>       Row cache size / save period in seconds: 0.0/0
>       Key cache size / save period in seconds: 200000.0/14400
>       Memtable thresholds: 0.571875/122/1440 (millions of ops/MB/minutes)
>       GC grace seconds: 864000
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 1.0
>       Replicate on write: false
>       Built indexes: []
> ...
> [default@Test] update column family test with comparator = 'LongType';
> comparators do not match.
> {code}
> why?? the CF is empty
> {code}
> [default@Test] update column family test with comparator = 'BytesType';
> f8e4dcb0-9cca-11e0-0000-d0583497e7ff
> Waiting for schema agreement...
> ... schemas agree across the cluster
> [default@Test] describe keyspace;
> ...
>     ColumnFamily: test
>       Key Validation Class: org.apache.cassandra.db.marshal.BytesType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.BytesType
>       Row cache size / save period in seconds: 0.0/0
>       Key cache size / save period in seconds: 200000.0/14400
>       Memtable thresholds: 0.571875/122/1440 (millions of ops/MB/minutes)
>       GC grace seconds: 864000
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 1.0
>       Replicate on write: false
>       Built indexes: []
> ...
> [default@Test] set test[ascii('row1')][long(1)]=integer(35);
> set test[ascii('row1')][long(2)]=integer(36);
> set test[ascii('row1')][long(3)]=integer(38);
> set test[ascii('row2')][long(1)]=integer(45);
> set test[ascii('row2')][long(2)]=integer(42);
> set test[ascii('row2')][long(3)]=integer(33);
> [default@Test] list test;
> Using default limit of 100
> -------------------
> RowKey: 726f7731
> => (column=0000000000000001, value=35, timestamp=1308744931122000)
> => (column=0000000000000002, value=36, timestamp=1308744931124000)
> => (column=0000000000000003, value=38, timestamp=1308744931125000)
> -------------------
> RowKey: 726f7732
> => (column=0000000000000001, value=45, timestamp=1308744931127000)
> => (column=0000000000000002, value=42, timestamp=1308744931128000)
> => (column=0000000000000003, value=33, timestamp=1308744932722000)
> 2 Rows Returned.
> [default@Test] update column family test with comparator = 'LongType';
> comparators do not match.
> {code}
> same question than before, my columns contains only long, why I can't?
> {code}
> [default@Test] update column family test with comparator = 'BytesType';
> [default@Test] describe keyspace;                                      
> Keyspace: Test:
>   Replication Strategy: org.apache.cassandra.locator.SimpleStrategy
>     Options: [replication_factor:1]
>   Column Families:
>     ColumnFamily: test
>       Key Validation Class: org.apache.cassandra.db.marshal.BytesType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.BytesType
>       Row cache size / save period in seconds: 0.0/0
>       Key cache size / save period in seconds: 200000.0/14400
>       Memtable thresholds: 0.571875/122/1440 (millions of ops/MB/minutes)
>       GC grace seconds: 864000
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 1.0
>       Replicate on write: false
>       Built indexes: []
>       Column Metadata:
>         Column Name:  (0000000000000001)
>           Validation Class: org.apache.cassandra.db.marshal.IntegerType
>         Column Name:  (0000000000000003)
>           Validation Class: org.apache.cassandra.db.marshal.IntegerType
>         Column Name:  (0000000000000002)
>           Validation Class: org.apache.cassandra.db.marshal.IntegerType
> {code}
> Column Metadata appear from nowhere. I don't think that it's expected.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

[jira] [Resolved] (CASSANDRA-2809) In the Cli, update column family with comparator; create Column metadata

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

Brandon Williams resolved CASSANDRA-2809.
-----------------------------------------

    Resolution: Fixed

Committed.

> In the Cli, update column family <cf> with comparator; create Column metadata
> -----------------------------------------------------------------------------
>
>                 Key: CASSANDRA-2809
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-2809
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Tools
>         Environment: Ubuntu 10.10, 32bit
> java version "1.6.0_24"
> installed from Debian packages of Brisk-beta2
>            Reporter: Silvère Lestang
>            Assignee: Pavel Yaskevich
>            Priority: Minor
>             Fix For: 0.8.2
>
>         Attachments: 2809-validate.txt
>
>
> Using cassandra-cli, I can't update the comparator of a column family with the type I want and when I did it with BytesType, Column metadata appear for each of my existing columns.
> Step to reproduce:
> {code}
> [default@unknown] create keyspace Test
>     with placement_strategy = 'org.apache.cassandra.locator.SimpleStrategy'
>     and strategy_options = [{replication_factor:1}];
> [default@unknown] use Test;
> Authenticated to keyspace: Test
> [default@Test] create column family test;
> [default@Test] describe keyspace;
> ...
>     ColumnFamily: test
>       Key Validation Class: org.apache.cassandra.db.marshal.BytesType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.BytesType
>       Row cache size / save period in seconds: 0.0/0
>       Key cache size / save period in seconds: 200000.0/14400
>       Memtable thresholds: 0.571875/122/1440 (millions of ops/MB/minutes)
>       GC grace seconds: 864000
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 1.0
>       Replicate on write: false
>       Built indexes: []
> ...
> [default@Test] update column family test with comparator = 'LongType';
> comparators do not match.
> {code}
> why?? the CF is empty
> {code}
> [default@Test] update column family test with comparator = 'BytesType';
> f8e4dcb0-9cca-11e0-0000-d0583497e7ff
> Waiting for schema agreement...
> ... schemas agree across the cluster
> [default@Test] describe keyspace;
> ...
>     ColumnFamily: test
>       Key Validation Class: org.apache.cassandra.db.marshal.BytesType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.BytesType
>       Row cache size / save period in seconds: 0.0/0
>       Key cache size / save period in seconds: 200000.0/14400
>       Memtable thresholds: 0.571875/122/1440 (millions of ops/MB/minutes)
>       GC grace seconds: 864000
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 1.0
>       Replicate on write: false
>       Built indexes: []
> ...
> [default@Test] set test[ascii('row1')][long(1)]=integer(35);
> set test[ascii('row1')][long(2)]=integer(36);
> set test[ascii('row1')][long(3)]=integer(38);
> set test[ascii('row2')][long(1)]=integer(45);
> set test[ascii('row2')][long(2)]=integer(42);
> set test[ascii('row2')][long(3)]=integer(33);
> [default@Test] list test;
> Using default limit of 100
> -------------------
> RowKey: 726f7731
> => (column=0000000000000001, value=35, timestamp=1308744931122000)
> => (column=0000000000000002, value=36, timestamp=1308744931124000)
> => (column=0000000000000003, value=38, timestamp=1308744931125000)
> -------------------
> RowKey: 726f7732
> => (column=0000000000000001, value=45, timestamp=1308744931127000)
> => (column=0000000000000002, value=42, timestamp=1308744931128000)
> => (column=0000000000000003, value=33, timestamp=1308744932722000)
> 2 Rows Returned.
> [default@Test] update column family test with comparator = 'LongType';
> comparators do not match.
> {code}
> same question than before, my columns contains only long, why I can't?
> {code}
> [default@Test] update column family test with comparator = 'BytesType';
> [default@Test] describe keyspace;                                      
> Keyspace: Test:
>   Replication Strategy: org.apache.cassandra.locator.SimpleStrategy
>     Options: [replication_factor:1]
>   Column Families:
>     ColumnFamily: test
>       Key Validation Class: org.apache.cassandra.db.marshal.BytesType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.BytesType
>       Row cache size / save period in seconds: 0.0/0
>       Key cache size / save period in seconds: 200000.0/14400
>       Memtable thresholds: 0.571875/122/1440 (millions of ops/MB/minutes)
>       GC grace seconds: 864000
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 1.0
>       Replicate on write: false
>       Built indexes: []
>       Column Metadata:
>         Column Name:  (0000000000000001)
>           Validation Class: org.apache.cassandra.db.marshal.IntegerType
>         Column Name:  (0000000000000003)
>           Validation Class: org.apache.cassandra.db.marshal.IntegerType
>         Column Name:  (0000000000000002)
>           Validation Class: org.apache.cassandra.db.marshal.IntegerType
> {code}
> Column Metadata appear from nowhere. I don't think that it's expected.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

[jira] [Commented] (CASSANDRA-2809) In the Cli, update column family with comparator; create Column metadata

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

Pavel Yaskevich commented on CASSANDRA-2809:
--------------------------------------------

That column metadata is a feature: when you use a function call in SET statement it is storing information about validation class for individual columns locally (without sync with server) that was added in context of CASSANDRA-1635. 

+1 of validate patch.

> In the Cli, update column family <cf> with comparator; create Column metadata
> -----------------------------------------------------------------------------
>
>                 Key: CASSANDRA-2809
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-2809
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Tools
>         Environment: Ubuntu 10.10, 32bit
> java version "1.6.0_24"
> installed from Debian packages of Brisk-beta2
>            Reporter: Silvère Lestang
>            Assignee: Pavel Yaskevich
>            Priority: Minor
>             Fix For: 0.8.2
>
>         Attachments: 2809-validate.txt
>
>
> Using cassandra-cli, I can't update the comparator of a column family with the type I want and when I did it with BytesType, Column metadata appear for each of my existing columns.
> Step to reproduce:
> {code}
> [default@unknown] create keyspace Test
>     with placement_strategy = 'org.apache.cassandra.locator.SimpleStrategy'
>     and strategy_options = [{replication_factor:1}];
> [default@unknown] use Test;
> Authenticated to keyspace: Test
> [default@Test] create column family test;
> [default@Test] describe keyspace;
> ...
>     ColumnFamily: test
>       Key Validation Class: org.apache.cassandra.db.marshal.BytesType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.BytesType
>       Row cache size / save period in seconds: 0.0/0
>       Key cache size / save period in seconds: 200000.0/14400
>       Memtable thresholds: 0.571875/122/1440 (millions of ops/MB/minutes)
>       GC grace seconds: 864000
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 1.0
>       Replicate on write: false
>       Built indexes: []
> ...
> [default@Test] update column family test with comparator = 'LongType';
> comparators do not match.
> {code}
> why?? the CF is empty
> {code}
> [default@Test] update column family test with comparator = 'BytesType';
> f8e4dcb0-9cca-11e0-0000-d0583497e7ff
> Waiting for schema agreement...
> ... schemas agree across the cluster
> [default@Test] describe keyspace;
> ...
>     ColumnFamily: test
>       Key Validation Class: org.apache.cassandra.db.marshal.BytesType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.BytesType
>       Row cache size / save period in seconds: 0.0/0
>       Key cache size / save period in seconds: 200000.0/14400
>       Memtable thresholds: 0.571875/122/1440 (millions of ops/MB/minutes)
>       GC grace seconds: 864000
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 1.0
>       Replicate on write: false
>       Built indexes: []
> ...
> [default@Test] set test[ascii('row1')][long(1)]=integer(35);
> set test[ascii('row1')][long(2)]=integer(36);
> set test[ascii('row1')][long(3)]=integer(38);
> set test[ascii('row2')][long(1)]=integer(45);
> set test[ascii('row2')][long(2)]=integer(42);
> set test[ascii('row2')][long(3)]=integer(33);
> [default@Test] list test;
> Using default limit of 100
> -------------------
> RowKey: 726f7731
> => (column=0000000000000001, value=35, timestamp=1308744931122000)
> => (column=0000000000000002, value=36, timestamp=1308744931124000)
> => (column=0000000000000003, value=38, timestamp=1308744931125000)
> -------------------
> RowKey: 726f7732
> => (column=0000000000000001, value=45, timestamp=1308744931127000)
> => (column=0000000000000002, value=42, timestamp=1308744931128000)
> => (column=0000000000000003, value=33, timestamp=1308744932722000)
> 2 Rows Returned.
> [default@Test] update column family test with comparator = 'LongType';
> comparators do not match.
> {code}
> same question than before, my columns contains only long, why I can't?
> {code}
> [default@Test] update column family test with comparator = 'BytesType';
> [default@Test] describe keyspace;                                      
> Keyspace: Test:
>   Replication Strategy: org.apache.cassandra.locator.SimpleStrategy
>     Options: [replication_factor:1]
>   Column Families:
>     ColumnFamily: test
>       Key Validation Class: org.apache.cassandra.db.marshal.BytesType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.BytesType
>       Row cache size / save period in seconds: 0.0/0
>       Key cache size / save period in seconds: 200000.0/14400
>       Memtable thresholds: 0.571875/122/1440 (millions of ops/MB/minutes)
>       GC grace seconds: 864000
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 1.0
>       Replicate on write: false
>       Built indexes: []
>       Column Metadata:
>         Column Name:  (0000000000000001)
>           Validation Class: org.apache.cassandra.db.marshal.IntegerType
>         Column Name:  (0000000000000003)
>           Validation Class: org.apache.cassandra.db.marshal.IntegerType
>         Column Name:  (0000000000000002)
>           Validation Class: org.apache.cassandra.db.marshal.IntegerType
> {code}
> Column Metadata appear from nowhere. I don't think that it's expected.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

[jira] [Commented] (CASSANDRA-2809) In the Cli, update column family with comparator; create Column metadata

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

Hudson commented on CASSANDRA-2809:
-----------------------------------

Integrated in Cassandra-0.7 #530 (See [https://builds.apache.org/job/Cassandra-0.7/530/])
    avoid including inferred types in CFupdate
patch by pyaskevich; reviewed by jbellis for CASSANDRA-2809

jbellis : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1147621
Files : 
* /cassandra/branches/cassandra-0.7/CHANGES.txt
* /cassandra/branches/cassandra-0.7/src/java/org/apache/cassandra/cli/CliClient.java


> In the Cli, update column family <cf> with comparator; create Column metadata
> -----------------------------------------------------------------------------
>
>                 Key: CASSANDRA-2809
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-2809
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Tools
>    Affects Versions: 0.7.0
>         Environment: Ubuntu 10.10, 32bit
> java version "1.6.0_24"
> installed from Debian packages of Brisk-beta2
>            Reporter: Silvère Lestang
>            Assignee: Pavel Yaskevich
>            Priority: Minor
>             Fix For: 0.7.8, 0.8.2
>
>         Attachments: 2809-validate.txt, CASSANDRA-2809.patch
>
>
> Using cassandra-cli, I can't update the comparator of a column family with the type I want and when I did it with BytesType, Column metadata appear for each of my existing columns.
> Step to reproduce:
> {code}
> [default@unknown] create keyspace Test
>     with placement_strategy = 'org.apache.cassandra.locator.SimpleStrategy'
>     and strategy_options = [{replication_factor:1}];
> [default@unknown] use Test;
> Authenticated to keyspace: Test
> [default@Test] create column family test;
> [default@Test] describe keyspace;
> ...
>     ColumnFamily: test
>       Key Validation Class: org.apache.cassandra.db.marshal.BytesType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.BytesType
>       Row cache size / save period in seconds: 0.0/0
>       Key cache size / save period in seconds: 200000.0/14400
>       Memtable thresholds: 0.571875/122/1440 (millions of ops/MB/minutes)
>       GC grace seconds: 864000
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 1.0
>       Replicate on write: false
>       Built indexes: []
> ...
> [default@Test] update column family test with comparator = 'LongType';
> comparators do not match.
> {code}
> why?? the CF is empty
> {code}
> [default@Test] update column family test with comparator = 'BytesType';
> f8e4dcb0-9cca-11e0-0000-d0583497e7ff
> Waiting for schema agreement...
> ... schemas agree across the cluster
> [default@Test] describe keyspace;
> ...
>     ColumnFamily: test
>       Key Validation Class: org.apache.cassandra.db.marshal.BytesType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.BytesType
>       Row cache size / save period in seconds: 0.0/0
>       Key cache size / save period in seconds: 200000.0/14400
>       Memtable thresholds: 0.571875/122/1440 (millions of ops/MB/minutes)
>       GC grace seconds: 864000
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 1.0
>       Replicate on write: false
>       Built indexes: []
> ...
> [default@Test] set test[ascii('row1')][long(1)]=integer(35);
> set test[ascii('row1')][long(2)]=integer(36);
> set test[ascii('row1')][long(3)]=integer(38);
> set test[ascii('row2')][long(1)]=integer(45);
> set test[ascii('row2')][long(2)]=integer(42);
> set test[ascii('row2')][long(3)]=integer(33);
> [default@Test] list test;
> Using default limit of 100
> -------------------
> RowKey: 726f7731
> => (column=0000000000000001, value=35, timestamp=1308744931122000)
> => (column=0000000000000002, value=36, timestamp=1308744931124000)
> => (column=0000000000000003, value=38, timestamp=1308744931125000)
> -------------------
> RowKey: 726f7732
> => (column=0000000000000001, value=45, timestamp=1308744931127000)
> => (column=0000000000000002, value=42, timestamp=1308744931128000)
> => (column=0000000000000003, value=33, timestamp=1308744932722000)
> 2 Rows Returned.
> [default@Test] update column family test with comparator = 'LongType';
> comparators do not match.
> {code}
> same question than before, my columns contains only long, why I can't?
> {code}
> [default@Test] update column family test with comparator = 'BytesType';
> [default@Test] describe keyspace;                                      
> Keyspace: Test:
>   Replication Strategy: org.apache.cassandra.locator.SimpleStrategy
>     Options: [replication_factor:1]
>   Column Families:
>     ColumnFamily: test
>       Key Validation Class: org.apache.cassandra.db.marshal.BytesType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.BytesType
>       Row cache size / save period in seconds: 0.0/0
>       Key cache size / save period in seconds: 200000.0/14400
>       Memtable thresholds: 0.571875/122/1440 (millions of ops/MB/minutes)
>       GC grace seconds: 864000
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 1.0
>       Replicate on write: false
>       Built indexes: []
>       Column Metadata:
>         Column Name:  (0000000000000001)
>           Validation Class: org.apache.cassandra.db.marshal.IntegerType
>         Column Name:  (0000000000000003)
>           Validation Class: org.apache.cassandra.db.marshal.IntegerType
>         Column Name:  (0000000000000002)
>           Validation Class: org.apache.cassandra.db.marshal.IntegerType
> {code}
> Column Metadata appear from nowhere. I don't think that it's expected.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

[jira] [Issue Comment Edited] (CASSANDRA-2809) In the Cli, update column family with comparator; create Column metadata

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

Pavel Yaskevich edited comment on CASSANDRA-2809 at 7/15/11 9:27 PM:
---------------------------------------------------------------------

How should it be stored on your opinion?

      was (Author: xedin):
    How should be store that on your opinion?
  
> In the Cli, update column family <cf> with comparator; create Column metadata
> -----------------------------------------------------------------------------
>
>                 Key: CASSANDRA-2809
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-2809
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Tools
>         Environment: Ubuntu 10.10, 32bit
> java version "1.6.0_24"
> installed from Debian packages of Brisk-beta2
>            Reporter: Silvère Lestang
>            Assignee: Pavel Yaskevich
>            Priority: Minor
>             Fix For: 0.8.2
>
>         Attachments: 2809-validate.txt
>
>
> Using cassandra-cli, I can't update the comparator of a column family with the type I want and when I did it with BytesType, Column metadata appear for each of my existing columns.
> Step to reproduce:
> {code}
> [default@unknown] create keyspace Test
>     with placement_strategy = 'org.apache.cassandra.locator.SimpleStrategy'
>     and strategy_options = [{replication_factor:1}];
> [default@unknown] use Test;
> Authenticated to keyspace: Test
> [default@Test] create column family test;
> [default@Test] describe keyspace;
> ...
>     ColumnFamily: test
>       Key Validation Class: org.apache.cassandra.db.marshal.BytesType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.BytesType
>       Row cache size / save period in seconds: 0.0/0
>       Key cache size / save period in seconds: 200000.0/14400
>       Memtable thresholds: 0.571875/122/1440 (millions of ops/MB/minutes)
>       GC grace seconds: 864000
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 1.0
>       Replicate on write: false
>       Built indexes: []
> ...
> [default@Test] update column family test with comparator = 'LongType';
> comparators do not match.
> {code}
> why?? the CF is empty
> {code}
> [default@Test] update column family test with comparator = 'BytesType';
> f8e4dcb0-9cca-11e0-0000-d0583497e7ff
> Waiting for schema agreement...
> ... schemas agree across the cluster
> [default@Test] describe keyspace;
> ...
>     ColumnFamily: test
>       Key Validation Class: org.apache.cassandra.db.marshal.BytesType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.BytesType
>       Row cache size / save period in seconds: 0.0/0
>       Key cache size / save period in seconds: 200000.0/14400
>       Memtable thresholds: 0.571875/122/1440 (millions of ops/MB/minutes)
>       GC grace seconds: 864000
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 1.0
>       Replicate on write: false
>       Built indexes: []
> ...
> [default@Test] set test[ascii('row1')][long(1)]=integer(35);
> set test[ascii('row1')][long(2)]=integer(36);
> set test[ascii('row1')][long(3)]=integer(38);
> set test[ascii('row2')][long(1)]=integer(45);
> set test[ascii('row2')][long(2)]=integer(42);
> set test[ascii('row2')][long(3)]=integer(33);
> [default@Test] list test;
> Using default limit of 100
> -------------------
> RowKey: 726f7731
> => (column=0000000000000001, value=35, timestamp=1308744931122000)
> => (column=0000000000000002, value=36, timestamp=1308744931124000)
> => (column=0000000000000003, value=38, timestamp=1308744931125000)
> -------------------
> RowKey: 726f7732
> => (column=0000000000000001, value=45, timestamp=1308744931127000)
> => (column=0000000000000002, value=42, timestamp=1308744931128000)
> => (column=0000000000000003, value=33, timestamp=1308744932722000)
> 2 Rows Returned.
> [default@Test] update column family test with comparator = 'LongType';
> comparators do not match.
> {code}
> same question than before, my columns contains only long, why I can't?
> {code}
> [default@Test] update column family test with comparator = 'BytesType';
> [default@Test] describe keyspace;                                      
> Keyspace: Test:
>   Replication Strategy: org.apache.cassandra.locator.SimpleStrategy
>     Options: [replication_factor:1]
>   Column Families:
>     ColumnFamily: test
>       Key Validation Class: org.apache.cassandra.db.marshal.BytesType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.BytesType
>       Row cache size / save period in seconds: 0.0/0
>       Key cache size / save period in seconds: 200000.0/14400
>       Memtable thresholds: 0.571875/122/1440 (millions of ops/MB/minutes)
>       GC grace seconds: 864000
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 1.0
>       Replicate on write: false
>       Built indexes: []
>       Column Metadata:
>         Column Name:  (0000000000000001)
>           Validation Class: org.apache.cassandra.db.marshal.IntegerType
>         Column Name:  (0000000000000003)
>           Validation Class: org.apache.cassandra.db.marshal.IntegerType
>         Column Name:  (0000000000000002)
>           Validation Class: org.apache.cassandra.db.marshal.IntegerType
> {code}
> Column Metadata appear from nowhere. I don't think that it's expected.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

[jira] [Updated] (CASSANDRA-2809) In the Cli, update column family with comparator; create Column metadata

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

Pavel Yaskevich updated CASSANDRA-2809:
---------------------------------------

    Attachment: CASSANDRA-2809.patch

patch for version 0.7 but can be applied on 0.8 also.

> In the Cli, update column family <cf> with comparator; create Column metadata
> -----------------------------------------------------------------------------
>
>                 Key: CASSANDRA-2809
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-2809
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Tools
>    Affects Versions: 0.7.6
>         Environment: Ubuntu 10.10, 32bit
> java version "1.6.0_24"
> installed from Debian packages of Brisk-beta2
>            Reporter: Silvère Lestang
>            Assignee: Pavel Yaskevich
>            Priority: Minor
>             Fix For: 0.7.8, 0.8.2
>
>         Attachments: 2809-validate.txt, CASSANDRA-2809.patch
>
>
> Using cassandra-cli, I can't update the comparator of a column family with the type I want and when I did it with BytesType, Column metadata appear for each of my existing columns.
> Step to reproduce:
> {code}
> [default@unknown] create keyspace Test
>     with placement_strategy = 'org.apache.cassandra.locator.SimpleStrategy'
>     and strategy_options = [{replication_factor:1}];
> [default@unknown] use Test;
> Authenticated to keyspace: Test
> [default@Test] create column family test;
> [default@Test] describe keyspace;
> ...
>     ColumnFamily: test
>       Key Validation Class: org.apache.cassandra.db.marshal.BytesType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.BytesType
>       Row cache size / save period in seconds: 0.0/0
>       Key cache size / save period in seconds: 200000.0/14400
>       Memtable thresholds: 0.571875/122/1440 (millions of ops/MB/minutes)
>       GC grace seconds: 864000
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 1.0
>       Replicate on write: false
>       Built indexes: []
> ...
> [default@Test] update column family test with comparator = 'LongType';
> comparators do not match.
> {code}
> why?? the CF is empty
> {code}
> [default@Test] update column family test with comparator = 'BytesType';
> f8e4dcb0-9cca-11e0-0000-d0583497e7ff
> Waiting for schema agreement...
> ... schemas agree across the cluster
> [default@Test] describe keyspace;
> ...
>     ColumnFamily: test
>       Key Validation Class: org.apache.cassandra.db.marshal.BytesType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.BytesType
>       Row cache size / save period in seconds: 0.0/0
>       Key cache size / save period in seconds: 200000.0/14400
>       Memtable thresholds: 0.571875/122/1440 (millions of ops/MB/minutes)
>       GC grace seconds: 864000
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 1.0
>       Replicate on write: false
>       Built indexes: []
> ...
> [default@Test] set test[ascii('row1')][long(1)]=integer(35);
> set test[ascii('row1')][long(2)]=integer(36);
> set test[ascii('row1')][long(3)]=integer(38);
> set test[ascii('row2')][long(1)]=integer(45);
> set test[ascii('row2')][long(2)]=integer(42);
> set test[ascii('row2')][long(3)]=integer(33);
> [default@Test] list test;
> Using default limit of 100
> -------------------
> RowKey: 726f7731
> => (column=0000000000000001, value=35, timestamp=1308744931122000)
> => (column=0000000000000002, value=36, timestamp=1308744931124000)
> => (column=0000000000000003, value=38, timestamp=1308744931125000)
> -------------------
> RowKey: 726f7732
> => (column=0000000000000001, value=45, timestamp=1308744931127000)
> => (column=0000000000000002, value=42, timestamp=1308744931128000)
> => (column=0000000000000003, value=33, timestamp=1308744932722000)
> 2 Rows Returned.
> [default@Test] update column family test with comparator = 'LongType';
> comparators do not match.
> {code}
> same question than before, my columns contains only long, why I can't?
> {code}
> [default@Test] update column family test with comparator = 'BytesType';
> [default@Test] describe keyspace;                                      
> Keyspace: Test:
>   Replication Strategy: org.apache.cassandra.locator.SimpleStrategy
>     Options: [replication_factor:1]
>   Column Families:
>     ColumnFamily: test
>       Key Validation Class: org.apache.cassandra.db.marshal.BytesType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.BytesType
>       Row cache size / save period in seconds: 0.0/0
>       Key cache size / save period in seconds: 200000.0/14400
>       Memtable thresholds: 0.571875/122/1440 (millions of ops/MB/minutes)
>       GC grace seconds: 864000
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 1.0
>       Replicate on write: false
>       Built indexes: []
>       Column Metadata:
>         Column Name:  (0000000000000001)
>           Validation Class: org.apache.cassandra.db.marshal.IntegerType
>         Column Name:  (0000000000000003)
>           Validation Class: org.apache.cassandra.db.marshal.IntegerType
>         Column Name:  (0000000000000002)
>           Validation Class: org.apache.cassandra.db.marshal.IntegerType
> {code}
> Column Metadata appear from nowhere. I don't think that it's expected.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

[jira] [Reopened] (CASSANDRA-2809) In the Cli, update column family with comparator; create Column metadata

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

Jonathan Ellis reopened CASSANDRA-2809:
---------------------------------------


bq. That column metadata is a feature: when you use a function call in SET statement it is storing information about validation class for individual columns locally

Ah, I remember that.  But this shouldn't show up in a describe keyspace or we cause the above confusion. :)

> In the Cli, update column family <cf> with comparator; create Column metadata
> -----------------------------------------------------------------------------
>
>                 Key: CASSANDRA-2809
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-2809
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Tools
>         Environment: Ubuntu 10.10, 32bit
> java version "1.6.0_24"
> installed from Debian packages of Brisk-beta2
>            Reporter: Silvère Lestang
>            Assignee: Pavel Yaskevich
>            Priority: Minor
>             Fix For: 0.8.2
>
>         Attachments: 2809-validate.txt
>
>
> Using cassandra-cli, I can't update the comparator of a column family with the type I want and when I did it with BytesType, Column metadata appear for each of my existing columns.
> Step to reproduce:
> {code}
> [default@unknown] create keyspace Test
>     with placement_strategy = 'org.apache.cassandra.locator.SimpleStrategy'
>     and strategy_options = [{replication_factor:1}];
> [default@unknown] use Test;
> Authenticated to keyspace: Test
> [default@Test] create column family test;
> [default@Test] describe keyspace;
> ...
>     ColumnFamily: test
>       Key Validation Class: org.apache.cassandra.db.marshal.BytesType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.BytesType
>       Row cache size / save period in seconds: 0.0/0
>       Key cache size / save period in seconds: 200000.0/14400
>       Memtable thresholds: 0.571875/122/1440 (millions of ops/MB/minutes)
>       GC grace seconds: 864000
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 1.0
>       Replicate on write: false
>       Built indexes: []
> ...
> [default@Test] update column family test with comparator = 'LongType';
> comparators do not match.
> {code}
> why?? the CF is empty
> {code}
> [default@Test] update column family test with comparator = 'BytesType';
> f8e4dcb0-9cca-11e0-0000-d0583497e7ff
> Waiting for schema agreement...
> ... schemas agree across the cluster
> [default@Test] describe keyspace;
> ...
>     ColumnFamily: test
>       Key Validation Class: org.apache.cassandra.db.marshal.BytesType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.BytesType
>       Row cache size / save period in seconds: 0.0/0
>       Key cache size / save period in seconds: 200000.0/14400
>       Memtable thresholds: 0.571875/122/1440 (millions of ops/MB/minutes)
>       GC grace seconds: 864000
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 1.0
>       Replicate on write: false
>       Built indexes: []
> ...
> [default@Test] set test[ascii('row1')][long(1)]=integer(35);
> set test[ascii('row1')][long(2)]=integer(36);
> set test[ascii('row1')][long(3)]=integer(38);
> set test[ascii('row2')][long(1)]=integer(45);
> set test[ascii('row2')][long(2)]=integer(42);
> set test[ascii('row2')][long(3)]=integer(33);
> [default@Test] list test;
> Using default limit of 100
> -------------------
> RowKey: 726f7731
> => (column=0000000000000001, value=35, timestamp=1308744931122000)
> => (column=0000000000000002, value=36, timestamp=1308744931124000)
> => (column=0000000000000003, value=38, timestamp=1308744931125000)
> -------------------
> RowKey: 726f7732
> => (column=0000000000000001, value=45, timestamp=1308744931127000)
> => (column=0000000000000002, value=42, timestamp=1308744931128000)
> => (column=0000000000000003, value=33, timestamp=1308744932722000)
> 2 Rows Returned.
> [default@Test] update column family test with comparator = 'LongType';
> comparators do not match.
> {code}
> same question than before, my columns contains only long, why I can't?
> {code}
> [default@Test] update column family test with comparator = 'BytesType';
> [default@Test] describe keyspace;                                      
> Keyspace: Test:
>   Replication Strategy: org.apache.cassandra.locator.SimpleStrategy
>     Options: [replication_factor:1]
>   Column Families:
>     ColumnFamily: test
>       Key Validation Class: org.apache.cassandra.db.marshal.BytesType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.BytesType
>       Row cache size / save period in seconds: 0.0/0
>       Key cache size / save period in seconds: 200000.0/14400
>       Memtable thresholds: 0.571875/122/1440 (millions of ops/MB/minutes)
>       GC grace seconds: 864000
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 1.0
>       Replicate on write: false
>       Built indexes: []
>       Column Metadata:
>         Column Name:  (0000000000000001)
>           Validation Class: org.apache.cassandra.db.marshal.IntegerType
>         Column Name:  (0000000000000003)
>           Validation Class: org.apache.cassandra.db.marshal.IntegerType
>         Column Name:  (0000000000000002)
>           Validation Class: org.apache.cassandra.db.marshal.IntegerType
> {code}
> Column Metadata appear from nowhere. I don't think that it's expected.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

[jira] [Updated] (CASSANDRA-2809) In the Cli, update column family with comparator; create Column metadata

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

Jonathan Ellis updated CASSANDRA-2809:
--------------------------------------

             Priority: Minor  (was: Major)
    Affects Version/s:     (was: 0.8.1)
        Fix Version/s: 0.8.2
             Assignee: Pavel Yaskevich

Changing comparators is not allowed, since the point of a comparator is that data within a row will be sorted on disk by the comparator's ordering.  Changing the comparator without rewriting the data would corrupt the sstable.

Not sure where that column_metadata comes from though.  Looks like a bug.

> In the Cli, update column family <cf> with comparator; create Column metadata
> -----------------------------------------------------------------------------
>
>                 Key: CASSANDRA-2809
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-2809
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Tools
>         Environment: Ubuntu 10.10, 32bit
> java version "1.6.0_24"
> installed from Debian packages of Brisk-beta2
>            Reporter: Silvère Lestang
>            Assignee: Pavel Yaskevich
>            Priority: Minor
>             Fix For: 0.8.2
>
>         Attachments: 2809-validate.txt
>
>
> Using cassandra-cli, I can't update the comparator of a column family with the type I want and when I did it with BytesType, Column metadata appear for each of my existing columns.
> Step to reproduce:
> {code}
> [default@unknown] create keyspace Test
>     with placement_strategy = 'org.apache.cassandra.locator.SimpleStrategy'
>     and strategy_options = [{replication_factor:1}];
> [default@unknown] use Test;
> Authenticated to keyspace: Test
> [default@Test] create column family test;
> [default@Test] describe keyspace;
> ...
>     ColumnFamily: test
>       Key Validation Class: org.apache.cassandra.db.marshal.BytesType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.BytesType
>       Row cache size / save period in seconds: 0.0/0
>       Key cache size / save period in seconds: 200000.0/14400
>       Memtable thresholds: 0.571875/122/1440 (millions of ops/MB/minutes)
>       GC grace seconds: 864000
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 1.0
>       Replicate on write: false
>       Built indexes: []
> ...
> [default@Test] update column family test with comparator = 'LongType';
> comparators do not match.
> {code}
> why?? the CF is empty
> {code}
> [default@Test] update column family test with comparator = 'BytesType';
> f8e4dcb0-9cca-11e0-0000-d0583497e7ff
> Waiting for schema agreement...
> ... schemas agree across the cluster
> [default@Test] describe keyspace;
> ...
>     ColumnFamily: test
>       Key Validation Class: org.apache.cassandra.db.marshal.BytesType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.BytesType
>       Row cache size / save period in seconds: 0.0/0
>       Key cache size / save period in seconds: 200000.0/14400
>       Memtable thresholds: 0.571875/122/1440 (millions of ops/MB/minutes)
>       GC grace seconds: 864000
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 1.0
>       Replicate on write: false
>       Built indexes: []
> ...
> [default@Test] set test[ascii('row1')][long(1)]=integer(35);
> set test[ascii('row1')][long(2)]=integer(36);
> set test[ascii('row1')][long(3)]=integer(38);
> set test[ascii('row2')][long(1)]=integer(45);
> set test[ascii('row2')][long(2)]=integer(42);
> set test[ascii('row2')][long(3)]=integer(33);
> [default@Test] list test;
> Using default limit of 100
> -------------------
> RowKey: 726f7731
> => (column=0000000000000001, value=35, timestamp=1308744931122000)
> => (column=0000000000000002, value=36, timestamp=1308744931124000)
> => (column=0000000000000003, value=38, timestamp=1308744931125000)
> -------------------
> RowKey: 726f7732
> => (column=0000000000000001, value=45, timestamp=1308744931127000)
> => (column=0000000000000002, value=42, timestamp=1308744931128000)
> => (column=0000000000000003, value=33, timestamp=1308744932722000)
> 2 Rows Returned.
> [default@Test] update column family test with comparator = 'LongType';
> comparators do not match.
> {code}
> same question than before, my columns contains only long, why I can't?
> {code}
> [default@Test] update column family test with comparator = 'BytesType';
> [default@Test] describe keyspace;                                      
> Keyspace: Test:
>   Replication Strategy: org.apache.cassandra.locator.SimpleStrategy
>     Options: [replication_factor:1]
>   Column Families:
>     ColumnFamily: test
>       Key Validation Class: org.apache.cassandra.db.marshal.BytesType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.BytesType
>       Row cache size / save period in seconds: 0.0/0
>       Key cache size / save period in seconds: 200000.0/14400
>       Memtable thresholds: 0.571875/122/1440 (millions of ops/MB/minutes)
>       GC grace seconds: 864000
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 1.0
>       Replicate on write: false
>       Built indexes: []
>       Column Metadata:
>         Column Name:  (0000000000000001)
>           Validation Class: org.apache.cassandra.db.marshal.IntegerType
>         Column Name:  (0000000000000003)
>           Validation Class: org.apache.cassandra.db.marshal.IntegerType
>         Column Name:  (0000000000000002)
>           Validation Class: org.apache.cassandra.db.marshal.IntegerType
> {code}
> Column Metadata appear from nowhere. I don't think that it's expected.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

[jira] [Commented] (CASSANDRA-2809) In the Cli, update column family with comparator; create Column metadata

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

Pavel Yaskevich commented on CASSANDRA-2809:
--------------------------------------------

How should be store that on your opinion?

> In the Cli, update column family <cf> with comparator; create Column metadata
> -----------------------------------------------------------------------------
>
>                 Key: CASSANDRA-2809
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-2809
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Tools
>         Environment: Ubuntu 10.10, 32bit
> java version "1.6.0_24"
> installed from Debian packages of Brisk-beta2
>            Reporter: Silvère Lestang
>            Assignee: Pavel Yaskevich
>            Priority: Minor
>             Fix For: 0.8.2
>
>         Attachments: 2809-validate.txt
>
>
> Using cassandra-cli, I can't update the comparator of a column family with the type I want and when I did it with BytesType, Column metadata appear for each of my existing columns.
> Step to reproduce:
> {code}
> [default@unknown] create keyspace Test
>     with placement_strategy = 'org.apache.cassandra.locator.SimpleStrategy'
>     and strategy_options = [{replication_factor:1}];
> [default@unknown] use Test;
> Authenticated to keyspace: Test
> [default@Test] create column family test;
> [default@Test] describe keyspace;
> ...
>     ColumnFamily: test
>       Key Validation Class: org.apache.cassandra.db.marshal.BytesType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.BytesType
>       Row cache size / save period in seconds: 0.0/0
>       Key cache size / save period in seconds: 200000.0/14400
>       Memtable thresholds: 0.571875/122/1440 (millions of ops/MB/minutes)
>       GC grace seconds: 864000
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 1.0
>       Replicate on write: false
>       Built indexes: []
> ...
> [default@Test] update column family test with comparator = 'LongType';
> comparators do not match.
> {code}
> why?? the CF is empty
> {code}
> [default@Test] update column family test with comparator = 'BytesType';
> f8e4dcb0-9cca-11e0-0000-d0583497e7ff
> Waiting for schema agreement...
> ... schemas agree across the cluster
> [default@Test] describe keyspace;
> ...
>     ColumnFamily: test
>       Key Validation Class: org.apache.cassandra.db.marshal.BytesType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.BytesType
>       Row cache size / save period in seconds: 0.0/0
>       Key cache size / save period in seconds: 200000.0/14400
>       Memtable thresholds: 0.571875/122/1440 (millions of ops/MB/minutes)
>       GC grace seconds: 864000
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 1.0
>       Replicate on write: false
>       Built indexes: []
> ...
> [default@Test] set test[ascii('row1')][long(1)]=integer(35);
> set test[ascii('row1')][long(2)]=integer(36);
> set test[ascii('row1')][long(3)]=integer(38);
> set test[ascii('row2')][long(1)]=integer(45);
> set test[ascii('row2')][long(2)]=integer(42);
> set test[ascii('row2')][long(3)]=integer(33);
> [default@Test] list test;
> Using default limit of 100
> -------------------
> RowKey: 726f7731
> => (column=0000000000000001, value=35, timestamp=1308744931122000)
> => (column=0000000000000002, value=36, timestamp=1308744931124000)
> => (column=0000000000000003, value=38, timestamp=1308744931125000)
> -------------------
> RowKey: 726f7732
> => (column=0000000000000001, value=45, timestamp=1308744931127000)
> => (column=0000000000000002, value=42, timestamp=1308744931128000)
> => (column=0000000000000003, value=33, timestamp=1308744932722000)
> 2 Rows Returned.
> [default@Test] update column family test with comparator = 'LongType';
> comparators do not match.
> {code}
> same question than before, my columns contains only long, why I can't?
> {code}
> [default@Test] update column family test with comparator = 'BytesType';
> [default@Test] describe keyspace;                                      
> Keyspace: Test:
>   Replication Strategy: org.apache.cassandra.locator.SimpleStrategy
>     Options: [replication_factor:1]
>   Column Families:
>     ColumnFamily: test
>       Key Validation Class: org.apache.cassandra.db.marshal.BytesType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.BytesType
>       Row cache size / save period in seconds: 0.0/0
>       Key cache size / save period in seconds: 200000.0/14400
>       Memtable thresholds: 0.571875/122/1440 (millions of ops/MB/minutes)
>       GC grace seconds: 864000
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 1.0
>       Replicate on write: false
>       Built indexes: []
>       Column Metadata:
>         Column Name:  (0000000000000001)
>           Validation Class: org.apache.cassandra.db.marshal.IntegerType
>         Column Name:  (0000000000000003)
>           Validation Class: org.apache.cassandra.db.marshal.IntegerType
>         Column Name:  (0000000000000002)
>           Validation Class: org.apache.cassandra.db.marshal.IntegerType
> {code}
> Column Metadata appear from nowhere. I don't think that it's expected.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

[jira] [Updated] (CASSANDRA-2809) In the Cli, update column family with comparator; create Column metadata

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

Jonathan Ellis updated CASSANDRA-2809:
--------------------------------------

    Affects Version/s:     (was: 0.7.6)
                       0.7.0

> In the Cli, update column family <cf> with comparator; create Column metadata
> -----------------------------------------------------------------------------
>
>                 Key: CASSANDRA-2809
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-2809
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Tools
>    Affects Versions: 0.7.0
>         Environment: Ubuntu 10.10, 32bit
> java version "1.6.0_24"
> installed from Debian packages of Brisk-beta2
>            Reporter: Silvère Lestang
>            Assignee: Pavel Yaskevich
>            Priority: Minor
>             Fix For: 0.7.8, 0.8.2
>
>         Attachments: 2809-validate.txt, CASSANDRA-2809.patch
>
>
> Using cassandra-cli, I can't update the comparator of a column family with the type I want and when I did it with BytesType, Column metadata appear for each of my existing columns.
> Step to reproduce:
> {code}
> [default@unknown] create keyspace Test
>     with placement_strategy = 'org.apache.cassandra.locator.SimpleStrategy'
>     and strategy_options = [{replication_factor:1}];
> [default@unknown] use Test;
> Authenticated to keyspace: Test
> [default@Test] create column family test;
> [default@Test] describe keyspace;
> ...
>     ColumnFamily: test
>       Key Validation Class: org.apache.cassandra.db.marshal.BytesType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.BytesType
>       Row cache size / save period in seconds: 0.0/0
>       Key cache size / save period in seconds: 200000.0/14400
>       Memtable thresholds: 0.571875/122/1440 (millions of ops/MB/minutes)
>       GC grace seconds: 864000
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 1.0
>       Replicate on write: false
>       Built indexes: []
> ...
> [default@Test] update column family test with comparator = 'LongType';
> comparators do not match.
> {code}
> why?? the CF is empty
> {code}
> [default@Test] update column family test with comparator = 'BytesType';
> f8e4dcb0-9cca-11e0-0000-d0583497e7ff
> Waiting for schema agreement...
> ... schemas agree across the cluster
> [default@Test] describe keyspace;
> ...
>     ColumnFamily: test
>       Key Validation Class: org.apache.cassandra.db.marshal.BytesType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.BytesType
>       Row cache size / save period in seconds: 0.0/0
>       Key cache size / save period in seconds: 200000.0/14400
>       Memtable thresholds: 0.571875/122/1440 (millions of ops/MB/minutes)
>       GC grace seconds: 864000
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 1.0
>       Replicate on write: false
>       Built indexes: []
> ...
> [default@Test] set test[ascii('row1')][long(1)]=integer(35);
> set test[ascii('row1')][long(2)]=integer(36);
> set test[ascii('row1')][long(3)]=integer(38);
> set test[ascii('row2')][long(1)]=integer(45);
> set test[ascii('row2')][long(2)]=integer(42);
> set test[ascii('row2')][long(3)]=integer(33);
> [default@Test] list test;
> Using default limit of 100
> -------------------
> RowKey: 726f7731
> => (column=0000000000000001, value=35, timestamp=1308744931122000)
> => (column=0000000000000002, value=36, timestamp=1308744931124000)
> => (column=0000000000000003, value=38, timestamp=1308744931125000)
> -------------------
> RowKey: 726f7732
> => (column=0000000000000001, value=45, timestamp=1308744931127000)
> => (column=0000000000000002, value=42, timestamp=1308744931128000)
> => (column=0000000000000003, value=33, timestamp=1308744932722000)
> 2 Rows Returned.
> [default@Test] update column family test with comparator = 'LongType';
> comparators do not match.
> {code}
> same question than before, my columns contains only long, why I can't?
> {code}
> [default@Test] update column family test with comparator = 'BytesType';
> [default@Test] describe keyspace;                                      
> Keyspace: Test:
>   Replication Strategy: org.apache.cassandra.locator.SimpleStrategy
>     Options: [replication_factor:1]
>   Column Families:
>     ColumnFamily: test
>       Key Validation Class: org.apache.cassandra.db.marshal.BytesType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.BytesType
>       Row cache size / save period in seconds: 0.0/0
>       Key cache size / save period in seconds: 200000.0/14400
>       Memtable thresholds: 0.571875/122/1440 (millions of ops/MB/minutes)
>       GC grace seconds: 864000
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 1.0
>       Replicate on write: false
>       Built indexes: []
>       Column Metadata:
>         Column Name:  (0000000000000001)
>           Validation Class: org.apache.cassandra.db.marshal.IntegerType
>         Column Name:  (0000000000000003)
>           Validation Class: org.apache.cassandra.db.marshal.IntegerType
>         Column Name:  (0000000000000002)
>           Validation Class: org.apache.cassandra.db.marshal.IntegerType
> {code}
> Column Metadata appear from nowhere. I don't think that it's expected.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

[jira] [Commented] (CASSANDRA-2809) In the Cli, update column family with comparator; create Column metadata

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

Hudson commented on CASSANDRA-2809:
-----------------------------------

Integrated in Cassandra-0.8 #216 (See [https://builds.apache.org/job/Cassandra-0.8/216/])
    cli validates CFMetaData on update.
Patch by jbellis, reviewed by Pavel Yaskevich for CASSANDRA-2809

brandonwilliams : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1147261
Files : 
* /cassandra/branches/cassandra-0.8/src/java/org/apache/cassandra/thrift/CassandraServer.java


> In the Cli, update column family <cf> with comparator; create Column metadata
> -----------------------------------------------------------------------------
>
>                 Key: CASSANDRA-2809
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-2809
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Tools
>         Environment: Ubuntu 10.10, 32bit
> java version "1.6.0_24"
> installed from Debian packages of Brisk-beta2
>            Reporter: Silvère Lestang
>            Assignee: Pavel Yaskevich
>            Priority: Minor
>             Fix For: 0.8.2
>
>         Attachments: 2809-validate.txt
>
>
> Using cassandra-cli, I can't update the comparator of a column family with the type I want and when I did it with BytesType, Column metadata appear for each of my existing columns.
> Step to reproduce:
> {code}
> [default@unknown] create keyspace Test
>     with placement_strategy = 'org.apache.cassandra.locator.SimpleStrategy'
>     and strategy_options = [{replication_factor:1}];
> [default@unknown] use Test;
> Authenticated to keyspace: Test
> [default@Test] create column family test;
> [default@Test] describe keyspace;
> ...
>     ColumnFamily: test
>       Key Validation Class: org.apache.cassandra.db.marshal.BytesType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.BytesType
>       Row cache size / save period in seconds: 0.0/0
>       Key cache size / save period in seconds: 200000.0/14400
>       Memtable thresholds: 0.571875/122/1440 (millions of ops/MB/minutes)
>       GC grace seconds: 864000
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 1.0
>       Replicate on write: false
>       Built indexes: []
> ...
> [default@Test] update column family test with comparator = 'LongType';
> comparators do not match.
> {code}
> why?? the CF is empty
> {code}
> [default@Test] update column family test with comparator = 'BytesType';
> f8e4dcb0-9cca-11e0-0000-d0583497e7ff
> Waiting for schema agreement...
> ... schemas agree across the cluster
> [default@Test] describe keyspace;
> ...
>     ColumnFamily: test
>       Key Validation Class: org.apache.cassandra.db.marshal.BytesType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.BytesType
>       Row cache size / save period in seconds: 0.0/0
>       Key cache size / save period in seconds: 200000.0/14400
>       Memtable thresholds: 0.571875/122/1440 (millions of ops/MB/minutes)
>       GC grace seconds: 864000
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 1.0
>       Replicate on write: false
>       Built indexes: []
> ...
> [default@Test] set test[ascii('row1')][long(1)]=integer(35);
> set test[ascii('row1')][long(2)]=integer(36);
> set test[ascii('row1')][long(3)]=integer(38);
> set test[ascii('row2')][long(1)]=integer(45);
> set test[ascii('row2')][long(2)]=integer(42);
> set test[ascii('row2')][long(3)]=integer(33);
> [default@Test] list test;
> Using default limit of 100
> -------------------
> RowKey: 726f7731
> => (column=0000000000000001, value=35, timestamp=1308744931122000)
> => (column=0000000000000002, value=36, timestamp=1308744931124000)
> => (column=0000000000000003, value=38, timestamp=1308744931125000)
> -------------------
> RowKey: 726f7732
> => (column=0000000000000001, value=45, timestamp=1308744931127000)
> => (column=0000000000000002, value=42, timestamp=1308744931128000)
> => (column=0000000000000003, value=33, timestamp=1308744932722000)
> 2 Rows Returned.
> [default@Test] update column family test with comparator = 'LongType';
> comparators do not match.
> {code}
> same question than before, my columns contains only long, why I can't?
> {code}
> [default@Test] update column family test with comparator = 'BytesType';
> [default@Test] describe keyspace;                                      
> Keyspace: Test:
>   Replication Strategy: org.apache.cassandra.locator.SimpleStrategy
>     Options: [replication_factor:1]
>   Column Families:
>     ColumnFamily: test
>       Key Validation Class: org.apache.cassandra.db.marshal.BytesType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.BytesType
>       Row cache size / save period in seconds: 0.0/0
>       Key cache size / save period in seconds: 200000.0/14400
>       Memtable thresholds: 0.571875/122/1440 (millions of ops/MB/minutes)
>       GC grace seconds: 864000
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 1.0
>       Replicate on write: false
>       Built indexes: []
>       Column Metadata:
>         Column Name:  (0000000000000001)
>           Validation Class: org.apache.cassandra.db.marshal.IntegerType
>         Column Name:  (0000000000000003)
>           Validation Class: org.apache.cassandra.db.marshal.IntegerType
>         Column Name:  (0000000000000002)
>           Validation Class: org.apache.cassandra.db.marshal.IntegerType
> {code}
> Column Metadata appear from nowhere. I don't think that it's expected.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

[jira] [Commented] (CASSANDRA-2809) In the Cli, update column family with comparator; create Column metadata

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

Jonathan Ellis commented on CASSANDRA-2809:
-------------------------------------------

I'd probably keep a "local" CFMetadata around and check that first.

> In the Cli, update column family <cf> with comparator; create Column metadata
> -----------------------------------------------------------------------------
>
>                 Key: CASSANDRA-2809
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-2809
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Tools
>         Environment: Ubuntu 10.10, 32bit
> java version "1.6.0_24"
> installed from Debian packages of Brisk-beta2
>            Reporter: Silvère Lestang
>            Assignee: Pavel Yaskevich
>            Priority: Minor
>             Fix For: 0.8.2
>
>         Attachments: 2809-validate.txt
>
>
> Using cassandra-cli, I can't update the comparator of a column family with the type I want and when I did it with BytesType, Column metadata appear for each of my existing columns.
> Step to reproduce:
> {code}
> [default@unknown] create keyspace Test
>     with placement_strategy = 'org.apache.cassandra.locator.SimpleStrategy'
>     and strategy_options = [{replication_factor:1}];
> [default@unknown] use Test;
> Authenticated to keyspace: Test
> [default@Test] create column family test;
> [default@Test] describe keyspace;
> ...
>     ColumnFamily: test
>       Key Validation Class: org.apache.cassandra.db.marshal.BytesType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.BytesType
>       Row cache size / save period in seconds: 0.0/0
>       Key cache size / save period in seconds: 200000.0/14400
>       Memtable thresholds: 0.571875/122/1440 (millions of ops/MB/minutes)
>       GC grace seconds: 864000
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 1.0
>       Replicate on write: false
>       Built indexes: []
> ...
> [default@Test] update column family test with comparator = 'LongType';
> comparators do not match.
> {code}
> why?? the CF is empty
> {code}
> [default@Test] update column family test with comparator = 'BytesType';
> f8e4dcb0-9cca-11e0-0000-d0583497e7ff
> Waiting for schema agreement...
> ... schemas agree across the cluster
> [default@Test] describe keyspace;
> ...
>     ColumnFamily: test
>       Key Validation Class: org.apache.cassandra.db.marshal.BytesType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.BytesType
>       Row cache size / save period in seconds: 0.0/0
>       Key cache size / save period in seconds: 200000.0/14400
>       Memtable thresholds: 0.571875/122/1440 (millions of ops/MB/minutes)
>       GC grace seconds: 864000
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 1.0
>       Replicate on write: false
>       Built indexes: []
> ...
> [default@Test] set test[ascii('row1')][long(1)]=integer(35);
> set test[ascii('row1')][long(2)]=integer(36);
> set test[ascii('row1')][long(3)]=integer(38);
> set test[ascii('row2')][long(1)]=integer(45);
> set test[ascii('row2')][long(2)]=integer(42);
> set test[ascii('row2')][long(3)]=integer(33);
> [default@Test] list test;
> Using default limit of 100
> -------------------
> RowKey: 726f7731
> => (column=0000000000000001, value=35, timestamp=1308744931122000)
> => (column=0000000000000002, value=36, timestamp=1308744931124000)
> => (column=0000000000000003, value=38, timestamp=1308744931125000)
> -------------------
> RowKey: 726f7732
> => (column=0000000000000001, value=45, timestamp=1308744931127000)
> => (column=0000000000000002, value=42, timestamp=1308744931128000)
> => (column=0000000000000003, value=33, timestamp=1308744932722000)
> 2 Rows Returned.
> [default@Test] update column family test with comparator = 'LongType';
> comparators do not match.
> {code}
> same question than before, my columns contains only long, why I can't?
> {code}
> [default@Test] update column family test with comparator = 'BytesType';
> [default@Test] describe keyspace;                                      
> Keyspace: Test:
>   Replication Strategy: org.apache.cassandra.locator.SimpleStrategy
>     Options: [replication_factor:1]
>   Column Families:
>     ColumnFamily: test
>       Key Validation Class: org.apache.cassandra.db.marshal.BytesType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.BytesType
>       Row cache size / save period in seconds: 0.0/0
>       Key cache size / save period in seconds: 200000.0/14400
>       Memtable thresholds: 0.571875/122/1440 (millions of ops/MB/minutes)
>       GC grace seconds: 864000
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 1.0
>       Replicate on write: false
>       Built indexes: []
>       Column Metadata:
>         Column Name:  (0000000000000001)
>           Validation Class: org.apache.cassandra.db.marshal.IntegerType
>         Column Name:  (0000000000000003)
>           Validation Class: org.apache.cassandra.db.marshal.IntegerType
>         Column Name:  (0000000000000002)
>           Validation Class: org.apache.cassandra.db.marshal.IntegerType
> {code}
> Column Metadata appear from nowhere. I don't think that it's expected.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

[jira] [Commented] (CASSANDRA-2809) In the Cli, update column family with comparator; create Column metadata

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

Pavel Yaskevich commented on CASSANDRA-2809:
--------------------------------------------

I took a look the code now and what I see is that describe keyspace always calling `thrift.describe_keyspace()` but in the example after adding rows you did a successful "update column family test with comparator = 'BytesType';" which persisted changes in column metadata. I think this is actually a good thing to have we just need to document that, what do you think, Jonathan?

> In the Cli, update column family <cf> with comparator; create Column metadata
> -----------------------------------------------------------------------------
>
>                 Key: CASSANDRA-2809
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-2809
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Tools
>         Environment: Ubuntu 10.10, 32bit
> java version "1.6.0_24"
> installed from Debian packages of Brisk-beta2
>            Reporter: Silvère Lestang
>            Assignee: Pavel Yaskevich
>            Priority: Minor
>             Fix For: 0.8.2
>
>         Attachments: 2809-validate.txt
>
>
> Using cassandra-cli, I can't update the comparator of a column family with the type I want and when I did it with BytesType, Column metadata appear for each of my existing columns.
> Step to reproduce:
> {code}
> [default@unknown] create keyspace Test
>     with placement_strategy = 'org.apache.cassandra.locator.SimpleStrategy'
>     and strategy_options = [{replication_factor:1}];
> [default@unknown] use Test;
> Authenticated to keyspace: Test
> [default@Test] create column family test;
> [default@Test] describe keyspace;
> ...
>     ColumnFamily: test
>       Key Validation Class: org.apache.cassandra.db.marshal.BytesType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.BytesType
>       Row cache size / save period in seconds: 0.0/0
>       Key cache size / save period in seconds: 200000.0/14400
>       Memtable thresholds: 0.571875/122/1440 (millions of ops/MB/minutes)
>       GC grace seconds: 864000
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 1.0
>       Replicate on write: false
>       Built indexes: []
> ...
> [default@Test] update column family test with comparator = 'LongType';
> comparators do not match.
> {code}
> why?? the CF is empty
> {code}
> [default@Test] update column family test with comparator = 'BytesType';
> f8e4dcb0-9cca-11e0-0000-d0583497e7ff
> Waiting for schema agreement...
> ... schemas agree across the cluster
> [default@Test] describe keyspace;
> ...
>     ColumnFamily: test
>       Key Validation Class: org.apache.cassandra.db.marshal.BytesType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.BytesType
>       Row cache size / save period in seconds: 0.0/0
>       Key cache size / save period in seconds: 200000.0/14400
>       Memtable thresholds: 0.571875/122/1440 (millions of ops/MB/minutes)
>       GC grace seconds: 864000
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 1.0
>       Replicate on write: false
>       Built indexes: []
> ...
> [default@Test] set test[ascii('row1')][long(1)]=integer(35);
> set test[ascii('row1')][long(2)]=integer(36);
> set test[ascii('row1')][long(3)]=integer(38);
> set test[ascii('row2')][long(1)]=integer(45);
> set test[ascii('row2')][long(2)]=integer(42);
> set test[ascii('row2')][long(3)]=integer(33);
> [default@Test] list test;
> Using default limit of 100
> -------------------
> RowKey: 726f7731
> => (column=0000000000000001, value=35, timestamp=1308744931122000)
> => (column=0000000000000002, value=36, timestamp=1308744931124000)
> => (column=0000000000000003, value=38, timestamp=1308744931125000)
> -------------------
> RowKey: 726f7732
> => (column=0000000000000001, value=45, timestamp=1308744931127000)
> => (column=0000000000000002, value=42, timestamp=1308744931128000)
> => (column=0000000000000003, value=33, timestamp=1308744932722000)
> 2 Rows Returned.
> [default@Test] update column family test with comparator = 'LongType';
> comparators do not match.
> {code}
> same question than before, my columns contains only long, why I can't?
> {code}
> [default@Test] update column family test with comparator = 'BytesType';
> [default@Test] describe keyspace;                                      
> Keyspace: Test:
>   Replication Strategy: org.apache.cassandra.locator.SimpleStrategy
>     Options: [replication_factor:1]
>   Column Families:
>     ColumnFamily: test
>       Key Validation Class: org.apache.cassandra.db.marshal.BytesType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.BytesType
>       Row cache size / save period in seconds: 0.0/0
>       Key cache size / save period in seconds: 200000.0/14400
>       Memtable thresholds: 0.571875/122/1440 (millions of ops/MB/minutes)
>       GC grace seconds: 864000
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 1.0
>       Replicate on write: false
>       Built indexes: []
>       Column Metadata:
>         Column Name:  (0000000000000001)
>           Validation Class: org.apache.cassandra.db.marshal.IntegerType
>         Column Name:  (0000000000000003)
>           Validation Class: org.apache.cassandra.db.marshal.IntegerType
>         Column Name:  (0000000000000002)
>           Validation Class: org.apache.cassandra.db.marshal.IntegerType
> {code}
> Column Metadata appear from nowhere. I don't think that it's expected.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

[jira] [Commented] (CASSANDRA-2809) In the Cli, update column family with comparator; create Column metadata

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

Pavel Yaskevich commented on CASSANDRA-2809:
--------------------------------------------

Ok, I will attach a patch fixing this in a few.

> In the Cli, update column family <cf> with comparator; create Column metadata
> -----------------------------------------------------------------------------
>
>                 Key: CASSANDRA-2809
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-2809
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Tools
>         Environment: Ubuntu 10.10, 32bit
> java version "1.6.0_24"
> installed from Debian packages of Brisk-beta2
>            Reporter: Silvère Lestang
>            Assignee: Pavel Yaskevich
>            Priority: Minor
>             Fix For: 0.8.2
>
>         Attachments: 2809-validate.txt
>
>
> Using cassandra-cli, I can't update the comparator of a column family with the type I want and when I did it with BytesType, Column metadata appear for each of my existing columns.
> Step to reproduce:
> {code}
> [default@unknown] create keyspace Test
>     with placement_strategy = 'org.apache.cassandra.locator.SimpleStrategy'
>     and strategy_options = [{replication_factor:1}];
> [default@unknown] use Test;
> Authenticated to keyspace: Test
> [default@Test] create column family test;
> [default@Test] describe keyspace;
> ...
>     ColumnFamily: test
>       Key Validation Class: org.apache.cassandra.db.marshal.BytesType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.BytesType
>       Row cache size / save period in seconds: 0.0/0
>       Key cache size / save period in seconds: 200000.0/14400
>       Memtable thresholds: 0.571875/122/1440 (millions of ops/MB/minutes)
>       GC grace seconds: 864000
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 1.0
>       Replicate on write: false
>       Built indexes: []
> ...
> [default@Test] update column family test with comparator = 'LongType';
> comparators do not match.
> {code}
> why?? the CF is empty
> {code}
> [default@Test] update column family test with comparator = 'BytesType';
> f8e4dcb0-9cca-11e0-0000-d0583497e7ff
> Waiting for schema agreement...
> ... schemas agree across the cluster
> [default@Test] describe keyspace;
> ...
>     ColumnFamily: test
>       Key Validation Class: org.apache.cassandra.db.marshal.BytesType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.BytesType
>       Row cache size / save period in seconds: 0.0/0
>       Key cache size / save period in seconds: 200000.0/14400
>       Memtable thresholds: 0.571875/122/1440 (millions of ops/MB/minutes)
>       GC grace seconds: 864000
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 1.0
>       Replicate on write: false
>       Built indexes: []
> ...
> [default@Test] set test[ascii('row1')][long(1)]=integer(35);
> set test[ascii('row1')][long(2)]=integer(36);
> set test[ascii('row1')][long(3)]=integer(38);
> set test[ascii('row2')][long(1)]=integer(45);
> set test[ascii('row2')][long(2)]=integer(42);
> set test[ascii('row2')][long(3)]=integer(33);
> [default@Test] list test;
> Using default limit of 100
> -------------------
> RowKey: 726f7731
> => (column=0000000000000001, value=35, timestamp=1308744931122000)
> => (column=0000000000000002, value=36, timestamp=1308744931124000)
> => (column=0000000000000003, value=38, timestamp=1308744931125000)
> -------------------
> RowKey: 726f7732
> => (column=0000000000000001, value=45, timestamp=1308744931127000)
> => (column=0000000000000002, value=42, timestamp=1308744931128000)
> => (column=0000000000000003, value=33, timestamp=1308744932722000)
> 2 Rows Returned.
> [default@Test] update column family test with comparator = 'LongType';
> comparators do not match.
> {code}
> same question than before, my columns contains only long, why I can't?
> {code}
> [default@Test] update column family test with comparator = 'BytesType';
> [default@Test] describe keyspace;                                      
> Keyspace: Test:
>   Replication Strategy: org.apache.cassandra.locator.SimpleStrategy
>     Options: [replication_factor:1]
>   Column Families:
>     ColumnFamily: test
>       Key Validation Class: org.apache.cassandra.db.marshal.BytesType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.BytesType
>       Row cache size / save period in seconds: 0.0/0
>       Key cache size / save period in seconds: 200000.0/14400
>       Memtable thresholds: 0.571875/122/1440 (millions of ops/MB/minutes)
>       GC grace seconds: 864000
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 1.0
>       Replicate on write: false
>       Built indexes: []
>       Column Metadata:
>         Column Name:  (0000000000000001)
>           Validation Class: org.apache.cassandra.db.marshal.IntegerType
>         Column Name:  (0000000000000003)
>           Validation Class: org.apache.cassandra.db.marshal.IntegerType
>         Column Name:  (0000000000000002)
>           Validation Class: org.apache.cassandra.db.marshal.IntegerType
> {code}
> Column Metadata appear from nowhere. I don't think that it's expected.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

[jira] [Commented] (CASSANDRA-2809) In the Cli, update column family with comparator; create Column metadata

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

Jonathan Ellis commented on CASSANDRA-2809:
-------------------------------------------

does this fix the describe problem too, or just the update one?

> In the Cli, update column family <cf> with comparator; create Column metadata
> -----------------------------------------------------------------------------
>
>                 Key: CASSANDRA-2809
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-2809
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Tools
>    Affects Versions: 0.7.6
>         Environment: Ubuntu 10.10, 32bit
> java version "1.6.0_24"
> installed from Debian packages of Brisk-beta2
>            Reporter: Silvère Lestang
>            Assignee: Pavel Yaskevich
>            Priority: Minor
>             Fix For: 0.7.8, 0.8.2
>
>         Attachments: 2809-validate.txt, CASSANDRA-2809.patch
>
>
> Using cassandra-cli, I can't update the comparator of a column family with the type I want and when I did it with BytesType, Column metadata appear for each of my existing columns.
> Step to reproduce:
> {code}
> [default@unknown] create keyspace Test
>     with placement_strategy = 'org.apache.cassandra.locator.SimpleStrategy'
>     and strategy_options = [{replication_factor:1}];
> [default@unknown] use Test;
> Authenticated to keyspace: Test
> [default@Test] create column family test;
> [default@Test] describe keyspace;
> ...
>     ColumnFamily: test
>       Key Validation Class: org.apache.cassandra.db.marshal.BytesType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.BytesType
>       Row cache size / save period in seconds: 0.0/0
>       Key cache size / save period in seconds: 200000.0/14400
>       Memtable thresholds: 0.571875/122/1440 (millions of ops/MB/minutes)
>       GC grace seconds: 864000
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 1.0
>       Replicate on write: false
>       Built indexes: []
> ...
> [default@Test] update column family test with comparator = 'LongType';
> comparators do not match.
> {code}
> why?? the CF is empty
> {code}
> [default@Test] update column family test with comparator = 'BytesType';
> f8e4dcb0-9cca-11e0-0000-d0583497e7ff
> Waiting for schema agreement...
> ... schemas agree across the cluster
> [default@Test] describe keyspace;
> ...
>     ColumnFamily: test
>       Key Validation Class: org.apache.cassandra.db.marshal.BytesType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.BytesType
>       Row cache size / save period in seconds: 0.0/0
>       Key cache size / save period in seconds: 200000.0/14400
>       Memtable thresholds: 0.571875/122/1440 (millions of ops/MB/minutes)
>       GC grace seconds: 864000
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 1.0
>       Replicate on write: false
>       Built indexes: []
> ...
> [default@Test] set test[ascii('row1')][long(1)]=integer(35);
> set test[ascii('row1')][long(2)]=integer(36);
> set test[ascii('row1')][long(3)]=integer(38);
> set test[ascii('row2')][long(1)]=integer(45);
> set test[ascii('row2')][long(2)]=integer(42);
> set test[ascii('row2')][long(3)]=integer(33);
> [default@Test] list test;
> Using default limit of 100
> -------------------
> RowKey: 726f7731
> => (column=0000000000000001, value=35, timestamp=1308744931122000)
> => (column=0000000000000002, value=36, timestamp=1308744931124000)
> => (column=0000000000000003, value=38, timestamp=1308744931125000)
> -------------------
> RowKey: 726f7732
> => (column=0000000000000001, value=45, timestamp=1308744931127000)
> => (column=0000000000000002, value=42, timestamp=1308744931128000)
> => (column=0000000000000003, value=33, timestamp=1308744932722000)
> 2 Rows Returned.
> [default@Test] update column family test with comparator = 'LongType';
> comparators do not match.
> {code}
> same question than before, my columns contains only long, why I can't?
> {code}
> [default@Test] update column family test with comparator = 'BytesType';
> [default@Test] describe keyspace;                                      
> Keyspace: Test:
>   Replication Strategy: org.apache.cassandra.locator.SimpleStrategy
>     Options: [replication_factor:1]
>   Column Families:
>     ColumnFamily: test
>       Key Validation Class: org.apache.cassandra.db.marshal.BytesType
>       Default column value validator: org.apache.cassandra.db.marshal.BytesType
>       Columns sorted by: org.apache.cassandra.db.marshal.BytesType
>       Row cache size / save period in seconds: 0.0/0
>       Key cache size / save period in seconds: 200000.0/14400
>       Memtable thresholds: 0.571875/122/1440 (millions of ops/MB/minutes)
>       GC grace seconds: 864000
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 1.0
>       Replicate on write: false
>       Built indexes: []
>       Column Metadata:
>         Column Name:  (0000000000000001)
>           Validation Class: org.apache.cassandra.db.marshal.IntegerType
>         Column Name:  (0000000000000003)
>           Validation Class: org.apache.cassandra.db.marshal.IntegerType
>         Column Name:  (0000000000000002)
>           Validation Class: org.apache.cassandra.db.marshal.IntegerType
> {code}
> Column Metadata appear from nowhere. I don't think that it's expected.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira