hive替换文件中特殊字符

select   regexp_replace(regexp_replace(regexp_replace(t.column_001,'',''),'12',''),'15' ,'') as column_001
           ,regexp_replace(regexp_replace(regexp_replace(t.column_002,'',''),'12',''),'15' ,'') as column_002
           ,regexp_replace(regexp_replace(regexp_replace(t.column_003,'',''),'12',''),'15' ,'') as column_003
           ,regexp_replace(regexp_replace(regexp_replace(t.column_004,'',''),'12',''),'15' ,'') as column_004
           ,regexp_replace(regexp_replace(regexp_replace(t.column_005,'',''),'12',''),'15' ,'') as column_005
           ,regexp_replace(regexp_replace(regexp_replace(t.column_006,'',''),'12',''),'15' ,'') as column_006
          ,regexp_replace(regexp_replace(regexp_replace(t.column_007,'',''),'12',''),'15' ,'') as column_007
from table_name t;

原文地址:https://www.cnblogs.com/Arabi/p/11811808.html