Which version of Hive are you on? The recent versions (hive >= 2.3) should support schema evolution in the ORC reader.
.. Owen On Wed, Jul 17, 2019 at 11:07 PM Jörn Franke <jornfra...@gmail.com> wrote: > 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 >
