Re: Using PIG with complex SQL Statement

2014-10-31 Thread Ryan Prociuk
Vineet, Pig 0.12 > supports the IN clause for filtering X = FILTER A BY (f1==8) OR (NOT (f2+f3 > f1)) OR (f1 IN (9, 10, 11)); Ryan On Thu, Oct 30, 2014 at 11:09 PM, Vineet Mishra wrote: > Hi Dan, > > Thanks for your response, although > > FILTER cat_ids BY (category_id == 1); > > is working

Re: Using PIG with complex SQL Statement

2014-10-31 Thread Dan DeCapria, CivicScience
Hi Vineet, I believe I am understand more about what you are asking for now. Note the the FILTER statement will only allow through any tuples matching the predicate logic condition specified in the filter (in this case your massive disjunction statement hard-coded in the script). Below is a poss