Sign in
apache
/
drill-test-framework
/
HEAD
/
.
/
framework
/
resources
/
Functional
/
complex
/
json
/
complex37.q
blob: 3d7282976e71d8e2431ba54fe90b78fbc6c32b66 [
file
] [
log
] [
blame
]
select
t
.
gbyi
,
max
(
t
.
id
)
maxid
,
count
(
t
.
oooa
.
oa
.
oab
.
oabc
[
0
].
rowId
)
countid
,
min
(
t
.
oooa
.
oa
.
oab
.
oabc
[
1
].
rowValue1
)
minvalue
,
max
(
t
.
oooa
.
oa
.
oab
.
oabc
[
1
].
rowValue2
)
maxvalue
from
`complex.json`
t
group
by
t
.
gbyi
;
