diff --git a/ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java b/ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java index 88fd0fc..fd3bde6 100644 --- a/ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java +++ b/ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java @@ -6977,6 +6977,8 @@ private Operator genReduceSinkPlanForSortingBucketing(Table tab, Operator input, private Operator genReduceSinkPlan(String dest, QB qb, Operator input, int numReducers) throws SemanticException { + Operator dummy = Operator.createDummy(); + dummy.setParentOperators(Arrays.asList(input)); RowResolver inputRR = opParseCtx.get(input).getRowResolver(); // First generate the expression for the partition and sort keys @@ -6987,11 +6989,14 @@ private Operator genReduceSinkPlan(String dest, QB qb, Operator input, partitionExprs = qb.getParseInfo().getDistributeByForClause(dest); } ArrayList partitionCols = new ArrayList(); + ArrayList partitionColsBack = new ArrayList(); if (partitionExprs != null) { int ccount = partitionExprs.getChildCount(); for (int i = 0; i < ccount; ++i) { ASTNode cl = (ASTNode) partitionExprs.getChild(i); - partitionCols.add(genExprNodeDesc(cl, inputRR)); + ExprNodeDesc exprNode = genExprNodeDesc(cl, inputRR); + partitionCols.add(exprNode); + partitionColsBack.add(ExprNodeDescUtils.backtrack(exprNode, dummy, input)); } } @@ -7014,8 +7019,6 @@ private Operator genReduceSinkPlan(String dest, QB qb, Operator input, } } } - Operator dummy = Operator.createDummy(); - dummy.setParentOperators(Arrays.asList(input)); ArrayList sortCols = new ArrayList(); ArrayList sortColsBack = new ArrayList(); @@ -7073,10 +7076,14 @@ private Operator genReduceSinkPlan(String dest, QB qb, Operator input, } continue; } - int vindex = valueBack == null ? -1 : ExprNodeDescUtils.indexOf(valueBack, valueColsBack); - if (vindex >= 0) { - index[i] = -vindex - 1; - continue; + + // Make Parition cols to persists in final list. + if (valueBack == null || ExprNodeDescUtils.indexOf(valueBack, partitionColsBack) < 0) { + int vindex = valueBack == null ? -1 : ExprNodeDescUtils.indexOf(valueBack, valueColsBack); + if (vindex >= 0) { + index[i] = -vindex - 1; + continue; + } } index[i] = -valueCols.size() - 1; String outputColName = getColumnInternalName(valueCols.size()); diff --git a/ql/src/test/queries/clientpositive/load_dyn_parts_with_distribute_by.q b/ql/src/test/queries/clientpositive/load_dyn_parts_with_distribute_by.q new file mode 100644 index 0000000..94f8ad7 --- /dev/null +++ b/ql/src/test/queries/clientpositive/load_dyn_parts_with_distribute_by.q @@ -0,0 +1,61 @@ +-- SORT_QUERY_RESULTS + +show partitions srcpart; + + +-- Creating and populating the source table. +create table if not exists source_hive_602_table like srcpart; +describe extended source_hive_602_table; + +from srcpart +insert overwrite table source_hive_602_table partition(ds='2008-12-31', hr= '11') select key, value where ds > '2008-04-08' and hr = '11'; + + +-- Creating the destination table. +create table if not exists destination_hive_602_table(bar1 string, bar2 string, bar3 string) partitioned by(ds string); +describe extended destination_hive_602_table; + + +set hive.exec.dynamic.partition=true; +set hive.exec.dynamic.partition.mode=nonstrict; + +-- Distribute By +explain +from source_hive_602_table +insert overwrite table destination_hive_602_table partition(ds) select value as value1, value as value2, value as value3, ds distribute by value3; + +from source_hive_602_table +insert overwrite table destination_hive_602_table partition(ds) select value as value1, value as value2, value as value3, ds distribute by value3; + +show partitions destination_hive_602_table; +select * from destination_hive_602_table; + +explain +from source_hive_602_table +insert overwrite table destination_hive_602_table partition(ds) select value as value1, value as value2, value as value3, ds cluster by value3; + +from source_hive_602_table +insert overwrite table destination_hive_602_table partition(ds) select value as value1, value as value2, value as value3, ds cluster by value3; + +show partitions destination_hive_602_table; +select * from destination_hive_602_table; + +explain +from source_hive_602_table +insert overwrite table destination_hive_602_table partition(ds) select value as value1, value as value2, value as value3, ds order by value3; + +from source_hive_602_table +insert overwrite table destination_hive_602_table partition(ds) select value as value1, value as value2, value as value3, ds order by value3; + +show partitions destination_hive_602_table; +select * from destination_hive_602_table; + +explain +from source_hive_602_table +insert overwrite table destination_hive_602_table partition(ds) select value as value1, value as value2, value as value3, ds sort by value3; + +from source_hive_602_table +insert overwrite table destination_hive_602_table partition(ds) select value as value1, value as value2, value as value3, ds sort by value3; + +show partitions destination_hive_602_table; +select * from destination_hive_602_table; diff --git a/ql/src/test/results/clientpositive/load_dyn_parts_with_distribute_by.q.out b/ql/src/test/results/clientpositive/load_dyn_parts_with_distribute_by.q.out new file mode 100644 index 0000000..34e63ac --- /dev/null +++ b/ql/src/test/results/clientpositive/load_dyn_parts_with_distribute_by.q.out @@ -0,0 +1,2528 @@ +PREHOOK: query: -- SORT_QUERY_RESULTS + +show partitions srcpart +PREHOOK: type: SHOWPARTITIONS +PREHOOK: Input: default@srcpart +POSTHOOK: query: -- SORT_QUERY_RESULTS + +show partitions srcpart +POSTHOOK: type: SHOWPARTITIONS +POSTHOOK: Input: default@srcpart +ds=2008-04-08/hr=11 +ds=2008-04-08/hr=12 +ds=2008-04-09/hr=11 +ds=2008-04-09/hr=12 +PREHOOK: query: -- Creating and populating the source table. +create table if not exists source_hive_602_table like srcpart +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +POSTHOOK: query: -- Creating and populating the source table. +create table if not exists source_hive_602_table like srcpart +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@source_hive_602_table +PREHOOK: query: describe extended source_hive_602_table +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@source_hive_602_table +POSTHOOK: query: describe extended source_hive_602_table +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@source_hive_602_table +key string default +value string default +ds string +hr string + +# Partition Information +# col_name data_type comment + +ds string +hr string + +#### A masked pattern was here #### +PREHOOK: query: from srcpart +insert overwrite table source_hive_602_table partition(ds='2008-12-31', hr= '11') select key, value where ds > '2008-04-08' and hr = '11' +PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart +PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11 +PREHOOK: Output: default@source_hive_602_table@ds=2008-12-31/hr=11 +POSTHOOK: query: from srcpart +insert overwrite table source_hive_602_table partition(ds='2008-12-31', hr= '11') select key, value where ds > '2008-04-08' and hr = '11' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart +POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11 +POSTHOOK: Output: default@source_hive_602_table@ds=2008-12-31/hr=11 +POSTHOOK: Lineage: source_hive_602_table PARTITION(ds=2008-12-31,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: source_hive_602_table PARTITION(ds=2008-12-31,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ] +PREHOOK: query: -- Creating the destination table. +create table if not exists destination_hive_602_table(bar1 string, bar2 string, bar3 string) partitioned by(ds string) +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +POSTHOOK: query: -- Creating the destination table. +create table if not exists destination_hive_602_table(bar1 string, bar2 string, bar3 string) partitioned by(ds string) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@destination_hive_602_table +PREHOOK: query: describe extended destination_hive_602_table +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@destination_hive_602_table +POSTHOOK: query: describe extended destination_hive_602_table +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@destination_hive_602_table +bar1 string +bar2 string +bar3 string +ds string + +# Partition Information +# col_name data_type comment + +ds string + +#### A masked pattern was here #### +PREHOOK: query: -- Distribute By +explain +from source_hive_602_table +insert overwrite table destination_hive_602_table partition(ds) select value as value1, value as value2, value as value3, ds distribute by value3 +PREHOOK: type: QUERY +POSTHOOK: query: -- Distribute By +explain +from source_hive_602_table +insert overwrite table destination_hive_602_table partition(ds) select value as value1, value as value2, value as value3, ds distribute by value3 +POSTHOOK: type: QUERY +STAGE DEPENDENCIES: + Stage-1 is a root stage + Stage-2 depends on stages: Stage-1 + Stage-0 depends on stages: Stage-2 + Stage-3 depends on stages: Stage-0 + +STAGE PLANS: + Stage: Stage-1 + Map Reduce + Map Operator Tree: + TableScan + alias: source_hive_602_table + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: value (type: string), value (type: string), value (type: string), ds (type: string) + outputColumnNames: _col0, _col1, _col2, _col3 + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + Reduce Output Operator + sort order: + Map-reduce partition columns: _col2 (type: string) + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string) + Reduce Operator Tree: + Select Operator + expressions: VALUE._col0 (type: string), VALUE._col1 (type: string), VALUE._col2 (type: string), VALUE._col3 (type: string) + outputColumnNames: _col0, _col1, _col2, _col3 + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + File Output Operator + compressed: false + table: + input format: org.apache.hadoop.mapred.SequenceFileInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe + + Stage: Stage-2 + Map Reduce + Map Operator Tree: + TableScan + Reduce Output Operator + key expressions: _col3 (type: string) + sort order: + + Map-reduce partition columns: _col3 (type: string) + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string) + Reduce Operator Tree: + Extract + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + File Output Operator + compressed: false + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + name: default.destination_hive_602_table + + Stage: Stage-0 + Move Operator + tables: + partition: + ds + replace: true + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + name: default.destination_hive_602_table + + Stage: Stage-3 + Stats-Aggr Operator + +PREHOOK: query: from source_hive_602_table +insert overwrite table destination_hive_602_table partition(ds) select value as value1, value as value2, value as value3, ds distribute by value3 +PREHOOK: type: QUERY +PREHOOK: Input: default@source_hive_602_table +PREHOOK: Input: default@source_hive_602_table@ds=2008-12-31/hr=11 +PREHOOK: Output: default@destination_hive_602_table +POSTHOOK: query: from source_hive_602_table +insert overwrite table destination_hive_602_table partition(ds) select value as value1, value as value2, value as value3, ds distribute by value3 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@source_hive_602_table +POSTHOOK: Input: default@source_hive_602_table@ds=2008-12-31/hr=11 +POSTHOOK: Output: default@destination_hive_602_table@ds=2008-12-31 +POSTHOOK: Lineage: destination_hive_602_table PARTITION(ds=2008-12-31).bar1 SIMPLE [(source_hive_602_table)source_hive_602_table.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: destination_hive_602_table PARTITION(ds=2008-12-31).bar2 SIMPLE [(source_hive_602_table)source_hive_602_table.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: destination_hive_602_table PARTITION(ds=2008-12-31).bar3 SIMPLE [(source_hive_602_table)source_hive_602_table.FieldSchema(name:value, type:string, comment:default), ] +PREHOOK: query: show partitions destination_hive_602_table +PREHOOK: type: SHOWPARTITIONS +PREHOOK: Input: default@destination_hive_602_table +POSTHOOK: query: show partitions destination_hive_602_table +POSTHOOK: type: SHOWPARTITIONS +POSTHOOK: Input: default@destination_hive_602_table +ds=2008-12-31 +PREHOOK: query: select * from destination_hive_602_table +PREHOOK: type: QUERY +PREHOOK: Input: default@destination_hive_602_table +PREHOOK: Input: default@destination_hive_602_table@ds=2008-12-31 +#### A masked pattern was here #### +POSTHOOK: query: select * from destination_hive_602_table +POSTHOOK: type: QUERY +POSTHOOK: Input: default@destination_hive_602_table +POSTHOOK: Input: default@destination_hive_602_table@ds=2008-12-31 +#### A masked pattern was here #### +val_0 val_0 val_0 2008-12-31 +val_0 val_0 val_0 2008-12-31 +val_0 val_0 val_0 2008-12-31 +val_10 val_10 val_10 2008-12-31 +val_100 val_100 val_100 2008-12-31 +val_100 val_100 val_100 2008-12-31 +val_103 val_103 val_103 2008-12-31 +val_103 val_103 val_103 2008-12-31 +val_104 val_104 val_104 2008-12-31 +val_104 val_104 val_104 2008-12-31 +val_105 val_105 val_105 2008-12-31 +val_11 val_11 val_11 2008-12-31 +val_111 val_111 val_111 2008-12-31 +val_113 val_113 val_113 2008-12-31 +val_113 val_113 val_113 2008-12-31 +val_114 val_114 val_114 2008-12-31 +val_116 val_116 val_116 2008-12-31 +val_118 val_118 val_118 2008-12-31 +val_118 val_118 val_118 2008-12-31 +val_119 val_119 val_119 2008-12-31 +val_119 val_119 val_119 2008-12-31 +val_119 val_119 val_119 2008-12-31 +val_12 val_12 val_12 2008-12-31 +val_12 val_12 val_12 2008-12-31 +val_120 val_120 val_120 2008-12-31 +val_120 val_120 val_120 2008-12-31 +val_125 val_125 val_125 2008-12-31 +val_125 val_125 val_125 2008-12-31 +val_126 val_126 val_126 2008-12-31 +val_128 val_128 val_128 2008-12-31 +val_128 val_128 val_128 2008-12-31 +val_128 val_128 val_128 2008-12-31 +val_129 val_129 val_129 2008-12-31 +val_129 val_129 val_129 2008-12-31 +val_131 val_131 val_131 2008-12-31 +val_133 val_133 val_133 2008-12-31 +val_134 val_134 val_134 2008-12-31 +val_134 val_134 val_134 2008-12-31 +val_136 val_136 val_136 2008-12-31 +val_137 val_137 val_137 2008-12-31 +val_137 val_137 val_137 2008-12-31 +val_138 val_138 val_138 2008-12-31 +val_138 val_138 val_138 2008-12-31 +val_138 val_138 val_138 2008-12-31 +val_138 val_138 val_138 2008-12-31 +val_143 val_143 val_143 2008-12-31 +val_145 val_145 val_145 2008-12-31 +val_146 val_146 val_146 2008-12-31 +val_146 val_146 val_146 2008-12-31 +val_149 val_149 val_149 2008-12-31 +val_149 val_149 val_149 2008-12-31 +val_15 val_15 val_15 2008-12-31 +val_15 val_15 val_15 2008-12-31 +val_150 val_150 val_150 2008-12-31 +val_152 val_152 val_152 2008-12-31 +val_152 val_152 val_152 2008-12-31 +val_153 val_153 val_153 2008-12-31 +val_155 val_155 val_155 2008-12-31 +val_156 val_156 val_156 2008-12-31 +val_157 val_157 val_157 2008-12-31 +val_158 val_158 val_158 2008-12-31 +val_160 val_160 val_160 2008-12-31 +val_162 val_162 val_162 2008-12-31 +val_163 val_163 val_163 2008-12-31 +val_164 val_164 val_164 2008-12-31 +val_164 val_164 val_164 2008-12-31 +val_165 val_165 val_165 2008-12-31 +val_165 val_165 val_165 2008-12-31 +val_166 val_166 val_166 2008-12-31 +val_167 val_167 val_167 2008-12-31 +val_167 val_167 val_167 2008-12-31 +val_167 val_167 val_167 2008-12-31 +val_168 val_168 val_168 2008-12-31 +val_169 val_169 val_169 2008-12-31 +val_169 val_169 val_169 2008-12-31 +val_169 val_169 val_169 2008-12-31 +val_169 val_169 val_169 2008-12-31 +val_17 val_17 val_17 2008-12-31 +val_170 val_170 val_170 2008-12-31 +val_172 val_172 val_172 2008-12-31 +val_172 val_172 val_172 2008-12-31 +val_174 val_174 val_174 2008-12-31 +val_174 val_174 val_174 2008-12-31 +val_175 val_175 val_175 2008-12-31 +val_175 val_175 val_175 2008-12-31 +val_176 val_176 val_176 2008-12-31 +val_176 val_176 val_176 2008-12-31 +val_177 val_177 val_177 2008-12-31 +val_178 val_178 val_178 2008-12-31 +val_179 val_179 val_179 2008-12-31 +val_179 val_179 val_179 2008-12-31 +val_18 val_18 val_18 2008-12-31 +val_18 val_18 val_18 2008-12-31 +val_180 val_180 val_180 2008-12-31 +val_181 val_181 val_181 2008-12-31 +val_183 val_183 val_183 2008-12-31 +val_186 val_186 val_186 2008-12-31 +val_187 val_187 val_187 2008-12-31 +val_187 val_187 val_187 2008-12-31 +val_187 val_187 val_187 2008-12-31 +val_189 val_189 val_189 2008-12-31 +val_19 val_19 val_19 2008-12-31 +val_190 val_190 val_190 2008-12-31 +val_191 val_191 val_191 2008-12-31 +val_191 val_191 val_191 2008-12-31 +val_192 val_192 val_192 2008-12-31 +val_193 val_193 val_193 2008-12-31 +val_193 val_193 val_193 2008-12-31 +val_193 val_193 val_193 2008-12-31 +val_194 val_194 val_194 2008-12-31 +val_195 val_195 val_195 2008-12-31 +val_195 val_195 val_195 2008-12-31 +val_196 val_196 val_196 2008-12-31 +val_197 val_197 val_197 2008-12-31 +val_197 val_197 val_197 2008-12-31 +val_199 val_199 val_199 2008-12-31 +val_199 val_199 val_199 2008-12-31 +val_199 val_199 val_199 2008-12-31 +val_2 val_2 val_2 2008-12-31 +val_20 val_20 val_20 2008-12-31 +val_200 val_200 val_200 2008-12-31 +val_200 val_200 val_200 2008-12-31 +val_201 val_201 val_201 2008-12-31 +val_202 val_202 val_202 2008-12-31 +val_203 val_203 val_203 2008-12-31 +val_203 val_203 val_203 2008-12-31 +val_205 val_205 val_205 2008-12-31 +val_205 val_205 val_205 2008-12-31 +val_207 val_207 val_207 2008-12-31 +val_207 val_207 val_207 2008-12-31 +val_208 val_208 val_208 2008-12-31 +val_208 val_208 val_208 2008-12-31 +val_208 val_208 val_208 2008-12-31 +val_209 val_209 val_209 2008-12-31 +val_209 val_209 val_209 2008-12-31 +val_213 val_213 val_213 2008-12-31 +val_213 val_213 val_213 2008-12-31 +val_214 val_214 val_214 2008-12-31 +val_216 val_216 val_216 2008-12-31 +val_216 val_216 val_216 2008-12-31 +val_217 val_217 val_217 2008-12-31 +val_217 val_217 val_217 2008-12-31 +val_218 val_218 val_218 2008-12-31 +val_219 val_219 val_219 2008-12-31 +val_219 val_219 val_219 2008-12-31 +val_221 val_221 val_221 2008-12-31 +val_221 val_221 val_221 2008-12-31 +val_222 val_222 val_222 2008-12-31 +val_223 val_223 val_223 2008-12-31 +val_223 val_223 val_223 2008-12-31 +val_224 val_224 val_224 2008-12-31 +val_224 val_224 val_224 2008-12-31 +val_226 val_226 val_226 2008-12-31 +val_228 val_228 val_228 2008-12-31 +val_229 val_229 val_229 2008-12-31 +val_229 val_229 val_229 2008-12-31 +val_230 val_230 val_230 2008-12-31 +val_230 val_230 val_230 2008-12-31 +val_230 val_230 val_230 2008-12-31 +val_230 val_230 val_230 2008-12-31 +val_230 val_230 val_230 2008-12-31 +val_233 val_233 val_233 2008-12-31 +val_233 val_233 val_233 2008-12-31 +val_235 val_235 val_235 2008-12-31 +val_237 val_237 val_237 2008-12-31 +val_237 val_237 val_237 2008-12-31 +val_238 val_238 val_238 2008-12-31 +val_238 val_238 val_238 2008-12-31 +val_239 val_239 val_239 2008-12-31 +val_239 val_239 val_239 2008-12-31 +val_24 val_24 val_24 2008-12-31 +val_24 val_24 val_24 2008-12-31 +val_241 val_241 val_241 2008-12-31 +val_242 val_242 val_242 2008-12-31 +val_242 val_242 val_242 2008-12-31 +val_244 val_244 val_244 2008-12-31 +val_247 val_247 val_247 2008-12-31 +val_248 val_248 val_248 2008-12-31 +val_249 val_249 val_249 2008-12-31 +val_252 val_252 val_252 2008-12-31 +val_255 val_255 val_255 2008-12-31 +val_255 val_255 val_255 2008-12-31 +val_256 val_256 val_256 2008-12-31 +val_256 val_256 val_256 2008-12-31 +val_257 val_257 val_257 2008-12-31 +val_258 val_258 val_258 2008-12-31 +val_26 val_26 val_26 2008-12-31 +val_26 val_26 val_26 2008-12-31 +val_260 val_260 val_260 2008-12-31 +val_262 val_262 val_262 2008-12-31 +val_263 val_263 val_263 2008-12-31 +val_265 val_265 val_265 2008-12-31 +val_265 val_265 val_265 2008-12-31 +val_266 val_266 val_266 2008-12-31 +val_27 val_27 val_27 2008-12-31 +val_272 val_272 val_272 2008-12-31 +val_272 val_272 val_272 2008-12-31 +val_273 val_273 val_273 2008-12-31 +val_273 val_273 val_273 2008-12-31 +val_273 val_273 val_273 2008-12-31 +val_274 val_274 val_274 2008-12-31 +val_275 val_275 val_275 2008-12-31 +val_277 val_277 val_277 2008-12-31 +val_277 val_277 val_277 2008-12-31 +val_277 val_277 val_277 2008-12-31 +val_277 val_277 val_277 2008-12-31 +val_278 val_278 val_278 2008-12-31 +val_278 val_278 val_278 2008-12-31 +val_28 val_28 val_28 2008-12-31 +val_280 val_280 val_280 2008-12-31 +val_280 val_280 val_280 2008-12-31 +val_281 val_281 val_281 2008-12-31 +val_281 val_281 val_281 2008-12-31 +val_282 val_282 val_282 2008-12-31 +val_282 val_282 val_282 2008-12-31 +val_283 val_283 val_283 2008-12-31 +val_284 val_284 val_284 2008-12-31 +val_285 val_285 val_285 2008-12-31 +val_286 val_286 val_286 2008-12-31 +val_287 val_287 val_287 2008-12-31 +val_288 val_288 val_288 2008-12-31 +val_288 val_288 val_288 2008-12-31 +val_289 val_289 val_289 2008-12-31 +val_291 val_291 val_291 2008-12-31 +val_292 val_292 val_292 2008-12-31 +val_296 val_296 val_296 2008-12-31 +val_298 val_298 val_298 2008-12-31 +val_298 val_298 val_298 2008-12-31 +val_298 val_298 val_298 2008-12-31 +val_30 val_30 val_30 2008-12-31 +val_302 val_302 val_302 2008-12-31 +val_305 val_305 val_305 2008-12-31 +val_306 val_306 val_306 2008-12-31 +val_307 val_307 val_307 2008-12-31 +val_307 val_307 val_307 2008-12-31 +val_308 val_308 val_308 2008-12-31 +val_309 val_309 val_309 2008-12-31 +val_309 val_309 val_309 2008-12-31 +val_310 val_310 val_310 2008-12-31 +val_311 val_311 val_311 2008-12-31 +val_311 val_311 val_311 2008-12-31 +val_311 val_311 val_311 2008-12-31 +val_315 val_315 val_315 2008-12-31 +val_316 val_316 val_316 2008-12-31 +val_316 val_316 val_316 2008-12-31 +val_316 val_316 val_316 2008-12-31 +val_317 val_317 val_317 2008-12-31 +val_317 val_317 val_317 2008-12-31 +val_318 val_318 val_318 2008-12-31 +val_318 val_318 val_318 2008-12-31 +val_318 val_318 val_318 2008-12-31 +val_321 val_321 val_321 2008-12-31 +val_321 val_321 val_321 2008-12-31 +val_322 val_322 val_322 2008-12-31 +val_322 val_322 val_322 2008-12-31 +val_323 val_323 val_323 2008-12-31 +val_325 val_325 val_325 2008-12-31 +val_325 val_325 val_325 2008-12-31 +val_327 val_327 val_327 2008-12-31 +val_327 val_327 val_327 2008-12-31 +val_327 val_327 val_327 2008-12-31 +val_33 val_33 val_33 2008-12-31 +val_331 val_331 val_331 2008-12-31 +val_331 val_331 val_331 2008-12-31 +val_332 val_332 val_332 2008-12-31 +val_333 val_333 val_333 2008-12-31 +val_333 val_333 val_333 2008-12-31 +val_335 val_335 val_335 2008-12-31 +val_336 val_336 val_336 2008-12-31 +val_338 val_338 val_338 2008-12-31 +val_339 val_339 val_339 2008-12-31 +val_34 val_34 val_34 2008-12-31 +val_341 val_341 val_341 2008-12-31 +val_342 val_342 val_342 2008-12-31 +val_342 val_342 val_342 2008-12-31 +val_344 val_344 val_344 2008-12-31 +val_344 val_344 val_344 2008-12-31 +val_345 val_345 val_345 2008-12-31 +val_348 val_348 val_348 2008-12-31 +val_348 val_348 val_348 2008-12-31 +val_348 val_348 val_348 2008-12-31 +val_348 val_348 val_348 2008-12-31 +val_348 val_348 val_348 2008-12-31 +val_35 val_35 val_35 2008-12-31 +val_35 val_35 val_35 2008-12-31 +val_35 val_35 val_35 2008-12-31 +val_351 val_351 val_351 2008-12-31 +val_353 val_353 val_353 2008-12-31 +val_353 val_353 val_353 2008-12-31 +val_356 val_356 val_356 2008-12-31 +val_360 val_360 val_360 2008-12-31 +val_362 val_362 val_362 2008-12-31 +val_364 val_364 val_364 2008-12-31 +val_365 val_365 val_365 2008-12-31 +val_366 val_366 val_366 2008-12-31 +val_367 val_367 val_367 2008-12-31 +val_367 val_367 val_367 2008-12-31 +val_368 val_368 val_368 2008-12-31 +val_369 val_369 val_369 2008-12-31 +val_369 val_369 val_369 2008-12-31 +val_369 val_369 val_369 2008-12-31 +val_37 val_37 val_37 2008-12-31 +val_37 val_37 val_37 2008-12-31 +val_373 val_373 val_373 2008-12-31 +val_374 val_374 val_374 2008-12-31 +val_375 val_375 val_375 2008-12-31 +val_377 val_377 val_377 2008-12-31 +val_378 val_378 val_378 2008-12-31 +val_379 val_379 val_379 2008-12-31 +val_382 val_382 val_382 2008-12-31 +val_382 val_382 val_382 2008-12-31 +val_384 val_384 val_384 2008-12-31 +val_384 val_384 val_384 2008-12-31 +val_384 val_384 val_384 2008-12-31 +val_386 val_386 val_386 2008-12-31 +val_389 val_389 val_389 2008-12-31 +val_392 val_392 val_392 2008-12-31 +val_393 val_393 val_393 2008-12-31 +val_394 val_394 val_394 2008-12-31 +val_395 val_395 val_395 2008-12-31 +val_395 val_395 val_395 2008-12-31 +val_396 val_396 val_396 2008-12-31 +val_396 val_396 val_396 2008-12-31 +val_396 val_396 val_396 2008-12-31 +val_397 val_397 val_397 2008-12-31 +val_397 val_397 val_397 2008-12-31 +val_399 val_399 val_399 2008-12-31 +val_399 val_399 val_399 2008-12-31 +val_4 val_4 val_4 2008-12-31 +val_400 val_400 val_400 2008-12-31 +val_401 val_401 val_401 2008-12-31 +val_401 val_401 val_401 2008-12-31 +val_401 val_401 val_401 2008-12-31 +val_401 val_401 val_401 2008-12-31 +val_401 val_401 val_401 2008-12-31 +val_402 val_402 val_402 2008-12-31 +val_403 val_403 val_403 2008-12-31 +val_403 val_403 val_403 2008-12-31 +val_403 val_403 val_403 2008-12-31 +val_404 val_404 val_404 2008-12-31 +val_404 val_404 val_404 2008-12-31 +val_406 val_406 val_406 2008-12-31 +val_406 val_406 val_406 2008-12-31 +val_406 val_406 val_406 2008-12-31 +val_406 val_406 val_406 2008-12-31 +val_407 val_407 val_407 2008-12-31 +val_409 val_409 val_409 2008-12-31 +val_409 val_409 val_409 2008-12-31 +val_409 val_409 val_409 2008-12-31 +val_41 val_41 val_41 2008-12-31 +val_411 val_411 val_411 2008-12-31 +val_413 val_413 val_413 2008-12-31 +val_413 val_413 val_413 2008-12-31 +val_414 val_414 val_414 2008-12-31 +val_414 val_414 val_414 2008-12-31 +val_417 val_417 val_417 2008-12-31 +val_417 val_417 val_417 2008-12-31 +val_417 val_417 val_417 2008-12-31 +val_418 val_418 val_418 2008-12-31 +val_419 val_419 val_419 2008-12-31 +val_42 val_42 val_42 2008-12-31 +val_42 val_42 val_42 2008-12-31 +val_421 val_421 val_421 2008-12-31 +val_424 val_424 val_424 2008-12-31 +val_424 val_424 val_424 2008-12-31 +val_427 val_427 val_427 2008-12-31 +val_429 val_429 val_429 2008-12-31 +val_429 val_429 val_429 2008-12-31 +val_43 val_43 val_43 2008-12-31 +val_430 val_430 val_430 2008-12-31 +val_430 val_430 val_430 2008-12-31 +val_430 val_430 val_430 2008-12-31 +val_431 val_431 val_431 2008-12-31 +val_431 val_431 val_431 2008-12-31 +val_431 val_431 val_431 2008-12-31 +val_432 val_432 val_432 2008-12-31 +val_435 val_435 val_435 2008-12-31 +val_436 val_436 val_436 2008-12-31 +val_437 val_437 val_437 2008-12-31 +val_438 val_438 val_438 2008-12-31 +val_438 val_438 val_438 2008-12-31 +val_438 val_438 val_438 2008-12-31 +val_439 val_439 val_439 2008-12-31 +val_439 val_439 val_439 2008-12-31 +val_44 val_44 val_44 2008-12-31 +val_443 val_443 val_443 2008-12-31 +val_444 val_444 val_444 2008-12-31 +val_446 val_446 val_446 2008-12-31 +val_448 val_448 val_448 2008-12-31 +val_449 val_449 val_449 2008-12-31 +val_452 val_452 val_452 2008-12-31 +val_453 val_453 val_453 2008-12-31 +val_454 val_454 val_454 2008-12-31 +val_454 val_454 val_454 2008-12-31 +val_454 val_454 val_454 2008-12-31 +val_455 val_455 val_455 2008-12-31 +val_457 val_457 val_457 2008-12-31 +val_458 val_458 val_458 2008-12-31 +val_458 val_458 val_458 2008-12-31 +val_459 val_459 val_459 2008-12-31 +val_459 val_459 val_459 2008-12-31 +val_460 val_460 val_460 2008-12-31 +val_462 val_462 val_462 2008-12-31 +val_462 val_462 val_462 2008-12-31 +val_463 val_463 val_463 2008-12-31 +val_463 val_463 val_463 2008-12-31 +val_466 val_466 val_466 2008-12-31 +val_466 val_466 val_466 2008-12-31 +val_466 val_466 val_466 2008-12-31 +val_467 val_467 val_467 2008-12-31 +val_468 val_468 val_468 2008-12-31 +val_468 val_468 val_468 2008-12-31 +val_468 val_468 val_468 2008-12-31 +val_468 val_468 val_468 2008-12-31 +val_469 val_469 val_469 2008-12-31 +val_469 val_469 val_469 2008-12-31 +val_469 val_469 val_469 2008-12-31 +val_469 val_469 val_469 2008-12-31 +val_469 val_469 val_469 2008-12-31 +val_47 val_47 val_47 2008-12-31 +val_470 val_470 val_470 2008-12-31 +val_472 val_472 val_472 2008-12-31 +val_475 val_475 val_475 2008-12-31 +val_477 val_477 val_477 2008-12-31 +val_478 val_478 val_478 2008-12-31 +val_478 val_478 val_478 2008-12-31 +val_479 val_479 val_479 2008-12-31 +val_480 val_480 val_480 2008-12-31 +val_480 val_480 val_480 2008-12-31 +val_480 val_480 val_480 2008-12-31 +val_481 val_481 val_481 2008-12-31 +val_482 val_482 val_482 2008-12-31 +val_483 val_483 val_483 2008-12-31 +val_484 val_484 val_484 2008-12-31 +val_485 val_485 val_485 2008-12-31 +val_487 val_487 val_487 2008-12-31 +val_489 val_489 val_489 2008-12-31 +val_489 val_489 val_489 2008-12-31 +val_489 val_489 val_489 2008-12-31 +val_489 val_489 val_489 2008-12-31 +val_490 val_490 val_490 2008-12-31 +val_491 val_491 val_491 2008-12-31 +val_492 val_492 val_492 2008-12-31 +val_492 val_492 val_492 2008-12-31 +val_493 val_493 val_493 2008-12-31 +val_494 val_494 val_494 2008-12-31 +val_495 val_495 val_495 2008-12-31 +val_496 val_496 val_496 2008-12-31 +val_497 val_497 val_497 2008-12-31 +val_498 val_498 val_498 2008-12-31 +val_498 val_498 val_498 2008-12-31 +val_498 val_498 val_498 2008-12-31 +val_5 val_5 val_5 2008-12-31 +val_5 val_5 val_5 2008-12-31 +val_5 val_5 val_5 2008-12-31 +val_51 val_51 val_51 2008-12-31 +val_51 val_51 val_51 2008-12-31 +val_53 val_53 val_53 2008-12-31 +val_54 val_54 val_54 2008-12-31 +val_57 val_57 val_57 2008-12-31 +val_58 val_58 val_58 2008-12-31 +val_58 val_58 val_58 2008-12-31 +val_64 val_64 val_64 2008-12-31 +val_65 val_65 val_65 2008-12-31 +val_66 val_66 val_66 2008-12-31 +val_67 val_67 val_67 2008-12-31 +val_67 val_67 val_67 2008-12-31 +val_69 val_69 val_69 2008-12-31 +val_70 val_70 val_70 2008-12-31 +val_70 val_70 val_70 2008-12-31 +val_70 val_70 val_70 2008-12-31 +val_72 val_72 val_72 2008-12-31 +val_72 val_72 val_72 2008-12-31 +val_74 val_74 val_74 2008-12-31 +val_76 val_76 val_76 2008-12-31 +val_76 val_76 val_76 2008-12-31 +val_77 val_77 val_77 2008-12-31 +val_78 val_78 val_78 2008-12-31 +val_8 val_8 val_8 2008-12-31 +val_80 val_80 val_80 2008-12-31 +val_82 val_82 val_82 2008-12-31 +val_83 val_83 val_83 2008-12-31 +val_83 val_83 val_83 2008-12-31 +val_84 val_84 val_84 2008-12-31 +val_84 val_84 val_84 2008-12-31 +val_85 val_85 val_85 2008-12-31 +val_86 val_86 val_86 2008-12-31 +val_87 val_87 val_87 2008-12-31 +val_9 val_9 val_9 2008-12-31 +val_90 val_90 val_90 2008-12-31 +val_90 val_90 val_90 2008-12-31 +val_90 val_90 val_90 2008-12-31 +val_92 val_92 val_92 2008-12-31 +val_95 val_95 val_95 2008-12-31 +val_95 val_95 val_95 2008-12-31 +val_96 val_96 val_96 2008-12-31 +val_97 val_97 val_97 2008-12-31 +val_97 val_97 val_97 2008-12-31 +val_98 val_98 val_98 2008-12-31 +val_98 val_98 val_98 2008-12-31 +PREHOOK: query: explain +from source_hive_602_table +insert overwrite table destination_hive_602_table partition(ds) select value as value1, value as value2, value as value3, ds cluster by value3 +PREHOOK: type: QUERY +POSTHOOK: query: explain +from source_hive_602_table +insert overwrite table destination_hive_602_table partition(ds) select value as value1, value as value2, value as value3, ds cluster by value3 +POSTHOOK: type: QUERY +STAGE DEPENDENCIES: + Stage-1 is a root stage + Stage-2 depends on stages: Stage-1 + Stage-0 depends on stages: Stage-2 + Stage-3 depends on stages: Stage-0 + +STAGE PLANS: + Stage: Stage-1 + Map Reduce + Map Operator Tree: + TableScan + alias: source_hive_602_table + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: value (type: string), ds (type: string) + outputColumnNames: _col2, _col3 + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + Reduce Output Operator + key expressions: _col2 (type: string) + sort order: + + Map-reduce partition columns: _col2 (type: string) + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + value expressions: _col3 (type: string) + Reduce Operator Tree: + Select Operator + expressions: KEY.reducesinkkey0 (type: string), KEY.reducesinkkey0 (type: string), KEY.reducesinkkey0 (type: string), VALUE._col0 (type: string) + outputColumnNames: _col0, _col1, _col2, _col3 + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + File Output Operator + compressed: false + table: + input format: org.apache.hadoop.mapred.SequenceFileInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe + + Stage: Stage-2 + Map Reduce + Map Operator Tree: + TableScan + Reduce Output Operator + key expressions: _col3 (type: string), _col2 (type: string) + sort order: ++ + Map-reduce partition columns: _col3 (type: string) + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string) + Reduce Operator Tree: + Extract + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + File Output Operator + compressed: false + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + name: default.destination_hive_602_table + + Stage: Stage-0 + Move Operator + tables: + partition: + ds + replace: true + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + name: default.destination_hive_602_table + + Stage: Stage-3 + Stats-Aggr Operator + +PREHOOK: query: from source_hive_602_table +insert overwrite table destination_hive_602_table partition(ds) select value as value1, value as value2, value as value3, ds cluster by value3 +PREHOOK: type: QUERY +PREHOOK: Input: default@source_hive_602_table +PREHOOK: Input: default@source_hive_602_table@ds=2008-12-31/hr=11 +PREHOOK: Output: default@destination_hive_602_table +POSTHOOK: query: from source_hive_602_table +insert overwrite table destination_hive_602_table partition(ds) select value as value1, value as value2, value as value3, ds cluster by value3 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@source_hive_602_table +POSTHOOK: Input: default@source_hive_602_table@ds=2008-12-31/hr=11 +POSTHOOK: Output: default@destination_hive_602_table@ds=2008-12-31 +POSTHOOK: Lineage: destination_hive_602_table PARTITION(ds=2008-12-31).bar1 SIMPLE [(source_hive_602_table)source_hive_602_table.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: destination_hive_602_table PARTITION(ds=2008-12-31).bar2 SIMPLE [(source_hive_602_table)source_hive_602_table.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: destination_hive_602_table PARTITION(ds=2008-12-31).bar3 SIMPLE [(source_hive_602_table)source_hive_602_table.FieldSchema(name:value, type:string, comment:default), ] +PREHOOK: query: show partitions destination_hive_602_table +PREHOOK: type: SHOWPARTITIONS +PREHOOK: Input: default@destination_hive_602_table +POSTHOOK: query: show partitions destination_hive_602_table +POSTHOOK: type: SHOWPARTITIONS +POSTHOOK: Input: default@destination_hive_602_table +ds=2008-12-31 +PREHOOK: query: select * from destination_hive_602_table +PREHOOK: type: QUERY +PREHOOK: Input: default@destination_hive_602_table +PREHOOK: Input: default@destination_hive_602_table@ds=2008-12-31 +#### A masked pattern was here #### +POSTHOOK: query: select * from destination_hive_602_table +POSTHOOK: type: QUERY +POSTHOOK: Input: default@destination_hive_602_table +POSTHOOK: Input: default@destination_hive_602_table@ds=2008-12-31 +#### A masked pattern was here #### +val_0 val_0 val_0 2008-12-31 +val_0 val_0 val_0 2008-12-31 +val_0 val_0 val_0 2008-12-31 +val_10 val_10 val_10 2008-12-31 +val_100 val_100 val_100 2008-12-31 +val_100 val_100 val_100 2008-12-31 +val_103 val_103 val_103 2008-12-31 +val_103 val_103 val_103 2008-12-31 +val_104 val_104 val_104 2008-12-31 +val_104 val_104 val_104 2008-12-31 +val_105 val_105 val_105 2008-12-31 +val_11 val_11 val_11 2008-12-31 +val_111 val_111 val_111 2008-12-31 +val_113 val_113 val_113 2008-12-31 +val_113 val_113 val_113 2008-12-31 +val_114 val_114 val_114 2008-12-31 +val_116 val_116 val_116 2008-12-31 +val_118 val_118 val_118 2008-12-31 +val_118 val_118 val_118 2008-12-31 +val_119 val_119 val_119 2008-12-31 +val_119 val_119 val_119 2008-12-31 +val_119 val_119 val_119 2008-12-31 +val_12 val_12 val_12 2008-12-31 +val_12 val_12 val_12 2008-12-31 +val_120 val_120 val_120 2008-12-31 +val_120 val_120 val_120 2008-12-31 +val_125 val_125 val_125 2008-12-31 +val_125 val_125 val_125 2008-12-31 +val_126 val_126 val_126 2008-12-31 +val_128 val_128 val_128 2008-12-31 +val_128 val_128 val_128 2008-12-31 +val_128 val_128 val_128 2008-12-31 +val_129 val_129 val_129 2008-12-31 +val_129 val_129 val_129 2008-12-31 +val_131 val_131 val_131 2008-12-31 +val_133 val_133 val_133 2008-12-31 +val_134 val_134 val_134 2008-12-31 +val_134 val_134 val_134 2008-12-31 +val_136 val_136 val_136 2008-12-31 +val_137 val_137 val_137 2008-12-31 +val_137 val_137 val_137 2008-12-31 +val_138 val_138 val_138 2008-12-31 +val_138 val_138 val_138 2008-12-31 +val_138 val_138 val_138 2008-12-31 +val_138 val_138 val_138 2008-12-31 +val_143 val_143 val_143 2008-12-31 +val_145 val_145 val_145 2008-12-31 +val_146 val_146 val_146 2008-12-31 +val_146 val_146 val_146 2008-12-31 +val_149 val_149 val_149 2008-12-31 +val_149 val_149 val_149 2008-12-31 +val_15 val_15 val_15 2008-12-31 +val_15 val_15 val_15 2008-12-31 +val_150 val_150 val_150 2008-12-31 +val_152 val_152 val_152 2008-12-31 +val_152 val_152 val_152 2008-12-31 +val_153 val_153 val_153 2008-12-31 +val_155 val_155 val_155 2008-12-31 +val_156 val_156 val_156 2008-12-31 +val_157 val_157 val_157 2008-12-31 +val_158 val_158 val_158 2008-12-31 +val_160 val_160 val_160 2008-12-31 +val_162 val_162 val_162 2008-12-31 +val_163 val_163 val_163 2008-12-31 +val_164 val_164 val_164 2008-12-31 +val_164 val_164 val_164 2008-12-31 +val_165 val_165 val_165 2008-12-31 +val_165 val_165 val_165 2008-12-31 +val_166 val_166 val_166 2008-12-31 +val_167 val_167 val_167 2008-12-31 +val_167 val_167 val_167 2008-12-31 +val_167 val_167 val_167 2008-12-31 +val_168 val_168 val_168 2008-12-31 +val_169 val_169 val_169 2008-12-31 +val_169 val_169 val_169 2008-12-31 +val_169 val_169 val_169 2008-12-31 +val_169 val_169 val_169 2008-12-31 +val_17 val_17 val_17 2008-12-31 +val_170 val_170 val_170 2008-12-31 +val_172 val_172 val_172 2008-12-31 +val_172 val_172 val_172 2008-12-31 +val_174 val_174 val_174 2008-12-31 +val_174 val_174 val_174 2008-12-31 +val_175 val_175 val_175 2008-12-31 +val_175 val_175 val_175 2008-12-31 +val_176 val_176 val_176 2008-12-31 +val_176 val_176 val_176 2008-12-31 +val_177 val_177 val_177 2008-12-31 +val_178 val_178 val_178 2008-12-31 +val_179 val_179 val_179 2008-12-31 +val_179 val_179 val_179 2008-12-31 +val_18 val_18 val_18 2008-12-31 +val_18 val_18 val_18 2008-12-31 +val_180 val_180 val_180 2008-12-31 +val_181 val_181 val_181 2008-12-31 +val_183 val_183 val_183 2008-12-31 +val_186 val_186 val_186 2008-12-31 +val_187 val_187 val_187 2008-12-31 +val_187 val_187 val_187 2008-12-31 +val_187 val_187 val_187 2008-12-31 +val_189 val_189 val_189 2008-12-31 +val_19 val_19 val_19 2008-12-31 +val_190 val_190 val_190 2008-12-31 +val_191 val_191 val_191 2008-12-31 +val_191 val_191 val_191 2008-12-31 +val_192 val_192 val_192 2008-12-31 +val_193 val_193 val_193 2008-12-31 +val_193 val_193 val_193 2008-12-31 +val_193 val_193 val_193 2008-12-31 +val_194 val_194 val_194 2008-12-31 +val_195 val_195 val_195 2008-12-31 +val_195 val_195 val_195 2008-12-31 +val_196 val_196 val_196 2008-12-31 +val_197 val_197 val_197 2008-12-31 +val_197 val_197 val_197 2008-12-31 +val_199 val_199 val_199 2008-12-31 +val_199 val_199 val_199 2008-12-31 +val_199 val_199 val_199 2008-12-31 +val_2 val_2 val_2 2008-12-31 +val_20 val_20 val_20 2008-12-31 +val_200 val_200 val_200 2008-12-31 +val_200 val_200 val_200 2008-12-31 +val_201 val_201 val_201 2008-12-31 +val_202 val_202 val_202 2008-12-31 +val_203 val_203 val_203 2008-12-31 +val_203 val_203 val_203 2008-12-31 +val_205 val_205 val_205 2008-12-31 +val_205 val_205 val_205 2008-12-31 +val_207 val_207 val_207 2008-12-31 +val_207 val_207 val_207 2008-12-31 +val_208 val_208 val_208 2008-12-31 +val_208 val_208 val_208 2008-12-31 +val_208 val_208 val_208 2008-12-31 +val_209 val_209 val_209 2008-12-31 +val_209 val_209 val_209 2008-12-31 +val_213 val_213 val_213 2008-12-31 +val_213 val_213 val_213 2008-12-31 +val_214 val_214 val_214 2008-12-31 +val_216 val_216 val_216 2008-12-31 +val_216 val_216 val_216 2008-12-31 +val_217 val_217 val_217 2008-12-31 +val_217 val_217 val_217 2008-12-31 +val_218 val_218 val_218 2008-12-31 +val_219 val_219 val_219 2008-12-31 +val_219 val_219 val_219 2008-12-31 +val_221 val_221 val_221 2008-12-31 +val_221 val_221 val_221 2008-12-31 +val_222 val_222 val_222 2008-12-31 +val_223 val_223 val_223 2008-12-31 +val_223 val_223 val_223 2008-12-31 +val_224 val_224 val_224 2008-12-31 +val_224 val_224 val_224 2008-12-31 +val_226 val_226 val_226 2008-12-31 +val_228 val_228 val_228 2008-12-31 +val_229 val_229 val_229 2008-12-31 +val_229 val_229 val_229 2008-12-31 +val_230 val_230 val_230 2008-12-31 +val_230 val_230 val_230 2008-12-31 +val_230 val_230 val_230 2008-12-31 +val_230 val_230 val_230 2008-12-31 +val_230 val_230 val_230 2008-12-31 +val_233 val_233 val_233 2008-12-31 +val_233 val_233 val_233 2008-12-31 +val_235 val_235 val_235 2008-12-31 +val_237 val_237 val_237 2008-12-31 +val_237 val_237 val_237 2008-12-31 +val_238 val_238 val_238 2008-12-31 +val_238 val_238 val_238 2008-12-31 +val_239 val_239 val_239 2008-12-31 +val_239 val_239 val_239 2008-12-31 +val_24 val_24 val_24 2008-12-31 +val_24 val_24 val_24 2008-12-31 +val_241 val_241 val_241 2008-12-31 +val_242 val_242 val_242 2008-12-31 +val_242 val_242 val_242 2008-12-31 +val_244 val_244 val_244 2008-12-31 +val_247 val_247 val_247 2008-12-31 +val_248 val_248 val_248 2008-12-31 +val_249 val_249 val_249 2008-12-31 +val_252 val_252 val_252 2008-12-31 +val_255 val_255 val_255 2008-12-31 +val_255 val_255 val_255 2008-12-31 +val_256 val_256 val_256 2008-12-31 +val_256 val_256 val_256 2008-12-31 +val_257 val_257 val_257 2008-12-31 +val_258 val_258 val_258 2008-12-31 +val_26 val_26 val_26 2008-12-31 +val_26 val_26 val_26 2008-12-31 +val_260 val_260 val_260 2008-12-31 +val_262 val_262 val_262 2008-12-31 +val_263 val_263 val_263 2008-12-31 +val_265 val_265 val_265 2008-12-31 +val_265 val_265 val_265 2008-12-31 +val_266 val_266 val_266 2008-12-31 +val_27 val_27 val_27 2008-12-31 +val_272 val_272 val_272 2008-12-31 +val_272 val_272 val_272 2008-12-31 +val_273 val_273 val_273 2008-12-31 +val_273 val_273 val_273 2008-12-31 +val_273 val_273 val_273 2008-12-31 +val_274 val_274 val_274 2008-12-31 +val_275 val_275 val_275 2008-12-31 +val_277 val_277 val_277 2008-12-31 +val_277 val_277 val_277 2008-12-31 +val_277 val_277 val_277 2008-12-31 +val_277 val_277 val_277 2008-12-31 +val_278 val_278 val_278 2008-12-31 +val_278 val_278 val_278 2008-12-31 +val_28 val_28 val_28 2008-12-31 +val_280 val_280 val_280 2008-12-31 +val_280 val_280 val_280 2008-12-31 +val_281 val_281 val_281 2008-12-31 +val_281 val_281 val_281 2008-12-31 +val_282 val_282 val_282 2008-12-31 +val_282 val_282 val_282 2008-12-31 +val_283 val_283 val_283 2008-12-31 +val_284 val_284 val_284 2008-12-31 +val_285 val_285 val_285 2008-12-31 +val_286 val_286 val_286 2008-12-31 +val_287 val_287 val_287 2008-12-31 +val_288 val_288 val_288 2008-12-31 +val_288 val_288 val_288 2008-12-31 +val_289 val_289 val_289 2008-12-31 +val_291 val_291 val_291 2008-12-31 +val_292 val_292 val_292 2008-12-31 +val_296 val_296 val_296 2008-12-31 +val_298 val_298 val_298 2008-12-31 +val_298 val_298 val_298 2008-12-31 +val_298 val_298 val_298 2008-12-31 +val_30 val_30 val_30 2008-12-31 +val_302 val_302 val_302 2008-12-31 +val_305 val_305 val_305 2008-12-31 +val_306 val_306 val_306 2008-12-31 +val_307 val_307 val_307 2008-12-31 +val_307 val_307 val_307 2008-12-31 +val_308 val_308 val_308 2008-12-31 +val_309 val_309 val_309 2008-12-31 +val_309 val_309 val_309 2008-12-31 +val_310 val_310 val_310 2008-12-31 +val_311 val_311 val_311 2008-12-31 +val_311 val_311 val_311 2008-12-31 +val_311 val_311 val_311 2008-12-31 +val_315 val_315 val_315 2008-12-31 +val_316 val_316 val_316 2008-12-31 +val_316 val_316 val_316 2008-12-31 +val_316 val_316 val_316 2008-12-31 +val_317 val_317 val_317 2008-12-31 +val_317 val_317 val_317 2008-12-31 +val_318 val_318 val_318 2008-12-31 +val_318 val_318 val_318 2008-12-31 +val_318 val_318 val_318 2008-12-31 +val_321 val_321 val_321 2008-12-31 +val_321 val_321 val_321 2008-12-31 +val_322 val_322 val_322 2008-12-31 +val_322 val_322 val_322 2008-12-31 +val_323 val_323 val_323 2008-12-31 +val_325 val_325 val_325 2008-12-31 +val_325 val_325 val_325 2008-12-31 +val_327 val_327 val_327 2008-12-31 +val_327 val_327 val_327 2008-12-31 +val_327 val_327 val_327 2008-12-31 +val_33 val_33 val_33 2008-12-31 +val_331 val_331 val_331 2008-12-31 +val_331 val_331 val_331 2008-12-31 +val_332 val_332 val_332 2008-12-31 +val_333 val_333 val_333 2008-12-31 +val_333 val_333 val_333 2008-12-31 +val_335 val_335 val_335 2008-12-31 +val_336 val_336 val_336 2008-12-31 +val_338 val_338 val_338 2008-12-31 +val_339 val_339 val_339 2008-12-31 +val_34 val_34 val_34 2008-12-31 +val_341 val_341 val_341 2008-12-31 +val_342 val_342 val_342 2008-12-31 +val_342 val_342 val_342 2008-12-31 +val_344 val_344 val_344 2008-12-31 +val_344 val_344 val_344 2008-12-31 +val_345 val_345 val_345 2008-12-31 +val_348 val_348 val_348 2008-12-31 +val_348 val_348 val_348 2008-12-31 +val_348 val_348 val_348 2008-12-31 +val_348 val_348 val_348 2008-12-31 +val_348 val_348 val_348 2008-12-31 +val_35 val_35 val_35 2008-12-31 +val_35 val_35 val_35 2008-12-31 +val_35 val_35 val_35 2008-12-31 +val_351 val_351 val_351 2008-12-31 +val_353 val_353 val_353 2008-12-31 +val_353 val_353 val_353 2008-12-31 +val_356 val_356 val_356 2008-12-31 +val_360 val_360 val_360 2008-12-31 +val_362 val_362 val_362 2008-12-31 +val_364 val_364 val_364 2008-12-31 +val_365 val_365 val_365 2008-12-31 +val_366 val_366 val_366 2008-12-31 +val_367 val_367 val_367 2008-12-31 +val_367 val_367 val_367 2008-12-31 +val_368 val_368 val_368 2008-12-31 +val_369 val_369 val_369 2008-12-31 +val_369 val_369 val_369 2008-12-31 +val_369 val_369 val_369 2008-12-31 +val_37 val_37 val_37 2008-12-31 +val_37 val_37 val_37 2008-12-31 +val_373 val_373 val_373 2008-12-31 +val_374 val_374 val_374 2008-12-31 +val_375 val_375 val_375 2008-12-31 +val_377 val_377 val_377 2008-12-31 +val_378 val_378 val_378 2008-12-31 +val_379 val_379 val_379 2008-12-31 +val_382 val_382 val_382 2008-12-31 +val_382 val_382 val_382 2008-12-31 +val_384 val_384 val_384 2008-12-31 +val_384 val_384 val_384 2008-12-31 +val_384 val_384 val_384 2008-12-31 +val_386 val_386 val_386 2008-12-31 +val_389 val_389 val_389 2008-12-31 +val_392 val_392 val_392 2008-12-31 +val_393 val_393 val_393 2008-12-31 +val_394 val_394 val_394 2008-12-31 +val_395 val_395 val_395 2008-12-31 +val_395 val_395 val_395 2008-12-31 +val_396 val_396 val_396 2008-12-31 +val_396 val_396 val_396 2008-12-31 +val_396 val_396 val_396 2008-12-31 +val_397 val_397 val_397 2008-12-31 +val_397 val_397 val_397 2008-12-31 +val_399 val_399 val_399 2008-12-31 +val_399 val_399 val_399 2008-12-31 +val_4 val_4 val_4 2008-12-31 +val_400 val_400 val_400 2008-12-31 +val_401 val_401 val_401 2008-12-31 +val_401 val_401 val_401 2008-12-31 +val_401 val_401 val_401 2008-12-31 +val_401 val_401 val_401 2008-12-31 +val_401 val_401 val_401 2008-12-31 +val_402 val_402 val_402 2008-12-31 +val_403 val_403 val_403 2008-12-31 +val_403 val_403 val_403 2008-12-31 +val_403 val_403 val_403 2008-12-31 +val_404 val_404 val_404 2008-12-31 +val_404 val_404 val_404 2008-12-31 +val_406 val_406 val_406 2008-12-31 +val_406 val_406 val_406 2008-12-31 +val_406 val_406 val_406 2008-12-31 +val_406 val_406 val_406 2008-12-31 +val_407 val_407 val_407 2008-12-31 +val_409 val_409 val_409 2008-12-31 +val_409 val_409 val_409 2008-12-31 +val_409 val_409 val_409 2008-12-31 +val_41 val_41 val_41 2008-12-31 +val_411 val_411 val_411 2008-12-31 +val_413 val_413 val_413 2008-12-31 +val_413 val_413 val_413 2008-12-31 +val_414 val_414 val_414 2008-12-31 +val_414 val_414 val_414 2008-12-31 +val_417 val_417 val_417 2008-12-31 +val_417 val_417 val_417 2008-12-31 +val_417 val_417 val_417 2008-12-31 +val_418 val_418 val_418 2008-12-31 +val_419 val_419 val_419 2008-12-31 +val_42 val_42 val_42 2008-12-31 +val_42 val_42 val_42 2008-12-31 +val_421 val_421 val_421 2008-12-31 +val_424 val_424 val_424 2008-12-31 +val_424 val_424 val_424 2008-12-31 +val_427 val_427 val_427 2008-12-31 +val_429 val_429 val_429 2008-12-31 +val_429 val_429 val_429 2008-12-31 +val_43 val_43 val_43 2008-12-31 +val_430 val_430 val_430 2008-12-31 +val_430 val_430 val_430 2008-12-31 +val_430 val_430 val_430 2008-12-31 +val_431 val_431 val_431 2008-12-31 +val_431 val_431 val_431 2008-12-31 +val_431 val_431 val_431 2008-12-31 +val_432 val_432 val_432 2008-12-31 +val_435 val_435 val_435 2008-12-31 +val_436 val_436 val_436 2008-12-31 +val_437 val_437 val_437 2008-12-31 +val_438 val_438 val_438 2008-12-31 +val_438 val_438 val_438 2008-12-31 +val_438 val_438 val_438 2008-12-31 +val_439 val_439 val_439 2008-12-31 +val_439 val_439 val_439 2008-12-31 +val_44 val_44 val_44 2008-12-31 +val_443 val_443 val_443 2008-12-31 +val_444 val_444 val_444 2008-12-31 +val_446 val_446 val_446 2008-12-31 +val_448 val_448 val_448 2008-12-31 +val_449 val_449 val_449 2008-12-31 +val_452 val_452 val_452 2008-12-31 +val_453 val_453 val_453 2008-12-31 +val_454 val_454 val_454 2008-12-31 +val_454 val_454 val_454 2008-12-31 +val_454 val_454 val_454 2008-12-31 +val_455 val_455 val_455 2008-12-31 +val_457 val_457 val_457 2008-12-31 +val_458 val_458 val_458 2008-12-31 +val_458 val_458 val_458 2008-12-31 +val_459 val_459 val_459 2008-12-31 +val_459 val_459 val_459 2008-12-31 +val_460 val_460 val_460 2008-12-31 +val_462 val_462 val_462 2008-12-31 +val_462 val_462 val_462 2008-12-31 +val_463 val_463 val_463 2008-12-31 +val_463 val_463 val_463 2008-12-31 +val_466 val_466 val_466 2008-12-31 +val_466 val_466 val_466 2008-12-31 +val_466 val_466 val_466 2008-12-31 +val_467 val_467 val_467 2008-12-31 +val_468 val_468 val_468 2008-12-31 +val_468 val_468 val_468 2008-12-31 +val_468 val_468 val_468 2008-12-31 +val_468 val_468 val_468 2008-12-31 +val_469 val_469 val_469 2008-12-31 +val_469 val_469 val_469 2008-12-31 +val_469 val_469 val_469 2008-12-31 +val_469 val_469 val_469 2008-12-31 +val_469 val_469 val_469 2008-12-31 +val_47 val_47 val_47 2008-12-31 +val_470 val_470 val_470 2008-12-31 +val_472 val_472 val_472 2008-12-31 +val_475 val_475 val_475 2008-12-31 +val_477 val_477 val_477 2008-12-31 +val_478 val_478 val_478 2008-12-31 +val_478 val_478 val_478 2008-12-31 +val_479 val_479 val_479 2008-12-31 +val_480 val_480 val_480 2008-12-31 +val_480 val_480 val_480 2008-12-31 +val_480 val_480 val_480 2008-12-31 +val_481 val_481 val_481 2008-12-31 +val_482 val_482 val_482 2008-12-31 +val_483 val_483 val_483 2008-12-31 +val_484 val_484 val_484 2008-12-31 +val_485 val_485 val_485 2008-12-31 +val_487 val_487 val_487 2008-12-31 +val_489 val_489 val_489 2008-12-31 +val_489 val_489 val_489 2008-12-31 +val_489 val_489 val_489 2008-12-31 +val_489 val_489 val_489 2008-12-31 +val_490 val_490 val_490 2008-12-31 +val_491 val_491 val_491 2008-12-31 +val_492 val_492 val_492 2008-12-31 +val_492 val_492 val_492 2008-12-31 +val_493 val_493 val_493 2008-12-31 +val_494 val_494 val_494 2008-12-31 +val_495 val_495 val_495 2008-12-31 +val_496 val_496 val_496 2008-12-31 +val_497 val_497 val_497 2008-12-31 +val_498 val_498 val_498 2008-12-31 +val_498 val_498 val_498 2008-12-31 +val_498 val_498 val_498 2008-12-31 +val_5 val_5 val_5 2008-12-31 +val_5 val_5 val_5 2008-12-31 +val_5 val_5 val_5 2008-12-31 +val_51 val_51 val_51 2008-12-31 +val_51 val_51 val_51 2008-12-31 +val_53 val_53 val_53 2008-12-31 +val_54 val_54 val_54 2008-12-31 +val_57 val_57 val_57 2008-12-31 +val_58 val_58 val_58 2008-12-31 +val_58 val_58 val_58 2008-12-31 +val_64 val_64 val_64 2008-12-31 +val_65 val_65 val_65 2008-12-31 +val_66 val_66 val_66 2008-12-31 +val_67 val_67 val_67 2008-12-31 +val_67 val_67 val_67 2008-12-31 +val_69 val_69 val_69 2008-12-31 +val_70 val_70 val_70 2008-12-31 +val_70 val_70 val_70 2008-12-31 +val_70 val_70 val_70 2008-12-31 +val_72 val_72 val_72 2008-12-31 +val_72 val_72 val_72 2008-12-31 +val_74 val_74 val_74 2008-12-31 +val_76 val_76 val_76 2008-12-31 +val_76 val_76 val_76 2008-12-31 +val_77 val_77 val_77 2008-12-31 +val_78 val_78 val_78 2008-12-31 +val_8 val_8 val_8 2008-12-31 +val_80 val_80 val_80 2008-12-31 +val_82 val_82 val_82 2008-12-31 +val_83 val_83 val_83 2008-12-31 +val_83 val_83 val_83 2008-12-31 +val_84 val_84 val_84 2008-12-31 +val_84 val_84 val_84 2008-12-31 +val_85 val_85 val_85 2008-12-31 +val_86 val_86 val_86 2008-12-31 +val_87 val_87 val_87 2008-12-31 +val_9 val_9 val_9 2008-12-31 +val_90 val_90 val_90 2008-12-31 +val_90 val_90 val_90 2008-12-31 +val_90 val_90 val_90 2008-12-31 +val_92 val_92 val_92 2008-12-31 +val_95 val_95 val_95 2008-12-31 +val_95 val_95 val_95 2008-12-31 +val_96 val_96 val_96 2008-12-31 +val_97 val_97 val_97 2008-12-31 +val_97 val_97 val_97 2008-12-31 +val_98 val_98 val_98 2008-12-31 +val_98 val_98 val_98 2008-12-31 +PREHOOK: query: explain +from source_hive_602_table +insert overwrite table destination_hive_602_table partition(ds) select value as value1, value as value2, value as value3, ds order by value3 +PREHOOK: type: QUERY +POSTHOOK: query: explain +from source_hive_602_table +insert overwrite table destination_hive_602_table partition(ds) select value as value1, value as value2, value as value3, ds order by value3 +POSTHOOK: type: QUERY +STAGE DEPENDENCIES: + Stage-1 is a root stage + Stage-2 depends on stages: Stage-1 + Stage-0 depends on stages: Stage-2 + Stage-3 depends on stages: Stage-0 + +STAGE PLANS: + Stage: Stage-1 + Map Reduce + Map Operator Tree: + TableScan + alias: source_hive_602_table + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: value (type: string), ds (type: string) + outputColumnNames: _col2, _col3 + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + Reduce Output Operator + key expressions: _col2 (type: string) + sort order: + + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + value expressions: _col3 (type: string) + Reduce Operator Tree: + Select Operator + expressions: KEY.reducesinkkey0 (type: string), KEY.reducesinkkey0 (type: string), KEY.reducesinkkey0 (type: string), VALUE._col0 (type: string) + outputColumnNames: _col0, _col1, _col2, _col3 + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + File Output Operator + compressed: false + table: + input format: org.apache.hadoop.mapred.SequenceFileInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe + + Stage: Stage-2 + Map Reduce + Map Operator Tree: + TableScan + Reduce Output Operator + key expressions: _col3 (type: string), _col2 (type: string) + sort order: ++ + Map-reduce partition columns: _col3 (type: string) + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string) + Reduce Operator Tree: + Extract + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + File Output Operator + compressed: false + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + name: default.destination_hive_602_table + + Stage: Stage-0 + Move Operator + tables: + partition: + ds + replace: true + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + name: default.destination_hive_602_table + + Stage: Stage-3 + Stats-Aggr Operator + +PREHOOK: query: from source_hive_602_table +insert overwrite table destination_hive_602_table partition(ds) select value as value1, value as value2, value as value3, ds order by value3 +PREHOOK: type: QUERY +PREHOOK: Input: default@source_hive_602_table +PREHOOK: Input: default@source_hive_602_table@ds=2008-12-31/hr=11 +PREHOOK: Output: default@destination_hive_602_table +POSTHOOK: query: from source_hive_602_table +insert overwrite table destination_hive_602_table partition(ds) select value as value1, value as value2, value as value3, ds order by value3 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@source_hive_602_table +POSTHOOK: Input: default@source_hive_602_table@ds=2008-12-31/hr=11 +POSTHOOK: Output: default@destination_hive_602_table@ds=2008-12-31 +POSTHOOK: Lineage: destination_hive_602_table PARTITION(ds=2008-12-31).bar1 SIMPLE [(source_hive_602_table)source_hive_602_table.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: destination_hive_602_table PARTITION(ds=2008-12-31).bar2 SIMPLE [(source_hive_602_table)source_hive_602_table.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: destination_hive_602_table PARTITION(ds=2008-12-31).bar3 SIMPLE [(source_hive_602_table)source_hive_602_table.FieldSchema(name:value, type:string, comment:default), ] +PREHOOK: query: show partitions destination_hive_602_table +PREHOOK: type: SHOWPARTITIONS +PREHOOK: Input: default@destination_hive_602_table +POSTHOOK: query: show partitions destination_hive_602_table +POSTHOOK: type: SHOWPARTITIONS +POSTHOOK: Input: default@destination_hive_602_table +ds=2008-12-31 +PREHOOK: query: select * from destination_hive_602_table +PREHOOK: type: QUERY +PREHOOK: Input: default@destination_hive_602_table +PREHOOK: Input: default@destination_hive_602_table@ds=2008-12-31 +#### A masked pattern was here #### +POSTHOOK: query: select * from destination_hive_602_table +POSTHOOK: type: QUERY +POSTHOOK: Input: default@destination_hive_602_table +POSTHOOK: Input: default@destination_hive_602_table@ds=2008-12-31 +#### A masked pattern was here #### +val_0 val_0 val_0 2008-12-31 +val_0 val_0 val_0 2008-12-31 +val_0 val_0 val_0 2008-12-31 +val_10 val_10 val_10 2008-12-31 +val_100 val_100 val_100 2008-12-31 +val_100 val_100 val_100 2008-12-31 +val_103 val_103 val_103 2008-12-31 +val_103 val_103 val_103 2008-12-31 +val_104 val_104 val_104 2008-12-31 +val_104 val_104 val_104 2008-12-31 +val_105 val_105 val_105 2008-12-31 +val_11 val_11 val_11 2008-12-31 +val_111 val_111 val_111 2008-12-31 +val_113 val_113 val_113 2008-12-31 +val_113 val_113 val_113 2008-12-31 +val_114 val_114 val_114 2008-12-31 +val_116 val_116 val_116 2008-12-31 +val_118 val_118 val_118 2008-12-31 +val_118 val_118 val_118 2008-12-31 +val_119 val_119 val_119 2008-12-31 +val_119 val_119 val_119 2008-12-31 +val_119 val_119 val_119 2008-12-31 +val_12 val_12 val_12 2008-12-31 +val_12 val_12 val_12 2008-12-31 +val_120 val_120 val_120 2008-12-31 +val_120 val_120 val_120 2008-12-31 +val_125 val_125 val_125 2008-12-31 +val_125 val_125 val_125 2008-12-31 +val_126 val_126 val_126 2008-12-31 +val_128 val_128 val_128 2008-12-31 +val_128 val_128 val_128 2008-12-31 +val_128 val_128 val_128 2008-12-31 +val_129 val_129 val_129 2008-12-31 +val_129 val_129 val_129 2008-12-31 +val_131 val_131 val_131 2008-12-31 +val_133 val_133 val_133 2008-12-31 +val_134 val_134 val_134 2008-12-31 +val_134 val_134 val_134 2008-12-31 +val_136 val_136 val_136 2008-12-31 +val_137 val_137 val_137 2008-12-31 +val_137 val_137 val_137 2008-12-31 +val_138 val_138 val_138 2008-12-31 +val_138 val_138 val_138 2008-12-31 +val_138 val_138 val_138 2008-12-31 +val_138 val_138 val_138 2008-12-31 +val_143 val_143 val_143 2008-12-31 +val_145 val_145 val_145 2008-12-31 +val_146 val_146 val_146 2008-12-31 +val_146 val_146 val_146 2008-12-31 +val_149 val_149 val_149 2008-12-31 +val_149 val_149 val_149 2008-12-31 +val_15 val_15 val_15 2008-12-31 +val_15 val_15 val_15 2008-12-31 +val_150 val_150 val_150 2008-12-31 +val_152 val_152 val_152 2008-12-31 +val_152 val_152 val_152 2008-12-31 +val_153 val_153 val_153 2008-12-31 +val_155 val_155 val_155 2008-12-31 +val_156 val_156 val_156 2008-12-31 +val_157 val_157 val_157 2008-12-31 +val_158 val_158 val_158 2008-12-31 +val_160 val_160 val_160 2008-12-31 +val_162 val_162 val_162 2008-12-31 +val_163 val_163 val_163 2008-12-31 +val_164 val_164 val_164 2008-12-31 +val_164 val_164 val_164 2008-12-31 +val_165 val_165 val_165 2008-12-31 +val_165 val_165 val_165 2008-12-31 +val_166 val_166 val_166 2008-12-31 +val_167 val_167 val_167 2008-12-31 +val_167 val_167 val_167 2008-12-31 +val_167 val_167 val_167 2008-12-31 +val_168 val_168 val_168 2008-12-31 +val_169 val_169 val_169 2008-12-31 +val_169 val_169 val_169 2008-12-31 +val_169 val_169 val_169 2008-12-31 +val_169 val_169 val_169 2008-12-31 +val_17 val_17 val_17 2008-12-31 +val_170 val_170 val_170 2008-12-31 +val_172 val_172 val_172 2008-12-31 +val_172 val_172 val_172 2008-12-31 +val_174 val_174 val_174 2008-12-31 +val_174 val_174 val_174 2008-12-31 +val_175 val_175 val_175 2008-12-31 +val_175 val_175 val_175 2008-12-31 +val_176 val_176 val_176 2008-12-31 +val_176 val_176 val_176 2008-12-31 +val_177 val_177 val_177 2008-12-31 +val_178 val_178 val_178 2008-12-31 +val_179 val_179 val_179 2008-12-31 +val_179 val_179 val_179 2008-12-31 +val_18 val_18 val_18 2008-12-31 +val_18 val_18 val_18 2008-12-31 +val_180 val_180 val_180 2008-12-31 +val_181 val_181 val_181 2008-12-31 +val_183 val_183 val_183 2008-12-31 +val_186 val_186 val_186 2008-12-31 +val_187 val_187 val_187 2008-12-31 +val_187 val_187 val_187 2008-12-31 +val_187 val_187 val_187 2008-12-31 +val_189 val_189 val_189 2008-12-31 +val_19 val_19 val_19 2008-12-31 +val_190 val_190 val_190 2008-12-31 +val_191 val_191 val_191 2008-12-31 +val_191 val_191 val_191 2008-12-31 +val_192 val_192 val_192 2008-12-31 +val_193 val_193 val_193 2008-12-31 +val_193 val_193 val_193 2008-12-31 +val_193 val_193 val_193 2008-12-31 +val_194 val_194 val_194 2008-12-31 +val_195 val_195 val_195 2008-12-31 +val_195 val_195 val_195 2008-12-31 +val_196 val_196 val_196 2008-12-31 +val_197 val_197 val_197 2008-12-31 +val_197 val_197 val_197 2008-12-31 +val_199 val_199 val_199 2008-12-31 +val_199 val_199 val_199 2008-12-31 +val_199 val_199 val_199 2008-12-31 +val_2 val_2 val_2 2008-12-31 +val_20 val_20 val_20 2008-12-31 +val_200 val_200 val_200 2008-12-31 +val_200 val_200 val_200 2008-12-31 +val_201 val_201 val_201 2008-12-31 +val_202 val_202 val_202 2008-12-31 +val_203 val_203 val_203 2008-12-31 +val_203 val_203 val_203 2008-12-31 +val_205 val_205 val_205 2008-12-31 +val_205 val_205 val_205 2008-12-31 +val_207 val_207 val_207 2008-12-31 +val_207 val_207 val_207 2008-12-31 +val_208 val_208 val_208 2008-12-31 +val_208 val_208 val_208 2008-12-31 +val_208 val_208 val_208 2008-12-31 +val_209 val_209 val_209 2008-12-31 +val_209 val_209 val_209 2008-12-31 +val_213 val_213 val_213 2008-12-31 +val_213 val_213 val_213 2008-12-31 +val_214 val_214 val_214 2008-12-31 +val_216 val_216 val_216 2008-12-31 +val_216 val_216 val_216 2008-12-31 +val_217 val_217 val_217 2008-12-31 +val_217 val_217 val_217 2008-12-31 +val_218 val_218 val_218 2008-12-31 +val_219 val_219 val_219 2008-12-31 +val_219 val_219 val_219 2008-12-31 +val_221 val_221 val_221 2008-12-31 +val_221 val_221 val_221 2008-12-31 +val_222 val_222 val_222 2008-12-31 +val_223 val_223 val_223 2008-12-31 +val_223 val_223 val_223 2008-12-31 +val_224 val_224 val_224 2008-12-31 +val_224 val_224 val_224 2008-12-31 +val_226 val_226 val_226 2008-12-31 +val_228 val_228 val_228 2008-12-31 +val_229 val_229 val_229 2008-12-31 +val_229 val_229 val_229 2008-12-31 +val_230 val_230 val_230 2008-12-31 +val_230 val_230 val_230 2008-12-31 +val_230 val_230 val_230 2008-12-31 +val_230 val_230 val_230 2008-12-31 +val_230 val_230 val_230 2008-12-31 +val_233 val_233 val_233 2008-12-31 +val_233 val_233 val_233 2008-12-31 +val_235 val_235 val_235 2008-12-31 +val_237 val_237 val_237 2008-12-31 +val_237 val_237 val_237 2008-12-31 +val_238 val_238 val_238 2008-12-31 +val_238 val_238 val_238 2008-12-31 +val_239 val_239 val_239 2008-12-31 +val_239 val_239 val_239 2008-12-31 +val_24 val_24 val_24 2008-12-31 +val_24 val_24 val_24 2008-12-31 +val_241 val_241 val_241 2008-12-31 +val_242 val_242 val_242 2008-12-31 +val_242 val_242 val_242 2008-12-31 +val_244 val_244 val_244 2008-12-31 +val_247 val_247 val_247 2008-12-31 +val_248 val_248 val_248 2008-12-31 +val_249 val_249 val_249 2008-12-31 +val_252 val_252 val_252 2008-12-31 +val_255 val_255 val_255 2008-12-31 +val_255 val_255 val_255 2008-12-31 +val_256 val_256 val_256 2008-12-31 +val_256 val_256 val_256 2008-12-31 +val_257 val_257 val_257 2008-12-31 +val_258 val_258 val_258 2008-12-31 +val_26 val_26 val_26 2008-12-31 +val_26 val_26 val_26 2008-12-31 +val_260 val_260 val_260 2008-12-31 +val_262 val_262 val_262 2008-12-31 +val_263 val_263 val_263 2008-12-31 +val_265 val_265 val_265 2008-12-31 +val_265 val_265 val_265 2008-12-31 +val_266 val_266 val_266 2008-12-31 +val_27 val_27 val_27 2008-12-31 +val_272 val_272 val_272 2008-12-31 +val_272 val_272 val_272 2008-12-31 +val_273 val_273 val_273 2008-12-31 +val_273 val_273 val_273 2008-12-31 +val_273 val_273 val_273 2008-12-31 +val_274 val_274 val_274 2008-12-31 +val_275 val_275 val_275 2008-12-31 +val_277 val_277 val_277 2008-12-31 +val_277 val_277 val_277 2008-12-31 +val_277 val_277 val_277 2008-12-31 +val_277 val_277 val_277 2008-12-31 +val_278 val_278 val_278 2008-12-31 +val_278 val_278 val_278 2008-12-31 +val_28 val_28 val_28 2008-12-31 +val_280 val_280 val_280 2008-12-31 +val_280 val_280 val_280 2008-12-31 +val_281 val_281 val_281 2008-12-31 +val_281 val_281 val_281 2008-12-31 +val_282 val_282 val_282 2008-12-31 +val_282 val_282 val_282 2008-12-31 +val_283 val_283 val_283 2008-12-31 +val_284 val_284 val_284 2008-12-31 +val_285 val_285 val_285 2008-12-31 +val_286 val_286 val_286 2008-12-31 +val_287 val_287 val_287 2008-12-31 +val_288 val_288 val_288 2008-12-31 +val_288 val_288 val_288 2008-12-31 +val_289 val_289 val_289 2008-12-31 +val_291 val_291 val_291 2008-12-31 +val_292 val_292 val_292 2008-12-31 +val_296 val_296 val_296 2008-12-31 +val_298 val_298 val_298 2008-12-31 +val_298 val_298 val_298 2008-12-31 +val_298 val_298 val_298 2008-12-31 +val_30 val_30 val_30 2008-12-31 +val_302 val_302 val_302 2008-12-31 +val_305 val_305 val_305 2008-12-31 +val_306 val_306 val_306 2008-12-31 +val_307 val_307 val_307 2008-12-31 +val_307 val_307 val_307 2008-12-31 +val_308 val_308 val_308 2008-12-31 +val_309 val_309 val_309 2008-12-31 +val_309 val_309 val_309 2008-12-31 +val_310 val_310 val_310 2008-12-31 +val_311 val_311 val_311 2008-12-31 +val_311 val_311 val_311 2008-12-31 +val_311 val_311 val_311 2008-12-31 +val_315 val_315 val_315 2008-12-31 +val_316 val_316 val_316 2008-12-31 +val_316 val_316 val_316 2008-12-31 +val_316 val_316 val_316 2008-12-31 +val_317 val_317 val_317 2008-12-31 +val_317 val_317 val_317 2008-12-31 +val_318 val_318 val_318 2008-12-31 +val_318 val_318 val_318 2008-12-31 +val_318 val_318 val_318 2008-12-31 +val_321 val_321 val_321 2008-12-31 +val_321 val_321 val_321 2008-12-31 +val_322 val_322 val_322 2008-12-31 +val_322 val_322 val_322 2008-12-31 +val_323 val_323 val_323 2008-12-31 +val_325 val_325 val_325 2008-12-31 +val_325 val_325 val_325 2008-12-31 +val_327 val_327 val_327 2008-12-31 +val_327 val_327 val_327 2008-12-31 +val_327 val_327 val_327 2008-12-31 +val_33 val_33 val_33 2008-12-31 +val_331 val_331 val_331 2008-12-31 +val_331 val_331 val_331 2008-12-31 +val_332 val_332 val_332 2008-12-31 +val_333 val_333 val_333 2008-12-31 +val_333 val_333 val_333 2008-12-31 +val_335 val_335 val_335 2008-12-31 +val_336 val_336 val_336 2008-12-31 +val_338 val_338 val_338 2008-12-31 +val_339 val_339 val_339 2008-12-31 +val_34 val_34 val_34 2008-12-31 +val_341 val_341 val_341 2008-12-31 +val_342 val_342 val_342 2008-12-31 +val_342 val_342 val_342 2008-12-31 +val_344 val_344 val_344 2008-12-31 +val_344 val_344 val_344 2008-12-31 +val_345 val_345 val_345 2008-12-31 +val_348 val_348 val_348 2008-12-31 +val_348 val_348 val_348 2008-12-31 +val_348 val_348 val_348 2008-12-31 +val_348 val_348 val_348 2008-12-31 +val_348 val_348 val_348 2008-12-31 +val_35 val_35 val_35 2008-12-31 +val_35 val_35 val_35 2008-12-31 +val_35 val_35 val_35 2008-12-31 +val_351 val_351 val_351 2008-12-31 +val_353 val_353 val_353 2008-12-31 +val_353 val_353 val_353 2008-12-31 +val_356 val_356 val_356 2008-12-31 +val_360 val_360 val_360 2008-12-31 +val_362 val_362 val_362 2008-12-31 +val_364 val_364 val_364 2008-12-31 +val_365 val_365 val_365 2008-12-31 +val_366 val_366 val_366 2008-12-31 +val_367 val_367 val_367 2008-12-31 +val_367 val_367 val_367 2008-12-31 +val_368 val_368 val_368 2008-12-31 +val_369 val_369 val_369 2008-12-31 +val_369 val_369 val_369 2008-12-31 +val_369 val_369 val_369 2008-12-31 +val_37 val_37 val_37 2008-12-31 +val_37 val_37 val_37 2008-12-31 +val_373 val_373 val_373 2008-12-31 +val_374 val_374 val_374 2008-12-31 +val_375 val_375 val_375 2008-12-31 +val_377 val_377 val_377 2008-12-31 +val_378 val_378 val_378 2008-12-31 +val_379 val_379 val_379 2008-12-31 +val_382 val_382 val_382 2008-12-31 +val_382 val_382 val_382 2008-12-31 +val_384 val_384 val_384 2008-12-31 +val_384 val_384 val_384 2008-12-31 +val_384 val_384 val_384 2008-12-31 +val_386 val_386 val_386 2008-12-31 +val_389 val_389 val_389 2008-12-31 +val_392 val_392 val_392 2008-12-31 +val_393 val_393 val_393 2008-12-31 +val_394 val_394 val_394 2008-12-31 +val_395 val_395 val_395 2008-12-31 +val_395 val_395 val_395 2008-12-31 +val_396 val_396 val_396 2008-12-31 +val_396 val_396 val_396 2008-12-31 +val_396 val_396 val_396 2008-12-31 +val_397 val_397 val_397 2008-12-31 +val_397 val_397 val_397 2008-12-31 +val_399 val_399 val_399 2008-12-31 +val_399 val_399 val_399 2008-12-31 +val_4 val_4 val_4 2008-12-31 +val_400 val_400 val_400 2008-12-31 +val_401 val_401 val_401 2008-12-31 +val_401 val_401 val_401 2008-12-31 +val_401 val_401 val_401 2008-12-31 +val_401 val_401 val_401 2008-12-31 +val_401 val_401 val_401 2008-12-31 +val_402 val_402 val_402 2008-12-31 +val_403 val_403 val_403 2008-12-31 +val_403 val_403 val_403 2008-12-31 +val_403 val_403 val_403 2008-12-31 +val_404 val_404 val_404 2008-12-31 +val_404 val_404 val_404 2008-12-31 +val_406 val_406 val_406 2008-12-31 +val_406 val_406 val_406 2008-12-31 +val_406 val_406 val_406 2008-12-31 +val_406 val_406 val_406 2008-12-31 +val_407 val_407 val_407 2008-12-31 +val_409 val_409 val_409 2008-12-31 +val_409 val_409 val_409 2008-12-31 +val_409 val_409 val_409 2008-12-31 +val_41 val_41 val_41 2008-12-31 +val_411 val_411 val_411 2008-12-31 +val_413 val_413 val_413 2008-12-31 +val_413 val_413 val_413 2008-12-31 +val_414 val_414 val_414 2008-12-31 +val_414 val_414 val_414 2008-12-31 +val_417 val_417 val_417 2008-12-31 +val_417 val_417 val_417 2008-12-31 +val_417 val_417 val_417 2008-12-31 +val_418 val_418 val_418 2008-12-31 +val_419 val_419 val_419 2008-12-31 +val_42 val_42 val_42 2008-12-31 +val_42 val_42 val_42 2008-12-31 +val_421 val_421 val_421 2008-12-31 +val_424 val_424 val_424 2008-12-31 +val_424 val_424 val_424 2008-12-31 +val_427 val_427 val_427 2008-12-31 +val_429 val_429 val_429 2008-12-31 +val_429 val_429 val_429 2008-12-31 +val_43 val_43 val_43 2008-12-31 +val_430 val_430 val_430 2008-12-31 +val_430 val_430 val_430 2008-12-31 +val_430 val_430 val_430 2008-12-31 +val_431 val_431 val_431 2008-12-31 +val_431 val_431 val_431 2008-12-31 +val_431 val_431 val_431 2008-12-31 +val_432 val_432 val_432 2008-12-31 +val_435 val_435 val_435 2008-12-31 +val_436 val_436 val_436 2008-12-31 +val_437 val_437 val_437 2008-12-31 +val_438 val_438 val_438 2008-12-31 +val_438 val_438 val_438 2008-12-31 +val_438 val_438 val_438 2008-12-31 +val_439 val_439 val_439 2008-12-31 +val_439 val_439 val_439 2008-12-31 +val_44 val_44 val_44 2008-12-31 +val_443 val_443 val_443 2008-12-31 +val_444 val_444 val_444 2008-12-31 +val_446 val_446 val_446 2008-12-31 +val_448 val_448 val_448 2008-12-31 +val_449 val_449 val_449 2008-12-31 +val_452 val_452 val_452 2008-12-31 +val_453 val_453 val_453 2008-12-31 +val_454 val_454 val_454 2008-12-31 +val_454 val_454 val_454 2008-12-31 +val_454 val_454 val_454 2008-12-31 +val_455 val_455 val_455 2008-12-31 +val_457 val_457 val_457 2008-12-31 +val_458 val_458 val_458 2008-12-31 +val_458 val_458 val_458 2008-12-31 +val_459 val_459 val_459 2008-12-31 +val_459 val_459 val_459 2008-12-31 +val_460 val_460 val_460 2008-12-31 +val_462 val_462 val_462 2008-12-31 +val_462 val_462 val_462 2008-12-31 +val_463 val_463 val_463 2008-12-31 +val_463 val_463 val_463 2008-12-31 +val_466 val_466 val_466 2008-12-31 +val_466 val_466 val_466 2008-12-31 +val_466 val_466 val_466 2008-12-31 +val_467 val_467 val_467 2008-12-31 +val_468 val_468 val_468 2008-12-31 +val_468 val_468 val_468 2008-12-31 +val_468 val_468 val_468 2008-12-31 +val_468 val_468 val_468 2008-12-31 +val_469 val_469 val_469 2008-12-31 +val_469 val_469 val_469 2008-12-31 +val_469 val_469 val_469 2008-12-31 +val_469 val_469 val_469 2008-12-31 +val_469 val_469 val_469 2008-12-31 +val_47 val_47 val_47 2008-12-31 +val_470 val_470 val_470 2008-12-31 +val_472 val_472 val_472 2008-12-31 +val_475 val_475 val_475 2008-12-31 +val_477 val_477 val_477 2008-12-31 +val_478 val_478 val_478 2008-12-31 +val_478 val_478 val_478 2008-12-31 +val_479 val_479 val_479 2008-12-31 +val_480 val_480 val_480 2008-12-31 +val_480 val_480 val_480 2008-12-31 +val_480 val_480 val_480 2008-12-31 +val_481 val_481 val_481 2008-12-31 +val_482 val_482 val_482 2008-12-31 +val_483 val_483 val_483 2008-12-31 +val_484 val_484 val_484 2008-12-31 +val_485 val_485 val_485 2008-12-31 +val_487 val_487 val_487 2008-12-31 +val_489 val_489 val_489 2008-12-31 +val_489 val_489 val_489 2008-12-31 +val_489 val_489 val_489 2008-12-31 +val_489 val_489 val_489 2008-12-31 +val_490 val_490 val_490 2008-12-31 +val_491 val_491 val_491 2008-12-31 +val_492 val_492 val_492 2008-12-31 +val_492 val_492 val_492 2008-12-31 +val_493 val_493 val_493 2008-12-31 +val_494 val_494 val_494 2008-12-31 +val_495 val_495 val_495 2008-12-31 +val_496 val_496 val_496 2008-12-31 +val_497 val_497 val_497 2008-12-31 +val_498 val_498 val_498 2008-12-31 +val_498 val_498 val_498 2008-12-31 +val_498 val_498 val_498 2008-12-31 +val_5 val_5 val_5 2008-12-31 +val_5 val_5 val_5 2008-12-31 +val_5 val_5 val_5 2008-12-31 +val_51 val_51 val_51 2008-12-31 +val_51 val_51 val_51 2008-12-31 +val_53 val_53 val_53 2008-12-31 +val_54 val_54 val_54 2008-12-31 +val_57 val_57 val_57 2008-12-31 +val_58 val_58 val_58 2008-12-31 +val_58 val_58 val_58 2008-12-31 +val_64 val_64 val_64 2008-12-31 +val_65 val_65 val_65 2008-12-31 +val_66 val_66 val_66 2008-12-31 +val_67 val_67 val_67 2008-12-31 +val_67 val_67 val_67 2008-12-31 +val_69 val_69 val_69 2008-12-31 +val_70 val_70 val_70 2008-12-31 +val_70 val_70 val_70 2008-12-31 +val_70 val_70 val_70 2008-12-31 +val_72 val_72 val_72 2008-12-31 +val_72 val_72 val_72 2008-12-31 +val_74 val_74 val_74 2008-12-31 +val_76 val_76 val_76 2008-12-31 +val_76 val_76 val_76 2008-12-31 +val_77 val_77 val_77 2008-12-31 +val_78 val_78 val_78 2008-12-31 +val_8 val_8 val_8 2008-12-31 +val_80 val_80 val_80 2008-12-31 +val_82 val_82 val_82 2008-12-31 +val_83 val_83 val_83 2008-12-31 +val_83 val_83 val_83 2008-12-31 +val_84 val_84 val_84 2008-12-31 +val_84 val_84 val_84 2008-12-31 +val_85 val_85 val_85 2008-12-31 +val_86 val_86 val_86 2008-12-31 +val_87 val_87 val_87 2008-12-31 +val_9 val_9 val_9 2008-12-31 +val_90 val_90 val_90 2008-12-31 +val_90 val_90 val_90 2008-12-31 +val_90 val_90 val_90 2008-12-31 +val_92 val_92 val_92 2008-12-31 +val_95 val_95 val_95 2008-12-31 +val_95 val_95 val_95 2008-12-31 +val_96 val_96 val_96 2008-12-31 +val_97 val_97 val_97 2008-12-31 +val_97 val_97 val_97 2008-12-31 +val_98 val_98 val_98 2008-12-31 +val_98 val_98 val_98 2008-12-31 +PREHOOK: query: explain +from source_hive_602_table +insert overwrite table destination_hive_602_table partition(ds) select value as value1, value as value2, value as value3, ds sort by value3 +PREHOOK: type: QUERY +POSTHOOK: query: explain +from source_hive_602_table +insert overwrite table destination_hive_602_table partition(ds) select value as value1, value as value2, value as value3, ds sort by value3 +POSTHOOK: type: QUERY +STAGE DEPENDENCIES: + Stage-1 is a root stage + Stage-2 depends on stages: Stage-1 + Stage-0 depends on stages: Stage-2 + Stage-3 depends on stages: Stage-0 + +STAGE PLANS: + Stage: Stage-1 + Map Reduce + Map Operator Tree: + TableScan + alias: source_hive_602_table + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: value (type: string), ds (type: string) + outputColumnNames: _col2, _col3 + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + Reduce Output Operator + key expressions: _col2 (type: string) + sort order: + + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + value expressions: _col3 (type: string) + Reduce Operator Tree: + Select Operator + expressions: KEY.reducesinkkey0 (type: string), KEY.reducesinkkey0 (type: string), KEY.reducesinkkey0 (type: string), VALUE._col0 (type: string) + outputColumnNames: _col0, _col1, _col2, _col3 + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + File Output Operator + compressed: false + table: + input format: org.apache.hadoop.mapred.SequenceFileInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe + + Stage: Stage-2 + Map Reduce + Map Operator Tree: + TableScan + Reduce Output Operator + key expressions: _col3 (type: string), _col2 (type: string) + sort order: ++ + Map-reduce partition columns: _col3 (type: string) + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string) + Reduce Operator Tree: + Extract + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + File Output Operator + compressed: false + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + name: default.destination_hive_602_table + + Stage: Stage-0 + Move Operator + tables: + partition: + ds + replace: true + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + name: default.destination_hive_602_table + + Stage: Stage-3 + Stats-Aggr Operator + +PREHOOK: query: from source_hive_602_table +insert overwrite table destination_hive_602_table partition(ds) select value as value1, value as value2, value as value3, ds sort by value3 +PREHOOK: type: QUERY +PREHOOK: Input: default@source_hive_602_table +PREHOOK: Input: default@source_hive_602_table@ds=2008-12-31/hr=11 +PREHOOK: Output: default@destination_hive_602_table +POSTHOOK: query: from source_hive_602_table +insert overwrite table destination_hive_602_table partition(ds) select value as value1, value as value2, value as value3, ds sort by value3 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@source_hive_602_table +POSTHOOK: Input: default@source_hive_602_table@ds=2008-12-31/hr=11 +POSTHOOK: Output: default@destination_hive_602_table@ds=2008-12-31 +POSTHOOK: Lineage: destination_hive_602_table PARTITION(ds=2008-12-31).bar1 SIMPLE [(source_hive_602_table)source_hive_602_table.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: destination_hive_602_table PARTITION(ds=2008-12-31).bar2 SIMPLE [(source_hive_602_table)source_hive_602_table.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: destination_hive_602_table PARTITION(ds=2008-12-31).bar3 SIMPLE [(source_hive_602_table)source_hive_602_table.FieldSchema(name:value, type:string, comment:default), ] +PREHOOK: query: show partitions destination_hive_602_table +PREHOOK: type: SHOWPARTITIONS +PREHOOK: Input: default@destination_hive_602_table +POSTHOOK: query: show partitions destination_hive_602_table +POSTHOOK: type: SHOWPARTITIONS +POSTHOOK: Input: default@destination_hive_602_table +ds=2008-12-31 +PREHOOK: query: select * from destination_hive_602_table +PREHOOK: type: QUERY +PREHOOK: Input: default@destination_hive_602_table +PREHOOK: Input: default@destination_hive_602_table@ds=2008-12-31 +#### A masked pattern was here #### +POSTHOOK: query: select * from destination_hive_602_table +POSTHOOK: type: QUERY +POSTHOOK: Input: default@destination_hive_602_table +POSTHOOK: Input: default@destination_hive_602_table@ds=2008-12-31 +#### A masked pattern was here #### +val_0 val_0 val_0 2008-12-31 +val_0 val_0 val_0 2008-12-31 +val_0 val_0 val_0 2008-12-31 +val_10 val_10 val_10 2008-12-31 +val_100 val_100 val_100 2008-12-31 +val_100 val_100 val_100 2008-12-31 +val_103 val_103 val_103 2008-12-31 +val_103 val_103 val_103 2008-12-31 +val_104 val_104 val_104 2008-12-31 +val_104 val_104 val_104 2008-12-31 +val_105 val_105 val_105 2008-12-31 +val_11 val_11 val_11 2008-12-31 +val_111 val_111 val_111 2008-12-31 +val_113 val_113 val_113 2008-12-31 +val_113 val_113 val_113 2008-12-31 +val_114 val_114 val_114 2008-12-31 +val_116 val_116 val_116 2008-12-31 +val_118 val_118 val_118 2008-12-31 +val_118 val_118 val_118 2008-12-31 +val_119 val_119 val_119 2008-12-31 +val_119 val_119 val_119 2008-12-31 +val_119 val_119 val_119 2008-12-31 +val_12 val_12 val_12 2008-12-31 +val_12 val_12 val_12 2008-12-31 +val_120 val_120 val_120 2008-12-31 +val_120 val_120 val_120 2008-12-31 +val_125 val_125 val_125 2008-12-31 +val_125 val_125 val_125 2008-12-31 +val_126 val_126 val_126 2008-12-31 +val_128 val_128 val_128 2008-12-31 +val_128 val_128 val_128 2008-12-31 +val_128 val_128 val_128 2008-12-31 +val_129 val_129 val_129 2008-12-31 +val_129 val_129 val_129 2008-12-31 +val_131 val_131 val_131 2008-12-31 +val_133 val_133 val_133 2008-12-31 +val_134 val_134 val_134 2008-12-31 +val_134 val_134 val_134 2008-12-31 +val_136 val_136 val_136 2008-12-31 +val_137 val_137 val_137 2008-12-31 +val_137 val_137 val_137 2008-12-31 +val_138 val_138 val_138 2008-12-31 +val_138 val_138 val_138 2008-12-31 +val_138 val_138 val_138 2008-12-31 +val_138 val_138 val_138 2008-12-31 +val_143 val_143 val_143 2008-12-31 +val_145 val_145 val_145 2008-12-31 +val_146 val_146 val_146 2008-12-31 +val_146 val_146 val_146 2008-12-31 +val_149 val_149 val_149 2008-12-31 +val_149 val_149 val_149 2008-12-31 +val_15 val_15 val_15 2008-12-31 +val_15 val_15 val_15 2008-12-31 +val_150 val_150 val_150 2008-12-31 +val_152 val_152 val_152 2008-12-31 +val_152 val_152 val_152 2008-12-31 +val_153 val_153 val_153 2008-12-31 +val_155 val_155 val_155 2008-12-31 +val_156 val_156 val_156 2008-12-31 +val_157 val_157 val_157 2008-12-31 +val_158 val_158 val_158 2008-12-31 +val_160 val_160 val_160 2008-12-31 +val_162 val_162 val_162 2008-12-31 +val_163 val_163 val_163 2008-12-31 +val_164 val_164 val_164 2008-12-31 +val_164 val_164 val_164 2008-12-31 +val_165 val_165 val_165 2008-12-31 +val_165 val_165 val_165 2008-12-31 +val_166 val_166 val_166 2008-12-31 +val_167 val_167 val_167 2008-12-31 +val_167 val_167 val_167 2008-12-31 +val_167 val_167 val_167 2008-12-31 +val_168 val_168 val_168 2008-12-31 +val_169 val_169 val_169 2008-12-31 +val_169 val_169 val_169 2008-12-31 +val_169 val_169 val_169 2008-12-31 +val_169 val_169 val_169 2008-12-31 +val_17 val_17 val_17 2008-12-31 +val_170 val_170 val_170 2008-12-31 +val_172 val_172 val_172 2008-12-31 +val_172 val_172 val_172 2008-12-31 +val_174 val_174 val_174 2008-12-31 +val_174 val_174 val_174 2008-12-31 +val_175 val_175 val_175 2008-12-31 +val_175 val_175 val_175 2008-12-31 +val_176 val_176 val_176 2008-12-31 +val_176 val_176 val_176 2008-12-31 +val_177 val_177 val_177 2008-12-31 +val_178 val_178 val_178 2008-12-31 +val_179 val_179 val_179 2008-12-31 +val_179 val_179 val_179 2008-12-31 +val_18 val_18 val_18 2008-12-31 +val_18 val_18 val_18 2008-12-31 +val_180 val_180 val_180 2008-12-31 +val_181 val_181 val_181 2008-12-31 +val_183 val_183 val_183 2008-12-31 +val_186 val_186 val_186 2008-12-31 +val_187 val_187 val_187 2008-12-31 +val_187 val_187 val_187 2008-12-31 +val_187 val_187 val_187 2008-12-31 +val_189 val_189 val_189 2008-12-31 +val_19 val_19 val_19 2008-12-31 +val_190 val_190 val_190 2008-12-31 +val_191 val_191 val_191 2008-12-31 +val_191 val_191 val_191 2008-12-31 +val_192 val_192 val_192 2008-12-31 +val_193 val_193 val_193 2008-12-31 +val_193 val_193 val_193 2008-12-31 +val_193 val_193 val_193 2008-12-31 +val_194 val_194 val_194 2008-12-31 +val_195 val_195 val_195 2008-12-31 +val_195 val_195 val_195 2008-12-31 +val_196 val_196 val_196 2008-12-31 +val_197 val_197 val_197 2008-12-31 +val_197 val_197 val_197 2008-12-31 +val_199 val_199 val_199 2008-12-31 +val_199 val_199 val_199 2008-12-31 +val_199 val_199 val_199 2008-12-31 +val_2 val_2 val_2 2008-12-31 +val_20 val_20 val_20 2008-12-31 +val_200 val_200 val_200 2008-12-31 +val_200 val_200 val_200 2008-12-31 +val_201 val_201 val_201 2008-12-31 +val_202 val_202 val_202 2008-12-31 +val_203 val_203 val_203 2008-12-31 +val_203 val_203 val_203 2008-12-31 +val_205 val_205 val_205 2008-12-31 +val_205 val_205 val_205 2008-12-31 +val_207 val_207 val_207 2008-12-31 +val_207 val_207 val_207 2008-12-31 +val_208 val_208 val_208 2008-12-31 +val_208 val_208 val_208 2008-12-31 +val_208 val_208 val_208 2008-12-31 +val_209 val_209 val_209 2008-12-31 +val_209 val_209 val_209 2008-12-31 +val_213 val_213 val_213 2008-12-31 +val_213 val_213 val_213 2008-12-31 +val_214 val_214 val_214 2008-12-31 +val_216 val_216 val_216 2008-12-31 +val_216 val_216 val_216 2008-12-31 +val_217 val_217 val_217 2008-12-31 +val_217 val_217 val_217 2008-12-31 +val_218 val_218 val_218 2008-12-31 +val_219 val_219 val_219 2008-12-31 +val_219 val_219 val_219 2008-12-31 +val_221 val_221 val_221 2008-12-31 +val_221 val_221 val_221 2008-12-31 +val_222 val_222 val_222 2008-12-31 +val_223 val_223 val_223 2008-12-31 +val_223 val_223 val_223 2008-12-31 +val_224 val_224 val_224 2008-12-31 +val_224 val_224 val_224 2008-12-31 +val_226 val_226 val_226 2008-12-31 +val_228 val_228 val_228 2008-12-31 +val_229 val_229 val_229 2008-12-31 +val_229 val_229 val_229 2008-12-31 +val_230 val_230 val_230 2008-12-31 +val_230 val_230 val_230 2008-12-31 +val_230 val_230 val_230 2008-12-31 +val_230 val_230 val_230 2008-12-31 +val_230 val_230 val_230 2008-12-31 +val_233 val_233 val_233 2008-12-31 +val_233 val_233 val_233 2008-12-31 +val_235 val_235 val_235 2008-12-31 +val_237 val_237 val_237 2008-12-31 +val_237 val_237 val_237 2008-12-31 +val_238 val_238 val_238 2008-12-31 +val_238 val_238 val_238 2008-12-31 +val_239 val_239 val_239 2008-12-31 +val_239 val_239 val_239 2008-12-31 +val_24 val_24 val_24 2008-12-31 +val_24 val_24 val_24 2008-12-31 +val_241 val_241 val_241 2008-12-31 +val_242 val_242 val_242 2008-12-31 +val_242 val_242 val_242 2008-12-31 +val_244 val_244 val_244 2008-12-31 +val_247 val_247 val_247 2008-12-31 +val_248 val_248 val_248 2008-12-31 +val_249 val_249 val_249 2008-12-31 +val_252 val_252 val_252 2008-12-31 +val_255 val_255 val_255 2008-12-31 +val_255 val_255 val_255 2008-12-31 +val_256 val_256 val_256 2008-12-31 +val_256 val_256 val_256 2008-12-31 +val_257 val_257 val_257 2008-12-31 +val_258 val_258 val_258 2008-12-31 +val_26 val_26 val_26 2008-12-31 +val_26 val_26 val_26 2008-12-31 +val_260 val_260 val_260 2008-12-31 +val_262 val_262 val_262 2008-12-31 +val_263 val_263 val_263 2008-12-31 +val_265 val_265 val_265 2008-12-31 +val_265 val_265 val_265 2008-12-31 +val_266 val_266 val_266 2008-12-31 +val_27 val_27 val_27 2008-12-31 +val_272 val_272 val_272 2008-12-31 +val_272 val_272 val_272 2008-12-31 +val_273 val_273 val_273 2008-12-31 +val_273 val_273 val_273 2008-12-31 +val_273 val_273 val_273 2008-12-31 +val_274 val_274 val_274 2008-12-31 +val_275 val_275 val_275 2008-12-31 +val_277 val_277 val_277 2008-12-31 +val_277 val_277 val_277 2008-12-31 +val_277 val_277 val_277 2008-12-31 +val_277 val_277 val_277 2008-12-31 +val_278 val_278 val_278 2008-12-31 +val_278 val_278 val_278 2008-12-31 +val_28 val_28 val_28 2008-12-31 +val_280 val_280 val_280 2008-12-31 +val_280 val_280 val_280 2008-12-31 +val_281 val_281 val_281 2008-12-31 +val_281 val_281 val_281 2008-12-31 +val_282 val_282 val_282 2008-12-31 +val_282 val_282 val_282 2008-12-31 +val_283 val_283 val_283 2008-12-31 +val_284 val_284 val_284 2008-12-31 +val_285 val_285 val_285 2008-12-31 +val_286 val_286 val_286 2008-12-31 +val_287 val_287 val_287 2008-12-31 +val_288 val_288 val_288 2008-12-31 +val_288 val_288 val_288 2008-12-31 +val_289 val_289 val_289 2008-12-31 +val_291 val_291 val_291 2008-12-31 +val_292 val_292 val_292 2008-12-31 +val_296 val_296 val_296 2008-12-31 +val_298 val_298 val_298 2008-12-31 +val_298 val_298 val_298 2008-12-31 +val_298 val_298 val_298 2008-12-31 +val_30 val_30 val_30 2008-12-31 +val_302 val_302 val_302 2008-12-31 +val_305 val_305 val_305 2008-12-31 +val_306 val_306 val_306 2008-12-31 +val_307 val_307 val_307 2008-12-31 +val_307 val_307 val_307 2008-12-31 +val_308 val_308 val_308 2008-12-31 +val_309 val_309 val_309 2008-12-31 +val_309 val_309 val_309 2008-12-31 +val_310 val_310 val_310 2008-12-31 +val_311 val_311 val_311 2008-12-31 +val_311 val_311 val_311 2008-12-31 +val_311 val_311 val_311 2008-12-31 +val_315 val_315 val_315 2008-12-31 +val_316 val_316 val_316 2008-12-31 +val_316 val_316 val_316 2008-12-31 +val_316 val_316 val_316 2008-12-31 +val_317 val_317 val_317 2008-12-31 +val_317 val_317 val_317 2008-12-31 +val_318 val_318 val_318 2008-12-31 +val_318 val_318 val_318 2008-12-31 +val_318 val_318 val_318 2008-12-31 +val_321 val_321 val_321 2008-12-31 +val_321 val_321 val_321 2008-12-31 +val_322 val_322 val_322 2008-12-31 +val_322 val_322 val_322 2008-12-31 +val_323 val_323 val_323 2008-12-31 +val_325 val_325 val_325 2008-12-31 +val_325 val_325 val_325 2008-12-31 +val_327 val_327 val_327 2008-12-31 +val_327 val_327 val_327 2008-12-31 +val_327 val_327 val_327 2008-12-31 +val_33 val_33 val_33 2008-12-31 +val_331 val_331 val_331 2008-12-31 +val_331 val_331 val_331 2008-12-31 +val_332 val_332 val_332 2008-12-31 +val_333 val_333 val_333 2008-12-31 +val_333 val_333 val_333 2008-12-31 +val_335 val_335 val_335 2008-12-31 +val_336 val_336 val_336 2008-12-31 +val_338 val_338 val_338 2008-12-31 +val_339 val_339 val_339 2008-12-31 +val_34 val_34 val_34 2008-12-31 +val_341 val_341 val_341 2008-12-31 +val_342 val_342 val_342 2008-12-31 +val_342 val_342 val_342 2008-12-31 +val_344 val_344 val_344 2008-12-31 +val_344 val_344 val_344 2008-12-31 +val_345 val_345 val_345 2008-12-31 +val_348 val_348 val_348 2008-12-31 +val_348 val_348 val_348 2008-12-31 +val_348 val_348 val_348 2008-12-31 +val_348 val_348 val_348 2008-12-31 +val_348 val_348 val_348 2008-12-31 +val_35 val_35 val_35 2008-12-31 +val_35 val_35 val_35 2008-12-31 +val_35 val_35 val_35 2008-12-31 +val_351 val_351 val_351 2008-12-31 +val_353 val_353 val_353 2008-12-31 +val_353 val_353 val_353 2008-12-31 +val_356 val_356 val_356 2008-12-31 +val_360 val_360 val_360 2008-12-31 +val_362 val_362 val_362 2008-12-31 +val_364 val_364 val_364 2008-12-31 +val_365 val_365 val_365 2008-12-31 +val_366 val_366 val_366 2008-12-31 +val_367 val_367 val_367 2008-12-31 +val_367 val_367 val_367 2008-12-31 +val_368 val_368 val_368 2008-12-31 +val_369 val_369 val_369 2008-12-31 +val_369 val_369 val_369 2008-12-31 +val_369 val_369 val_369 2008-12-31 +val_37 val_37 val_37 2008-12-31 +val_37 val_37 val_37 2008-12-31 +val_373 val_373 val_373 2008-12-31 +val_374 val_374 val_374 2008-12-31 +val_375 val_375 val_375 2008-12-31 +val_377 val_377 val_377 2008-12-31 +val_378 val_378 val_378 2008-12-31 +val_379 val_379 val_379 2008-12-31 +val_382 val_382 val_382 2008-12-31 +val_382 val_382 val_382 2008-12-31 +val_384 val_384 val_384 2008-12-31 +val_384 val_384 val_384 2008-12-31 +val_384 val_384 val_384 2008-12-31 +val_386 val_386 val_386 2008-12-31 +val_389 val_389 val_389 2008-12-31 +val_392 val_392 val_392 2008-12-31 +val_393 val_393 val_393 2008-12-31 +val_394 val_394 val_394 2008-12-31 +val_395 val_395 val_395 2008-12-31 +val_395 val_395 val_395 2008-12-31 +val_396 val_396 val_396 2008-12-31 +val_396 val_396 val_396 2008-12-31 +val_396 val_396 val_396 2008-12-31 +val_397 val_397 val_397 2008-12-31 +val_397 val_397 val_397 2008-12-31 +val_399 val_399 val_399 2008-12-31 +val_399 val_399 val_399 2008-12-31 +val_4 val_4 val_4 2008-12-31 +val_400 val_400 val_400 2008-12-31 +val_401 val_401 val_401 2008-12-31 +val_401 val_401 val_401 2008-12-31 +val_401 val_401 val_401 2008-12-31 +val_401 val_401 val_401 2008-12-31 +val_401 val_401 val_401 2008-12-31 +val_402 val_402 val_402 2008-12-31 +val_403 val_403 val_403 2008-12-31 +val_403 val_403 val_403 2008-12-31 +val_403 val_403 val_403 2008-12-31 +val_404 val_404 val_404 2008-12-31 +val_404 val_404 val_404 2008-12-31 +val_406 val_406 val_406 2008-12-31 +val_406 val_406 val_406 2008-12-31 +val_406 val_406 val_406 2008-12-31 +val_406 val_406 val_406 2008-12-31 +val_407 val_407 val_407 2008-12-31 +val_409 val_409 val_409 2008-12-31 +val_409 val_409 val_409 2008-12-31 +val_409 val_409 val_409 2008-12-31 +val_41 val_41 val_41 2008-12-31 +val_411 val_411 val_411 2008-12-31 +val_413 val_413 val_413 2008-12-31 +val_413 val_413 val_413 2008-12-31 +val_414 val_414 val_414 2008-12-31 +val_414 val_414 val_414 2008-12-31 +val_417 val_417 val_417 2008-12-31 +val_417 val_417 val_417 2008-12-31 +val_417 val_417 val_417 2008-12-31 +val_418 val_418 val_418 2008-12-31 +val_419 val_419 val_419 2008-12-31 +val_42 val_42 val_42 2008-12-31 +val_42 val_42 val_42 2008-12-31 +val_421 val_421 val_421 2008-12-31 +val_424 val_424 val_424 2008-12-31 +val_424 val_424 val_424 2008-12-31 +val_427 val_427 val_427 2008-12-31 +val_429 val_429 val_429 2008-12-31 +val_429 val_429 val_429 2008-12-31 +val_43 val_43 val_43 2008-12-31 +val_430 val_430 val_430 2008-12-31 +val_430 val_430 val_430 2008-12-31 +val_430 val_430 val_430 2008-12-31 +val_431 val_431 val_431 2008-12-31 +val_431 val_431 val_431 2008-12-31 +val_431 val_431 val_431 2008-12-31 +val_432 val_432 val_432 2008-12-31 +val_435 val_435 val_435 2008-12-31 +val_436 val_436 val_436 2008-12-31 +val_437 val_437 val_437 2008-12-31 +val_438 val_438 val_438 2008-12-31 +val_438 val_438 val_438 2008-12-31 +val_438 val_438 val_438 2008-12-31 +val_439 val_439 val_439 2008-12-31 +val_439 val_439 val_439 2008-12-31 +val_44 val_44 val_44 2008-12-31 +val_443 val_443 val_443 2008-12-31 +val_444 val_444 val_444 2008-12-31 +val_446 val_446 val_446 2008-12-31 +val_448 val_448 val_448 2008-12-31 +val_449 val_449 val_449 2008-12-31 +val_452 val_452 val_452 2008-12-31 +val_453 val_453 val_453 2008-12-31 +val_454 val_454 val_454 2008-12-31 +val_454 val_454 val_454 2008-12-31 +val_454 val_454 val_454 2008-12-31 +val_455 val_455 val_455 2008-12-31 +val_457 val_457 val_457 2008-12-31 +val_458 val_458 val_458 2008-12-31 +val_458 val_458 val_458 2008-12-31 +val_459 val_459 val_459 2008-12-31 +val_459 val_459 val_459 2008-12-31 +val_460 val_460 val_460 2008-12-31 +val_462 val_462 val_462 2008-12-31 +val_462 val_462 val_462 2008-12-31 +val_463 val_463 val_463 2008-12-31 +val_463 val_463 val_463 2008-12-31 +val_466 val_466 val_466 2008-12-31 +val_466 val_466 val_466 2008-12-31 +val_466 val_466 val_466 2008-12-31 +val_467 val_467 val_467 2008-12-31 +val_468 val_468 val_468 2008-12-31 +val_468 val_468 val_468 2008-12-31 +val_468 val_468 val_468 2008-12-31 +val_468 val_468 val_468 2008-12-31 +val_469 val_469 val_469 2008-12-31 +val_469 val_469 val_469 2008-12-31 +val_469 val_469 val_469 2008-12-31 +val_469 val_469 val_469 2008-12-31 +val_469 val_469 val_469 2008-12-31 +val_47 val_47 val_47 2008-12-31 +val_470 val_470 val_470 2008-12-31 +val_472 val_472 val_472 2008-12-31 +val_475 val_475 val_475 2008-12-31 +val_477 val_477 val_477 2008-12-31 +val_478 val_478 val_478 2008-12-31 +val_478 val_478 val_478 2008-12-31 +val_479 val_479 val_479 2008-12-31 +val_480 val_480 val_480 2008-12-31 +val_480 val_480 val_480 2008-12-31 +val_480 val_480 val_480 2008-12-31 +val_481 val_481 val_481 2008-12-31 +val_482 val_482 val_482 2008-12-31 +val_483 val_483 val_483 2008-12-31 +val_484 val_484 val_484 2008-12-31 +val_485 val_485 val_485 2008-12-31 +val_487 val_487 val_487 2008-12-31 +val_489 val_489 val_489 2008-12-31 +val_489 val_489 val_489 2008-12-31 +val_489 val_489 val_489 2008-12-31 +val_489 val_489 val_489 2008-12-31 +val_490 val_490 val_490 2008-12-31 +val_491 val_491 val_491 2008-12-31 +val_492 val_492 val_492 2008-12-31 +val_492 val_492 val_492 2008-12-31 +val_493 val_493 val_493 2008-12-31 +val_494 val_494 val_494 2008-12-31 +val_495 val_495 val_495 2008-12-31 +val_496 val_496 val_496 2008-12-31 +val_497 val_497 val_497 2008-12-31 +val_498 val_498 val_498 2008-12-31 +val_498 val_498 val_498 2008-12-31 +val_498 val_498 val_498 2008-12-31 +val_5 val_5 val_5 2008-12-31 +val_5 val_5 val_5 2008-12-31 +val_5 val_5 val_5 2008-12-31 +val_51 val_51 val_51 2008-12-31 +val_51 val_51 val_51 2008-12-31 +val_53 val_53 val_53 2008-12-31 +val_54 val_54 val_54 2008-12-31 +val_57 val_57 val_57 2008-12-31 +val_58 val_58 val_58 2008-12-31 +val_58 val_58 val_58 2008-12-31 +val_64 val_64 val_64 2008-12-31 +val_65 val_65 val_65 2008-12-31 +val_66 val_66 val_66 2008-12-31 +val_67 val_67 val_67 2008-12-31 +val_67 val_67 val_67 2008-12-31 +val_69 val_69 val_69 2008-12-31 +val_70 val_70 val_70 2008-12-31 +val_70 val_70 val_70 2008-12-31 +val_70 val_70 val_70 2008-12-31 +val_72 val_72 val_72 2008-12-31 +val_72 val_72 val_72 2008-12-31 +val_74 val_74 val_74 2008-12-31 +val_76 val_76 val_76 2008-12-31 +val_76 val_76 val_76 2008-12-31 +val_77 val_77 val_77 2008-12-31 +val_78 val_78 val_78 2008-12-31 +val_8 val_8 val_8 2008-12-31 +val_80 val_80 val_80 2008-12-31 +val_82 val_82 val_82 2008-12-31 +val_83 val_83 val_83 2008-12-31 +val_83 val_83 val_83 2008-12-31 +val_84 val_84 val_84 2008-12-31 +val_84 val_84 val_84 2008-12-31 +val_85 val_85 val_85 2008-12-31 +val_86 val_86 val_86 2008-12-31 +val_87 val_87 val_87 2008-12-31 +val_9 val_9 val_9 2008-12-31 +val_90 val_90 val_90 2008-12-31 +val_90 val_90 val_90 2008-12-31 +val_90 val_90 val_90 2008-12-31 +val_92 val_92 val_92 2008-12-31 +val_95 val_95 val_95 2008-12-31 +val_95 val_95 val_95 2008-12-31 +val_96 val_96 val_96 2008-12-31 +val_97 val_97 val_97 2008-12-31 +val_97 val_97 val_97 2008-12-31 +val_98 val_98 val_98 2008-12-31 +val_98 val_98 val_98 2008-12-31