You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@pig.apache.org by "Viraj Bhat (JIRA)" <ji...@apache.org> on 2008/10/18 04:22:44 UTC

[jira] Updated: (PIG-502) Limit and Illustrate do not work together

     [ https://issues.apache.org/jira/browse/PIG-502?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Viraj Bhat updated PIG-502:
---------------------------

    Description: 
Suppose a user wants to do an illustrate command after limiting his data to a certain number of records, it does not seem to work..
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
{code}
MYDATA = load 'testfilelarge.txt' as (f1, f2, f3, f4, f5);
MYDATA  = limit MYDATA 10;
describe MYDATA;
illustrate MYDATA;
{code}
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Running this script produces the following output and error
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
MYDATA: {f1: bytearray,f2: bytearray,f3: bytearray,f4: bytearray,f5: bytearray}
2008-10-18 02:14:26,900 [main] INFO  org.apache.pig.backend.hadoop.executionengine.HExecutionEngine - Connecting to hadoop fil
e system at: hdfs://localhost:9000
2008-10-18 02:14:27,013 [main] INFO  org.apache.pig.backend.hadoop.executionengine.HExecutionEngine - Connecting to map-reduce
 job tracker at: localhost:9001
java.lang.RuntimeException: Unrecognized logical operator.
        at org.apache.pig.pen.EquivalenceClasses.GetEquivalenceClasses(EquivalenceClasses.java:60)
        at org.apache.pig.pen.DerivedDataVisitor.evaluateOperator(DerivedDataVisitor.java:368)
        at org.apache.pig.pen.DerivedDataVisitor.visit(DerivedDataVisitor.java:273)
        at org.apache.pig.impl.logicalLayer.LOLimit.visit(LOLimit.java:71)
        at org.apache.pig.impl.logicalLayer.LOLimit.visit(LOLimit.java:10)
        at org.apache.pig.impl.plan.DependencyOrderWalker.walk(DependencyOrderWalker.java:68)
        at org.apache.pig.impl.plan.PlanVisitor.visit(PlanVisitor.java:51)
        at org.apache.pig.pen.LineageTrimmingVisitor.init(LineageTrimmingVisitor.java:98)
        at org.apache.pig.pen.LineageTrimmingVisitor.<init>(LineageTrimmingVisitor.java:90)
        at org.apache.pig.pen.ExampleGenerator.getExamples(ExampleGenerator.java:106)
        at org.apache.pig.PigServer.getExamples(PigServer.java:630)
        at org.apache.pig.tools.grunt.GruntParser.processIllustrate(GruntParser.java:279)
        at org.apache.pig.tools.pigscript.parser.PigScriptParser.parse(PigScriptParser.java:183)
        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)
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
If I remove the illustrate and replace it with "dump MYDATA;"  it works..
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
{code}
MYDATA = load 'testfilelarge.txt' as (f1, f2, f3, f4, f5);
MYDATA  = limit MYDATA 10;
describe MYDATA;
-- illustrate MYDATA;
dump MYDATA;
{code}
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

  was:
Suppose a user want to do an {code} illustrate{code} command after limiting his data to a certain number of records, it does not seem to work
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
{code}
MYDATA = load 'testfilelarge.txt' as (f1, f2, f3, f4, f5);
MYDATA  = limit MYDATA 10;
describe MYDATA;
illustrate MYDATA;
{code}
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Running this script produces the following output and error
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
MYDATA: {f1: bytearray,f2: bytearray,f3: bytearray,f4: bytearray,f5: bytearray}
2008-10-18 02:14:26,900 [main] INFO  org.apache.pig.backend.hadoop.executionengine.HExecutionEngine - Connecting to hadoop fil
e system at: hdfs://localhost:9000
2008-10-18 02:14:27,013 [main] INFO  org.apache.pig.backend.hadoop.executionengine.HExecutionEngine - Connecting to map-reduce
 job tracker at: localhost:9001
