[
https://issues.apache.org/jira/browse/DRILL-1421?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14196239#comment-14196239
]
Jinfeng Ni commented on DRILL-1421:
-----------------------------------
+1. Looked at the optiq change as well new unit test case in Drill.
Just one minor comment:
If possible, could you please make the sample data (rankings.tbl and
uservisits.tbl) smaller? Currently they have 5k-10k rows. I assume we would be
able to recreate the problem with smaller data, since the problem is in planer
stage. Using larger sample data in the unit test would slow down the full
maven build each time when someone runs.
> 3 way join over text files (no views) fails
> -------------------------------------------
>
> Key: DRILL-1421
> URL: https://issues.apache.org/jira/browse/DRILL-1421
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - Flow
> Reporter: Rahul Challapalli
> Assignee: Aman Sinha
> Priority: Critical
> Fix For: 0.7.0
>
> Attachments:
> 0002-DRILL-1421-Add-unit-tests-and-data.-Bump-up-drill-op.patch, error.txt,
> rankings.tbl, temp.tbl, uservisits.tbl
>
>
> git.commit.id.abbrev=1ce7c93
> The below query which joins 2 text files work
> {code}
> select r.columns[1] from rankings r, uservisits u where
> r.columns[1]=u.columns[1];
> {code}
> However the below query with a 3-way join over text files just hangs in sql
> line without throwing any error
> {code}
> select r.columns[1] from rankings r, uservisits u, `temp.tbl` t where
> r.columns[1]=u.columns[1] and r.columns[1] = t.columns[0];
> {code}
> Attached the error from the log file along with the data files
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
