Re: Having trouble using regex serde

2011-09-30 Thread Jonathan
So the regex has to match every piece of the line completely. I wrote the regex so that it just takes a few helpful things out of the log line. Thanks for your help Jonathan On Sat, Oct 1, 2011 at 12:14 AM, Vijay wrote: > The log lines are in some kind of JSON format though. The regex needs >

Re: Having trouble using regex serde

2011-09-30 Thread Vijay
The log lines are in some kind of JSON format though. The regex needs to literally match the log lines. On Fri, Sep 30, 2011 at 8:52 PM, Jonathan wrote: > Hi, > I am  trying to parse an apache2 log using > the 'org.apache.hadoop.hive.contrib.serde2.RegexSerDe'. I am able to load > the tables usin

Having trouble using regex serde

2011-09-30 Thread Jonathan
Hi, I am trying to parse an apache2 log using the 'org.apache.hadoop.hive.contrib.serde2.RegexSerDe'. I am able to load the tables using the script below but its showing up each of the 3 rows as null for every entry. CREATE TABLE apachelog4 ( ip STRING, time STRING, beacon STRING) ROW FORM