-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 followin
ence Analyst
OANDA Corporation
www: oanda.com www: fxtrade.com
e: mgro...@oanda.com
"Best Trading Platform" - World Finance's Forex Awards 2009.
"The One to Watch" - Treasury Today's Adam Smith Awards 2009.
- Original Message -
From: "Loren Siebert"
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
wrote:
> I have been struggling with this for a while so I would appr
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
I have been struggling with this for a while so I would appreciate any advice
that you any of you may have.
I have a file of the format
"Xyz"~"qsd"~"1234"
I created the following table definition to get the data loaded
CREATE TABLE dummy
(f1 string,
f2string,
f3 string)
ROW FORMA
