Aggregate Function COUNT(*)

Quiz

The following program shows the query for this function −

Query

0: jdbc:drill:zk = local> select count(*) from dfs.`/Users/../workspace/Drill-samples/student_list.json`;

EXPR$0
10

This count(*) function returns the total number of records.

apache_drill_query_using_json.htm

Print Page