Sign in
◑
Theme
apache
/
drill-test-framework
/
HEAD
/
.
/
framework
/
resources
/
Functional
/
ctas
/
ctas_flatten
/
2rows
/
functions1.q
blob: f6c1f2b2aa3f9ae85deb5f31e3c20586f31a54e2 [
file
]
create table dfs
.
ctas_flatten
.
`functions1_ctas`
as
select
MAX
(
sub
.
val
)
from
(
select
flatten
(
d
.
lst_lst
[
0
])
val
from
`data1.json`
d
)
sub
;
select
*
from
dfs
.
ctas_flatten
.
`functions1_ctas`
;
drop table dfs
.
ctas_flatten
.
`functions1_ctas`
;