Q:

Increase every character in particular column to next characters - hive

I am working on hive. I want to decode all records in name column by increasing every character to count 3. Example if name is abc i want cde. How can I do this using hive?

A:

EDIT : A much simpler solution : with TRANSLATE function.
SELECT TRANSLATE (name,
                  'abcdefghijklmnopqrstuvwxyz',
                  'defghijklmnopqrstuvwxyzabc')
  FROM yourtable;

OLD Approach (Don't use )
You could use a combination of splitting, converting to ascii, adding reconverting and joining them back into a string.
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;

O/p:
name name_plus_3
----  ----------
abc def        
pqr stu  

