Hello,
How to go about sharding a super column family?
I tried this ...
create column family user_notifications_by_type_resource
with column_type = 'Super'
and comparator = 'UTF8Type'
and subcomparator = 'UTF8Type'
and default_validation_class = 'BytesType'
and key_validation_class = 'LongType'
and column_metadata=[{column_name:shard, validation_class:AsciiType, index_type:KEYS}]
and rows_cached = 0.0
and row_cache_save_period = 0
and row_cache_keys_to_save = 2147483647
and keys_cached = 200000.0
and key_cache_save_period = 14400
and read_repair_chance = 1.0
and gc_grace = 864000
and min_compaction_threshold = 4
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 = 'user notifications by type and resource';
and got -
Line 11 => Secondary indexes are not supported on supercolumns
Thanks
Naga Vijay