drop_all_indexes.py

import pycassa

sm = pycassa.system_manager.SystemManager('127.0.0.1:9160')

keyspaces = sm.list_keyspaces()

for keyspace in keyspaces:
    if keyspace == 'system':
        continue
    cfs = sm.get_keyspace_column_families(keyspace)
    for cfname, metadata in cfs.iteritems():
        for col in metadata.column_metadata:
            if col.index_name is not None:
                print('Dropping index {0}.{1}.{2}'.format(keyspace, cfname, col.name))
                sm.drop_index(keyspace, cfname, col.name)