Re: Query failing in Hive 2.2

2018-01-22 Thread Raghuraman Murugaiyan
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 .

Re: Query failing in Hive 2.2

2018-01-20 Thread Mich Talebzadeh
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

Query failing in Hive 2.2

2018-01-19 Thread Raghuraman Murugaiyan
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