Thanks for help! ---- ??:"Stamatis
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
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!