Thank you Mich, I tried the cast function too, but it still failed with
the below exception :
Failed with exception java.io.IOException:java.io.IOException: Unknown
encoding kind: DICTIONARY_V2
dictionarySize: 7
in column 219
Table Layout :
Old Partition Metadata : Col1 String, Col2 Struct .
Your Hive metadata reflects the new data type of the column changed from
type A to type B.
The old partitions have data stored as type A. These have not changed.
If you run the query on the old partition you would probably need to use
CAST function to change the column from B to A so it is compat
