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

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

#
text | 143 lines | 134 code | 9 blank | 0 comment | 0 complexity | 27923fe7c46ecbbfce4a19ed996938c6 MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0
  1. PREHOOK: query: CREATE TABLE dest1(c1 STRING, c2 INT, c3 DOUBLE) STORED AS TEXTFILE
  2. PREHOOK: type: CREATETABLE
  3. POSTHOOK: query: CREATE TABLE dest1(c1 STRING, c2 INT, c3 DOUBLE) STORED AS TEXTFILE
  4. POSTHOOK: type: CREATETABLE
  5. POSTHOOK: Output: default@dest1
  6. PREHOOK: query: EXPLAIN
  7. FROM src1
  8. INSERT OVERWRITE TABLE dest1 SELECT 4 + NULL, src1.key - NULL, NULL + NULL
  9. PREHOOK: type: QUERY
  10. POSTHOOK: query: EXPLAIN
  11. FROM src1
  12. INSERT OVERWRITE TABLE dest1 SELECT 4 + NULL, src1.key - NULL, NULL + NULL
  13. POSTHOOK: type: QUERY
  14. ABSTRACT SYNTAX TREE:
  15. (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src1))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME dest1))) (TOK_SELECT (TOK_SELEXPR (+ 4 TOK_NULL)) (TOK_SELEXPR (- (. (TOK_TABLE_OR_COL src1) key) TOK_NULL)) (TOK_SELEXPR (+ TOK_NULL TOK_NULL)))))
  16. STAGE DEPENDENCIES:
  17. Stage-1 is a root stage
  18. Stage-5 depends on stages: Stage-1 , consists of Stage-4, Stage-3
  19. Stage-4
  20. Stage-0 depends on stages: Stage-4, Stage-3
  21. Stage-2 depends on stages: Stage-0
  22. Stage-3
  23. STAGE PLANS:
  24. Stage: Stage-1
  25. Map Reduce
  26. Alias -> Map Operator Tree:
  27. src1
  28. TableScan
  29. alias: src1
  30. Select Operator
  31. expressions:
  32. expr: (4 + null)
  33. type: int
  34. expr: (key - null)
  35. type: double
  36. expr: (null + null)
  37. type: tinyint
  38. outputColumnNames: _col0, _col1, _col2
  39. Select Operator
  40. expressions:
  41. expr: _col0
  42. type: int
  43. expr: UDFToInteger(_col1)
  44. type: int
  45. expr: UDFToDouble(_col2)
  46. type: double
  47. outputColumnNames: _col0, _col1, _col2
  48. File Output Operator
  49. compressed: false
  50. GlobalTableId: 1
  51. table:
  52. input format: org.apache.hadoop.mapred.TextInputFormat
  53. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  54. serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
  55. name: default.dest1
  56. Stage: Stage-5
  57. Conditional Operator
  58. Stage: Stage-4
  59. Move Operator
  60. files:
  61. hdfs directory: true
  62. destination: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_15-58-29_945_2393196627067798243/-ext-10000
  63. Stage: Stage-0
  64. Move Operator
  65. tables:
  66. replace: true
  67. table:
  68. input format: org.apache.hadoop.mapred.TextInputFormat
  69. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  70. serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
  71. name: default.dest1
  72. Stage: Stage-2
  73. Stats-Aggr Operator
  74. Stage: Stage-3
  75. Map Reduce
  76. Alias -> Map Operator Tree:
  77. pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_15-58-29_945_2393196627067798243/-ext-10002
  78. File Output Operator
  79. compressed: false
  80. GlobalTableId: 0
  81. table:
  82. input format: org.apache.hadoop.mapred.TextInputFormat
  83. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  84. serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
  85. name: default.dest1
  86. PREHOOK: query: FROM src1
  87. INSERT OVERWRITE TABLE dest1 SELECT 4 + NULL, src1.key - NULL, NULL + NULL
  88. PREHOOK: type: QUERY
  89. PREHOOK: Input: default@src1
  90. PREHOOK: Output: default@dest1
  91. POSTHOOK: query: FROM src1
  92. INSERT OVERWRITE TABLE dest1 SELECT 4 + NULL, src1.key - NULL, NULL + NULL
  93. POSTHOOK: type: QUERY
  94. POSTHOOK: Input: default@src1
  95. POSTHOOK: Output: default@dest1
  96. POSTHOOK: Lineage: dest1.c1 EXPRESSION []
  97. POSTHOOK: Lineage: dest1.c2 EXPRESSION [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
  98. POSTHOOK: Lineage: dest1.c3 EXPRESSION []
  99. PREHOOK: query: SELECT dest1.* FROM dest1
  100. PREHOOK: type: QUERY
  101. PREHOOK: Input: default@dest1
  102. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_15-58-34_679_4447149587092293479/-mr-10000
  103. POSTHOOK: query: SELECT dest1.* FROM dest1
  104. POSTHOOK: type: QUERY
  105. POSTHOOK: Input: default@dest1
  106. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_15-58-34_679_4447149587092293479/-mr-10000
  107. POSTHOOK: Lineage: dest1.c1 EXPRESSION []
  108. POSTHOOK: Lineage: dest1.c2 EXPRESSION [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
  109. POSTHOOK: Lineage: dest1.c3 EXPRESSION []
  110. NULL NULL NULL
  111. NULL NULL NULL
  112. NULL NULL NULL
  113. NULL NULL NULL
  114. NULL NULL NULL
  115. NULL NULL NULL
  116. NULL NULL NULL
  117. NULL NULL NULL
  118. NULL NULL NULL
  119. NULL NULL NULL
  120. NULL NULL NULL
  121. NULL NULL NULL
  122. NULL NULL NULL
  123. NULL NULL NULL
  124. NULL NULL NULL
  125. NULL NULL NULL
  126. NULL NULL NULL
  127. NULL NULL NULL
  128. NULL NULL NULL
  129. NULL NULL NULL
  130. NULL NULL NULL
  131. NULL NULL NULL
  132. NULL NULL NULL
  133. NULL NULL NULL
  134. NULL NULL NULL