PageRenderTime 46ms CodeModel.GetById 21ms RepoModel.GetById 0ms app.codeStats 0ms

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

#
text | 71 lines | 61 code | 10 blank | 0 comment | 0 complexity | 4dc90cc35c9c371cee49853a6f050281 MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0 
    

  1. set hive.optimize.ppd=true;
    2. 

  2. 

  3. EXPLAIN EXTENDED
    4. 

  4.  FROM 
    5. 

  5.   src a
    6. 

  6.  LEFT OUTER JOIN 
    7. 

  7.   srcpart b 
    8. 

  8.  ON (a.key = b.key AND b.ds = '2008-04-08')
    9. 

  9.  SELECT a.key, a.value, b.key, b.value
    10. 

  10.  WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25;
    11. 

  11. 

  12.  FROM 
    13. 

  13.   src a
    14. 

  14.  LEFT OUTER JOIN 
    15. 

  15.   srcpart b 
    16. 

  16.  ON (a.key = b.key AND b.ds = '2008-04-08')
    17. 

  17.  SELECT a.key, a.value, b.key, b.value
    18. 

  18.  WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25;
    19. 

  19. 

  20. EXPLAIN EXTENDED
    21. 

  21.  FROM 
    22. 

  22.   srcpart a
    23. 

  23.  LEFT OUTER JOIN 
    24. 

  24.   src b 
    25. 

  25.  ON (a.key = b.key AND a.ds = '2008-04-08')
    26. 

  26.  SELECT a.key, a.value, b.key, b.value
    27. 

  27.  WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25;
    28. 

  28. 

  29.  FROM 
    30. 

  30.   srcpart a
    31. 

  31.  LEFT OUTER JOIN 
    32. 

  32.   src b 
    33. 

  33.  ON (a.key = b.key AND a.ds = '2008-04-08')
    34. 

  34.  SELECT a.key, a.value, b.key, b.value
    35. 

  35.  WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25;
    36. 

  36. 

  37. 

  38. EXPLAIN EXTENDED
    39. 

  39.  FROM 
    40. 

  40.   src a
    41. 

  41.  LEFT OUTER JOIN 
    42. 

  42.   srcpart b 
    43. 

  43.  ON (a.key = b.key)
    44. 

  44.  SELECT a.key, a.value, b.key, b.value
    45. 

  45.  WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25 AND b.ds = '2008-04-08';
    46. 

  46. 

  47.  FROM 
    48. 

  48.   src a
    49. 

  49.  LEFT OUTER JOIN 
    50. 

  50.   srcpart b 
    51. 

  51.  ON (a.key = b.key)
    52. 

  52.  SELECT a.key, a.value, b.key, b.value
    53. 

  53.  WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25 AND b.ds = '2008-04-08';
    54. 

  54. 

  55. EXPLAIN EXTENDED
    56. 

  56.  FROM 
    57. 

  57.   srcpart a
    58. 

  58.  LEFT OUTER JOIN 
    59. 

  59.   src b 
    60. 

  60.  ON (a.key = b.key)
    61. 

  61.  SELECT a.key, a.value, b.key, b.value
    62. 

  62.  WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25 AND a.ds = '2008-04-08';
    63. 

  63. 

  64.  FROM 
    65. 

  65.   srcpart a
    66. 

  66.  LEFT OUTER JOIN 
    67. 

  67.   src b 
    68. 

  68.  ON (a.key = b.key)
    69. 

  69.  SELECT a.key, a.value, b.key, b.value
    70. 

  70.  WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25 AND a.ds = '2008-04-08';
    71. 

  71. 

  72.