hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Raghunath, Ranjith" <Ranjith.Raghuna...@usaa.com>
Subject Regex and serde with hive
Date Fri, 23 Dec 2011 04:49:47 GMT
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,
  f2    string,
  f3     string)
ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.RegexSerDe'
WITH SERDEPROPERTIES  (
"input.regex" = "([^\"~]*) ([^\"~]*) ([^\"~]*)?",
"output.format.string" = "%1$s %2$s %3$s");

When I load the data in and try to perform a select get NULL values. Thanks again.
Thank you,
Ranjith


Mime
View raw message