[
https://issues.apache.org/jira/browse/DRILL-4490?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15188522#comment-15188522
]
ASF GitHub Bot commented on DRILL-4490:
---------------------------------------
Github user jinfengni commented on a diff in the pull request:
https://github.com/apache/drill/pull/423#discussion_r55625819
--- Diff:
exec/java-exec/src/test/java/org/apache/drill/exec/fn/impl/TestAggregateFunctions.java
---
@@ -460,4 +466,23 @@ public void testGroupBySystemFuncFileSystemTable()
throws Exception {
public void test4443() throws Exception {
test("SELECT MIN(columns[1]) FROM dfs_test.`%s/agg/4443.csv` GROUP BY
columns[0]", TEST_RES_PATH);
}
+
+ @Test
+ public void testCountStarRequired() throws Exception {
+ final String query = "select count(*) as col from
cp.`tpch/region.parquet` limit 0";
--- End diff --
this does not have to be used with "limit 0", right? can you add one more
case without using "limit 0"?
> Count(*) function returns as optional instead of required
> ---------------------------------------------------------
>
> Key: DRILL-4490
> URL: https://issues.apache.org/jira/browse/DRILL-4490
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - Data Types
> Affects Versions: 1.6.0
> Reporter: Krystal
> Assignee: Sean Hsuan-Yi Chu
>
> git.commit.id.abbrev=c8a7840
> I have the following CTAS query:
> create table test as select count(*) as col1 from cp.`tpch/orders.parquet`;
> The schema of the test table shows col1 as optional:
> message root {
> optional int64 col1;
> }
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
