hadoop-pig-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Viraj Bhat (JIRA)" <j...@apache.org>
Subject [jira] Created: (PIG-499) Alias which contains substring "as" causes Parser to throw a syntax error
Date Fri, 17 Oct 2008 00:02:44 GMT
Alias which contains substring "as" causes Parser to throw a syntax error
-------------------------------------------------------------------------

                 Key: PIG-499
                 URL: https://issues.apache.org/jira/browse/PIG-499
             Project: Pig
          Issue Type: Bug
    Affects Versions: types_branch
         Environment: Hadoop 18
            Reporter: Viraj Bhat
             Fix For: types_branch


---------------------------------------------------------------------------------------
MYDATA = load 'testfile.txt' as (f1, f2, f3, f4, f5);
MYDATA_PROJECTION = foreach MYDATA generate f3, f5;
CAST = group MYDATA_PROJECTION by f3;
RESULT = foreach CAST {
          MYSORTED = ORDER MYDATA_PROJECTION by f5;
          generate flatten(MYSORTED);
}
dump RESULT;
---------------------------------------------------------------------------------------
The above query throws a syntax error 
java.io.IOException: Encountered "dump" at line 8, column 1.
Was expecting one of:
    "parallel" ...
    ";" ...
    
        at org.apache.pig.PigServer.parseQuery(PigServer.java:298)
        at org.apache.pig.PigServer.registerQuery(PigServer.java:263)
        at org.apache.pig.tools.grunt.GruntParser.processPig(GruntParser.java:439)
        at org.apache.pig.tools.pigscript.parser.PigScriptParser.parse(PigScriptParser.java:249)
        at org.apache.pig.tools.grunt.GruntParser.parseStopOnError(GruntParser.java:84)
        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: Encountered "dump" at line
8, column 1.
Was expecting one of:
    "parallel" ...
    ";" ...
    
        at org.apache.pig.impl.logicalLayer.parser.QueryParser.generateParseException(QueryParser.java:7763)
        at org.apache.pig.impl.logicalLayer.parser.QueryParser.jj_consume_token(QueryParser.java:7640)
        at org.apache.pig.impl.logicalLayer.parser.QueryParser.Parse(QueryParser.java:551)
        at org.apache.pig.impl.logicalLayer.LogicalPlanBuilder.parse(LogicalPlanBuilder.java:60)
        at org.apache.pig.PigServer.parseQuery(PigServer.java:295)
        ... 6 more
---------------------------------------------------------------------------------------
But now changing this query to:(changing CAST to CST) makes the query execute successfully.
 
---------------------------------------------------------------------------------------
MYDATA = load 'testfile.txt' as (f1, f2, f3, f4, f5);
MYDATA_PROJECTION = foreach MYDATA generate f3, f5;
CST = group MYDATA_PROJECTION by f3;
RESULT = foreach CST {
          MYSORTED = ORDER MYDATA_PROJECTION by f5;
          generate flatten(MYSORTED);
}
dump RESULT;
---------------------------------------------------------------------------------------
I believe this might have been caused due to the patch which resolved issue: https://issues.apache.org/jira/browse/PIG-437

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message