How does the columns in the table match the "input.regex" ? In other words, which part of the regex matches the columns of the table?
Will anybody offer some help? 2011/5/30 YUYANG LAN <asyura...@gmail.com> > 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 // > -- dujinhang
