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!