[ 
https://issues.apache.org/jira/browse/TAJO-401?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jaehwa Jung resolved TAJO-401.
------------------------------

       Resolution: Cannot Reproduce
    Fix Version/s:     (was: 0.9.0)

Thanks [~prafulla] and [~hyunsik].

There is a typo and I found that two keywords ran successfully as follows:
{code:xml}
default> select * from table1;
id,  name,  score,  type
-------------------------------
1,  name1-1,  1.1,  a
2,  name1-2,  2.3,  b
3,  name1-3,  3.4,  c
4,  name1-4,  4.5,  d
5,  name1-5,  5.6,  e
(5 rows, 0.065 sec, 501 B selected)

default> select * from table1 where name != 'a';
Progress: 0%, response time: 1.361 sec
Progress: 0%, response time: 2.363 sec
Progress: 0%, response time: 3.365 sec
Progress: 100%, response time: 3.61 sec
id,  name,  score,  type
-------------------------------
1,  name1-1,  1.1,  a
2,  name1-2,  2.3,  b
3,  name1-3,  3.4,  c
4,  name1-4,  4.5,  d
5,  name1-5,  5.6,  e
(5 rows, 3.61 sec, 80 B selected)

default> select * from table1 where name <> 'a';
Progress: 0%, response time: 1.205 sec
Progress: 100%, response time: 1.275 sec
id,  name,  score,  type
-------------------------------
1,  name1-1,  1.1,  a
2,  name1-2,  2.3,  b
3,  name1-3,  3.4,  c
4,  name1-4,  4.5,  d
5,  name1-5,  5.6,  e
(5 rows, 1.275 sec, 80 B selected)
{code}

> Support '!=' operator
> ---------------------
>
>                 Key: TAJO-401
>                 URL: https://issues.apache.org/jira/browse/TAJO-401
>             Project: Tajo
>          Issue Type: Bug
>          Components: parser
>            Reporter: Jaehwa Jung
>              Labels: newbie
>
> If I write '!=' operator at where clause, TajoCli made a exception as follows:
> {code:xml}
> tajo> select * from table1 != 'a';
> Exception in thread "main" java.lang.IllegalArgumentException: != 'a';: event 
> not found
>       at jline.console.ConsoleReader.expandEvents(ConsoleReader.java:734)
>       at jline.console.ConsoleReader.finishBuffer(ConsoleReader.java:604)
>       at jline.console.ConsoleReader.accept(ConsoleReader.java:1912)
>       at jline.console.ConsoleReader.readLine(ConsoleReader.java:2537)
>       at jline.console.ConsoleReader.readLine(ConsoleReader.java:2162)
>       at org.apache.tajo.cli.TajoCli.runShell(TajoCli.java:192)
>       at org.apache.tajo.cli.TajoCli.main(TajoCli.java:721)
> {code}



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Reply via email to