Sign in
apache
/
drill-test-framework
/
9a5d7ecf7f32f0e95c0ea874e75d785fdee9e51d
/
.
/
framework
/
resources
/
Functional
/
flatten_operators
/
2rows
/
filter16.q
blob: c6725182ecb98c4a2e9f3517a98701aca8e4ccee [
file
] [
log
] [
blame
]
select
s
.
rms
.
mapid
from
(
select
d
.
type type
,
flatten
(
d
.
map
.
rm
)
rms
from
`data.json`
d
where
d
.
map
.
rm
[
0
].
mapid
=
'm1'
)
s
where
s
.
rms
.
mapid
=
'm2'
;