HIVE sql取中文

select 
     regexp_replace(str,'[^\\u4e00-\\u9fa5]','') as str1
from (
    select 'test测试test' as str
) t
;
posted @ 2018-07-25 16:00  chenzechao  阅读(950)  评论(0)    收藏  举报