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)
