[jira] [Commented] (CASSANDRA-4805) live update compaction strategy destroy counter column family
[ https://issues.apache.org/jira/browse/CASSANDRA-4805?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13476853#comment-13476853 ] sunjian commented on CASSANDRA-4805: [~jbellis] thanks . I am using CQL3 to create tables , but not all with composite key . And there are tables created by thrift API as will . I will try the 1.2 beta2 > live update compaction strategy destroy counter column family > -- > > Key: CASSANDRA-4805 > URL: https://issues.apache.org/jira/browse/CASSANDRA-4805 > Project: Cassandra > Issue Type: Bug > Components: Core >Affects Versions: 1.1.5 > Environment: centos 64 , cassandra 1.1.5 >Reporter: sunjian > > 1. in a running cassandra cluster with 5 nodes > 2. CLI : update column family {user_stats (a counter column family)} with > compaction_strategy='LeveledCompactionStrategy' > 3. nodetool -h host_ip compact > result : > can't INCR/DECR the counter column any more , but it's OK to read . > > counter column family definition : > String sql = "CREATE TABLE user_stats (" + > "user_id bigint ," + > "counter_type text ," + > "counter_for_what text ," + > "counter_value counter ," + > " PRIMARY KEY(" > + " user_id " > + "," > + "counter_type " > + "," > + "counter_for_what " > +")) WITH read_repair_chance = 1.0 AND > replicate_on_write=true " ; > [exception] > java.sql.SQLSyntaxErrorException: InvalidRequestException(why:Unknown > identifier counter_value) > at > org.apache.cassandra.cql.jdbc.CassandraPreparedStatement.(CassandraPreparedStatement.java:92) > > at > org.apache.cassandra.cql.jdbc.CassandraConnection.prepareStatement(CassandraConnection.java:303) > -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-4805) live update compaction strategy destroy counter column family
[ https://issues.apache.org/jira/browse/CASSANDRA-4805?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13476676#comment-13476676 ] Jonathan Ellis commented on CASSANDRA-4805: --- If you are using CQL3, then I would definitely consider that. beta2 will be released shortly and that will give you a better idea what to expect. > live update compaction strategy destroy counter column family > -- > > Key: CASSANDRA-4805 > URL: https://issues.apache.org/jira/browse/CASSANDRA-4805 > Project: Cassandra > Issue Type: Bug > Components: Core >Affects Versions: 1.1.5 > Environment: centos 64 , cassandra 1.1.5 >Reporter: sunjian > > 1. in a running cassandra cluster with 5 nodes > 2. CLI : update column family {user_stats (a counter column family)} with > compaction_strategy='LeveledCompactionStrategy' > 3. nodetool -h host_ip compact > result : > can't INCR/DECR the counter column any more , but it's OK to read . > > counter column family definition : > String sql = "CREATE TABLE user_stats (" + > "user_id bigint ," + > "counter_type text ," + > "counter_for_what text ," + > "counter_value counter ," + > " PRIMARY KEY(" > + " user_id " > + "," > + "counter_type " > + "," > + "counter_for_what " > +")) WITH read_repair_chance = 1.0 AND > replicate_on_write=true " ; > [exception] > java.sql.SQLSyntaxErrorException: InvalidRequestException(why:Unknown > identifier counter_value) > at > org.apache.cassandra.cql.jdbc.CassandraPreparedStatement.(CassandraPreparedStatement.java:92) > > at > org.apache.cassandra.cql.jdbc.CassandraConnection.prepareStatement(CassandraConnection.java:303) > -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-4805) live update compaction strategy destroy counter column family
[ https://issues.apache.org/jira/browse/CASSANDRA-4805?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13476674#comment-13476674 ] sunjian commented on CASSANDRA-4805: [~jbellis] We use cassandra 1.1.5 currently , shall we update the cluster to 1.2 after it released ? > live update compaction strategy destroy counter column family > -- > > Key: CASSANDRA-4805 > URL: https://issues.apache.org/jira/browse/CASSANDRA-4805 > Project: Cassandra > Issue Type: Bug > Components: Core >Affects Versions: 1.1.5 > Environment: centos 64 , cassandra 1.1.5 >Reporter: sunjian > > 1. in a running cassandra cluster with 5 nodes > 2. CLI : update column family {user_stats (a counter column family)} with > compaction_strategy='LeveledCompactionStrategy' > 3. nodetool -h host_ip compact > result : > can't INCR/DECR the counter column any more , but it's OK to read . > > counter column family definition : > String sql = "CREATE TABLE user_stats (" + > "user_id bigint ," + > "counter_type text ," + > "counter_for_what text ," + > "counter_value counter ," + > " PRIMARY KEY(" > + " user_id " > + "," > + "counter_type " > + "," > + "counter_for_what " > +")) WITH read_repair_chance = 1.0 AND > replicate_on_write=true " ; > [exception] > java.sql.SQLSyntaxErrorException: InvalidRequestException(why:Unknown > identifier counter_value) > at > org.apache.cassandra.cql.jdbc.CassandraPreparedStatement.(CassandraPreparedStatement.java:92) > > at > org.apache.cassandra.cql.jdbc.CassandraConnection.prepareStatement(CassandraConnection.java:303) > -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira