我在配置单元中运行此查询
with missed_codes as (
SELECT col1, left(col1, 3) || '.' || substr(col1, 4) as col2 FROM "table"
)
select * from missed_codes
我得到了这个错误:
Error while compiling statement: FAILED: ParseException line 1:7 cannot recognize input near 'LEFT' '(' 'col1' in select clause
输入列:
col1
A018
B672
预期输出:
col1 col2
A018 A01.8
B672 B67.2
我不明白这个查询有什么问题.如有任何帮助,不胜感激