[
https://issues.apache.org/jira/browse/TAJO-401?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14009189#comment-14009189
]
Hyunsik Choi commented on TAJO-401:
-----------------------------------
Hi Prafulla,
I understood that Jaehwa intend the alias of 'NOT EQUAL'. According to my brief
survey \[1\], most of commercial RDBMS supports {{<>}} as well as {{!=}}. So, I
think that it would be better if Tajo support both inequality operators.
\[1\]
http://stackoverflow.com/questions/723195/should-i-use-or-for-not-equal-in-tsql
> 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
> Fix For: 0.9.0
>
>
> 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)
