hive 队列名设置

set mapreduce.job.queuename=shujubu;select daa1.*
  from dw_activity_antirush_result daa1
  join (select applyid,
               count(1) as cn
          from dw_activity_antirush_result
         group by applyid
        having count(1) >= 2) daa2 on daa2.applyid = daa1.applyid order by rand() limit 10;