You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@pig.apache.org by "Koji Noguchi (Jira)" <ji...@apache.org> on 2020/01/09 21:51:00 UTC
[jira] [Resolved] (PIG-5393) ERROR grunt.Grunt: ERROR 2225:
Projection with nothing to reference!
[ https://issues.apache.org/jira/browse/PIG-5393?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Koji Noguchi resolved PIG-5393.
-------------------------------
Resolution: Invalid
Sorry for the late response.
{quote}
This script runs fine on Cloudera.... However, the error happens on AWS EMR
{quote}
We are using Jiras only for reporting bugs or raising enhancements and feature requests. We don't provide support to users here for debugging issues with pig script and the data.
Please try asking on user@pig.apache.org or try asking on stackoverflow. (I periodically review the questions there.)
> 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
> Priority: Major
>
> 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)