Sign in
apache
/
drill-test-framework
/
0c85b4fdd97d4bceb9f295eb434983b210bff100
/
.
/
framework
/
resources
/
Functional
/
limit0
/
hbase
/
data
/
union_all.q
blob: 81ef97019079ca70edac20a0bbc321b2396afc46 [
file
] [
log
] [
blame
]
select
*
from
(
select
cast
(
s
.
onecf
.
name
as
varchar
(
35
))
name
from
student s
where
cast
(
s
.
twocf
.
age
as
integer
)
<
20
UNION ALL
select
cast
(
v
.
onecf
.
name
as
varchar
(
35
))
name
from
voter v
where
cast
(
v
.
twocf
.
age
as
integer
)
<
20
)
student
;