question Hive - Select working in shell but not in Hue in Support Questions

Hive - Select working in shell but not in Hue

AlinaGHERMAN — Fri, 16 Sep 2022 09:20:00 GMT

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!

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

Romainr — Thu, 22 Jan 2015 17:46:36 GMT

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

AlinaGHERMAN — Thu, 22 Jan 2015 18:22:45 GMT

Yes, I added the serde jar in beeswax also

Thank you!

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

AlinaGHERMAN — Mon, 26 Jan 2015 07:42:04 GMT

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

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

Romainr — Mon, 26 Jan 2015 09:41:36 GMT

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

AlinaGHERMAN — Mon, 26 Jan 2015 10:51:18 GMT

Hello,

It was with beeswax :

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

Thank you!

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

Romainr — Mon, 26 Jan 2015 14:08:36 GMT

Yes, you need to try with 'beeline':

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

Romain

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

AlinaGHERMAN — Mon, 26 Jan 2015 16:08:38 GMT

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!

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

Romainr — Tue, 27 Jan 2015 09:26:36 GMT

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

AlinaGHERMAN — Tue, 27 Jan 2015 13:11:20 GMT

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)

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

AlinaGHERMAN — Tue, 03 Feb 2015 14:01:57 GMT

In the select there was a ',' missing.

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

Romainr — Tue, 03 Feb 2015 14:26:07 GMT

Awesome 🙂

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

skylark — Fri, 01 May 2015 23:35:45 GMT

hi, Romain,

I am having the same issue. I just installed CDH5.4 and use json-serde-1.3-jar-with-dependencies.jar to create external table.

CREATE EXTERNAL TABLE IF NOT EXISTS mytable2 (field1 string, field2 int, field3 string, field4 double) ROW FORMAT SERDE 'org.openx.data.jsonserde.JsonSerDe' WITH SERDEPROPERTIES ( "ignore.malformed.json" = "true") LOCATION '/tmp/mytable2';

The testing data is:

{"field1":"data1","field2":100,"field3":"more data1","field4":123.001}

In Hive CLI I am able to query the table. But when I use beeline or Hue interface, I got the same error:

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

I have copied the json-serde-1.3-jar-with-dependencies.jar to the following directory but it still does not work:

/var/opt/cloudera/parcels/CDH/lib/hive/lib/

/var/opt/cloudera/parcels/CDH/lib/hadoop/lib/

/var/opt/cloudera/parcels/CDH/lib/hadoop-mapreduce/lib/

/var/opt/cloudera/parcels/CDH/lib/hadoop-0.20-mapreduce/lib/

Do you know the reason?

thanks

Bin

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

Romainr — Tue, 05 May 2015 03:58:13 GMT

Did you load the jar in the editor?

A bit like http://gethue.com/hadoop-tutorial-hive-udf-in-1-minute/

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

rastogishivam — Tue, 17 May 2016 17:21:35 GMT

Hi Romainr,
I am using cdh5.5.2 with Hue 3.9.0.
As part of Hive Config, I have set Hive Auxiliary JARs Directory as '/usr/lib/hive/lib' which contains the Json Serde Jar.
Further I have -
1) Using Hive Command Line - Created a table in Hive, with [ ROW FORMAT SERDE 'com.cloudera.hive.serde.JSONSerDe' ]
2) Loaded sample data to Hive table
3) Ran 'select * tableName;' successfully.
4) When I ran the same in < Hue - Hive Editor >, I am facing the following error-
FAILED: RuntimeException MetaException(message:java.lang.ClassNotFoundException Class com.cloudera.hive.serde.JSONSerDe not found)

Can you please advise ?