You have to create a new table with this column as varchar and do a select insert from the old table.
> Am 18.07.2019 um 01:14 schrieb William Shen <wills...@marinsoftware.com>: > > Hi all, > > I assumed that it should be compatible to convert column type varchar to > string, however, after running ALTER TABLE table CHANGE col col STRING, I > encounter the following error when querying the column from hive: > > Failed with exception > java.io.IOException:org.apache.hadoop.hive.ql.metadata.HiveException: > java.lang.ClassCastException: > org.apache.hadoop.hive.serde2.io.HiveVarcharWritable cannot be cast to > org.apache.hadoop.io.Text > > Anyone encountered this before, or know how to work around this? > > Thank you! > > - Will
