PageRenderTime 31ms CodeModel.GetById 9ms RepoModel.GetById 0ms app.codeStats 0ms

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

#
text | 107 lines | 101 code | 6 blank | 0 comment | 0 complexity | 9db44839513bba61a81c048cfcd5d043 MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0
  1. PREHOOK: query: create table dest32(a int)
  2. PREHOOK: type: CREATETABLE
  3. POSTHOOK: query: create table dest32(a int)
  4. POSTHOOK: type: CREATETABLE
  5. POSTHOOK: Output: default@dest32
  6. PREHOOK: query: create table tst_dest32(a int)
  7. PREHOOK: type: CREATETABLE
  8. POSTHOOK: query: create table tst_dest32(a int)
  9. POSTHOOK: type: CREATETABLE
  10. POSTHOOK: Output: default@tst_dest32
  11. PREHOOK: query: explain
  12. insert overwrite table dest32
  13. select count(1) from srcbucket
  14. PREHOOK: type: QUERY
  15. POSTHOOK: query: explain
  16. insert overwrite table dest32
  17. select count(1) from srcbucket
  18. POSTHOOK: type: QUERY
  19. ABSTRACT SYNTAX TREE:
  20. (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME srcbucket))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME dest32))) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION count 1)))))
  21. STAGE DEPENDENCIES:
  22. Stage-1 is a root stage
  23. Stage-0 depends on stages: Stage-1
  24. Stage-2 depends on stages: Stage-0
  25. STAGE PLANS:
  26. Stage: Stage-1
  27. Map Reduce
  28. Alias -> Map Operator Tree:
  29. srcbucket
  30. TableScan
  31. alias: srcbucket
  32. Select Operator
  33. Group By Operator
  34. aggregations:
  35. expr: count(1)
  36. bucketGroup: false
  37. mode: hash
  38. outputColumnNames: _col0
  39. Reduce Output Operator
  40. sort order:
  41. tag: -1
  42. value expressions:
  43. expr: _col0
  44. type: bigint
  45. Reduce Operator Tree:
  46. Group By Operator
  47. aggregations:
  48. expr: count(VALUE._col0)
  49. bucketGroup: false
  50. mode: mergepartial
  51. outputColumnNames: _col0
  52. Select Operator
  53. expressions:
  54. expr: _col0
  55. type: bigint
  56. outputColumnNames: _col0
  57. Select Operator
  58. expressions:
  59. expr: UDFToInteger(_col0)
  60. type: int
  61. outputColumnNames: _col0
  62. File Output Operator
  63. compressed: false
  64. GlobalTableId: 1
  65. table:
  66. input format: org.apache.hadoop.mapred.TextInputFormat
  67. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  68. serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
  69. name: default.tst_dest32
  70. Stage: Stage-0
  71. Move Operator
  72. tables:
  73. replace: true
  74. table:
  75. input format: org.apache.hadoop.mapred.TextInputFormat
  76. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  77. serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
  78. name: default.tst_dest32
  79. Stage: Stage-2
  80. Stats-Aggr Operator
  81. PREHOOK: query: insert overwrite table dest32
  82. select count(1) from srcbucket
  83. PREHOOK: type: QUERY
  84. PREHOOK: Input: default@srcbucket
  85. PREHOOK: Output: default@tst_dest32
  86. POSTHOOK: query: insert overwrite table dest32
  87. select count(1) from srcbucket
  88. POSTHOOK: type: QUERY
  89. POSTHOOK: Input: default@srcbucket
  90. POSTHOOK: Output: default@tst_dest32
  91. POSTHOOK: Lineage: tst_dest32.a EXPRESSION [(srcbucket)srcbucket.null, ]
  92. PREHOOK: query: select * from tst_dest32
  93. PREHOOK: type: QUERY
  94. PREHOOK: Input: default@tst_dest32
  95. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_15-55-25_816_8083027825061354059/-mr-10000
  96. POSTHOOK: query: select * from tst_dest32
  97. POSTHOOK: type: QUERY
  98. POSTHOOK: Input: default@tst_dest32
  99. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_15-55-25_816_8083027825061354059/-mr-10000
  100. POSTHOOK: Lineage: tst_dest32.a EXPRESSION [(srcbucket)srcbucket.null, ]
  101. 1000