方法一
sqlContext.sql("select distinct sn from hr.sample_terminal_three")
.rdd.map(_.toString).subtract(sqlContext.sql("select distinct sn from hr.live_terminal")
.rdd.map(_.toString).distinct).count
方法二
sql("SELECT COUNT(1) FROM hr.sample_terminal_three te
Left JOIN hr.live_terminal tr
ON te.sn = tr.sn where tr.brand is null ").collect