How to remove multiple characters at once using regexp_replace() in Hive?

Question

I'm trying to cleanup my data in a Hive table. I need to replace some characters in a column but I'm unable to figure out how to remove multiple characters at once in using regexp_replace() in Hive SQL.

The below is straightforward and works as expected:

select regexp_replace('abc-de-ghi', '-','');

and outputs: abcdefghi

But I don't know how to clean up a string with different characters in it:

select regexp_replace('abc-de/ghi@jkl:mn#op', <i-dont-know-what-goes-here>,'');

Can someone please help me with this?

leftjoin · Accepted Answer · 2019-09-03 14:11:40Z

3

Use '[-/@:#]' template with character set (in the brackets) you want to remove:

select regexp_replace('abc-de/ghi@jkl:mn#op','[-/@:#]','');

Result:

OK
abcdeghijklmnop
Time taken: 4.656 seconds, Fetched: 1 row(s)

edited Sep 3, 2019 at 14:11

answered Sep 3, 2019 at 14:06

leftjoin

38.5k8 gold badges64 silver badges126 bronze badges

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

Collectives™ on Stack Overflow

How to remove multiple characters at once using regexp_replace() in Hive?

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