Sign in
apache
/
drill-test-framework
/
9a5d7ecf7f32f0e95c0ea874e75d785fdee9e51d
/
.
/
framework
/
resources
/
Functional
/
flatten_operators
/
2rows
/
orderby13_DRILL-2075.q
blob: dc444c58f0dd30925efa42b93deb39e97c8ef2f5 [
file
] [
log
] [
blame
]
select
s
.
evnts
.
evnt_id
from
(
select
d
.
type type
,
flatten
(
d
.
events
)
evnts
from
`data.json`
d
where
d
.
type
=
'web'
order
by
d
.
uid
)
s
where
s
.
evnts
.
type
=
'cmpgn4'
and
s
.
type
=
'web'
;