like语句
1、sql：
select * from brrps_mart_org_map
where part_date =20170208
and branch03_name like '%北京%‘
2、hive：
select * from brrps_mart_org_map
where part_date =20170208
and branch03_name like concat('%','北京','%')
1、sql：
select * from brrps_mart_org_map
where part_date =20170208
and branch03_name like '%北京%‘
2、hive：
select * from brrps_mart_org_map
where part_date =20170208
and branch03_name like concat('%','北京','%')
本文标题：hive语句
本文链接：https://www.haomeiwen.com/subject/zgtwittx.html
网友评论