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