Hive – Normalize String to Alphanumeric character only using regular expression December 5, 2014 by datafireball select mpn, REGEXP_REPLACE(upper(mpn), ‘[^a-zA-Z0-9]+’, ”) as mpn_norm from … Share this: Click to share on X (Opens in new window) X Click to share on Facebook (Opens in new window) Facebook Like Loading... Related