org.apache.hadoop.hive.serde2.io.DoubleWritable cannot be cast to org.apache.hadoop.hive.serde2.io.HiveDecimalWritable error

Fri, 06 May 2016 16:28:53 -0700 

I created a table using SparkSQL and loaded parquet data into the table but
when I attempt to do a 'SELECT * FROM tbl' I keep running into this error:

Error: java.io.IOException:
org.apache.hadoop.hive.ql.metadata.HiveException:
java.lang.ClassCastException:
org.apache.hadoop.hive.serde2.io.DoubleWritable cannot be cast to
org.apache.hadoop.hive.serde2.io.HiveDecimalWritable (state=,code=0)

Here is how I created the table:

CREATE TABLE IF NOT EXISTS tbl (
     c1 STRING,
     c2 STRING,
     value DECIMAL(28, 22))
 STORED AS PARQUET")

Is there anyway to fix this error or do I need some other way to load the
data into the table?

Thanks!

Reply via email to