You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "David A (JIRA)" <ji...@apache.org> on 2016/05/28 20:09:12 UTC

[jira] [Commented] (DRILL-2759) Wrong result on count(*) from empty csv file

    [ https://issues.apache.org/jira/browse/DRILL-2759?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15305582#comment-15305582 ] 

David A commented on DRILL-2759:
--------------------------------

Returns 0 now.

select count(*) from dfs.`/Users/davida/empty.csv`;
+---------+
| EXPR$0  |
+---------+
| 0       |
+---------+
1 row selected (0.405 seconds)

> Wrong result on count(*) from empty csv file
> --------------------------------------------
>
>                 Key: DRILL-2759
>                 URL: https://issues.apache.org/jira/browse/DRILL-2759
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Storage - Text & CSV
>    Affects Versions: 0.9.0
>            Reporter: Victoria Markman
>            Priority: Critical
>             Fix For: Future
>
>
> t1.csv is an empty file:
> {code}
> 0: jdbc:drill:schema=dfs> select count(*) from `bigtable/2015/01/t1.csv`;
> Query failed: IllegalArgumentException: Incoming endpoints 1 is greater than number of row groups 0
> Error: exception while executing query: Failure while executing query. (state=,code=0)
> {code}



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