You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Aihua Xu (JIRA)" <ji...@apache.org> on 2018/08/07 17:30:00 UTC
[jira] [Created] (HIVE-20331) Query with union all, lateral view
and Join fails with "cannot find parent in the child operator"
Aihua Xu created HIVE-20331:
-------------------------------
Summary: 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
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)