Failed with exception java.io.IOException:org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.ClassCastException: org.apache.hadoop.hive.serde2.io.HiveDecimalWritable cannot be cast to org.apache.hadoop.io.LongWritable

[#1]

got the above error while select the records from hive table.

[#2]

Hey @Sundar Lakshmanan!
Could you share with us the following output?

describe formatted <table_name>;

Usually, this happens to mismatched types or some data overflowing the datatype.
Are you able to do a simple query?

select * from <table_name> limit 10;

Hope this helps!

[#3]

No i cant view the result of this simple query