Yeah, that would work. 10 should be released within weeks.
D On Tue, Apr 10, 2012 at 2:42 PM, James Newhaven <[email protected]> wrote: > Thanks for the responses. Until 0.10 is released what alternatives do > I have if limit can only take constants? > > I suspect I could use TOP if that supports variables? > > > > On 10 Apr 2012, at 10:20 PM, Dmitriy Ryaboy <[email protected]> wrote: > >> Fixed in 0.10 actually >> >> https://issues.apache.org/jira/browse/PIG-1926 >> >> But if you are using the scalar feature, you should cast explicitly. >> >> D >> >> On Tue, Apr 10, 2012 at 2:11 PM, Stan Rosenberg >> <[email protected]> wrote: >>> I believe the syntax of LIMIT does not admit an arbitrary expression; >>> it only admits constants. At least this is what the documentation >>> says. >>> >>> stan >>> >>> >>> On Tue, Apr 10, 2012 at 4:33 PM, James Newhaven >>> <[email protected]> wrote: >>>> Hi, >>>> >>>> I am trying to a limit the output size using LIMIT. I want to the limit >>>> size to be 5 percent of the total output size like this: >>>> >>>> -- Put all the inids in a bag so we can count them. >>>> G = GROUP F ALL; >>>> >>>> -- Count everything in the bag >>>> H = FOREACH G GENERATE COUNT_STAR(F) AS total; >>>> >>>> -- Limit out to 5 percent of the total. >>>> I = LIMIT F H.total * 0.05; >>>> >>>> However, when I define the last line with the LIMIT operator, I get the >>>> following error. Does anyone know a way around this? >>>> >>>> ERROR 1200: <line 362, column 12> mismatched input 'H' expecting set null >>>> >>>> Failed to parse: <line 362, column 12> mismatched input 'H' expecting set >>>> null >>>> at >>>> org.apache.pig.parser.QueryParserDriver.parse(QueryParserDriver.java:222) >>>> >>>> >>>> Thanks, >>>> James
