PageRenderTime 244ms CodeModel.GetById 17ms RepoModel.GetById 0ms app.codeStats 0ms

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

#
text | 240 lines | 221 code | 19 blank | 0 comment | 0 complexity | 05eea09b87091148051215516c60d2b9 MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0 
    

  1. PREHOOK: query: EXPLAIN
    2. 

  2. CREATE TABLE symlink_text_input_format (key STRING, value STRING) STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.SymlinkTextInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat'
    3. 

  3. PREHOOK: type: CREATETABLE
    4. 

  4. POSTHOOK: query: EXPLAIN
    5. 

  5. CREATE TABLE symlink_text_input_format (key STRING, value STRING) STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.SymlinkTextInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat'
    6. 

  6. POSTHOOK: type: CREATETABLE
    7. 

  7. ABSTRACT SYNTAX TREE:
    8. 

  8.   (TOK_CREATETABLE (TOK_TABNAME symlink_text_input_format) TOK_LIKETABLE (TOK_TABCOLLIST (TOK_TABCOL key TOK_STRING) (TOK_TABCOL value TOK_STRING)) (TOK_TABLEFILEFORMAT 'org.apache.hadoop.hive.ql.io.SymlinkTextInputFormat' 'org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat'))
    9. 

  9. 

  10. STAGE DEPENDENCIES:
    11. 

  11.   Stage-0 is a root stage
    12. 

  12. 

  13. STAGE PLANS:
    14. 

  14.   Stage: Stage-0
    15. 

  15.       Create Table Operator:
    16. 

  16.         Create Table
    17. 

  17.           columns: key string, value string
    18. 

  18.           if not exists: false
    19. 

  19.           input format: org.apache.hadoop.hive.ql.io.SymlinkTextInputFormat
    20. 

  20.           # buckets: -1
    21. 

  21.           output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
    22. 

  22.           name: symlink_text_input_format
    23. 

  23.           isExternal: false
    24. 

  24. 

  25. 

  26. PREHOOK: query: CREATE TABLE symlink_text_input_format (key STRING, value STRING) STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.SymlinkTextInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat'
    27. 

  27. PREHOOK: type: CREATETABLE
    28. 

  28. POSTHOOK: query: CREATE TABLE symlink_text_input_format (key STRING, value STRING) STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.SymlinkTextInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat'
    29. 

  29. POSTHOOK: type: CREATETABLE
    30. 

  30. POSTHOOK: Output: default@symlink_text_input_format
    31. 

  31. PREHOOK: query: EXPLAIN SELECT * FROM symlink_text_input_format order by key, value
    32. 

  32. PREHOOK: type: QUERY
    33. 

  33. POSTHOOK: query: EXPLAIN SELECT * FROM symlink_text_input_format order by key, value
    34. 

  34. POSTHOOK: type: QUERY
    35. 

  35. ABSTRACT SYNTAX TREE:
    36. 

  36.   (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME symlink_text_input_format))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL key)) (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL value)))))
    37. 

  37. 

  38. STAGE DEPENDENCIES:
    39. 

  39.   Stage-1 is a root stage
    40. 

  40.   Stage-0 is a root stage
    41. 

  41. 

  42. STAGE PLANS:
    43. 

  43.   Stage: Stage-1
    44. 

  44.     Map Reduce
    45. 

  45.       Alias -> Map Operator Tree:
    46. 

  46.         symlink_text_input_format 
    47. 

  47.           TableScan
    48. 

  48.             alias: symlink_text_input_format
    49. 

  49.             Select Operator
    50. 

  50.               expressions:
    51. 

  51.                     expr: key
    52. 

  52.                     type: string
    53. 

  53.                     expr: value
    54. 

  54.                     type: string
    55. 

  55.               outputColumnNames: _col0, _col1
    56. 

  56.               Reduce Output Operator
    57. 

  57.                 key expressions:
    58. 

  58.                       expr: _col0
    59. 

  59.                       type: string
    60. 

  60.                       expr: _col1
    61. 

  61.                       type: string
    62. 

  62.                 sort order: ++
    63. 

  63.                 tag: -1
    64. 

  64.                 value expressions:
    65. 

  65.                       expr: _col0
    66. 

  66.                       type: string
    67. 

  67.                       expr: _col1
    68. 

  68.                       type: string
    69. 

  69.       Reduce Operator Tree:
    70. 

  70.         Extract
    71. 

  71.           File Output Operator
    72. 

  72.             compressed: false
    73. 

  73.             GlobalTableId: 0
    74. 

  74.             table:
    75. 

  75.                 input format: org.apache.hadoop.mapred.TextInputFormat
    76. 

  76.                 output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    77. 

  77. 

  78.   Stage: Stage-0
    79. 

  79.     Fetch Operator
    80. 

  80.       limit: -1
    81. 

  81. 

  82. 

  83. PREHOOK: query: SELECT * FROM symlink_text_input_format order by key, value
    84. 

  84. PREHOOK: type: QUERY
    85. 

  85. PREHOOK: Input: default@symlink_text_input_format
    86. 

  86. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-24-10_305_4117602077727755730/-mr-10000
    87. 

  87. POSTHOOK: query: SELECT * FROM symlink_text_input_format order by key, value
    88. 

  88. POSTHOOK: type: QUERY
    89. 

  89. POSTHOOK: Input: default@symlink_text_input_format
    90. 

  90. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-24-10_305_4117602077727755730/-mr-10000
    91. 

  91. 1	11
    92. 

  92. 2	12
    93. 

  93. 2	12
    94. 

  94. 2	22
    95. 

  95. 3	13
    96. 

  96. 3	13
    97. 

  97. 4	14
    98. 

  98. 4	14
    99. 

  99. 5	15
    100. 

  100. 6	16
    101. 

  101. 7	17
    102. 

  102. 7	17
    103. 

  103. 8	18
    104. 

  104. 8	18
    105. 

  105. 8	18
    106. 

  106. 8	28
    107. 

  107. PREHOOK: query: EXPLAIN SELECT value FROM symlink_text_input_format order by value
    108. 

  108. PREHOOK: type: QUERY
    109. 

  109. POSTHOOK: query: EXPLAIN SELECT value FROM symlink_text_input_format order by value
    110. 

  110. POSTHOOK: type: QUERY
    111. 

  111. ABSTRACT SYNTAX TREE:
    112. 

  112.   (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME symlink_text_input_format))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL value))) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL value)))))
    113. 

  113. 

  114. STAGE DEPENDENCIES:
    115. 

  115.   Stage-1 is a root stage
    116. 

  116.   Stage-0 is a root stage
    117. 

  117. 

  118. STAGE PLANS:
    119. 

  119.   Stage: Stage-1
    120. 

  120.     Map Reduce
    121. 

  121.       Alias -> Map Operator Tree:
    122. 

  122.         symlink_text_input_format 
    123. 

  123.           TableScan
    124. 

  124.             alias: symlink_text_input_format
    125. 

  125.             Select Operator
    126. 

  126.               expressions:
    127. 

  127.                     expr: value
    128. 

  128.                     type: string
    129. 

  129.               outputColumnNames: _col0
    130. 

  130.               Reduce Output Operator
    131. 

  131.                 key expressions:
    132. 

  132.                       expr: _col0
    133. 

  133.                       type: string
    134. 

  134.                 sort order: +
    135. 

  135.                 tag: -1
    136. 

  136.                 value expressions:
    137. 

  137.                       expr: _col0
    138. 

  138.                       type: string
    139. 

  139.       Reduce Operator Tree:
    140. 

  140.         Extract
    141. 

  141.           File Output Operator
    142. 

  142.             compressed: false
    143. 

  143.             GlobalTableId: 0
    144. 

  144.             table:
    145. 

  145.                 input format: org.apache.hadoop.mapred.TextInputFormat
    146. 

  146.                 output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    147. 

  147. 

  148.   Stage: Stage-0
    149. 

  149.     Fetch Operator
    150. 

  150.       limit: -1
    151. 

  151. 

  152. 

  153. PREHOOK: query: SELECT value FROM symlink_text_input_format order by value
    154. 

  154. PREHOOK: type: QUERY
    155. 

  155. PREHOOK: Input: default@symlink_text_input_format
    156. 

  156. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-24-13_733_1088047071909969175/-mr-10000
    157. 

  157. POSTHOOK: query: SELECT value FROM symlink_text_input_format order by value
    158. 

  158. POSTHOOK: type: QUERY
    159. 

  159. POSTHOOK: Input: default@symlink_text_input_format
    160. 

  160. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-24-13_733_1088047071909969175/-mr-10000
    161. 

  161. 11
    162. 

  162. 12
    163. 

  163. 12
    164. 

  164. 13
    165. 

  165. 13
    166. 

  166. 14
    167. 

  167. 14
    168. 

  168. 15
    169. 

  169. 16
    170. 

  170. 17
    171. 

  171. 17
    172. 

  172. 18
    173. 

  173. 18
    174. 

  174. 18
    175. 

  175. 22
    176. 

  176. 28
    177. 

  177. PREHOOK: query: EXPLAIN SELECT count(1) FROM symlink_text_input_format
    178. 

  178. PREHOOK: type: QUERY
    179. 

  179. POSTHOOK: query: EXPLAIN SELECT count(1) FROM symlink_text_input_format
    180. 

  180. POSTHOOK: type: QUERY
    181. 

  181. ABSTRACT SYNTAX TREE:
    182. 

  182.   (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME symlink_text_input_format))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION count 1)))))
    183. 

  183. 

  184. STAGE DEPENDENCIES:
    185. 

  185.   Stage-1 is a root stage
    186. 

  186.   Stage-0 is a root stage
    187. 

  187. 

  188. STAGE PLANS:
    189. 

  189.   Stage: Stage-1
    190. 

  190.     Map Reduce
    191. 

  191.       Alias -> Map Operator Tree:
    192. 

  192.         symlink_text_input_format 
    193. 

  193.           TableScan
    194. 

  194.             alias: symlink_text_input_format
    195. 

  195.             Select Operator
    196. 

  196.               Group By Operator
    197. 

  197.                 aggregations:
    198. 

  198.                       expr: count(1)
    199. 

  199.                 bucketGroup: false
    200. 

  200.                 mode: hash
    201. 

  201.                 outputColumnNames: _col0
    202. 

  202.                 Reduce Output Operator
    203. 

  203.                   sort order: 
    204. 

  204.                   tag: -1
    205. 

  205.                   value expressions:
    206. 

  206.                         expr: _col0
    207. 

  207.                         type: bigint
    208. 

  208.       Reduce Operator Tree:
    209. 

  209.         Group By Operator
    210. 

  210.           aggregations:
    211. 

  211.                 expr: count(VALUE._col0)
    212. 

  212.           bucketGroup: false
    213. 

  213.           mode: mergepartial
    214. 

  214.           outputColumnNames: _col0
    215. 

  215.           Select Operator
    216. 

  216.             expressions:
    217. 

  217.                   expr: _col0
    218. 

  218.                   type: bigint
    219. 

  219.             outputColumnNames: _col0
    220. 

  220.             File Output Operator
    221. 

  221.               compressed: false
    222. 

  222.               GlobalTableId: 0
    223. 

  223.               table:
    224. 

  224.                   input format: org.apache.hadoop.mapred.TextInputFormat
    225. 

  225.                   output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    226. 

  226. 

  227.   Stage: Stage-0
    228. 

  228.     Fetch Operator
    229. 

  229.       limit: -1
    230. 

  230. 

  231. 

  232. PREHOOK: query: SELECT count(1) FROM symlink_text_input_format
    233. 

  233. PREHOOK: type: QUERY
    234. 

  234. PREHOOK: Input: default@symlink_text_input_format
    235. 

  235. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-24-17_064_8014152935662500610/-mr-10000
    236. 

  236. POSTHOOK: query: SELECT count(1) FROM symlink_text_input_format
    237. 

  237. POSTHOOK: type: QUERY
    238. 

  238. POSTHOOK: Input: default@symlink_text_input_format
    239. 

  239. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-24-17_064_8014152935662500610/-mr-10000
    240. 

  240. 16
    241. 

  241.