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.

Kickstart Your Career

Get certified by completing the course

Get Started