PageRenderTime 28ms CodeModel.GetById 5ms RepoModel.GetById 0ms app.codeStats 0ms

/tags/release-0.0.0-rc0/hive/external/ql/src/test/results/clientpositive/input22.q.out

#
text | 94 lines | 89 code | 5 blank | 0 comment | 0 complexity | e0c30c90674f426a244eb31407d9a34f MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0
  1. PREHOOK: query: CREATE TABLE INPUT4(KEY STRING, VALUE STRING) STORED AS TEXTFILE
  2. PREHOOK: type: CREATETABLE
  3. POSTHOOK: query: CREATE TABLE INPUT4(KEY STRING, VALUE STRING) STORED AS TEXTFILE
  4. POSTHOOK: type: CREATETABLE
  5. POSTHOOK: Output: default@INPUT4
  6. PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE INPUT4
  7. PREHOOK: type: LOAD
  8. POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE INPUT4
  9. POSTHOOK: type: LOAD
  10. POSTHOOK: Output: default@input4
  11. PREHOOK: query: EXPLAIN
  12. SELECT a.KEY2
  13. FROM (SELECT INPUT4.*, INPUT4.KEY as KEY2
  14. FROM INPUT4) a
  15. ORDER BY KEY2 LIMIT 10
  16. PREHOOK: type: QUERY
  17. POSTHOOK: query: EXPLAIN
  18. SELECT a.KEY2
  19. FROM (SELECT INPUT4.*, INPUT4.KEY as KEY2
  20. FROM INPUT4) a
  21. ORDER BY KEY2 LIMIT 10
  22. POSTHOOK: type: QUERY
  23. ABSTRACT SYNTAX TREE:
  24. (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME INPUT4))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF (TOK_TABNAME INPUT4))) (TOK_SELEXPR (. (TOK_TABLE_OR_COL INPUT4) KEY) KEY2)))) a)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL a) KEY2))) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL KEY2))) (TOK_LIMIT 10)))
  25. STAGE DEPENDENCIES:
  26. Stage-1 is a root stage
  27. Stage-0 is a root stage
  28. STAGE PLANS:
  29. Stage: Stage-1
  30. Map Reduce
  31. Alias -> Map Operator Tree:
  32. a:input4
  33. TableScan
  34. alias: input4
  35. Select Operator
  36. expressions:
  37. expr: key
  38. type: string
  39. outputColumnNames: _col2
  40. Select Operator
  41. expressions:
  42. expr: _col2
  43. type: string
  44. outputColumnNames: _col0
  45. Reduce Output Operator
  46. key expressions:
  47. expr: _col0
  48. type: string
  49. sort order: +
  50. tag: -1
  51. value expressions:
  52. expr: _col0
  53. type: string
  54. Reduce Operator Tree:
  55. Extract
  56. Limit
  57. File Output Operator
  58. compressed: false
  59. GlobalTableId: 0
  60. table:
  61. input format: org.apache.hadoop.mapred.TextInputFormat
  62. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  63. Stage: Stage-0
  64. Fetch Operator
  65. limit: 10
  66. PREHOOK: query: SELECT a.KEY2
  67. FROM (SELECT INPUT4.*, INPUT4.KEY as KEY2
  68. FROM INPUT4) a
  69. ORDER BY KEY2 LIMIT 10
  70. PREHOOK: type: QUERY
  71. PREHOOK: Input: default@input4
  72. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_15-54-24_674_3065567534327682962/-mr-10000
  73. POSTHOOK: query: SELECT a.KEY2
  74. FROM (SELECT INPUT4.*, INPUT4.KEY as KEY2
  75. FROM INPUT4) a
  76. ORDER BY KEY2 LIMIT 10
  77. POSTHOOK: type: QUERY
  78. POSTHOOK: Input: default@input4
  79. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_15-54-24_674_3065567534327682962/-mr-10000
  80. 0
  81. 0
  82. 0
  83. 10
  84. 100
  85. 100
  86. 103
  87. 103
  88. 104
  89. 104