Hive sql常用语句

1. 查看两个表相同的记录数

select count(*) from db1.tb1 A inner join db2.tb2 B on (A.account = B.mobile);
等价于
select count(*) from db1.tb1 A, db2.tb2 B where A.account = B.mobile;

2. 查看非空记录

select count(*) from db1.tb1 where mobile != ''