hive语句
2017-02-09 本文已影响0人
queenieyin
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('%','北京','%')
