Reply
Champion Alumni
Posts: 196
Registered: ‎11-18-2014
Accepted Solution

Hive - Select working in shell but not in Hue

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
Cloudera Employee
Posts: 723
Registered: ‎07-30-2013

Re: Hive - Select working in shell but not in Hue

Which Hue / Hive version are you using?

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

Romain

Champion Alumni
Posts: 196
Registered: ‎11-18-2014

Re: Hive - Select working in shell but not in Hue

Yes, I added the serde jar in beeswax also

 

Thank you!

GHERMAN Alina
Champion Alumni
Posts: 196
Registered: ‎11-18-2014

Re: Hive - Select working in shell but not in Hue

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
Cloudera Employee
Posts: 723
Registered: ‎07-30-2013

Re: Hive - Select working in shell but not in Hue

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

Champion Alumni
Posts: 196
Registered: ‎11-18-2014

Re: Hive - Select working in shell but not in Hue

Hello,

 

It was with beeswax :

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

 

Thank you!

GHERMAN Alina
Cloudera Employee
Posts: 723
Registered: ‎07-30-2013

Re: Hive - Select working in shell but not in Hue

Champion Alumni
Posts: 196
Registered: ‎11-18-2014

Re: Hive - Select working in shell but not in Hue

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
Cloudera Employee
Posts: 723
Registered: ‎07-30-2013

Re: Hive - Select working in shell but not in Hue

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

Champion Alumni
Posts: 196
Registered: ‎11-18-2014

Re: Hive - Select working in shell but not in Hue

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