/tags/release-0.0.0-rc0/hive/external/ql/src/test/queries/clientpositive/nullgroup4.q

# · text · 31 lines · 20 code · 11 blank · 0 comment · 0 complexity · 576442fad3580af1b56978234d0bc576 MD5 · raw file

  1. set hive.map.aggr=true;
  2. set hive.groupby.skewindata=true;
  3. explain
  4. select count(1), count(distinct x.value) from src x where x.key = 9999;
  5. select count(1), count(distinct x.value) from src x where x.key = 9999;
  6. set hive.map.aggr=true;
  7. set hive.groupby.skewindata=false;
  8. explain
  9. select count(1), count(distinct x.value) from src x where x.key = 9999;
  10. select count(1), count(distinct x.value) from src x where x.key = 9999;
  11. set hive.map.aggr=false;
  12. set hive.groupby.skewindata=true;
  13. explain
  14. select count(1), count(distinct x.value) from src x where x.key = 9999;
  15. select count(1), count(distinct x.value) from src x where x.key = 9999;
  16. set hive.map.aggr=false;
  17. set hive.groupby.skewindata=false;
  18. explain
  19. select count(1), count(distinct x.value) from src x where x.key = 9999;
  20. select count(1), count(distinct x.value) from src x where x.key = 9999;