hive> with t as (select stack(3,'17.843.983-9','8.365.938-1','10.294.487-5') as col)
> select regexp_replace(col,'\\.','')
> from t
> ;
OK
_c0
17843983-9
8365938-1
10294487-5
或
hive> with t as (select stack(3,'17.843.983-9','8.365.938-1','10.294.487-5') as col)
> select replace(col,'.','')
> from t
> ;
OK
_c0
17843983-9
8365938-1
10294487-5
1条答案
按热度按时间p5fdfcr11#
或