Thanks for help!
-- --
??: "Stamatis Zampetakis"
Hello,
I think it would be easier to understand the problem if you have a query at
hand:
SELECT id FROM author WHERE fname != 'Victor'
0 | Victor
1 | null
2 | Alex
The query should return 2 in every standard compliant SQL database.
Victor != Victor evaluates to FALSE
null != Victor evaluates t
Hi,all:
I want to know why the hive needs to filter the NULL when use '<>' or '!='
in HQL?
Normally,in Oracle or other Databases the NULL will not be filtered when using
'<>' or '!='.
This could be a JIRA?
Thanks!