You need to tell Hive about the JAR. This is how I do it in hive-site.xml:
<property>
<name>hive.aux.jars.path</name>
<value>file:///usr/lib/hive/lib/hive-contrib-0.7.0-CDH3B4.jar</value>
<description>These JAR file are available to all users for all
jobs</description>
</property>
On Apr 5, 2011, at 3:50 PM, Jasper Knulst wrote:
> Hi(ve),
>
> I created a table like this;
>
> create table testtable (veld1 STRING,veld2 STRING,veld3 STRING) ROW FORMAT
> SERDE 'org.apache.hadoop.hive.contrib.serde2.RegexSerDe'
> > WITH SERDEPROPERTIES ("input.regex" =
> "([a-z]{4}[0-9])þ([a-z]{4}[0-9])þ([a-z]{4}[0-9])") STORED AS TEXTFILE;
>
>
> The table is OK, select * from testtable shows the contents of the underlying
> HDFS file.
>
> However when I invoke a MR job by select veld2 from testtable, the MR job
> starts but I get mapper errors saying:
>
> "Caused by: org.apache.hadoop.hive.ql.metadata.HiveException:
> java.lang.ClassNotFoundException:
> org.apache.hadoop.hive.contrib.serde2.RegexSerDe"
>
> I already copied the hive serde jar (in my case hive-serde-0.7.0-CDH3B4.jar)
> to $HADOOP_HOME/lib and restarted jobtracker/tasktrackers but that doesn't
> help.
>
> Cheers Jasper
>
> --
> Kind Regards \ Met Vriendelijke Groet,
>
>
>
>
>
> Jasper Knulst
>
> BI Consultant
>
> <image001.gif>
>
>
>
> VLC Den Haag
> Gildeweg 5B
> 2632 BD Nootdorp
>
>
> M: +31 (0)6 19 66 75 11
>
> T: +31 (0)15 764 07 50
> ------------------------------------------------------------
>
> Skype: jasper_knulst_vlc
>
