[jira] [Created] (DRILL-7358) Text reader returns nothing for count queries over empty files

["Arina Ielchiieva (Jira)" <ji...@apache.org>]

Arina Ielchiieva created DRILL-7358:
---------------------------------------

             Summary: Text reader returns nothing for count queries over empty files
                 Key: DRILL-7358
                 URL: https://issues.apache.org/jira/browse/DRILL-7358
             Project: Apache Drill
          Issue Type: Bug
    Affects Versions: 1.16.0
            Reporter: Arina Ielchiieva
            Assignee: Paul Rogers
             Fix For: 1.17.0


If we do count over empty CSV files (with or without headers), there is not result.
Though expecting result is 0.

Unit tests examples:

{code}
@Test
public void testCount() throws Exception {
  String fileName = "headersOnly.csv";
  try (PrintWriter out = new PrintWriter(new FileWriter(new File(testDir, fileName)))) {
    out.print("a,b,c"); // note: no \n in the end
  }

  queryBuilder().sql("SELECT count(1) FROM `dfs.data`.`" + fileName + "`").print();
}
{code}

{code}
@Test
public void testCount() throws Exception {
  String fileName = "empty.csv";

  File file = new File(testDir, fileName);
  assertTrue(file.createNewFile());

  queryBuilder().sql("SELECT count(1) FROM `dfs.data`.`" + fileName + "`").print();
}
{code}




--
This message was sent by Atlassian Jira
(v8.3.2#803003)