blob: 910d089908b427fcd2c121e00a58614e0f9932a3 [file] [log] [blame]
set hive.mapred.mode=nonstrict;
-- SORT_QUERY_RESULTS
create table test(x string, y string);
insert into test values ('q', 'q'), ('q', 'w'), (NULL, 'q'), ('q', NULL), (NULL, NULL);
select *, x<=>y, not (x<=> y), (x <=> y) = false from test;