Thanks Loren,
That worked!
Jasper
2011/4/6 Loren Siebert <lo...@siebert.org>
> 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
> >
> > --
> >
>
