如何替换雪花表中的字符串
如何替换雪花表中的字符串
提问于 2021-05-21 23:11:08
我有一张雪花桌，我叫TEST_TABLE
SOURCE_RECORD_ID COL_A COL_B COL_C
paragon_altdata:model:2021-04-29_003108:1 A A A
paragon_altdata:model:2021-04-29_003108:2 A A A
paragon_altdata:model:2021-04-29_003108:3 A A A
paragon_altdata:model:2021-04-29_003108:4 A A A
paragon_altdata:model:2021-04-29_003108:5 A A A
paragon_altdata:model:2021-04-29_003108:6 A A A
paragon_altdata:model:2021-04-29_003108:7 A A A
paragon_altdata:model:2021-04-29_003108:8 A A A
paragon_altdata:model:2021-04-29_003108:9 A A A在此表中，我希望将第一列中的部分字符串paragon_altdata替换为paragonintel_altdata
我的表格应该如下所示
SOURCE_RECORD_ID COL_A COL_B COL_C
paragonintel_altdata:model:2021-04-29_003108:1 A A A
paragonintel_altdata:model:2021-04-29_003108:2 A A A
paragonintel_altdata:model:2021-04-29_003108:3 A A A
paragonintel_altdata:model:2021-04-29_003108:4 A A A
paragonintel_altdata:model:2021-04-29_003108:5 A A A
paragonintel_altdata:model:2021-04-29_003108:6 A A A
paragonintel_altdata:model:2021-04-29_003108:7 A A A
paragonintel_altdata:model:2021-04-29_003108:8 A A A
paragonintel_altdata:model:2021-04-29_003108:9 A A A请任何人在这方面帮助我
回答 1
Stack Overflow用户
回答已采纳
发布于 2021-05-21 23:20:34
您可以只使用replace，然后使用create table as select创建一个新表
create NEW_TABLE as
select
replace(SOURCE_RECORD_ID, 'paragon_', 'paragonintel_') as SOURCE_RECORD_ID
,COL_A
,COL_B
,COL_C
from TEST_TABLE
;然后，您可以交换它们并丢弃旧的。
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/67639515
复制相关文章
相似问题
腾讯云开发者
