PageRenderTime 40ms CodeModel.GetById 18ms RepoModel.GetById 0ms app.codeStats 0ms

/tags/release-0.2.0-rc0/hive/external/ql/src/test/results/clientpositive/order.q.out

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

  1. PREHOOK: query: EXPLAIN
    2. 

  2. SELECT x.* FROM SRC x ORDER BY key limit 10
    3. 

  3. PREHOOK: type: QUERY
    4. 

  4. POSTHOOK: query: EXPLAIN
    5. 

  5. SELECT x.* FROM SRC x ORDER BY key limit 10
    6. 

  6. POSTHOOK: type: QUERY
    7. 

  7. ABSTRACT SYNTAX TREE:
    8. 

  8.   (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME SRC) x)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF (TOK_TABNAME x)))) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL key))) (TOK_LIMIT 10)))
    9. 

  9. 

  10. STAGE DEPENDENCIES:
    11. 

  11.   Stage-1 is a root stage
    12. 

  12.   Stage-0 is a root stage
    13. 

  13. 

  14. STAGE PLANS:
    15. 

  15.   Stage: Stage-1
    16. 

  16.     Map Reduce
    17. 

  17.       Alias -> Map Operator Tree:
    18. 

  18.         x 
    19. 

  19.           TableScan
    20. 

  20.             alias: x
    21. 

  21.             Select Operator
    22. 

  22.               expressions:
    23. 

  23.                     expr: key
    24. 

  24.                     type: string
    25. 

  25.                     expr: value
    26. 

  26.                     type: string
    27. 

  27.               outputColumnNames: _col0, _col1
    28. 

  28.               Reduce Output Operator
    29. 

  29.                 key expressions:
    30. 

  30.                       expr: _col0
    31. 

  31.                       type: string
    32. 

  32.                 sort order: +
    33. 

  33.                 tag: -1
    34. 

  34.                 value expressions:
    35. 

  35.                       expr: _col0
    36. 

  36.                       type: string
    37. 

  37.                       expr: _col1
    38. 

  38.                       type: string
    39. 

  39.       Reduce Operator Tree:
    40. 

  40.         Extract
    41. 

  41.           Limit
    42. 

  42.             File Output Operator
    43. 

  43.               compressed: false
    44. 

  44.               GlobalTableId: 0
    45. 

  45.               table:
    46. 

  46.                   input format: org.apache.hadoop.mapred.TextInputFormat
    47. 

  47.                   output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    48. 

  48. 

  49.   Stage: Stage-0
    50. 

  50.     Fetch Operator
    51. 

  51.       limit: 10
    52. 

  52. 

  53. 

  54. PREHOOK: query: SELECT x.* FROM SRC x ORDER BY key limit 10
    55. 

  55. PREHOOK: type: QUERY
    56. 

  56. PREHOOK: Input: default@src
    57. 

  57. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-49-58_470_1953591839692924192/-mr-10000
    58. 

  58. POSTHOOK: query: SELECT x.* FROM SRC x ORDER BY key limit 10
    59. 

  59. POSTHOOK: type: QUERY
    60. 

  60. POSTHOOK: Input: default@src
    61. 

  61. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-49-58_470_1953591839692924192/-mr-10000
    62. 

  62. 0	val_0
    63. 

  63. 0	val_0
    64. 

  64. 0	val_0
    65. 

  65. 10	val_10
    66. 

  66. 100	val_100
    67. 

  67. 100	val_100
    68. 

  68. 103	val_103
    69. 

  69. 103	val_103
    70. 

  70. 104	val_104
    71. 

  71. 104	val_104
    72. 

  72. PREHOOK: query: EXPLAIN
    73. 

  73. SELECT x.* FROM SRC x ORDER BY key desc limit 10
    74. 

  74. PREHOOK: type: QUERY
    75. 

  75. POSTHOOK: query: EXPLAIN
    76. 

  76. SELECT x.* FROM SRC x ORDER BY key desc limit 10
    77. 

  77. POSTHOOK: type: QUERY
    78. 

  78. ABSTRACT SYNTAX TREE:
    79. 

  79.   (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME SRC) x)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF (TOK_TABNAME x)))) (TOK_ORDERBY (TOK_TABSORTCOLNAMEDESC (TOK_TABLE_OR_COL key))) (TOK_LIMIT 10)))
    80. 

  80. 

  81. STAGE DEPENDENCIES:
    82. 

  82.   Stage-1 is a root stage
    83. 

  83.   Stage-0 is a root stage
    84. 

  84. 

  85. STAGE PLANS:
    86. 

  86.   Stage: Stage-1
    87. 

  87.     Map Reduce
    88. 

  88.       Alias -> Map Operator Tree:
    89. 

  89.         x 
    90. 

  90.           TableScan
    91. 

  91.             alias: x
    92. 

  92.             Select Operator
    93. 

  93.               expressions:
    94. 

  94.                     expr: key
    95. 

  95.                     type: string
    96. 

  96.                     expr: value
    97. 

  97.                     type: string
    98. 

  98.               outputColumnNames: _col0, _col1
    99. 

  99.               Reduce Output Operator
    100. 

  100.                 key expressions:
    101. 

  101.                       expr: _col0
    102. 

  102.                       type: string
    103. 

  103.                 sort order: -
    104. 

  104.                 tag: -1
    105. 

  105.                 value expressions:
    106. 

  106.                       expr: _col0
    107. 

  107.                       type: string
    108. 

  108.                       expr: _col1
    109. 

  109.                       type: string
    110. 

  110.       Reduce Operator Tree:
    111. 

  111.         Extract
    112. 

  112.           Limit
    113. 

  113.             File Output Operator
    114. 

  114.               compressed: false
    115. 

  115.               GlobalTableId: 0
    116. 

  116.               table:
    117. 

  117.                   input format: org.apache.hadoop.mapred.TextInputFormat
    118. 

  118.                   output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    119. 

  119. 

  120.   Stage: Stage-0
    121. 

  121.     Fetch Operator
    122. 

  122.       limit: 10
    123. 

  123. 

  124. 

  125. PREHOOK: query: SELECT x.* FROM SRC x ORDER BY key desc limit 10
    126. 

  126. PREHOOK: type: QUERY
    127. 

  127. PREHOOK: Input: default@src
    128. 

  128. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-50-01_948_5416711380647864500/-mr-10000
    129. 

  129. POSTHOOK: query: SELECT x.* FROM SRC x ORDER BY key desc limit 10
    130. 

  130. POSTHOOK: type: QUERY
    131. 

  131. POSTHOOK: Input: default@src
    132. 

  132. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-50-01_948_5416711380647864500/-mr-10000
    133. 

  133. 98	val_98
    134. 

  134. 98	val_98
    135. 

  135. 97	val_97
    136. 

  136. 97	val_97
    137. 

  137. 96	val_96
    138. 

  138. 95	val_95
    139. 

  139. 95	val_95
    140. 

  140. 92	val_92
    141. 

  141. 90	val_90
    142. 

  142. 90	val_90
    143. 

  143.