[
https://issues.apache.org/jira/browse/DRILL-6638?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16562558#comment-16562558
]
ASF GitHub Bot commented on DRILL-6638:
---------------------------------------
ilooner closed pull request #1402: DRILL-6638: Fix TestE2EUnnestAndLateral
tests introduced with DRILL-6546
URL: https://github.com/apache/drill/pull/1402
This is a PR merged from a forked repository.
As GitHub hides the original diff on merge, it is displayed below for
the sake of provenance:
As this is a foreign pull request (from a fork), the diff is supplied
below (as it won't show otherwise due to GitHub magic):
diff --git
a/exec/java-exec/src/test/java/org/apache/drill/exec/physical/impl/lateraljoin/TestE2EUnnestAndLateral.java
b/exec/java-exec/src/test/java/org/apache/drill/exec/physical/impl/lateraljoin/TestE2EUnnestAndLateral.java
index 88108a602f7..f8b58b9a940 100644
---
a/exec/java-exec/src/test/java/org/apache/drill/exec/physical/impl/lateraljoin/TestE2EUnnestAndLateral.java
+++
b/exec/java-exec/src/test/java/org/apache/drill/exec/physical/impl/lateraljoin/TestE2EUnnestAndLateral.java
@@ -174,7 +174,7 @@ public void testMultiUnnestAtSameLevel() throws Exception {
public void testUnnestWithItem() throws Exception {
String sql = "select u.item from\n" +
"cp.`lateraljoin/nested-customer.parquet` c," +
- "unnest(c.orders['items']) as u(item)\n" +
+ "unnest(c.orders[0]['items']) as u(item)\n" +
"limit 1";
testBuilder()
@@ -207,7 +207,7 @@ public void testUnnestWithFunctionCall() throws Exception {
public void testUnnestWithMap() throws Exception {
String sql = "select u.item from\n" +
"cp.`lateraljoin/nested-customer.parquet` c," +
- "unnest(c.orders.items) as u(item)\n" +
+ "unnest(c.orders[0].items) as u(item)\n" +
"limit 1";
testBuilder()
@@ -225,8 +225,8 @@ public void testUnnestWithMap() throws Exception {
public void testMultiUnnestWithMap() throws Exception {
String sql = "select u.item from\n" +
"cp.`lateraljoin/nested-customer.parquet` c," +
- "unnest(c.orders.items) as u(item)," +
- "unnest(c.orders.items) as u1(item1)\n" +
+ "unnest(c.orders[0].items) as u(item)," +
+ "unnest(c.orders[0].items) as u1(item1)\n" +
"limit 1";
testBuilder()
----------------------------------------------------------------
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:
[email protected]
> Fix TestE2EUnnestAndLateral tests introduced with DRILL-6546
> ------------------------------------------------------------
>
> Key: DRILL-6638
> URL: https://issues.apache.org/jira/browse/DRILL-6638
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - Flow
> Affects Versions: 1.14.0
> Reporter: Sorabh Hamirwasia
> Assignee: Volodymyr Vysotskyi
> Priority: Major
> Labels: ready-to-commit
> Fix For: 1.15.0
>
>
> All the tests with Map introduced with DRILL-6546 are trying to access
> repeated items within repeated orders directly which is not supported. One
> should unnest orders and then unnest items in these query.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
