Sign in
apache
/
drill-test-framework
/
9a5d7ecf7f32f0e95c0ea874e75d785fdee9e51d
/
.
/
framework
/
resources
/
Functional
/
flatten_operators
/
general
/
jira1679.q
blob: 57feb7f7e0914b9a315dc89af596c4b458c64040 [
file
] [
log
] [
blame
]
with
tmp
as
(
select
1
as
fixedcolumn
,
flatten
(
columns
)
as
newcol
from
dfs
.
`/drill/testdata/flatten_operators/jira1679/b.csv`
)
select
regexp_replace
(
cast
(
tmp
.
newcol
as
VARCHAR
(
4
)),
'a'
,
'b'
)
from
tmp
;