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

# · text · 28 lines · 24 code · 4 blank · 0 comment · 0 complexity · 7a219dd2a5f644ae54547cfa1dcbf649 MD5 · raw file 

    

  1. EXPLAIN
    2. 

  2. SELECT /*+ MAPJOIN(z) */ subq.key1, z.value
    3. 

  3. FROM
    4. 

  4. (SELECT /*+ MAPJOIN(x) */ x.key as key1, x.value as value1, y.key as key2, y.value as value2 
    5. 

  5.  FROM src1 x JOIN src y ON (x.key = y.key)) subq
    6. 

  6.  JOIN srcpart z ON (subq.key1 = z.key and z.ds='2008-04-08' and z.hr=11);
    7. 

  7.  
    8. 

  8. SELECT /*+ MAPJOIN(z) */ subq.key1, z.value
    9. 

  9. FROM
    10. 

  10. (SELECT /*+ MAPJOIN(x) */ x.key as key1, x.value as value1, y.key as key2, y.value as value2 
    11. 

  11.  FROM src1 x JOIN src y ON (x.key = y.key)) subq
    12. 

  12.  JOIN srcpart z ON (subq.key1 = z.key and z.ds='2008-04-08' and z.hr=11);
    13. 

  13.  
    14. 

  14. EXPLAIN 
    15. 

  15. SELECT /*+ MAPJOIN(z) */ subq.key1, z.value
    16. 

  16. FROM
    17. 

  17. (SELECT /*+ MAPJOIN(x) */ x.key as key1, x.value as value1, y.key as key2, y.value as value2 
    18. 

  18.  FROM src1 x JOIN src y ON (x.key = y.key)) subq
    19. 

  19.  JOIN srcpart z ON (subq.key1 = z.key and z.ds='2008-04-08' and z.hr=11) 
    20. 

  20.  order by subq.key1;
    21. 

  21. 

  22. 

  23. SELECT /*+ MAPJOIN(z) */ subq.key1, z.value
    24. 

  24. FROM
    25. 

  25. (SELECT /*+ MAPJOIN(x) */ x.key as key1, x.value as value1, y.key as key2, y.value as value2  
    26. 

  26.  FROM src1 x JOIN src y ON (x.key = y.key)) subq 
    27. 

  27.  JOIN srcpart z ON (subq.key1 = z.key and z.ds='2008-04-08' and z.hr=11)  
    28. 

  28.  order by subq.key1;
    29.