[jira] [Created] (DRILL-1423) "exists" function does not work with text files

["Rahul Challapalli (JIRA)" <ji...@apache.org>]

Rahul Challapalli created DRILL-1423:
----------------------------------------

             Summary: "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


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)