maybe change the regex to "input.regex"="(.+)&&&(.+)\^\^.+?"
------------------ Original ------------------ From: "jinhang du"<dujinh...@gmail.com>; Date: Mon, May 30, 2011 05:07 PM To: "user"<user@hive.apache.org>; Subject: Question about create hive tables. 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
