You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Arina Ielchiieva (Jira)" <ji...@apache.org> on 2019/10/07 11:32:00 UTC
[jira] [Updated] (DRILL-7358) Text reader returns nothing for count
queries over empty files
[ https://issues.apache.org/jira/browse/DRILL-7358?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Arina Ielchiieva updated DRILL-7358:
------------------------------------
Labels: ready-to-commit (was: )
> 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
> Priority: Major
> Labels: ready-to-commit
> Fix For: 1.17.0
>
>
> If we do count over empty CSV files (with or without headers), there is no 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.4#803005)