drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rahul Challapalli (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-1423) "exists" function does not work with text files
Date Tue, 16 Sep 2014 21:35:34 GMT

     [ https://issues.apache.org/jira/browse/DRILL-1423?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Rahul Challapalli updated DRILL-1423:
-------------------------------------
    Attachment: error.log
                lineitem.tbl
                orders.tbl

> "exists" function does not work with text files
> -----------------------------------------------
>
>                 Key: DRILL-1423
>                 URL: https://issues.apache.org/jira/browse/DRILL-1423
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Execution - Codegen
>            Reporter: Rahul Challapalli
>            Assignee: Mehant Baid
>         Attachments: error.log, lineitem.tbl, orders.tbl
>
>
> git.commit.id.abbrev=1ce7c93
> The below query does not work on text files. However it works properly on parquet files
along with views on top of text files
> {code}
> select
>   o.columns[5]
> from
>   `orders.tbl` o
> where
>   exists (
>     select
>       *
>     from
>       `lineitem.tbl` l
>     where
>        l.columns[0] = o.columns[0]
>   )
> {code}
> I attached the error log and the data files used. Let me know if you have any questions.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message