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

Re: UDF constructor params?

2011-04-05 Thread John Sichi
https://issues.apache.org/jira/browse/HIVE-1016 https://issues.apache.org/jira/browse/HIVE-1360 JVS On Apr 5, 2011, at 11:20 AM, Larry Ogrodnek wrote: > For some UDFs I'm working on now it feels like it would be handy to be > able to pass in parameters during construction. It's an integration >

Re: UDF constructor params?

2011-04-05 Thread Edward Capriolo
On Tue, Apr 5, 2011 at 2:20 PM, Larry Ogrodnek wrote: > For some UDFs I'm working on now it feels like it would be handy to be > able to pass in parameters during construction.  It's an integration > with an external reporting API... > > e.g. > > -- include last 30 days from april 4th > create tem

UDF constructor params?

2011-04-05 Thread Larry Ogrodnek
For some UDFs I'm working on now it feels like it would be handy to be able to pass in parameters during construction. It's an integration with an external reporting API... e.g. -- include last 30 days from april 4th create temporary function orders_last_month as 'com.example.OrderSearch("201104