[jira] [Created] (PIG-5393) ERROR grunt.Grunt: ERROR 2225: Projection with nothing to reference!

["Tatyana Alexeyev (Jira)" <ji...@apache.org>]

Tatyana Alexeyev created PIG-5393:
-------------------------------------

             Summary:  ERROR grunt.Grunt: ERROR 2225: Projection with nothing to reference!
                 Key: PIG-5393
                 URL: https://issues.apache.org/jira/browse/PIG-5393
             Project: Pig
          Issue Type: Bug
            Reporter: Tatyana Alexeyev


I got an error while running the pig SCRIPT 19/09/18 03:16:18 ERROR grunt.Grunt: ERROR 2225: Projection with nothing to reference! Pig Stack Trace --------------- ERROR 2225: Projection with nothing to reference! org.apache.pig.impl.logicalLayer.FrontendException: ERROR 2000: Error processing rule NestedLimitOptimizer. Try -t NestedLimitOptimizer at org.apache.pig.newplan.optimizer.PlanOptimizer.optimize([PlanOptimizer.java:125 |planoptimizer.java:125] ) at org.apache.pig.newplan.logical.relational.LogicalPlan.optimize([LogicalPlan.java:281 |logicalplan.java:281] ) at org.apache.pig.PigServer.executeCompiledLogicalPlan([PigServer.java:1458 |pigserver.java:1458] ) at org.apache.pig.PigServer.execute([PigServer.java:1449 |pigserver.java:1449] ) at org.apache.pig.PigServer.executeBatch([PigServer.java:489 |pigserver.java:489] ) at org.apache.pig.PigServer.executeBatch([PigServer.java:472 |pigserver.java:472] ) at org.apache.pig.tools.grunt.GruntParser.executeBatch(G Caused by: org.apache.pig.impl.logicalLayer.FrontendException: ERROR 2225: Projection with nothing to reference! 

 

 This script runs fine on Cloudera.... However, the error happens on AWS EMR. The script is in the attachment I can include the data set if needed ... 

 

It caused by the following statement:

 

 

avgPriceForMkpData = FOREACH groupedSellerMkpData { orderedSellerMkpData = ORDER sellerMkpData BY Total_Price ASC; min2MkpPrices = LIMIT orderedSellerMkpData 2; GENERATE min2MkpPrices.SSIN, min2MkpPrices.Source, (COUNT(orderedSellerMkpData) >= 1 ?(long)ROUND(AVG(min2MkpPrices.Shipping_Cost_Deduced)*100) : 0) AS Shipping_Cost_Deduced, min2MkpPrices.Source_Group, (COUNT(orderedSellerMkpData) >= 1 ?(long)ROUND(AVG(min2MkpPrices.Total_Price)*100) : 0) AS Total_Price; 

 

Can you please help?

Tanya

 

 

 

 

 

 

 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)