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
Hi All,
I have a table partitioned on a date column. We have changed the data type
of one of the field for the older partitions and the data type of the newer
partitions will remain the same as the table. When I tried to run a simple
Select query on the older partitions , the query is failing with