[jira] [Commented] (DRILL-1421) 3 way join over text files (no views) fails

["Jinfeng Ni (JIRA)" <ji...@apache.org>]

    [ 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)