hive匹配中文及字母

hive匹配中文及字母

一 匹配含有中文的

匹配表order.order_info表，字段province举例 
select province from order.order_info 
where province regexp '[\\u4E00-\\u9FFF]+'

二 匹配全中文

匹配表order.order_info表，字段province举例 
select province from order.order_info 
where province not REGEXP '[u0391-uFFE5]'

三 匹配不含中文

匹配表order.order_info表，字段province举例 
select province from order.order_info 
where not regexp(province,'[\\u4E00-\\u9FFF]+')

四 匹配只包含小写英文或大写

匹配表order.order_info表，字段province举例 
select province from order.order_info 
where province rlike'[a-z]+' --小写

匹配表order.order_info表，字段province举例 
select province from order.order_info 
where province rlike'[A-Z]+' --大写

五 匹配不包含大小写英文字符

匹配表order.order_info表，字段province举例 
select province from order.order_info 
where province not rlike'([a-z]|[A-Z])+'

六 匹配任意数字

匹配表order.order_info表，字段province举例 
select province from order.order_info 
where province rlike'[0-9]+'