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