PageRenderTime 41ms CodeModel.GetById 36ms app.highlight 2ms RepoModel.GetById 1ms app.codeStats 0ms

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

#
text | 204 lines | 195 code | 9 blank | 0 comment | 0 complexity | 3ca98150bf63e7d6a852917d0dfb9788 MD5 | raw file
  1PREHOOK: query: CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE
  2PREHOOK: type: CREATETABLE
  3POSTHOOK: query: CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE
  4POSTHOOK: type: CREATETABLE
  5POSTHOOK: Output: default@dest1
  6PREHOOK: query: EXPLAIN
  7FROM src
  8INSERT OVERWRITE TABLE dest1 SELECT src.key, src.value WHERE src.key < 100
  9PREHOOK: type: QUERY
 10POSTHOOK: query: EXPLAIN
 11FROM src
 12INSERT OVERWRITE TABLE dest1 SELECT src.key, src.value WHERE src.key < 100
 13POSTHOOK: type: QUERY
 14ABSTRACT SYNTAX TREE:
 15  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME dest1))) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL src) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL src) value))) (TOK_WHERE (< (. (TOK_TABLE_OR_COL src) key) 100))))
 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        src 
 30          TableScan
 31            alias: src
 32            Filter Operator
 33              predicate:
 34                  expr: (key < 100)
 35                  type: boolean
 36              Filter Operator
 37                predicate:
 38                    expr: (key < 100)
 39                    type: boolean
 40                Select Operator
 41                  expressions:
 42                        expr: key
 43                        type: string
 44                        expr: value
 45                        type: string
 46                  outputColumnNames: _col0, _col1
 47                  Select Operator
 48                    expressions:
 49                          expr: UDFToInteger(_col0)
 50                          type: int
 51                          expr: _col1
 52                          type: string
 53                    outputColumnNames: _col0, _col1
 54                    File Output Operator
 55                      compressed: false
 56                      GlobalTableId: 1
 57                      table:
 58                          input format: org.apache.hadoop.mapred.TextInputFormat
 59                          output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 60                          serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 61                          name: default.dest1
 62
 63  Stage: Stage-5
 64    Conditional Operator
 65
 66  Stage: Stage-4
 67    Move Operator
 68      files:
 69          hdfs directory: true
 70          destination: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_15-52-58_172_8568028770497058894/-ext-10000
 71
 72  Stage: Stage-0
 73    Move Operator
 74      tables:
 75          replace: true
 76          table:
 77              input format: org.apache.hadoop.mapred.TextInputFormat
 78              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 79              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 80              name: default.dest1
 81
 82  Stage: Stage-2
 83    Stats-Aggr Operator
 84
 85  Stage: Stage-3
 86    Map Reduce
 87      Alias -> Map Operator Tree:
 88        pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_15-52-58_172_8568028770497058894/-ext-10002 
 89            File Output Operator
 90              compressed: false
 91              GlobalTableId: 0
 92              table:
 93                  input format: org.apache.hadoop.mapred.TextInputFormat
 94                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 95                  serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 96                  name: default.dest1
 97
 98
 99PREHOOK: query: FROM src
100INSERT OVERWRITE TABLE dest1 SELECT src.key, src.value WHERE src.key < 100
101PREHOOK: type: QUERY
102PREHOOK: Input: default@src
103PREHOOK: Output: default@dest1
104POSTHOOK: query: FROM src
105INSERT OVERWRITE TABLE dest1 SELECT src.key, src.value WHERE src.key < 100
106POSTHOOK: type: QUERY
107POSTHOOK: Input: default@src
108POSTHOOK: Output: default@dest1
109POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
110POSTHOOK: Lineage: dest1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
111PREHOOK: query: SELECT dest1.* FROM dest1
112PREHOOK: type: QUERY
113PREHOOK: Input: default@dest1
114PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_15-53-02_873_6071119767222393784/-mr-10000
115POSTHOOK: query: SELECT dest1.* FROM dest1
116POSTHOOK: type: QUERY
117POSTHOOK: Input: default@dest1
118POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_15-53-02_873_6071119767222393784/-mr-10000
119POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
120POSTHOOK: Lineage: dest1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
12186	val_86
12227	val_27
12398	val_98
12466	val_66
12537	val_37
12615	val_15
12782	val_82
12817	val_17
1290	val_0
13057	val_57
13120	val_20
13292	val_92
13347	val_47
13472	val_72
1354	val_4
13635	val_35
13754	val_54
13851	val_51
13965	val_65
14083	val_83
14112	val_12
14267	val_67
14384	val_84
14458	val_58
1458	val_8
14624	val_24
14742	val_42
1480	val_0
14996	val_96
15026	val_26
15151	val_51
15243	val_43
15395	val_95
15498	val_98
15585	val_85
15677	val_77
1570	val_0
15887	val_87
15915	val_15
16072	val_72
16190	val_90
16219	val_19
16310	val_10
1645	val_5
16558	val_58
16635	val_35
16795	val_95
16811	val_11
16934	val_34
17042	val_42
17178	val_78
17276	val_76
17341	val_41
17430	val_30
17564	val_64
17676	val_76
17774	val_74
17869	val_69
17933	val_33
18070	val_70
1815	val_5
1822	val_2
18335	val_35
18480	val_80
18544	val_44
18653	val_53
18790	val_90
18812	val_12
1895	val_5
19070	val_70
19124	val_24
19270	val_70
19383	val_83
19426	val_26
19567	val_67
19618	val_18
1979	val_9
19818	val_18
19997	val_97
20084	val_84
20128	val_28
20237	val_37
20390	val_90
20497	val_97