hi, how about this ? (.+)&&&(.+?)(?:\^\^.*)?
On Mon, May 30, 2011 at 6:07 PM, jinhang du <dujinh...@gmail.com> wrote: > 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 > -- ------------------------------------------------------- DAVID RAN UYOU //
