Hive 编程专题 八： 列引用之 RLike 条件

环境：

Hive: 2.7.7
Oracle SQL Developer
Cloudera JDBC Driver

案例 - 1 ： where name RLike ‘.(a|l|i)’

select * from default.employee 
where name RLike '.*(a|l|i)+'

数据部署：

insert into default.employee (name,salary,subordinates,deductions,address)
select 'liton'
    ,345
    ,array('liton','acai','ayun') as sub
    , map('liton',1,'acai',2,'ayun',7) as ded
    ,named_struct('street',"zhejiang",  'city',"hangzhou",  'state',"hubin",  'zip',"201210")
from student 
limit 1 


insert into default.employee (name,salary,subordinates,deductions,address)
select 'tencent'
    ,543
    ,array('tencent','acai','ayun') as sub
    , map('tencent',1,'acai',2,'ayun',7) as ded
    ,named_struct('street',"zhejiang",  'city',"hangzhou",  'state',"hubin",  'zip',"201210")
from student 
limit 1

结果：