hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jinhang du <dujinh...@gmail.com>
Subject Re: Question about create hive tables.
Date Tue, 31 May 2011 07:00:56 GMT
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 <asyura414@gmail.com>

> 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 //
>



-- 
dujinhang

Mime
View raw message