hadoop-pig-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Santhosh Srinivasan (JIRA)" <j...@apache.org>
Subject [jira] Commented: (PIG-305) Nested order by queries return only one key instead of all keys
Date Tue, 15 Jul 2008 18:15:31 GMT

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

Santhosh Srinivasan commented on PIG-305:
-----------------------------------------

A debug output for the above query without the store command is given below. The post-parse
logical plan looks fine.

{noformat}
08/07/15 10:55:01 INFO parser.QueryParser: Generate Inputs: [(Name: SORT Test-Plan-Builder-5
Operator Key: Test-Plan-Builder-5)]
08/07/15 10:55:01 INFO parser.QueryParser: Generate Input required
08/07/15 10:55:01 INFO parser.QueryParser: Connected (Name: SORT Test-Plan-Builder-5 Operator
Key: Test-Plan-Builder-5) to (Name: Project Test-Plan-Builder-6 Projections:  [*]  Overloaded:
false Operator Key: Test-Plan-Builder-6)
Printing the logical plan
ForEach Test-Plan-Builder-8 Schema: {bytearray} Type: bag
|   |
|   Project Test-Plan-Builder-6 Projections:  [*]  Overloaded: false FieldSchema: c1: tuple
Type: tuple
|   Input: SORT Test-Plan-Builder-5|
|   |---SORT Test-Plan-Builder-5 Schema: null Type: bag
|       |   |
|       |   Project Test-Plan-Builder-4 Projections:  [*]  Overloaded: false FieldSchema:
a: bag Type: bag
|       |   Input: Project Test-Plan-Builder-3 Projections: [1] Overloaded: fals
|       |
|       |---Project Test-Plan-Builder-3 Projections: [1] Overloaded: false FieldSchema: a:
bag Type: bag
|           Input: CoGroup Test-Plan-Builder-2
|
|---CoGroup Test-Plan-Builder-2 Schema: {group: bytearray,a: {null}} Type: Unknown
    |   |
    |   Project Test-Plan-Builder-1 Projections: [0] Overloaded: false FieldSchema: bytearray
Type: bytearray
    |   Input: Load Test-Plan-Builder-
    |
    |---Load Test-Plan-Builder-0 Schema: null Type: bag
{noformat}

> Nested order by queries return only one key instead of all keys
> ---------------------------------------------------------------
>
>                 Key: PIG-305
>                 URL: https://issues.apache.org/jira/browse/PIG-305
>             Project: Pig
>          Issue Type: Bug
>          Components: impl
>    Affects Versions: types_branch
>            Reporter: Alan Gates
>            Assignee: Santhosh Srinivasan
>             Fix For: types_branch
>
>
> Queries like:
> {code}
> a = load 'myfile';                                                                  
                         
> b = group a by $0;                                                                  
                                                                           
> c = foreach b {
>     c1 = order $1 by *; 
>     generate flatten(c1); 
> };                                                                                  
                  
> store c into 'outfile';
> {code}
> return just one key of the data instead of returning all keys.

-- 
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