环境:
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
结果: