Replacing values

[Mark <st...@gmail.com>]

I have some tuples and I would like to be able to transform the first 
row using the REGEX_EXTRACT method but leave all the other rows 
untouched. Now I can easily do this with known and/or named fields but I 
do not know the exact number of values in each tuple so something like 
the following will not work:

foo = foreach views generate REGEX_EXTRACT($0, '.*\\b(\\d+)$', 1), $1, 
$2, $3

I've tried the following but this duplicates the first value un-extracted:

foo = foreach views generate REGEX_EXTRACT($0, '.*\\b(\\d+)$', 1), *

Is there anyway I can accomplish modifying just the first value in each 
tuple with an unknown number of values in each tuple?

Thanks

Re: Replacing values

[Thejas Nair <th...@hortonworks.com>]

We released the range projection feature in pig 0.9 because we knew you 
were going to ask this question ;)

See - 
http://www.hortonworks.com/new-apache-pig-0-9-features-part-3-additional-features/
and http://pig.apache.org/docs/r0.9.0/basic.html#expressions

That would be -

foo = foreach views generate REGEX_EXTRACT($0, '.*\\b(\\d+)$', 1), $1 .. ;

Thanks,
Thejas




On 8/9/11 10:25 PM, Mark wrote:
> I have some tuples and I would like to be able to transform the first
> row using the REGEX_EXTRACT method but leave all the other rows
> untouched. Now I can easily do this with known and/or named fields but I
> do not know the exact number of values in each tuple so something like
> the following will not work:
>
> foo = foreach views generate REGEX_EXTRACT($0, '.*\\b(\\d+)$', 1), $1,
> $2, $3
>
> I've tried the following but this duplicates the first value un-extracted:
>
> foo = foreach views generate REGEX_EXTRACT($0, '.*\\b(\\d+)$', 1), *
>
> Is there anyway I can accomplish modifying just the first value in each
> tuple with an unknown number of values in each tuple?
>
> Thanks
>
>
>
>
>