You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Panshul Whisper <ou...@gmail.com> on 2013/10/16 15:42:33 UTC

Where to get hive serde jars.

Hello,

I am trying to implement Serde in hive for reading Json files directly into
my hive tables.
I am using cloudera hue for querying to the hive server.

Where can I get the cloudera hive serde jars from?
or am I missing something else?

when I create a table with the following statement:

create external table if not exists power_raw_json (
  value STRING
  )
  ROW FORMAT SERDE 'com.cloudera.hive.serde.JSONSerDe'
  Location 's3n://verivox-rawdata/strom/version1/2013_10_1/';

I get the following error:

FAILED: Error in metadata: Cannot validate serde:
com.cloudera.hive.serde.JSONSerDe


My guess, I need to add the serde jar to the path of Hive server, but where
do I find the Jars?

Thanking you for the help.
-- 
Regards,
Ouch Whisper
010101010101

Re: Where to get hive serde jars.

Posted by Sonal Goyal <so...@gmail.com>.
You can get the ser de from https://github.com/cloudera/cdh-twitter-example. I am not sure if there is a prebuilt version in any Cloudera repo, but you can check with the Cloudera team. 



Sent from my iPad

On Oct 16, 2013, at 7:12 PM, Panshul Whisper <ou...@gmail.com> wrote:

> Hello,
> 
> I am trying to implement Serde in hive for reading Json files directly into my hive tables.
> I am using cloudera hue for querying to the hive server. 
> 
> Where can I get the cloudera hive serde jars from? 
> or am I missing something else?
> 
> when I create a table with the following statement: 
> 
> create external table if not exists power_raw_json (
>   value STRING
>   )
>   ROW FORMAT SERDE 'com.cloudera.hive.serde.JSONSerDe'
>   Location 's3n://verivox-rawdata/strom/version1/2013_10_1/';
> 
> I get the following error:
> 
> FAILED: Error in metadata: Cannot validate serde: com.cloudera.hive.serde.JSONSerDe
> 
> My guess, I need to add the serde jar to the path of Hive server, but where do I find the Jars?
> 
> Thanking you for the help.
> -- 
> Regards,
> Ouch Whisper
> 010101010101