Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here. Want to know more about what has changed? Check out the Community News blog.

Hive - Select working in shell but not in Hue

SOLVED Go to solution

Hive - Select working in shell but not in Hue

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

Accepted Solutions

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

Champion Alumni

In the select there was a ',' missing. 

GHERMAN Alina
14 REPLIES 14

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

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

Champion Alumni

Yes, I added the serde jar in beeswax also

 

Thank you!

GHERMAN Alina

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

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

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)

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

Champion Alumni

Hello,

 

It was with beeswax :

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

 

Thank you!

GHERMAN Alina

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

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

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

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.

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

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