You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "paul cannon (Commented) (JIRA)" <ji...@apache.org> on 2012/03/26 17:34:27 UTC
[jira] [Commented] (CASSANDRA-4083) cqlsh fails to list counter CF
[ https://issues.apache.org/jira/browse/CASSANDRA-4083?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13238485#comment-13238485 ]
paul cannon commented on CASSANDRA-4083:
----------------------------------------
Item (1) is as intended; all current (at least all official) cassandra interfaces include row keys with only tombstone columns in them when fetching a range of keys. This behavior is apparently useful for some applications. Changing the behavior, or adding some sort of option or CQL syntax to omit those, would be doable but would need a separate dedicated JIRA ticket and some discussion.
I'll put in a fix for item (2).
> cqlsh fails to list counter CF
> ------------------------------
>
> Key: CASSANDRA-4083
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4083
> Project: Cassandra
> Issue Type: Bug
> Components: Tools
> Affects Versions: 1.0.8
> Reporter: Radim Kolar
> Assignee: paul cannon
>
> 1.
> These rows displayed are tombstones, they should not be displayed at all
> 2.
> It fails on first counter
> cqlsh> select * from whois.ipbans;
> KEY,80.65.56.165
> KEY,ACA35681.ipt.aol.com
> KEY,204.229.100.77
> KEY,31.223.184.51
> KEY,75.144.148.1
> KEY,189.27.59.210
> KEY,111.191.88.7
> KEY,152.26.21.2
> KEY,81.43.98.238
> KEY,64.71.194.172
> KEY,189.83.117.145
> KEY,159.0.53.197
> KEY,190.236.203.195
> KEY,130.255.163.20
> Traceback (most recent call last):
> File "/usr/local/bin/cqlsh", line 580, in onecmd
> self.handle_statement(st)
> File "/usr/local/bin/cqlsh", line 605, in handle_statement
> return custom_handler(parsed)
> File "/usr/local/bin/cqlsh", line 662, in do_select
> self.perform_statement_as_tokens(parsed.matched, decoder=decoder)
> File "/usr/local/bin/cqlsh", line 665, in perform_statement_as_tokens
> return self.perform_statement(cqlhandling.cql_detokenize(tokens), decoder=decoder)
> File "/usr/local/bin/cqlsh", line 692, in perform_statement
> self.print_result(self.cursor)
> File "/usr/local/bin/cqlsh", line 729, in print_result
> self.print_dynamic_result(cursor)
> File "/usr/local/bin/cqlsh", line 764, in print_dynamic_result
> colvals = [self.myformat_value(val, casstype) for (val, casstype) in zip(row, coltypes)]
> File "/usr/local/bin/cqlsh", line 402, in myformat_value
> float_precision=self.display_float_precision)
> File "/usr/local/bin/cqlsh", line 346, in format_value
> escapedval = val.replace('\\', '\\\\')
> AttributeError: 'int' object has no attribute 'replace'
> [default@whois] list ipbans;
> Using default limit of 100
> -------------------
> RowKey: 80.65.56.165
> -------------------
> RowKey: ACA35681.ipt.aol.com
> -------------------
> RowKey: 204.229.100.77
> -------------------
> RowKey: 31.223.184.51
> -------------------
> RowKey: 75.144.148.1
> -------------------
> RowKey: 189.27.59.210
> -------------------
> RowKey: 111.191.88.7
> -------------------
> RowKey: 152.26.21.2
> -------------------
> RowKey: 81.43.98.238
> -------------------
> RowKey: 64.71.194.172
> -------------------
> RowKey: 189.83.117.145
> -------------------
> RowKey: 159.0.53.197
> -------------------
> RowKey: 190.236.203.195
> -------------------
> RowKey: 130.255.163.20
> -------------------
> RowKey: 80.248.237.157
> => (counter=hits, value=4)
> -------------------
> create column family ipbans
> with column_type = 'Standard'
> and comparator = 'AsciiType'
> and default_validation_class = 'CounterColumnType'
> and key_validation_class = 'AsciiType'
> and rows_cached = 500.0
> and row_cache_save_period = 0
> and row_cache_keys_to_save = 2147483647
> and keys_cached = 50000.0
> and key_cache_save_period = 14400
> and read_repair_chance = 0.2
> and gc_grace = 86400
> and min_compaction_threshold = 2
> and max_compaction_threshold = 32
> and replicate_on_write = true
> and row_cache_provider = 'ConcurrentLinkedHashCacheProvider'
> and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
> and comment = 'number of queries per IP address'
> and column_metadata = [
> {column_name : 'hits',
> validation_class : CounterColumnType}];
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira