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