[jira] [Updated] (HIVE-20331) Query with union all, lateral view and Join fails with "cannot find parent in the child operator"

["Aihua Xu (JIRA)" <ji...@apache.org>]

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

Aihua Xu updated HIVE-20331:
----------------------------
    Attachment: HIVE-20331.1.patch

> Query with union all, lateral view and Join fails with "cannot find parent in the child operator"
> -------------------------------------------------------------------------------------------------
>
>                 Key: HIVE-20331
>                 URL: https://issues.apache.org/jira/browse/HIVE-20331
>             Project: Hive
>          Issue Type: Bug
>          Components: Physical Optimizer
>    Affects Versions: 2.1.1
>            Reporter: Aihua Xu
>            Assignee: Aihua Xu
>            Priority: Major
>         Attachments: HIVE-20331.1.patch
>
>
> The following query with Union, Lateral view and Join will fail during execution with the exception below.
> {noformat}
> create table t1(col1 int);
> SELECT 1 AS `col1`
> FROM t1
> UNION ALL
>   SELECT 2 AS `col1`
>   FROM
>     (SELECT col1
>      FROM t1
>     ) x1
>     JOIN
>       (SELECT col1
>       FROM
>         (SELECT 
>           Row_Number() over (PARTITION BY col1 ORDER BY col1) AS `col1`
>         FROM t1
>         ) x2 lateral VIEW explode(map(10,1))`mapObj` AS `col2`, `col3`
>       ) `expdObj`      
> {noformat}
> {noformat}
> Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: Hive internal error: cannot find parent in the child operator!
>         at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:362) ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT]
>         at org.apache.hadoop.hive.ql.exec.MapOperator.initializeMapOperator(MapOperator.java:509) ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT]
>         at org.apache.hadoop.hive.ql.exec.mr.ExecMapper.configure(ExecMapper.java:116) ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT]
> {noformat}
> After debugging, seems we have issues in GenMRFileSink1 class in which we are setting incorrect aliasToWork to the MapWork.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)