Apache Drill - SQL Operator IN

The following program shows the query for this function −

Query

0: jdbc:drill:zk = local> select name,age,addr from dfs.`/Users/../workspace/Drill-samples/student_list.json`
   where ID in (‘001','003');

Result

name age     addr
Adam 12  23 new street
Bob  12  10 cross street

The IN operator returns result in the set condition.