Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Hive - Select working in shell but not in Hue

avatar
Champion Alumni

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!

GHERMAN Alina
1 ACCEPTED SOLUTION

avatar
Champion Alumni

In the select there was a ',' missing. 

GHERMAN Alina

View solution in original post

14 REPLIES 14

avatar
Super Guru
Which Hue / Hive version are you using?

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

Romain

avatar
Champion Alumni

Yes, I added the serde jar in beeswax also

 

Thank you!

GHERMAN Alina

avatar
Champion Alumni

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

GHERMAN Alina

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

avatar
Champion Alumni

Hello,

 

It was with beeswax :

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

 

Thank you!

GHERMAN Alina

avatar
Super Guru

avatar
Champion Alumni

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!

GHERMAN Alina

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

avatar
Champion Alumni

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)

GHERMAN Alina