java.lang.RuntimeException: Unrecognized logical operator.
        at org.apache.pig.pen.EquivalenceClasses.GetEquivalenceClasses(EquivalenceClasses.java:60)
        at org.apache.pig.pen.DerivedDataVisitor.evaluateOperator(DerivedDataVisitor.java:368)
        at org.apache.pig.pen.DerivedDataVisitor.visit(DerivedDataVisitor.java:273)
        at org.apache.pig.impl.logicalLayer.LOLimit.visit(LOLimit.java:71)
        at org.apache.pig.impl.logicalLayer.LOLimit.visit(LOLimit.java:10)
        at org.apache.pig.impl.plan.DependencyOrderWalker.walk(DependencyOrderWalker.java:68)
        at org.apache.pig.impl.plan.PlanVisitor.visit(PlanVisitor.java:51)
        at org.apache.pig.pen.LineageTrimmingVisitor.init(LineageTrimmingVisitor.java:98)
        at org.apache.pig.pen.LineageTrimmingVisitor.<init>(LineageTrimmingVisitor.java:90)
        at org.apache.pig.pen.ExampleGenerator.getExamples(ExampleGenerator.java:106)
        at org.apache.pig.PigServer.getExamples(PigServer.java:630)
        at org.apache.pig.tools.grunt.GruntParser.processIllustrate(GruntParser.java:279)
        at org.apache.pig.tools.pigscript.parser.PigScriptParser.parse(PigScriptParser.java:183)
        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)
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
If I remove the illustrate and replace it with {code} dump MYDATA; {code} it works..
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
{code}
MYDATA = load 'testfilelarge.txt' as (f1, f2, f3, f4, f5);
MYDATA  = limit MYDATA 10;
describe MYDATA;
-- illustrate MYDATA;
dump MYDATA;
{code}
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------


> Limit and Illustrate do not work together
> -----------------------------------------
>
>                 Key: PIG-502
>                 URL: https://issues.apache.org/jira/browse/PIG-502
>             Project: Pig
>          Issue Type: Improvement
>          Components: tools
>    Affects Versions: types_branch
>         Environment: Hadoop 18
>            Reporter: Viraj Bhat
>
> Suppose a user wants to do an illustrate command after limiting his data to a certain number of records, it does not seem to work..
> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
> {code}
> MYDATA = load 'testfilelarge.txt' as (f1, f2, f3, f4, f5);
> MYDATA  = limit MYDATA 10;
> describe MYDATA;
> illustrate MYDATA;
> {code}
> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
> Running this script produces the following output and error
> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
> MYDATA: {f1: bytearray,f2: bytearray,f3: bytearray,f4: bytearray,f5: bytearray}
> 2008-10-18 02:14:26,900 [main] INFO  org.apache.pig.backend.hadoop.executionengine.HExecutionEngine - Connecting to hadoop fil
> e system at: hdfs://localhost:9000
> 2008-10-18 02:14:27,013 [main] INFO  org.apache.pig.backend.hadoop.executionengine.HExecutionEngine - Connecting to map-reduce
>  job tracker at: localhost:9001
> java.lang.RuntimeException: Unrecognized logical operator.
>         at org.apache.pig.pen.EquivalenceClasses.GetEquivalenceClasses(EquivalenceClasses.java:60)
>         at org.apache.pig.pen.DerivedDataVisitor.evaluateOperator(DerivedDataVisitor.java:368)
>         at org.apache.pig.pen.DerivedDataVisitor.visit(DerivedDataVisitor.java:273)
>         at org.apache.pig.impl.logicalLayer.LOLimit.visit(LOLimit.java:71)
>         at org.apache.pig.impl.logicalLayer.LOLimit.visit(LOLimit.java:10)
>         at org.apache.pig.impl.plan.DependencyOrderWalker.walk(DependencyOrderWalker.java:68)
>         at org.apache.pig.impl.plan.PlanVisitor.visit(PlanVisitor.java:51)
>         at org.apache.pig.pen.LineageTrimmingVisitor.init(LineageTrimmingVisitor.java:98)
>         at org.apache.pig.pen.LineageTrimmingVisitor.<init>(LineageTrimmingVisitor.java:90)
>         at org.apache.pig.pen.ExampleGenerator.getExamples(ExampleGenerator.java:106)
>         at org.apache.pig.PigServer.getExamples(PigServer.java:630)
>         at org.apache.pig.tools.grunt.GruntParser.processIllustrate(GruntParser.java:279)
>         at org.apache.pig.tools.pigscript.parser.PigScriptParser.parse(PigScriptParser.java:183)
>         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)
> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
> If I remove the illustrate and replace it with "dump MYDATA;"  it works..
> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
> {code}
> MYDATA = load 'testfilelarge.txt' as (f1, f2, f3, f4, f5);
> MYDATA  = limit MYDATA 10;
> describe MYDATA;
> -- illustrate MYDATA;
> dump MYDATA;
> {code}
> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

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