Sign in
apache
/
drill-test-framework
/
0c85b4fdd97d4bceb9f295eb434983b210bff100
/
.
/
framework
/
resources
/
Functional
/
union
/
union_22.q
blob: eb6b2d36e4816e7d9a59e75568e4fc576a1cbee1 [
file
] [
log
] [
blame
]
SELECT c1
,
c3
,
c5
,
c7
,
c9 FROM
`union_01.parquet`
WHERE c3
in
(
'CA'
,
'WI'
,
'MN'
)
UNION SELECT c1
,
c3
,
c5
,
c7
,
c9 FROM
`union_02.parquet`
WHERE c3 NOT
in
(
'CA'
,
'WI'
,
'MN'
);