Sign in
apache
/
drill-test-framework
/
HEAD
/
.
/
framework
/
resources
/
Functional
/
complex
/
json
/
complex214.q
blob: 02ed10baf4d612ab17e7f42fa576f6d2b7014b13 [
file
] [
log
] [
blame
]
select
t
.
gbyt
,
min
(
t
.
oooa
.
oa
.
oab
.
oabc
[
1
].
rowValue1
)
minoooa
from
`complex.json`
t
group
by
t
.
gbyt having min
(
t
.
oooa
.
oa
.
oab
.
oabc
[
1
].
rowValue1
)
in
(
1
,
2
,
3
,
14
,
33
,
41
,
50
)
order
by
minoooa
;