soumyakanti3578 commented on a change in pull request #2163:
URL: https://github.com/apache/hive/pull/2163#discussion_r611713345
##########
File path: ql/src/test/results/clientpositive/llap/compare_cols_null.q.out
##########
@@ -121,6 +126,7 @@ POSTHOOK: query: select * from ccn_table where key <=>
'123a'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@ccn_table
#### A masked pattern was here ####
+NULL t1
Review comment:
I think it is because we are inserting `String` values to nullable `INT`
field:
`create table ccn_table(key int, value string);`
`insert into ccn_table values('123a', 't1'), ('123', 't2');`
`('123a', 't1')` is inserted as `NULL, 't1'`
And, in this select statement: `select * from ccn_table where key <=>
'123a';` `key <=> '123a'` resolves to `key IS NOT DISTINCT FROM null`, which
returns the output seen above.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
