PageRenderTime 47ms CodeModel.GetById 20ms RepoModel.GetById 1ms app.codeStats 0ms

/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
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0 
    

  1. set hive.map.aggr=true;
    2. 

  2. set hive.groupby.skewindata=true;
    3. 

  3. 

  4. explain
    5. 

  5. select count(1), count(distinct x.value) from src x where x.key = 9999;
    6. 

  6. 

  7. select count(1), count(distinct x.value) from src x where x.key = 9999;
    8. 

  8. 

  9. set hive.map.aggr=true;
    10. 

  10. set hive.groupby.skewindata=false;
    11. 

  11. 

  12. explain
    13. 

  13. select count(1), count(distinct x.value) from src x where x.key = 9999;
    14. 

  14. 

  15. select count(1), count(distinct x.value) from src x where x.key = 9999;
    16. 

  16. 

  17. set hive.map.aggr=false;
    18. 

  18. set hive.groupby.skewindata=true;
    19. 

  19. 

  20. explain
    21. 

  21. select count(1), count(distinct x.value) from src x where x.key = 9999;
    22. 

  22. 

  23. select count(1), count(distinct x.value) from src x where x.key = 9999;
    24. 

  24. 

  25. set hive.map.aggr=false;
    26. 

  26. set hive.groupby.skewindata=false;
    27. 

  27. 

  28. explain
    29. 

  29. select count(1), count(distinct x.value) from src x where x.key = 9999;
    30. 

  30. 

  31. select count(1), count(distinct x.value) from src x where x.key = 9999;
    32. 

  32.