Mailing-List: contact dev-help@pig.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@pig.apache.org
Date: Sun, 4 Dec 2011 19:30:40 +0000 (UTC)
From: "vaibhav  (Commented) (JIRA)" <jira@apache.org>
To: pig-dev@hadoop.apache.org
Message-ID: 
 <567147602.39304.1323027040199.JavaMail.tomcat@hel.zones.apache.org>
Subject: [jira] [Commented] (PIG-1324) Logical Optimizer: Nested column
 pruning
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ https://issues.apache.org/jira/browse/PIG-1324?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13162446#comment-13162446 ] 

vaibhav  commented on PIG-1324:
-------------------------------

2011-12-05 00:18:30,969 [main] ERROR org.apache.pig.tools.grunt.Grunt - ERROR 1066: Unable to open iterator for alias jnd,how to solve it,
in this script;


users = load 'users' as (name:chararray, city:chararray);
cinfo = load 'cityinfo' as (city:chararray, population:int);
jnd = join cinfo by city, users by city using 'skewed';
                
> Logical Optimizer: Nested column pruning
> ----------------------------------------
>
>                 Key: PIG-1324
>                 URL: https://issues.apache.org/jira/browse/PIG-1324
>             Project: Pig
>          Issue Type: Sub-task
>          Components: impl
>    Affects Versions: 0.7.0
>            Reporter: Daniel Dai
>            Assignee: Daniel Dai
>
> Currently, column pruning does not prune sub-fields inside a complex data-type. For example:
> A = load '1.txt' as (a0, a1, a2);
> B = group A by a0;
> C = foreach B generate group, SUM(A.a1);
> Currently, since we group A as a bag, and some part of the bag is used in the following statement, so none of the fields inside A can be pruned. We shall keep track of sub-fields and figure out a2 is not actually needed.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira