- Treasury Today's Adam Smith Awards 2009.
- Original Message -
From: Loren Siebert lo...@siebert.org
To: user@hive.apache.org
Sent: Friday, December 23, 2011 2:27:15 AM
Subject: Re: Regex and serde with hive
The input regexp does not look right to me. You are expecting a space between
-Original Message-
From: Mark Grover [mailto:mgro...@oanda.com]
Sent: Friday, December 23, 2011 9:29 AM
To: user@hive.apache.org
Subject: Re: Regex and serde with hive
Hi Ranjith,
Like Loren, I don't think the regex you are using is correct.
If you use a create table command like the following
The input regexp does not look right to me. You are expecting a space between
groups, but your example contains no spaces. And where do you handle the
first/last quotes? Wouldn’t it look more like this:
input.regex = “\([^\~]*)[\~]*([^\~]*)[\~]*([^\~]*)\
Rather than trying to tackle it all at
If the format is simply delimited like this, you don't need to use the
RegexSerde. Hive's default format with the right FIELDS TERMINATED
BY setting will work great.
-Vijay
On Thu, Dec 22, 2011 at 8:49 PM, Raghunath, Ranjith
ranjith.raghuna...@usaa.com wrote:
I have been struggling with this