Sign in
apache
/
hive
/
6b095edc31a9baa0ae805e2b5aea88101284d84b
/
.
/
ql
/
src
/
test
/
queries
/
clientpositive
/
equal_ns.q
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
;