[
https://issues.apache.org/jira/browse/DRILL-6671?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16574523#comment-16574523
]
ASF GitHub Bot commented on DRILL-6671:
---------------------------------------
vvysotskyi commented on a change in pull request #1426: DRILL-6671: Multi level
lateral unnest join is throwing an exception …
URL: https://github.com/apache/drill/pull/1426#discussion_r208841144
##########
File path:
exec/java-exec/src/test/java/org/apache/drill/exec/physical/impl/lateraljoin/TestE2EUnnestAndLateral.java
##########
@@ -169,13 +169,31 @@ public void
testLeftLateral_WithFilterAndLimitInSubQuery() throws Exception {
@Test
public void testMultiUnnestAtSameLevel() throws Exception {
String Sql = "EXPLAIN PLAN FOR SELECT customer.c_name, customer.c_address,
U1.order_id, U1.order_amt," +
- " U1.itemName, U1.itemNum" + " FROM
cp.`lateraljoin/nested-customer.parquet` customer, LATERAL" +
- " (SELECT t.ord.o_id AS order_id, t.ord.o_amount AS order_amt,
U2.item_name AS itemName, U2.item_num AS " +
- "itemNum FROM UNNEST(customer.orders) t(ord) , LATERAL" +
- " (SELECT t1.ord.i_name AS item_name, t1.ord.i_number AS item_num FROM
UNNEST(t.ord) AS t1(ord)) AS U2) AS U1";
+ " U1.itemName, U1.itemNum" + " FROM
cp.`lateraljoin/nested-customer.parquet` customer, LATERAL" +
+ " (SELECT t.ord.o_id AS order_id, t.ord.o_amount AS order_amt,
U2.item_name AS itemName, U2.item_num AS " +
+ "itemNum FROM UNNEST(customer.orders) t(ord) , LATERAL" +
+ " (SELECT t1.ord.i_name AS item_name, t1.ord.i_number AS item_num
FROM UNNEST(t.ord) AS t1(ord)) AS U2) AS U1";
runAndLog(Sql);
}
+ @Test
+ public void testMultiUnnestAtSameLevelExec() throws Exception {
+ String Sql = "SELECT customer.c_name, customer.c_address, U1.order_id,
U1.order_amt," +
Review comment:
Please rename string in lower case: `Sql` -> `sql`
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
> Multi level lateral unnest join is throwing an exception during materializing
> the plan.
> ---------------------------------------------------------------------------------------
>
> Key: DRILL-6671
> URL: https://issues.apache.org/jira/browse/DRILL-6671
> Project: Apache Drill
> Issue Type: Bug
> Components: Query Planning & Optimization
> Affects Versions: 1.15.0
> Reporter: Hanumath Rao Maduri
> Assignee: Hanumath Rao Maduri
> Priority: Major
>
> testMultiUnnestAtSameLevel in TestE2EUnnestAndLateral is throwing an
> execution in Materializer.java. This is due to incorrect matching of Unnest
> and Lateral join.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
