hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "皮皮" <wang.aj...@qq.com>
Subject Re:Question about create hive tables.
Date Mon, 30 May 2011 09:20:54 GMT
maybe  change  the regex to 
"input.regex"="(.+)&&&(.+)\^\^.+?" 










 
 
------------------ Original ------------------
From:  "jinhang du"<dujinhang@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
Mime
View raw message