Aggregate Function AVG(expression)

Quiz

The following program shows the query for this function −

Query

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

EXPR$0
69.0

Here, the output is the average result of mark1 column.

apache_drill_query_using_json.htm

Print Page