Apache Drill - REPEATED_COUNT Function

This function counts the values in an array.

Syntax

REPEATED_COUNT (array)

The following program shows the query for this function −

Query

0: jdbc:drill:zk = local> select REPEATED_COUNT(num2) from
   dfs.`/Users/../workspace/Drill-samples/array.json`;

Result

EXPR$0
3

Kickstart Your Career

Get certified by completing the course

Get Started