[
https://issues.apache.org/jira/browse/DRILL-7358?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Arina Ielchiieva updated DRILL-7358:
------------------------------------
Description:
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}
was:
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}
> 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
> 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.2#803003)
