Apache Drill - SQL Operator OR

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 ID = '007' or 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
007  Jack  13    male     six      55     45     45    2 park street      111222

Here, the OR operator produces the result if anyone condition matches from the above query.

Kickstart Your Career

Get certified by completing the course

Get Started