Sign in
apache
/
drill-test-framework
/
HEAD
/
.
/
framework
/
resources
/
Functional
/
complex
/
json
/
complex282.q
blob: 8f1e9dbb50c669101fdcf7551f5b55886aae117b [
file
] [
log
] [
blame
]
select
tt
.
id
,
tt
.
soa0
.
`in`
+
tt
.
soa1
.
fl
*
tt
.
soa2
.
fl
from
(
select
t
.
id id
,
t
.
soa
[
0
]
soa0
,
t
.
soa
[
1
]
soa1
,
t
.
soa
[
2
]
soa2
from
`complex.json`
t
)
tt
where
tt
.
id
<=
20
;