编辑：一个更简单的解决方案：使用 TRANSLATE 功能。

SELECT TRANSLATE (name,
                  'abcdefghijklmnopqrstuvwxyz',
                  'defghijklmnopqrstuvwxyzabc')
  FROM yourtable;

旧方法（不使用）
您可以结合使用拆分、转换为ascii、添加再转换和将它们连接回字符串。

WITH t AS
  ( SELECT 'abc' AS name
       UNION ALL
  SELECT 'pqr' AS name
  ) ,
  ASC AS
  (SELECT name,
    ASCII(t1.letter) ascii_number
  FROM t LATERAL VIEW explode(split( REGEXP_REPLACE(name,'(.)' , '$1|') , '\\|') ) t1 AS letter
  )
SELECT name,
  concat_ws('',collect_set( DECODE(unhex(hex(ascii_number+3)), 'US-ASCII') ) ) as name_plus_3
FROM ASC
GROUP BY name;

订单号：

name name_plus_3
----  ----------
abc def        
pqr stu