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

Reply via email to