?????? ??Why the NULL will be filterd in HQL??

2020-06-26 Thread ????????
Thanks for help! ---- ??:"Stamatis

Re: 【Why the NULL will be filterd in HQL】

2020-06-26 Thread 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

??Why the NULL will be filterd in HQL??

2020-06-25 Thread ????????
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!