Today it is not possible to change the comparators (compare_with and compare_subcolumns_with). I went through the discussion on thread http://comments.gmane.org/gmane.comp.db.cassandra.user/12466.
Does it make sense to atleast allow one way change i.e. from specific types to generic type? For eg change from TimeUUIDType or UTF8 to BytesType. This could be a manual process where users will do the schema change and then run major compaction on all the nodes to fix the ordering. Thanks, Naren