I created a json table in Hive and then I loaded data from a folder into it. The query is sucessful.
ADD JAR /data/hive/jars/json-serde-1.3-jar-with-dependencies.jar;
Select * from myTable
However, when I try to access the table I get an error:
java.lang.ClassCastException: java.lang.String cannot be cast to java.lang.Integer
When I try to access the same table with the same query in Hive shell I do not get any error and I can acess the table.
Where should I look for? IS there any other jar that I have to add in order to make this work in beeswax(hue)?
And my hive version is :
Subversion git://rhel64-6-0-mk4.jenkins.cloudera.com/data/1/jenkins/workspace/generic-package-rhel64-6-0/topdir/BUILD/hive-0.13.1-cdh5.3.0 -r 8e266e052e423af592871e2dfe09d54c03f6a0e8
Compiled by jenkins on Tue Dec 16 19:03:11 PST 2014
With beeline I get the same error:
Error: java.lang.ClassCastException: java.lang.String cannot be cast to java.lang.Integer (state=,code=0)
But.. I get this only with this table! I don't thing is a hive configuration (We installed everything with Cloudera Manager and we didn't changed the default settings)