Sign in
apache
/
drill-test-framework
/
HEAD
/
.
/
framework
/
resources
/
Functional
/
limit0
/
union
/
plan
/
union_32.q
blob: a80561889710f30edab634978f89944df072a557 [
file
]
explain plan
for
select
*
from
(
SELECT c1
,
c2
,
c3
,
c4
,
c5
,
c6
,
c7
,
c8
,
c9 FROM
`union_01_v`
WHERE c1 NOT
in
(-
1
,
0
,
1
,
99999.99
)
UNION SELECT c1
,
c2
,
c3
,
c4
,
c5
,
c6
,
c7
,
c8
,
c9 FROM
`union_02_v`
WHERE c1 NOT
in
(-
1
,
0
,
1
,
99999.99
,
402
)
)
t limit
0
;