Sign in
apache
/
drill-test-framework
/
HEAD
/
.
/
framework
/
resources
/
Functional
/
complex
/
parquet
/
complex132.q
blob: 6e255bfecb6b5849baf582fdb92b4d9cb3d71c4f [
file
] [
log
] [
blame
]
select
mod
(
trunc
(
t
.
sfa
[
1
]),
10
)
sfamod
,
max
(
t
.
sfa
[
0
])
sfamax
,
min
(
t
.
sfa
[
1
])
sfamin
,
avg
(
t
.
sfa
[
2
])
sfaavg
,
count
(
t
.
sfa
[
3
])
sfacount
from
`complex.json`
t
group
by
mod
(
trunc
(
t
.
sfa
[
1
]),
10
)
order
by
avg
(
t
.
sfa
[
2
]);