Uploaded image for project: 'Pig'
  1. Pig
  2. PIG-455

"group" alias is lost after a flatten(group)

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 0.2.0
    • 0.2.0
    • None
    • None
    • Patch Available

    Description

      script:

      a = load 'st10k' as (name, age, gpa);
      b = group a by name;
      c = foreach b generate flatten(group), COUNT(a) as cnt;
      d = foreach c generate group;
      dump d;
      

      Error:

      java.io.IOException: Invalid alias: group in {bytearray,cnt: long}
              at org.apache.pig.PigServer.parseQuery(PigServer.java:293)
              at org.apache.pig.PigServer.registerQuery(PigServer.java:258)
              at org.apache.pig.tools.grunt.GruntParser.processPig(GruntParser.java:432)
              at org.apache.pig.tools.pigscript.parser.PigScriptParser.parse(PigScriptParser.java:242)
              at org.apache.pig.tools.grunt.GruntParser.parseStopOnError(GruntParser.java:83)
              at org.apache.pig.tools.grunt.Grunt.exec(Grunt.java:64)
              at org.apache.pig.Main.main(Main.java:306)
      Caused by: org.apache.pig.impl.logicalLayer.parser.ParseException: Invalid alias: group in {bytearray,cnt: long}
              at org.apache.pig.impl.logicalLayer.parser.QueryParser.AliasFieldOrSpec(QueryParser.java:5851)
              at org.apache.pig.impl.logicalLayer.parser.QueryParser.ColOrSpec(QueryParser.java:5709)
              at org.apache.pig.impl.logicalLayer.parser.QueryParser.BaseEvalSpec(QueryParser.java:4012)
              at org.apache.pig.impl.logicalLayer.parser.QueryParser.UnaryExpr(QueryParser.java:3909)
              at org.apache.pig.impl.logicalLayer.parser.QueryParser.CastExpr(QueryParser.java:3863)
              at org.apache.pig.impl.logicalLayer.parser.QueryParser.MultiplicativeExpr(QueryParser.java:3772)
              at org.apache.pig.impl.logicalLayer.parser.QueryParser.AdditiveExpr(QueryParser.java:3698)
              at org.apache.pig.impl.logicalLayer.parser.QueryParser.InfixExpr(QueryParser.java:3664)
              at org.apache.pig.impl.logicalLayer.parser.QueryParser.FlattenedGenerateItem(QueryParser.java:3590)
              at org.apache.pig.impl.logicalLayer.parser.QueryParser.FlattenedGenerateItemList(QueryParser.java:3500)
              at org.apache.pig.impl.logicalLayer.parser.QueryParser.GenerateStatement(QueryParser.java:3457)
              at org.apache.pig.impl.logicalLayer.parser.QueryParser.NestedBlock(QueryParser.java:2933)
              at org.apache.pig.impl.logicalLayer.parser.QueryParser.ForEachClause(QueryParser.java:2336)
              at org.apache.pig.impl.logicalLayer.parser.QueryParser.BaseExpr(QueryParser.java:973)
              at org.apache.pig.impl.logicalLayer.parser.QueryParser.Expr(QueryParser.java:748)
              at org.apache.pig.impl.logicalLayer.parser.QueryParser.Parse(QueryParser.java:549)
              at org.apache.pig.impl.logicalLayer.LogicalPlanBuilder.parse(LogicalPlanBuilder.java:60)
              at org.apache.pig.PigServer.parseQuery(PigServer.java:290)
              ... 6 more
      
      

      Attachments

        1. PIG-455.patch
          2 kB
          Pradeep Kamath

        Activity

          People

            pkamath Pradeep Kamath
            pkamath Pradeep Kamath
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: