Hive - Select working in shell but not in Hue

[#1]

Hello,

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)? 

Thank you!

[#2]

Which Hue / Hive version are you using?

Did you add the jar as a jar resource in the Beeswax/Hive Editor in Hue?

Romain

[#3]

Yes, I added the serde jar in beeswax also

Thank you!

[#4]

And my hive version is :

Hive 0.13.1-cdh5.3.0

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

[#5]

When you tried with the Hive shell, was it with 'beeline'? (as the 'hive'
command is different as it is not using HiveServer2)

[#6]

Hello,

It was with beeswax :

http://<ip of my namenode>:8888/beeswax/#query

Thank you!

[#7]

Yes, you need to try with 'beeline':

http://www.cloudera.com/content/cloudera/en/documentation/core/latest/topics/cdh_ig_hiveserver2_star...

Romain

[#8]

With beeline I get the same error:

 Error: java.lang.ClassCastException: java.lang.String cannot be cast to java.lang.Integer (state=,code=0)

Thank you!

[#9]

Here we go, your Hive setup has probably a problem. You should follow-up on
the Hive list.

[#10]

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)