Apache Drill - SQL Operator AND

The following program shows the query for this function −

Query

0: jdbc:drill:zk = local> select * from dfs.`/Users/../workspace/Drill-samples/student_list.json`
   where age = 12 and mark3 = 70;

Result

ID   name  age  gender  standard  mark1  mark2  mark3        addr         pincode
003  Bob   12    male     six      60     80     70    10 cross street    111222
004 David  12    male     six      50     70     70    15 express avenue  111222

Here, the AND operator produces the result when the condition matches to age = 12 and mark3 = 70.

Kickstart Your Career

Get certified by completing the course

Get Started