[
https://issues.apache.org/jira/browse/DRILL-3843?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14908687#comment-14908687
]
Daniel Barclay (Drill) commented on DRILL-3843:
-----------------------------------------------
Why is a zero expected rather than zero rows?
If directory "blah" is really non-existent (your report doesn't actually say),
wouldn't the value of the WHERE clause always be false, and therefore wouldn't
the result have zero rows?
> Any query returns empty results when we have a filter on a non-existent
> directory
> ---------------------------------------------------------------------------------
>
> Key: DRILL-3843
> URL: https://issues.apache.org/jira/browse/DRILL-3843
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - Flow
> Reporter: Rahul Challapalli
>
> git.commit.id.abbrev=3c89b30
> The below query should return 0 instead it returns no results
> {code}
> select l_shipdate from lineitem where dir0='blah';
> +-------------+
> | l_shipdate |
> +-------------+
> +-------------+
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
