Re: Problem Hive table RegexSerDe and Hadoop MR

2011-04-05 Thread Jasper Knulst
Thanks Loren, That worked! Jasper 2011/4/6 Loren Siebert > You need to tell Hive about the JAR. This is how I do it in hive-site.xml: > > > hive.aux.jars.path > file:///usr/lib/hive/lib/hive-contrib-0.7.0-CDH3B4.jar > These JAR file are available to all users for all > jobs > > > > On Apr

Re: Problem Hive table RegexSerDe and Hadoop MR

2011-04-05 Thread Loren Siebert
You need to tell Hive about the JAR. This is how I do it in hive-site.xml: hive.aux.jars.path file:///usr/lib/hive/lib/hive-contrib-0.7.0-CDH3B4.jar These JAR file are available to all users for all jobs On Apr 5, 2011, at 3:50 PM, Jasper Knulst wrote: > Hi(ve), > > I created a table

Problem Hive table RegexSerDe and Hadoop MR

2011-04-05 Thread Jasper Knulst
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 i