The issue can be reproduced by following the example in contrib:
*
hive/contrib/src/test/queries/clientpositive/serde_regex.q*
sample log data can be obtained from there itself.
By the way, my version of hive is 0.7.0 , hadoop 0.20.2
Thanks,
MIS.
On Fri, Sep 9, 2011 at 2:55 PM, Ankit Jain <ankitjainc...@gmail.com> wrote:
> can you provide me sample log data
>
> Thanks,
> Ankit
>
>
> On Fri, Sep 9, 2011 at 2:33 AM, MIS <misapa...@gmail.com> wrote:
>
>> I want to access individual columns from a table created with row
>> delimited by RegexSerde.
>>
>> For example,
>> I have created a table as below:
>>
>> create table test ( col1 STRING, col2 STRING )
>> ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.RegexSerDe'
>> WITH SERDEPROPERTIES ("input.regex" = "([^ ]*) ([^ ]*)",
>> "output.format.string" = "%$1s %$2s");
>>
>> After loading valid data,
>> *select * from test* workd fine,
>>
>> however *select col1 from test* or *select col2 from test* or *select
>> col1, col2 from test* fail.
>>
>> how do I achieve the above.
>>
>> Thanks,
>> MIS.
>>
>
>
