You need to run "add jar" before running the SELECT command. Don't copy it to $hadoop_dir/lib - That will make upgrading Hive much harder.
Zheng On Thu, Sep 10, 2009 at 9:10 PM, Mayuran Yogarajah < [email protected]> wrote: > I have a table with: > ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.RegexSerDe' > > When I do a select on the table with a WHERE clause it runs a mapred job > which fails with the following: > > java.lang.ClassNotFoundException: > org.apache.hadoop.hive.contrib.serde2.RegexSerDe > > > I have copied $hive_build_dir/build/serde/hive_serde.jar into > $hadoop_dir/lib. I'm not > sure if I need to do anything else to get this working. Can anyone help? > > thanks > -- Yours, Zheng
