Apache Drill - SQL Operator NOT

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 mark1 not in (80,75,70);

Result

ID   name  age  gender  standard  mark1  mark2  mark3       addr          pincode
002  Amit  12    male     six      40     50     40    12 old street      111222
003  Bob   12    male     six      60     80     70    10 cross street    111222
004  David 12    male     six      50     70     70    15 express avenue  111222
006  Ganga 12   female    six      100    95     98    25 north street    111222
007  Jack  13    male     six      55     45     45    2 park street      111222
008  Leena 12   female    six      90     85     95    24 south street    111222

Kickstart Your Career

Get certified by completing the course

Get Started