You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Jacques Nadeau (JIRA)" <ji...@apache.org> on 2015/01/04 22:28:45 UTC
[jira] [Updated] (DRILL-1423) "exists" function does not work with
text files
[ https://issues.apache.org/jira/browse/DRILL-1423?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jacques Nadeau updated DRILL-1423:
----------------------------------
Fix Version/s: 0.8.0
Assignee: Aman Sinha (was: Mehant Baid)
> "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: Aman Sinha
> Fix For: 0.8.0
>
> 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)