I too have the same scenario where in the column was decimal and updated to bigint, now getting error while querying the column.  the data type on the table and the parquet file are aligned.   Error: java.io.IOException: java.lang.ClassCastException: org.apache.hadoop.io.LongWritable cannot be cast to org.apache.hadoop.hive.serde2.io.HiveDecimalWritable (state=,code=0)   If you have already resolved the issue, much appreciate if you could let know what worked for you.    Thanks  Dinesh ... View more

No i cant view the result of this simple query   ... View more

Thanks @ Sandeep Nemuri @ rguruvannagari works fine ... View more

@Sundar Lakshmanan When you are having a derived column then you should create an alias for it instead of treating it like a variable assignment. Ex. Select (your calculation for derived column) as derived_column. SELECT CONSUMER_R , CNTRY_ISO_C , (CASE WHEN ( DTBIRTH_Y = '0001-01-01' ) THEN 0 ELSE cast((DATEDIFF(current_date,'0001-01-01')/365) as smallint) END) as NEW_AGE, .... ... View more

@Sundar Lakshmanan Glad it helped. Happy Hadooping! ... View more

@Sundar Lakshmanan Glad we found the problem. If you are satisfied, please accept the original answer. (That's how HCC works 🙂 ... View more

@Sundar Lakshmanan If "Yess", can you please accept Ayub's answer to help us manage answered questions. Tnx! ... View more

Well, this is my first visit to your blog! Your blog provided us valuable information .You have done a marvelous job - happy wheels , I think this is an informative post and it is very useful and knowledgeable. I really enjoyed reading this post. big fan, thank you! - happy wheels ... View more