Sign in
apache
/
drill-test-framework
/
refs/heads/main
/
.
/
framework
/
resources
/
Functional
/
complex
/
json
/
complex134.q
blob: 6d7439866eeb3b00826a600fddd5f771d260f9b0 [
file
]
select
mod
(
t
.
soa
[
0
].
`in`
,
10
)
soamod
,
avg
(
t
.
soa
[
1
].
fl
)
soaavg
,
count
(
t
.
soa
[
2
].
nul
)
soacount
,
count
(
distinct
(
t
.
soa
[
3
].
bool
))
soadist
from
`complex.json`
t
group
by
mod
(
t
.
soa
[
0
].
`in`
,
10
)
order
by
mod
(
t
.
soa
[
0
].
`in`
,
10
);