hive_sql

select a.*,b.valid_state,b.valid_state from 
(select * from poi_release.map_poi_hn_click_validity_problem where dt = '2021-11-12' and valid_state != 'no_record') a 
inner join 
(select * from poi_release.map_poi_hn_click_validity_problem where dt = '2021-11-09' and valid_state = 'no_record') b
on a.c_address = b.c_address ;

纯数字

select industry_code,industry_name from base_organization where (industry_name REGEXP '[^0-9.]')=0 ;