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 to UNKNOWN
Alex != Victor evaluates to TRUE
The WHERE clause removes tuples for which the condition evaluates to FALSE
or UNKNOWN and this is the normal behavior.
Best,
Stamatis
On Fri, Jun 26, 2020 at 2:36 AM 忝忝向仧 <153488...@qq.com> wrote:
> 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!