we can convert text to varchar by alter command.
I have a table structure like :
CREATE TABLE killrvideo.videos ( video_id timeuuid PRIMARY KEY, added_date timestamp, comments text, title text )
and I want to edit datatype of comments to varchar.
the data is :
comments ---------------- Hi ! There Hi ! Datastax Hi ! Cassandra Hi ! Devlopers Hi ! Admins
but when i execute alter command :
alter table videos alter comments type varchar; InvalidRequest: Error from server: code=2200 [Invalid query] message="Altering of types is not allowed"
this is failing but why ? compatibility is ok but still not working for me