Apache Drill - SQL Operator LIKE

The Like Operator is used for pattern matching.

The following program shows the query for this function −

Query

0: jdbc:drill:zk = local> select name from dfs.`/Users/../workspace/Drill-samples/student_list.json`
   where name like ‘A%';

Result

name
Adam
Amit

The above query returns this result, when the name first letter is starting with ‘A’.