cqlsh> select * from whois.ipbans;
 KEY,80.65.56.165
 KEY,204.229.100.77
 KEY,75.144.148.1
 KEY,111.191.88.7
'int' object has no attribute 'replace'
cqlsh>

its counter CF

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}];

Reply via email to