Can I drop composite index in CLI? What’s syntax? Or do I have to use cqlsh?
[default@mobilelogks] drop index on
MobilePushNotificationLog.retryCount;
Column 'retryCount' does
not have an index.
[default@mobilelogks] help drop index;
drop index on <cf>.<column>;
Drops index on specified column of the column family.
Required Parameters:
- cf: Name of the column family.
- column: Name of the column to delete index on.
Example:
drop index on Users.name;
create column family MobilePushNotificationLog
with column_type = 'Standard'
and comparator = 'UTF8Type'
and default_validation_class = 'BytesType'
and key_validation_class = 'UTF8Type'
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 = 'SerializingCacheProvider'
and compaction_strategy =
'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
and column_metadata = [
{column_name : 'adjUserName',
validation_class : UTF8Type},
{column_name : 'clientId',
validation_class : UTF8Type},
{column_name : 'consumer',
validation_class : UTF8Type},
{column_name : 'createdTime',
validation_class : UTF8Type},
{column_name : 'data',
validation_class : UTF8Type},
{column_name : 'deliveredTime',
validation_class : UTF8Type,
index_name : 'MobilePushNotificationLog_deliveredTime_idx',
index_type : 0},
{column_name : 'deliveryPolicy',
validation_class : UTF8Type},
{column_name : 'deviceId',
validation_class : UTF8Type,
index_name :
'MobilePushNotificationLog_deviceId_idx',
index_type : 0},
{column_name : 'deviceToken',
validation_class : UTF8Type},
{column_name : 'error',
validation_class : UTF8Type},
{column_name : 'eventName',
validation_class : UTF8Type,
index_name :
'MobilePushNotificationLog_eventName_idx',
index_type : 0},
{column_name : 'notifId',
validation_class : UTF8Type},
{column_name : 'payload',
validation_class : UTF8Type},
{column_name : 'referenceId',
validation_class : UTF8Type,
index_name :
'MobilePushNotificationLog_referenceId_idx',
index_type : 0},
{column_name : 'retryCount',
validation_class : UTF8Type},
{column_name : 'status',
validation_class : UTF8Type},
{column_name : 'userName',
validation_class : UTF8Type,
index_name : 'MobilePushNotificationLog_userName_idx',
index_type : 0}];
Feng Qu
