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
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
<<image001.gif>>
