Sign in
apache
/
drill-test-framework
/
9a5d7ecf7f32f0e95c0ea874e75d785fdee9e51d
/
.
/
framework
/
resources
/
Functional
/
limit0
/
filters
/
plan
/
q24.sql
blob: c55600c41e58f27b00ab2d9620d0707e19032835 [
file
] [
log
] [
blame
]
explain
plan
for
select
*
from
(
select
x
,
y
,
z
from
(
select
t1
.
a1
,
max
(
t1
.
b1
),
avg
(
t1
.
a1
)
from
t1_v t1
,
t2_v t2
where
t1
.
c1
=
t2
.
c2
group
by
t1
.
a1
,
t1
.
b1
)
as
sq
(
x
,
y
,
z
)
where
y
not
like
'%b%'
OR
x
=
10
)
t limit
0
;