PageRenderTime 20ms CodeModel.GetById 15ms app.highlight 2ms RepoModel.GetById 1ms 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
  1PREHOOK: query: create table dest32(a int)
  2PREHOOK: type: CREATETABLE
  3POSTHOOK: query: create table dest32(a int)
  4POSTHOOK: type: CREATETABLE
  5POSTHOOK: Output: default@dest32
  6PREHOOK: query: create table tst_dest32(a int)
  7PREHOOK: type: CREATETABLE
  8POSTHOOK: query: create table tst_dest32(a int)
  9POSTHOOK: type: CREATETABLE
 10POSTHOOK: Output: default@tst_dest32
 11PREHOOK: query: explain 
 12insert overwrite table dest32
 13select count(1) from srcbucket
 14PREHOOK: type: QUERY
 15POSTHOOK: query: explain 
 16insert overwrite table dest32
 17select count(1) from srcbucket
 18POSTHOOK: type: QUERY
 19ABSTRACT 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
 22STAGE DEPENDENCIES:
 23  Stage-1 is a root stage
 24  Stage-0 depends on stages: Stage-1
 25  Stage-2 depends on stages: Stage-0
 26
 27STAGE PLANS:
 28  Stage: Stage-1
 29    Map Reduce
 30      Alias -> Map Operator Tree:
 31        srcbucket 
 32          TableScan
 33            alias: srcbucket
 34            Select Operator
 35              Group By Operator
 36                aggregations:
 37                      expr: count(1)
 38                bucketGroup: false
 39                mode: hash
 40                outputColumnNames: _col0
 41                Reduce Output Operator
 42                  sort order: 
 43                  tag: -1
 44                  value expressions:
 45                        expr: _col0
 46                        type: bigint
 47      Reduce Operator Tree:
 48        Group By Operator
 49          aggregations:
 50                expr: count(VALUE._col0)
 51          bucketGroup: false
 52          mode: mergepartial
 53          outputColumnNames: _col0
 54          Select Operator
 55            expressions:
 56                  expr: _col0
 57                  type: bigint
 58            outputColumnNames: _col0
 59            Select Operator
 60              expressions:
 61                    expr: UDFToInteger(_col0)
 62                    type: int
 63              outputColumnNames: _col0
 64              File Output Operator
 65                compressed: false
 66                GlobalTableId: 1
 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.tst_dest32
 72
 73  Stage: Stage-0
 74    Move Operator
 75      tables:
 76          replace: true
 77          table:
 78              input format: org.apache.hadoop.mapred.TextInputFormat
 79              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 80              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 81              name: default.tst_dest32
 82
 83  Stage: Stage-2
 84    Stats-Aggr Operator
 85
 86
 87PREHOOK: query: insert overwrite table dest32
 88select count(1) from srcbucket
 89PREHOOK: type: QUERY
 90PREHOOK: Input: default@srcbucket
 91PREHOOK: Output: default@tst_dest32
 92POSTHOOK: query: insert overwrite table dest32
 93select count(1) from srcbucket
 94POSTHOOK: type: QUERY
 95POSTHOOK: Input: default@srcbucket
 96POSTHOOK: Output: default@tst_dest32
 97POSTHOOK: Lineage: tst_dest32.a EXPRESSION [(srcbucket)srcbucket.null, ]
 98PREHOOK: query: select * from tst_dest32
 99PREHOOK: type: QUERY
100PREHOOK: Input: default@tst_dest32
101PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_15-55-25_816_8083027825061354059/-mr-10000
102POSTHOOK: query: select * from tst_dest32
103POSTHOOK: type: QUERY
104POSTHOOK: Input: default@tst_dest32
105POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_15-55-25_816_8083027825061354059/-mr-10000
106POSTHOOK: Lineage: tst_dest32.a EXPRESSION [(srcbucket)srcbucket.null, ]
1071000