Details
-
Sub-task
-
Status: Patch Available
-
Major
-
Resolution: Unresolved
-
2.0.0
-
None
-
None
Description
Execute the following query
CREATE TABLE `t1`(`pattern` array<int>); explain select * from t1 lateral view explode(pattern) tbl1 as col1 lateral view explode(pattern) tbl1 as col1 lateral view explode(pattern) tbl1 as col1 lateral view explode(pattern) tbl1 as col1 lateral view explode(pattern) tbl1 as col1 lateral view explode(pattern) tbl1 as col1 lateral view explode(pattern) tbl1 as col1 lateral view explode(pattern) tbl1 as col1 lateral view explode(pattern) tbl1 as col1 lateral view explode(pattern) tbl1 as col1 lateral view explode(pattern) tbl1 as col1 lateral view explode(pattern) tbl1 as col1 lateral view explode(pattern) tbl1 as col1 lateral view explode(pattern) tbl1 as col1 lateral view explode(pattern) tbl1 as col1 lateral view explode(pattern) tbl1 as col1 lateral view explode(pattern) tbl1 as col1 lateral view explode(pattern) tbl1 as col1 lateral view explode(pattern) tbl1 as col1 lateral view explode(pattern) tbl1 as col1 lateral view explode(pattern) tbl1 as col1 lateral view explode(pattern) tbl1 as col1 lateral view explode(pattern) tbl1 as col1 lateral view explode(pattern) tbl1 as col1 lateral view explode(pattern) tbl1 as col1 lateral view explode(pattern) tbl1 as col1 lateral view explode(pattern) tbl1 as col1 lateral view explode(pattern) tbl1 as col1 lateral view explode(pattern) tbl1 as col1;
After HIVE-11617 gets fixed, the explain output still takes forever since we are recursively printing operator info which could be an issue if the ops could have multiple children and parents, like lateral view case. Right now, if a node has multiple parents, then it including its descendants will be printed multiple times. We should print once and probably print just a reference later on.