PageRenderTime 22ms CodeModel.GetById 12ms app.highlight 4ms RepoModel.GetById 1ms app.codeStats 1ms

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

#
text | 120 lines | 111 code | 9 blank | 0 comment | 0 complexity | ef5dc6818e5901ce73fd7175ce417f9c MD5 | raw file
  1PREHOOK: query: CREATE TABLE dest1(key INT, value STRING, mapvalue STRING) STORED AS TEXTFILE
  2PREHOOK: type: CREATETABLE
  3POSTHOOK: query: CREATE TABLE dest1(key INT, value STRING, mapvalue STRING) STORED AS TEXTFILE
  4POSTHOOK: type: CREATETABLE
  5POSTHOOK: Output: default@dest1
  6PREHOOK: query: EXPLAIN
  7FROM src_thrift
  8INSERT OVERWRITE TABLE dest1 SELECT src_thrift.lint[1], src_thrift.lintstring[0].mystring, src_thrift.mstringstring['key_2']
  9PREHOOK: type: QUERY
 10POSTHOOK: query: EXPLAIN
 11FROM src_thrift
 12INSERT OVERWRITE TABLE dest1 SELECT src_thrift.lint[1], src_thrift.lintstring[0].mystring, src_thrift.mstringstring['key_2']
 13POSTHOOK: type: QUERY
 14ABSTRACT SYNTAX TREE:
 15  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src_thrift))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME dest1))) (TOK_SELECT (TOK_SELEXPR ([ (. (TOK_TABLE_OR_COL src_thrift) lint) 1)) (TOK_SELEXPR (. ([ (. (TOK_TABLE_OR_COL src_thrift) lintstring) 0) mystring)) (TOK_SELEXPR ([ (. (TOK_TABLE_OR_COL src_thrift) mstringstring) 'key_2')))))
 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_thrift 
 30          TableScan
 31            alias: src_thrift
 32            Select Operator
 33              expressions:
 34                    expr: lint[1]
 35                    type: int
 36                    expr: lintstring[0].mystring
 37                    type: string
 38                    expr: mstringstring['key_2']
 39                    type: string
 40              outputColumnNames: _col0, _col1, _col2
 41              File Output Operator
 42                compressed: false
 43                GlobalTableId: 1
 44                table:
 45                    input format: org.apache.hadoop.mapred.TextInputFormat
 46                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 47                    serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 48                    name: default.dest1
 49
 50  Stage: Stage-5
 51    Conditional Operator
 52
 53  Stage: Stage-4
 54    Move Operator
 55      files:
 56          hdfs directory: true
 57          destination: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-00-46_704_4766549513524517865/-ext-10000
 58
 59  Stage: Stage-0
 60    Move Operator
 61      tables:
 62          replace: true
 63          table:
 64              input format: org.apache.hadoop.mapred.TextInputFormat
 65              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 66              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 67              name: default.dest1
 68
 69  Stage: Stage-2
 70    Stats-Aggr Operator
 71
 72  Stage: Stage-3
 73    Map Reduce
 74      Alias -> Map Operator Tree:
 75        pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-00-46_704_4766549513524517865/-ext-10002 
 76            File Output Operator
 77              compressed: false
 78              GlobalTableId: 0
 79              table:
 80                  input format: org.apache.hadoop.mapred.TextInputFormat
 81                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 82                  serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 83                  name: default.dest1
 84
 85
 86PREHOOK: query: FROM src_thrift
 87INSERT OVERWRITE TABLE dest1 SELECT src_thrift.lint[1], src_thrift.lintstring[0].mystring, src_thrift.mstringstring['key_2']
 88PREHOOK: type: QUERY
 89PREHOOK: Input: default@src_thrift
 90PREHOOK: Output: default@dest1
 91POSTHOOK: query: FROM src_thrift
 92INSERT OVERWRITE TABLE dest1 SELECT src_thrift.lint[1], src_thrift.lintstring[0].mystring, src_thrift.mstringstring['key_2']
 93POSTHOOK: type: QUERY
 94POSTHOOK: Input: default@src_thrift
 95POSTHOOK: Output: default@dest1
 96POSTHOOK: Lineage: dest1.key EXPRESSION [(src_thrift)src_thrift.FieldSchema(name:lint, type:array<int>, comment:from deserializer), ]
 97POSTHOOK: Lineage: dest1.mapvalue EXPRESSION [(src_thrift)src_thrift.FieldSchema(name:mstringstring, type:map<string,string>, comment:from deserializer), ]
 98POSTHOOK: Lineage: dest1.value EXPRESSION [(src_thrift)src_thrift.FieldSchema(name:lintstring, type:array<org.apache.hadoop.hive.serde2.thrift.test.IntString>, comment:from deserializer), ]
 99PREHOOK: query: SELECT dest1.* FROM dest1
100PREHOOK: type: QUERY
101PREHOOK: Input: default@dest1
102PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-00-51_408_1129725040190996164/-mr-10000
103POSTHOOK: query: SELECT dest1.* FROM dest1
104POSTHOOK: type: QUERY
105POSTHOOK: Input: default@dest1
106POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-00-51_408_1129725040190996164/-mr-10000
107POSTHOOK: Lineage: dest1.key EXPRESSION [(src_thrift)src_thrift.FieldSchema(name:lint, type:array<int>, comment:from deserializer), ]
108POSTHOOK: Lineage: dest1.mapvalue EXPRESSION [(src_thrift)src_thrift.FieldSchema(name:mstringstring, type:map<string,string>, comment:from deserializer), ]
109POSTHOOK: Lineage: dest1.value EXPRESSION [(src_thrift)src_thrift.FieldSchema(name:lintstring, type:array<org.apache.hadoop.hive.serde2.thrift.test.IntString>, comment:from deserializer), ]
1100	0	NULL
1112	1	NULL
1124	8	value_2
1136	27	NULL
1148	64	NULL
11510	125	NULL
11612	216	NULL
11714	343	NULL
11816	512	NULL
11918	729	NULL
120NULL	NULL	NULL