PageRenderTime 30ms CodeModel.GetById 18ms app.highlight 8ms RepoModel.GetById 1ms app.codeStats 0ms

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

#
text | 189 lines | 183 code | 6 blank | 0 comment | 0 complexity | be4ef3b5c655169c46b93b15f6a206a8 MD5 | raw file
  1PREHOOK: query: create table t1(key string, value string) partitioned by (ds string)
  2PREHOOK: type: CREATETABLE
  3POSTHOOK: query: create table t1(key string, value string) partitioned by (ds string)
  4POSTHOOK: type: CREATETABLE
  5POSTHOOK: Output: default@t1
  6PREHOOK: query: create table t2(key string, value string) partitioned by (ds string)
  7PREHOOK: type: CREATETABLE
  8POSTHOOK: query: create table t2(key string, value string) partitioned by (ds string)
  9POSTHOOK: type: CREATETABLE
 10POSTHOOK: Output: default@t2
 11PREHOOK: query: insert overwrite table t1 partition (ds='1')
 12select key, value from src
 13PREHOOK: type: QUERY
 14PREHOOK: Input: default@src
 15PREHOOK: Output: default@t1@ds=1
 16POSTHOOK: query: insert overwrite table t1 partition (ds='1')
 17select key, value from src
 18POSTHOOK: type: QUERY
 19POSTHOOK: Input: default@src
 20POSTHOOK: Output: default@t1@ds=1
 21POSTHOOK: Lineage: t1 PARTITION(ds=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 22POSTHOOK: Lineage: t1 PARTITION(ds=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 23PREHOOK: query: insert overwrite table t1 partition (ds='2')
 24select key, value from src
 25PREHOOK: type: QUERY
 26PREHOOK: Input: default@src
 27PREHOOK: Output: default@t1@ds=2
 28POSTHOOK: query: insert overwrite table t1 partition (ds='2')
 29select key, value from src
 30POSTHOOK: type: QUERY
 31POSTHOOK: Input: default@src
 32POSTHOOK: Output: default@t1@ds=2
 33POSTHOOK: Lineage: t1 PARTITION(ds=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 34POSTHOOK: Lineage: t1 PARTITION(ds=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 35POSTHOOK: Lineage: t1 PARTITION(ds=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 36POSTHOOK: Lineage: t1 PARTITION(ds=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 37PREHOOK: query: insert overwrite table t2 partition (ds='1')
 38select key, value from src
 39PREHOOK: type: QUERY
 40PREHOOK: Input: default@src
 41PREHOOK: Output: default@t2@ds=1
 42POSTHOOK: query: insert overwrite table t2 partition (ds='1')
 43select key, value from src
 44POSTHOOK: type: QUERY
 45POSTHOOK: Input: default@src
 46POSTHOOK: Output: default@t2@ds=1
 47POSTHOOK: Lineage: t1 PARTITION(ds=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 48POSTHOOK: Lineage: t1 PARTITION(ds=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 49POSTHOOK: Lineage: t1 PARTITION(ds=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 50POSTHOOK: Lineage: t1 PARTITION(ds=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 51POSTHOOK: Lineage: t2 PARTITION(ds=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 52POSTHOOK: Lineage: t2 PARTITION(ds=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 53PREHOOK: query: explain
 54select count(1) from t1 join t2 on t1.key=t2.key where t1.ds='1' and t2.ds='1'
 55PREHOOK: type: QUERY
 56POSTHOOK: query: explain
 57select count(1) from t1 join t2 on t1.key=t2.key where t1.ds='1' and t2.ds='1'
 58POSTHOOK: type: QUERY
 59POSTHOOK: Lineage: t1 PARTITION(ds=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 60POSTHOOK: Lineage: t1 PARTITION(ds=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 61POSTHOOK: Lineage: t1 PARTITION(ds=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 62POSTHOOK: Lineage: t1 PARTITION(ds=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 63POSTHOOK: Lineage: t2 PARTITION(ds=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 64POSTHOOK: Lineage: t2 PARTITION(ds=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 65ABSTRACT SYNTAX TREE:
 66  (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_TABREF (TOK_TABNAME t1)) (TOK_TABREF (TOK_TABNAME t2)) (= (. (TOK_TABLE_OR_COL t1) key) (. (TOK_TABLE_OR_COL t2) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION count 1))) (TOK_WHERE (and (= (. (TOK_TABLE_OR_COL t1) ds) '1') (= (. (TOK_TABLE_OR_COL t2) ds) '1')))))
 67
 68STAGE DEPENDENCIES:
 69  Stage-1 is a root stage
 70  Stage-2 depends on stages: Stage-1
 71  Stage-0 is a root stage
 72
 73STAGE PLANS:
 74  Stage: Stage-1
 75    Map Reduce
 76      Alias -> Map Operator Tree:
 77        t1 
 78          TableScan
 79            alias: t1
 80            Filter Operator
 81              predicate:
 82                  expr: (((hash(rand(460476415)) & 2147483647) % 32) = 0)
 83                  type: boolean
 84              Reduce Output Operator
 85                key expressions:
 86                      expr: key
 87                      type: string
 88                sort order: +
 89                Map-reduce partition columns:
 90                      expr: key
 91                      type: string
 92                tag: 0
 93                value expressions:
 94                      expr: ds
 95                      type: string
 96        t2 
 97          TableScan
 98            alias: t2
 99            Filter Operator
100              predicate:
101                  expr: (((hash(rand(460476415)) & 2147483647) % 32) = 0)
102                  type: boolean
103              Reduce Output Operator
104                key expressions:
105                      expr: key
106                      type: string
107                sort order: +
108                Map-reduce partition columns:
109                      expr: key
110                      type: string
111                tag: 1
112                value expressions:
113                      expr: ds
114                      type: string
115      Reduce Operator Tree:
116        Join Operator
117          condition map:
118               Inner Join 0 to 1
119          condition expressions:
120            0 {VALUE._col2}
121            1 {VALUE._col2}
122          handleSkewJoin: false
123          outputColumnNames: _col2, _col7
124          Select Operator
125            Group By Operator
126              aggregations:
127                    expr: count(1)
128              bucketGroup: false
129              mode: hash
130              outputColumnNames: _col0
131              File Output Operator
132                compressed: false
133                GlobalTableId: 0
134                table:
135                    input format: org.apache.hadoop.mapred.SequenceFileInputFormat
136                    output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
137
138  Stage: Stage-2
139    Map Reduce
140      Alias -> Map Operator Tree:
141        file:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_15-56-17_686_3261350439842445445/-mr-10002 
142            Reduce Output Operator
143              sort order: 
144              tag: -1
145              value expressions:
146                    expr: _col0
147                    type: bigint
148      Reduce Operator Tree:
149        Group By Operator
150          aggregations:
151                expr: count(VALUE._col0)
152          bucketGroup: false
153          mode: mergepartial
154          outputColumnNames: _col0
155          Select Operator
156            expressions:
157                  expr: _col0
158                  type: bigint
159            outputColumnNames: _col0
160            File Output Operator
161              compressed: false
162              GlobalTableId: 0
163              table:
164                  input format: org.apache.hadoop.mapred.TextInputFormat
165                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
166
167  Stage: Stage-0
168    Fetch Operator
169      limit: -1
170
171
172PREHOOK: query: select count(1) from t1 join t2 on t1.key=t2.key where t1.ds='1' and t2.ds='1'
173PREHOOK: type: QUERY
174PREHOOK: Input: default@t1@ds=1
175PREHOOK: Input: default@t2@ds=1
176PREHOOK: Output: file:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_15-56-17_843_8594138521492763524/-mr-10000
177POSTHOOK: query: select count(1) from t1 join t2 on t1.key=t2.key where t1.ds='1' and t2.ds='1'
178POSTHOOK: type: QUERY
179POSTHOOK: Input: default@t1@ds=1
180POSTHOOK: Input: default@t2@ds=1
181POSTHOOK: Output: file:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_15-56-17_843_8594138521492763524/-mr-10000
182POSTHOOK: Lineage: t1 PARTITION(ds=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
183POSTHOOK: Lineage: t1 PARTITION(ds=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
184POSTHOOK: Lineage: t1 PARTITION(ds=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
185POSTHOOK: Lineage: t1 PARTITION(ds=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
186POSTHOOK: Lineage: t2 PARTITION(ds=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
187POSTHOOK: Lineage: t2 PARTITION(ds=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
18818
189mapred.job.tracker=does.notexist.com:666