hive:multiple string replace in a column

Question

It's easy to replace a character one time with a function such as this:

regexp_replace(string INITIAL_STRING, string PATTERN, string REPLACEMENT)

But how to deal with multiple string replacements in a column at one time?

For example, with relation like A to @, B to #, C to Z, how would one change "ABC" into "@#Z"?

One way is to use nested regexp_replace(regexp_replace(...),...) for each pattern. — serge_k
– serge_k, Commented Jul 15, 2019 at 5:22

leftjoin · Accepted Answer · 2019-07-15 05:48:45Z

1

Use translate(input, from, to) function, it translates the input string by replacing the characters present in the from string with the corresponding characters in the to string:

hive> select translate('initial string ABC A B C','ABC','@#Z');
OK
initial string @#Z @ # Z
Time taken: 0.063 seconds, Fetched: 1 row(s)

answered Jul 15, 2019 at 5:48

leftjoin

38.5k8 gold badges64 silver badges126 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

hive:multiple string replace in a column

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related