hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From YUYANG LAN <asyura...@gmail.com>
Subject Re: Question about create hive tables.
Date Mon, 30 May 2011 13:45:57 GMT
hi, how about this ?

(.+)&&&(.+?)(?:\^\^.*)?

On Mon, May 30, 2011 at 6:07 PM, jinhang du <dujinhang@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 //

Mime
View raw message