Apache Kylin: How to use '!=' in queries?

Asked Aug 12 '16 at 09:11

Active Aug 12 '16 at 09:11

Viewed 273 times

I got a short question on Apache kylin (version 1.5.3). I have built a cube successfully. Now I want to use the 'insight' tab of kylin to submit some queries. I have a table with two columns (id[varchar], abc[int]).

Queries like

select id, abc
from table
where abc = 12;

are working fine. But

select id, abc
from table
where abc != 12;

returns an error:

Lexical error at line 3, column 11. Encountered: "!" (33), after : ""

Does anyone knows the right lexical term of 'not'?

Thank you in advance, Søren

asked Aug 12 '16 at 09:11

Søren

1

Did you try **<>** ? – Pham X. Bach Aug 12 '16 at 09:13
I did not. Its working. I knew this was too easy... Thank you @ Pham X. Bach – Søren Aug 12 '16 at 09:16
np, some db don't support **!=** operator. nice day to you. – Pham X. Bach Aug 12 '16 at 09:20
And `not` sometimes is usefull – Konstantin Sorokin Aug 12 '16 at 10:14
'not' is returning the error message: Was expecting one of: "DISTINCT" ... "NOT" "DISTINCT" ... "A" ... "NOT" ... "NOT" "NULL" ... "NOT" "TRUE" ... "NOT" "FALSE" ... "NOT" "UNKNOWN" ... "NULL" ... "TRUE" ... "FALSE" ... "UNKNOWN" ... – Søren Aug 12 '16 at 13:42

Apache Kylin: How to use '!=' in queries?

0 Answers0