Sign in
apache
/
drill-test-framework
/
0c85b4fdd97d4bceb9f295eb434983b210bff100
/
.
/
framework
/
resources
/
Functional
/
json
/
kvgenflatten-nulls
/
withinGroupBy9.q
blob: d290d2ae6bcd2792253419f8f37948a2e3f183cd [
file
] [
log
] [
blame
]
select
uid
,
MAX
(
l1
+
l2
)
from
(
select
uid
,
flatten
(
lst_lst
[
1
])
l1
,
flatten
(
lst_lst
[
0
])
l2
from
`data.json`
)
sub
group
by
uid
,
l1
,
l2
;