My data format is as follows: a&&&b c&&&b^^xyz c&&&d^^hdo
create table f(str1 string, str2 string) ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.RegexSerDe' With SERDEPROPERTIES ( "input.regex"="(.+)&&&(.+)(\^\^.+)?" ) My aim is : a b c b c d However , a b c b^^xyz c d^^hdo So how to fix the regex to get the right answer? Thank you for help. -- dujinhang
