Re: Dereferencing columns of nested bags

2011-04-11 Thread Daniel Dai
com] Sent: Friday, April 08, 2011 4:32 PM To: user@pig.apache.org Cc: Badrinarayanan S Subject: Re: Dereferencing columns of nested bags How are you trying to reference it ? Within foreach ? Filter ? Or elsewhere ? Doesn't something like $1.$1.($0, $1) not work to reference key, value as a

RE: Dereferencing columns of nested bags

2011-04-09 Thread Badrinarayanan S
, April 09, 2011 4:45 PM To: user@pig.apache.org Cc: Daniel Dai Subject: Re: Dereferencing columns of nested bags If you try to project that out, you will end up with exceptions - which was the issue being raised (not the expected functionality - which is understood well : whether flatten is required

RE: Dereferencing columns of nested bags

2011-04-09 Thread Badrinarayanan S
It helps. Thanks. -Original Message- From: Daniel Dai [mailto:jiany...@yahoo-inc.com] Sent: Saturday, April 09, 2011 2:39 AM To: user@pig.apache.org Subject: Re: Dereferencing columns of nested bags Bag dereference results a bag with less columns. It does not reduce the nested levels

Re: Dereferencing columns of nested bags

2011-04-09 Thread Mridul Muralidharan
l aggregation that $1.$1.$0 (for ex) provides). Regards, Mridul Thanks, badri -Original Message- From: Mridul Muralidharan [mailto:mrid...@yahoo-inc.com] Sent: Friday, April 08, 2011 4:32 PM To: user@pig.apache.org Cc: Badrinarayanan S Subject: Re: Dereferencing columns of nested bags How are

Re: Dereferencing columns of nested bags

2011-04-08 Thread Daniel Dai
d...@yahoo-inc.com] Sent: Friday, April 08, 2011 4:32 PM To: user@pig.apache.org Cc: Badrinarayanan S Subject: Re: Dereferencing columns of nested bags How are you trying to reference it ? Within foreach ? Filter ? Or elsewhere ? Doesn't something like $1.$1.($0, $1) not work to reference

Re: Dereferencing columns of nested bags

2011-04-08 Thread Mridul Muralidharan
] Sent: Friday, April 08, 2011 4:32 PM To: user@pig.apache.org Cc: Badrinarayanan S Subject: Re: Dereferencing columns of nested bags How are you trying to reference it ? Within foreach ? Filter ? Or elsewhere ? Doesn't something like $1.$1.($0, $1) not work to reference key, value as a

RE: Dereferencing columns of nested bags

2011-04-08 Thread Badrinarayanan S
columns of nested bags How are you trying to reference it ? Within foreach ? Filter ? Or elsewhere ? Doesn't something like $1.$1.($0, $1) not work to reference key, value as a tuple ? - Mridul On Friday 08 April 2011 03:38 PM, Badrinarayanan S wrote: > Is it possible to dereference

Re: Dereferencing columns of nested bags

2011-04-08 Thread Mridul Muralidharan
How are you trying to reference it ? Within foreach ? Filter ? Or elsewhere ? Doesn't something like $1.$1.($0, $1) not work to reference key, value as a tuple ? - Mridul On Friday 08 April 2011 03:38 PM, Badrinarayanan S wrote: Is it possible to dereference a column part of a nested ba

Dereferencing columns of nested bags

2011-04-08 Thread Badrinarayanan S
Is it possible to dereference a column part of a nested bag. In the schema given below, I am trying to dereference the columns Key and Value which is part of visit bag which is part of visits bag. (id, visits:bag{visittuple:tuple(timestamp, visit:bag{details:tuple(Key:chararray, Value:chararray