cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Feng Qu <mail...@gmail.com>
Subject can I drop a composite index using cli?
Date Fri, 20 Jul 2012 20:59:39 GMT
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
Mime
View raw message