PageRenderTime 21ms CodeModel.GetById 15ms app.highlight 3ms RepoModel.GetById 1ms app.codeStats 0ms

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

#
text | 127 lines | 118 code | 9 blank | 0 comment | 0 complexity | 4ad5d3623bbf0c1b892f630b767d4124 MD5 | raw file
  1PREHOOK: query: CREATE TABLE dest1(lint_size INT, lintstring_size INT, mstringstring_size INT) STORED AS TEXTFILE
  2PREHOOK: type: CREATETABLE
  3POSTHOOK: query: CREATE TABLE dest1(lint_size INT, lintstring_size INT, mstringstring_size INT) STORED AS TEXTFILE
  4POSTHOOK: type: CREATETABLE
  5POSTHOOK: Output: default@dest1
  6PREHOOK: query: EXPLAIN
  7FROM src_thrift
  8INSERT OVERWRITE TABLE dest1 SELECT size(src_thrift.lint), size(src_thrift.lintstring), size(src_thrift.mstringstring) where src_thrift.lint IS NOT NULL AND NOT (src_thrift.mstringstring IS NULL)
  9PREHOOK: type: QUERY
 10POSTHOOK: query: EXPLAIN
 11FROM src_thrift
 12INSERT OVERWRITE TABLE dest1 SELECT size(src_thrift.lint), size(src_thrift.lintstring), size(src_thrift.mstringstring) where src_thrift.lint IS NOT NULL AND NOT (src_thrift.mstringstring IS NULL)
 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_FUNCTION size (. (TOK_TABLE_OR_COL src_thrift) lint))) (TOK_SELEXPR (TOK_FUNCTION size (. (TOK_TABLE_OR_COL src_thrift) lintstring))) (TOK_SELEXPR (TOK_FUNCTION size (. (TOK_TABLE_OR_COL src_thrift) mstringstring)))) (TOK_WHERE (AND (TOK_FUNCTION TOK_ISNOTNULL (. (TOK_TABLE_OR_COL src_thrift) lint)) (NOT (TOK_FUNCTION TOK_ISNULL (. (TOK_TABLE_OR_COL src_thrift) mstringstring)))))))
 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            Filter Operator
 33              predicate:
 34                  expr: (lint is not null and (not mstringstring is null))
 35                  type: boolean
 36              Filter Operator
 37                predicate:
 38                    expr: (lint is not null and (not mstringstring is null))
 39                    type: boolean
 40                Select Operator
 41                  expressions:
 42                        expr: size(lint)
 43                        type: int
 44                        expr: size(lintstring)
 45                        type: int
 46                        expr: size(mstringstring)
 47                        type: int
 48                  outputColumnNames: _col0, _col1, _col2
 49                  File Output Operator
 50                    compressed: false
 51                    GlobalTableId: 1
 52                    table:
 53                        input format: org.apache.hadoop.mapred.TextInputFormat
 54                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 55                        serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 56                        name: default.dest1
 57
 58  Stage: Stage-5
 59    Conditional Operator
 60
 61  Stage: Stage-4
 62    Move Operator
 63      files:
 64          hdfs directory: true
 65          destination: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-00-52_022_1356599412846277755/-ext-10000
 66
 67  Stage: Stage-0
 68    Move Operator
 69      tables:
 70          replace: true
 71          table:
 72              input format: org.apache.hadoop.mapred.TextInputFormat
 73              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 74              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 75              name: default.dest1
 76
 77  Stage: Stage-2
 78    Stats-Aggr Operator
 79
 80  Stage: Stage-3
 81    Map Reduce
 82      Alias -> Map Operator Tree:
 83        pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-00-52_022_1356599412846277755/-ext-10002 
 84            File Output Operator
 85              compressed: false
 86              GlobalTableId: 0
 87              table:
 88                  input format: org.apache.hadoop.mapred.TextInputFormat
 89                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 90                  serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 91                  name: default.dest1
 92
 93
 94PREHOOK: query: FROM src_thrift
 95INSERT OVERWRITE TABLE dest1 SELECT size(src_thrift.lint), size(src_thrift.lintstring), size(src_thrift.mstringstring) where src_thrift.lint IS NOT NULL AND NOT (src_thrift.mstringstring IS NULL)
 96PREHOOK: type: QUERY
 97PREHOOK: Input: default@src_thrift
 98PREHOOK: Output: default@dest1
 99POSTHOOK: query: FROM src_thrift
100INSERT OVERWRITE TABLE dest1 SELECT size(src_thrift.lint), size(src_thrift.lintstring), size(src_thrift.mstringstring) where src_thrift.lint IS NOT NULL AND NOT (src_thrift.mstringstring IS NULL)
101POSTHOOK: type: QUERY
102POSTHOOK: Input: default@src_thrift
103POSTHOOK: Output: default@dest1
104POSTHOOK: Lineage: dest1.lint_size EXPRESSION [(src_thrift)src_thrift.FieldSchema(name:lint, type:array<int>, comment:from deserializer), ]
105POSTHOOK: Lineage: dest1.lintstring_size EXPRESSION [(src_thrift)src_thrift.FieldSchema(name:lintstring, type:array<org.apache.hadoop.hive.serde2.thrift.test.IntString>, comment:from deserializer), ]
106POSTHOOK: Lineage: dest1.mstringstring_size EXPRESSION [(src_thrift)src_thrift.FieldSchema(name:mstringstring, type:map<string,string>, comment:from deserializer), ]
107PREHOOK: query: SELECT dest1.* FROM dest1
108PREHOOK: type: QUERY
109PREHOOK: Input: default@dest1
110PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-00-56_761_7597331630264632053/-mr-10000
111POSTHOOK: query: SELECT dest1.* FROM dest1
112POSTHOOK: type: QUERY
113POSTHOOK: Input: default@dest1
114POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-00-56_761_7597331630264632053/-mr-10000
115POSTHOOK: Lineage: dest1.lint_size EXPRESSION [(src_thrift)src_thrift.FieldSchema(name:lint, type:array<int>, comment:from deserializer), ]
116POSTHOOK: Lineage: dest1.lintstring_size EXPRESSION [(src_thrift)src_thrift.FieldSchema(name:lintstring, type:array<org.apache.hadoop.hive.serde2.thrift.test.IntString>, comment:from deserializer), ]
117POSTHOOK: Lineage: dest1.mstringstring_size EXPRESSION [(src_thrift)src_thrift.FieldSchema(name:mstringstring, type:map<string,string>, comment:from deserializer), ]
1183	1	1
1193	1	1
1203	1	1
1213	1	1
1223	1	1
1233	1	1
1243	1	1
1253	1	1
1263	1	1
1273	1	1