You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by gu...@apache.org on 2014/01/06 22:32:41 UTC

svn commit: r1556041 [24/42] - in /hive/trunk: cli/src/java/org/apache/hadoop/hive/cli/ common/src/java/org/apache/hadoop/hive/conf/ ql/src/java/org/apache/hadoop/hive/ql/ ql/src/java/org/apache/hadoop/hive/ql/exec/ ql/src/java/org/apache/hadoop/hive/q...

Modified: hive/trunk/ql/src/test/results/compiler/plan/join2.q.xml
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/compiler/plan/join2.q.xml?rev=1556041&r1=1556040&r2=1556041&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/compiler/plan/join2.q.xml (original)
+++ hive/trunk/ql/src/test/results/compiler/plan/join2.q.xml Mon Jan  6 21:32:38 2014
@@ -308,213 +308,209 @@
            <string>$INTNAME</string> 
            <object id="TableScanOperator0" class="org.apache.hadoop.hive.ql.exec.TableScanOperator"> 
             <void property="childOperators"> 
-             <object class="java.util.ArrayList"> 
-              <void method="add"> 
-               <object id="ReduceSinkOperator0" class="org.apache.hadoop.hive.ql.exec.ReduceSinkOperator"> 
-                <void property="columnExprMap"> 
-                 <object class="java.util.HashMap"> 
-                  <void method="put"> 
-                   <string>VALUE._col4</string> 
-                   <object id="ExprNodeColumnDesc0" class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> 
-                    <void property="column"> 
-                     <string>_col0</string> 
-                    </void> 
-                    <void property="tabAlias"> 
-                     <string>src1</string> 
-                    </void> 
-                    <void property="typeInfo"> 
-                     <object id="PrimitiveTypeInfo0" class="org.apache.hadoop.hive.serde2.typeinfo.PrimitiveTypeInfo"> 
-                      <void property="typeName"> 
-                       <string>string</string> 
-                      </void> 
-                     </object> 
-                    </void> 
-                   </object> 
-                  </void> 
-                 </object> 
-                </void> 
-                <void property="conf"> 
-                 <object class="org.apache.hadoop.hive.ql.plan.ReduceSinkDesc"> 
-                  <void property="distinctColumnIndices"> 
-                   <object class="java.util.ArrayList"/> 
-                  </void> 
-                  <void property="keyCols"> 
-                   <object id="ArrayList0" class="java.util.ArrayList"> 
-                    <void method="add"> 
-                     <object class="org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc"> 
-                      <void property="children"> 
-                       <object class="java.util.ArrayList"> 
-                        <void method="add"> 
-                         <object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> 
-                          <void property="column"> 
-                           <string>_col0</string> 
-                          </void> 
-                          <void property="tabAlias"> 
-                           <string>src1</string> 
-                          </void> 
-                          <void property="typeInfo"> 
-                           <object idref="PrimitiveTypeInfo0"/> 
-                          </void> 
-                         </object> 
-                        </void> 
-                        <void method="add"> 
-                         <object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> 
-                          <void property="column"> 
-                           <string>_col4</string> 
-                          </void> 
-                          <void property="tabAlias"> 
-                           <string>src2</string> 
-                          </void> 
-                          <void property="typeInfo"> 
-                           <object idref="PrimitiveTypeInfo0"/> 
-                          </void> 
-                         </object> 
-                        </void> 
-                       </object> 
-                      </void> 
-                      <void property="genericUDF"> 
-                       <object class="org.apache.hadoop.hive.ql.udf.generic.GenericUDFOPPlus"/> 
-                      </void> 
-                      <void property="typeInfo"> 
-                       <object id="PrimitiveTypeInfo1" class="org.apache.hadoop.hive.serde2.typeinfo.PrimitiveTypeInfo"> 
-                        <void property="typeName"> 
-                         <string>double</string> 
-                        </void> 
-                       </object> 
-                      </void> 
-                     </object> 
-                    </void> 
-                   </object> 
-                  </void> 
-                  <void property="keySerializeInfo"> 
-                   <object class="org.apache.hadoop.hive.ql.plan.TableDesc"> 
-                    <void property="inputFileFormatClass"> 
-                     <class>org.apache.hadoop.mapred.SequenceFileInputFormat</class> 
-                    </void> 
-                    <void property="outputFileFormatClass"> 
-                     <class>org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat</class> 
-                    </void> 
-                    <void property="properties"> 
-                     <object class="java.util.Properties"> 
-                      <void method="put"> 
-                       <string>columns</string> 
-                       <string>joinkey0</string> 
-                      </void> 
-                      <void method="put"> 
-                       <string>serialization.lib</string> 
-                       <string>org.apache.hadoop.hive.serde2.binarysortable.BinarySortableSerDe</string> 
-                      </void> 
-                      <void method="put"> 
-                       <string>serialization.sort.order</string> 
-                       <string>+</string> 
-                      </void> 
-                      <void method="put"> 
-                       <string>columns.types</string> 
-                       <string>double</string> 
-                      </void> 
-                     </object> 
-                    </void> 
-                   </object> 
-                  </void> 
-                  <void property="numDistributionKeys"> 
-                   <int>1</int> 
-                  </void> 
-                  <void property="numReducers"> 
-                   <int>-1</int> 
-                  </void> 
-                  <void property="outputKeyColumnNames"> 
-                   <object class="java.util.ArrayList"> 
-                    <void method="add"> 
-                     <string>reducesinkkey0</string> 
-                    </void> 
-                   </object> 
-                  </void> 
-                  <void property="outputValueColumnNames"> 
-                   <object class="java.util.ArrayList"> 
-                    <void method="add"> 
-                     <string>_col4</string> 
-                    </void> 
-                   </object> 
-                  </void> 
-                  <void property="partitionCols"> 
-                   <object idref="ArrayList0"/> 
-                  </void> 
-                  <void property="valueCols"> 
-                   <object class="java.util.ArrayList"> 
-                    <void method="add"> 
-                     <object idref="ExprNodeColumnDesc0"/> 
-                    </void> 
-                   </object> 
-                  </void> 
-                  <void property="valueSerializeInfo"> 
-                   <object id="TableDesc1" class="org.apache.hadoop.hive.ql.plan.TableDesc"> 
-                    <void property="inputFileFormatClass"> 
-                     <class>org.apache.hadoop.mapred.SequenceFileInputFormat</class> 
-                    </void> 
-                    <void property="outputFileFormatClass"> 
-                     <class>org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat</class> 
-                    </void> 
-                    <void property="properties"> 
-                     <object class="java.util.Properties"> 
-                      <void method="put"> 
-                       <string>columns</string> 
-                       <string>_col4</string> 
-                      </void> 
-                      <void method="put"> 
-                       <string>serialization.lib</string> 
-                       <string>org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe</string> 
-                      </void> 
-                      <void method="put"> 
-                       <string>columns.types</string> 
-                       <string>string</string> 
-                      </void> 
-                      <void method="put"> 
-                       <string>escape.delim</string> 
-                       <string>\</string> 
-                      </void> 
-                     </object> 
-                    </void> 
-                   </object> 
-                  </void> 
-                 </object> 
-                </void> 
-                <void property="operatorId"> 
-                 <string>RS_6</string> 
-                </void> 
-                <void property="parentOperators"> 
-                 <object class="java.util.ArrayList"> 
-                  <void method="add"> 
-                   <object idref="TableScanOperator0"/> 
-                  </void> 
-                 </object> 
-                </void> 
-                <void property="schema"> 
-                 <object class="org.apache.hadoop.hive.ql.exec.RowSchema"> 
-                  <void property="signature"> 
-                   <object class="java.util.ArrayList"> 
-                    <void method="add"> 
-                     <object class="org.apache.hadoop.hive.ql.exec.ColumnInfo"> 
-                      <void property="internalName"> 
-                       <string>VALUE._col4</string> 
-                      </void> 
-                      <void property="tabAlias"> 
-                       <string>src1</string> 
-                      </void> 
-                      <void property="type"> 
-                       <object idref="PrimitiveTypeInfo0"/> 
-                      </void> 
-                      <void property="typeName"> 
-                       <string>string</string> 
-                      </void> 
-                     </object> 
-                    </void> 
-                   </object> 
-                  </void> 
-                 </object> 
-                </void> 
-               </object> 
-              </void> 
-             </object> 
+             <void method="add"> 
+              <object id="ReduceSinkOperator0" class="org.apache.hadoop.hive.ql.exec.ReduceSinkOperator"> 
+               <void property="columnExprMap"> 
+                <object class="java.util.HashMap"> 
+                 <void method="put"> 
+                  <string>VALUE._col4</string> 
+                  <object id="ExprNodeColumnDesc0" class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> 
+                   <void property="column"> 
+                    <string>_col0</string> 
+                   </void> 
+                   <void property="tabAlias"> 
+                    <string>src1</string> 
+                   </void> 
+                   <void property="typeInfo"> 
+                    <object id="PrimitiveTypeInfo0" class="org.apache.hadoop.hive.serde2.typeinfo.PrimitiveTypeInfo"> 
+                     <void property="typeName"> 
+                      <string>string</string> 
+                     </void> 
+                    </object> 
+                   </void> 
+                  </object> 
+                 </void> 
+                </object> 
+               </void> 
+               <void property="conf"> 
+                <object class="org.apache.hadoop.hive.ql.plan.ReduceSinkDesc"> 
+                 <void property="distinctColumnIndices"> 
+                  <object class="java.util.ArrayList"/> 
+                 </void> 
+                 <void property="keyCols"> 
+                  <object id="ArrayList0" class="java.util.ArrayList"> 
+                   <void method="add"> 
+                    <object class="org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc"> 
+                     <void property="children"> 
+                      <object class="java.util.ArrayList"> 
+                       <void method="add"> 
+                        <object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> 
+                         <void property="column"> 
+                          <string>_col0</string> 
+                         </void> 
+                         <void property="tabAlias"> 
+                          <string>src1</string> 
+                         </void> 
+                         <void property="typeInfo"> 
+                          <object idref="PrimitiveTypeInfo0"/> 
+                         </void> 
+                        </object> 
+                       </void> 
+                       <void method="add"> 
+                        <object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> 
+                         <void property="column"> 
+                          <string>_col4</string> 
+                         </void> 
+                         <void property="tabAlias"> 
+                          <string>src2</string> 
+                         </void> 
+                         <void property="typeInfo"> 
+                          <object idref="PrimitiveTypeInfo0"/> 
+                         </void> 
+                        </object> 
+                       </void> 
+                      </object> 
+                     </void> 
+                     <void property="genericUDF"> 
+                      <object class="org.apache.hadoop.hive.ql.udf.generic.GenericUDFOPPlus"/> 
+                     </void> 
+                     <void property="typeInfo"> 
+                      <object id="PrimitiveTypeInfo1" class="org.apache.hadoop.hive.serde2.typeinfo.PrimitiveTypeInfo"> 
+                       <void property="typeName"> 
+                        <string>double</string> 
+                       </void> 
+                      </object> 
+                     </void> 
+                    </object> 
+                   </void> 
+                  </object> 
+                 </void> 
+                 <void property="keySerializeInfo"> 
+                  <object class="org.apache.hadoop.hive.ql.plan.TableDesc"> 
+                   <void property="inputFileFormatClass"> 
+                    <class>org.apache.hadoop.mapred.SequenceFileInputFormat</class> 
+                   </void> 
+                   <void property="outputFileFormatClass"> 
+                    <class>org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat</class> 
+                   </void> 
+                   <void property="properties"> 
+                    <object class="java.util.Properties"> 
+                     <void method="put"> 
+                      <string>columns</string> 
+                      <string>joinkey0</string> 
+                     </void> 
+                     <void method="put"> 
+                      <string>serialization.lib</string> 
+                      <string>org.apache.hadoop.hive.serde2.binarysortable.BinarySortableSerDe</string> 
+                     </void> 
+                     <void method="put"> 
+                      <string>serialization.sort.order</string> 
+                      <string>+</string> 
+                     </void> 
+                     <void method="put"> 
+                      <string>columns.types</string> 
+                      <string>double</string> 
+                     </void> 
+                    </object> 
+                   </void> 
+                  </object> 
+                 </void> 
+                 <void property="numDistributionKeys"> 
+                  <int>1</int> 
+                 </void> 
+                 <void property="numReducers"> 
+                  <int>-1</int> 
+                 </void> 
+                 <void property="outputKeyColumnNames"> 
+                  <object class="java.util.ArrayList"> 
+                   <void method="add"> 
+                    <string>reducesinkkey0</string> 
+                   </void> 
+                  </object> 
+                 </void> 
+                 <void property="outputValueColumnNames"> 
+                  <object class="java.util.ArrayList"> 
+                   <void method="add"> 
+                    <string>_col4</string> 
+                   </void> 
+                  </object> 
+                 </void> 
+                 <void property="partitionCols"> 
+                  <object idref="ArrayList0"/> 
+                 </void> 
+                 <void property="valueCols"> 
+                  <object class="java.util.ArrayList"> 
+                   <void method="add"> 
+                    <object idref="ExprNodeColumnDesc0"/> 
+                   </void> 
+                  </object> 
+                 </void> 
+                 <void property="valueSerializeInfo"> 
+                  <object id="TableDesc1" class="org.apache.hadoop.hive.ql.plan.TableDesc"> 
+                   <void property="inputFileFormatClass"> 
+                    <class>org.apache.hadoop.mapred.SequenceFileInputFormat</class> 
+                   </void> 
+                   <void property="outputFileFormatClass"> 
+                    <class>org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat</class> 
+                   </void> 
+                   <void property="properties"> 
+                    <object class="java.util.Properties"> 
+                     <void method="put"> 
+                      <string>columns</string> 
+                      <string>_col4</string> 
+                     </void> 
+                     <void method="put"> 
+                      <string>serialization.lib</string> 
+                      <string>org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe</string> 
+                     </void> 
+                     <void method="put"> 
+                      <string>columns.types</string> 
+                      <string>string</string> 
+                     </void> 
+                     <void method="put"> 
+                      <string>escape.delim</string> 
+                      <string>\</string> 
+                     </void> 
+                    </object> 
+                   </void> 
+                  </object> 
+                 </void> 
+                </object> 
+               </void> 
+               <void property="operatorId"> 
+                <string>RS_6</string> 
+               </void> 
+               <void property="parentOperators"> 
+                <void method="add"> 
+                 <object idref="TableScanOperator0"/> 
+                </void> 
+               </void> 
+               <void property="schema"> 
+                <object class="org.apache.hadoop.hive.ql.exec.RowSchema"> 
+                 <void property="signature"> 
+                  <object class="java.util.ArrayList"> 
+                   <void method="add"> 
+                    <object class="org.apache.hadoop.hive.ql.exec.ColumnInfo"> 
+                     <void property="internalName"> 
+                      <string>VALUE._col4</string> 
+                     </void> 
+                     <void property="tabAlias"> 
+                      <string>src1</string> 
+                     </void> 
+                     <void property="type"> 
+                      <object idref="PrimitiveTypeInfo0"/> 
+                     </void> 
+                     <void property="typeName"> 
+                      <string>string</string> 
+                     </void> 
+                    </object> 
+                   </void> 
+                  </object> 
+                 </void> 
+                </object> 
+               </void> 
+              </object> 
+             </void> 
             </void> 
             <void property="conf"> 
              <object class="org.apache.hadoop.hive.ql.plan.TableScanDesc"/> 
@@ -588,205 +584,201 @@
            <string>src3</string> 
            <object id="TableScanOperator1" class="org.apache.hadoop.hive.ql.exec.TableScanOperator"> 
             <void property="childOperators"> 
-             <object class="java.util.ArrayList"> 
-              <void method="add"> 
-               <object id="ReduceSinkOperator1" class="org.apache.hadoop.hive.ql.exec.ReduceSinkOperator"> 
-                <void property="columnExprMap"> 
-                 <object class="java.util.HashMap"> 
-                  <void method="put"> 
-                   <string>VALUE._col1</string> 
-                   <object id="ExprNodeColumnDesc1" class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> 
-                    <void property="column"> 
-                     <string>value</string> 
-                    </void> 
-                    <void property="tabAlias"> 
-                     <string>src3</string> 
-                    </void> 
-                    <void property="typeInfo"> 
-                     <object idref="PrimitiveTypeInfo0"/> 
-                    </void> 
-                   </object> 
-                  </void> 
-                 </object> 
-                </void> 
-                <void property="conf"> 
-                 <object class="org.apache.hadoop.hive.ql.plan.ReduceSinkDesc"> 
-                  <void property="distinctColumnIndices"> 
-                   <object class="java.util.ArrayList"/> 
-                  </void> 
-                  <void property="keyCols"> 
-                   <object id="ArrayList1" class="java.util.ArrayList"> 
-                    <void method="add"> 
-                     <object class="org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc"> 
-                      <void property="children"> 
-                       <object class="java.util.ArrayList"> 
-                        <void method="add"> 
-                         <object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> 
-                          <void property="column"> 
-                           <string>key</string> 
-                          </void> 
-                          <void property="tabAlias"> 
-                           <string>src3</string> 
-                          </void> 
-                          <void property="typeInfo"> 
-                           <object idref="PrimitiveTypeInfo0"/> 
-                          </void> 
-                         </object> 
-                        </void> 
-                       </object> 
-                      </void> 
-                      <void property="genericUDF"> 
-                       <object class="org.apache.hadoop.hive.ql.udf.generic.GenericUDFBridge"> 
-                        <void property="udfClassName"> 
-                         <string>org.apache.hadoop.hive.ql.udf.UDFToDouble</string> 
-                        </void> 
-                        <void property="udfName"> 
-                         <string>UDFToDouble</string> 
-                        </void> 
-                       </object> 
-                      </void> 
-                      <void property="typeInfo"> 
-                       <object idref="PrimitiveTypeInfo1"/> 
-                      </void> 
-                     </object> 
-                    </void> 
-                   </object> 
-                  </void> 
-                  <void property="keySerializeInfo"> 
-                   <object id="TableDesc2" class="org.apache.hadoop.hive.ql.plan.TableDesc"> 
-                    <void property="inputFileFormatClass"> 
-                     <class>org.apache.hadoop.mapred.SequenceFileInputFormat</class> 
-                    </void> 
-                    <void property="outputFileFormatClass"> 
-                     <class>org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat</class> 
-                    </void> 
-                    <void property="properties"> 
-                     <object class="java.util.Properties"> 
-                      <void method="put"> 
-                       <string>columns</string> 
-                       <string>joinkey0</string> 
-                      </void> 
-                      <void method="put"> 
-                       <string>serialization.lib</string> 
-                       <string>org.apache.hadoop.hive.serde2.binarysortable.BinarySortableSerDe</string> 
-                      </void> 
-                      <void method="put"> 
-                       <string>serialization.sort.order</string> 
-                       <string>+</string> 
-                      </void> 
-                      <void method="put"> 
-                       <string>columns.types</string> 
-                       <string>double</string> 
-                      </void> 
-                     </object> 
-                    </void> 
-                   </object> 
-                  </void> 
-                  <void property="numDistributionKeys"> 
-                   <int>1</int> 
-                  </void> 
-                  <void property="numReducers"> 
-                   <int>-1</int> 
-                  </void> 
-                  <void property="outputKeyColumnNames"> 
-                   <object class="java.util.ArrayList"> 
-                    <void method="add"> 
-                     <string>reducesinkkey0</string> 
-                    </void> 
-                   </object> 
-                  </void> 
-                  <void property="outputValueColumnNames"> 
-                   <object class="java.util.ArrayList"> 
-                    <void method="add"> 
-                     <string>_col1</string> 
-                    </void> 
-                   </object> 
-                  </void> 
-                  <void property="partitionCols"> 
-                   <object idref="ArrayList1"/> 
-                  </void> 
-                  <void property="tag"> 
-                   <int>1</int> 
-                  </void> 
-                  <void property="valueCols"> 
-                   <object class="java.util.ArrayList"> 
-                    <void method="add"> 
-                     <object idref="ExprNodeColumnDesc1"/> 
-                    </void> 
-                   </object> 
-                  </void> 
-                  <void property="valueSerializeInfo"> 
-                   <object id="TableDesc3" class="org.apache.hadoop.hive.ql.plan.TableDesc"> 
-                    <void property="inputFileFormatClass"> 
-                     <class>org.apache.hadoop.mapred.SequenceFileInputFormat</class> 
-                    </void> 
-                    <void property="outputFileFormatClass"> 
-                     <class>org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat</class> 
-                    </void> 
-                    <void property="properties"> 
-                     <object class="java.util.Properties"> 
-                      <void method="put"> 
-                       <string>columns</string> 
-                       <string>_col1</string> 
-                      </void> 
-                      <void method="put"> 
-                       <string>serialization.lib</string> 
-                       <string>org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe</string> 
-                      </void> 
-                      <void method="put"> 
-                       <string>columns.types</string> 
-                       <string>string</string> 
-                      </void> 
-                      <void method="put"> 
-                       <string>escape.delim</string> 
-                       <string>\</string> 
-                      </void> 
-                     </object> 
-                    </void> 
-                   </object> 
-                  </void> 
-                 </object> 
-                </void> 
-                <void property="inputAlias"> 
-                 <string>src3</string> 
-                </void> 
-                <void property="operatorId"> 
-                 <string>RS_7</string> 
-                </void> 
-                <void property="parentOperators"> 
-                 <object class="java.util.ArrayList"> 
-                  <void method="add"> 
-                   <object idref="TableScanOperator1"/> 
-                  </void> 
-                 </object> 
-                </void> 
-                <void property="schema"> 
-                 <object class="org.apache.hadoop.hive.ql.exec.RowSchema"> 
-                  <void property="signature"> 
-                   <object class="java.util.ArrayList"> 
-                    <void method="add"> 
-                     <object class="org.apache.hadoop.hive.ql.exec.ColumnInfo"> 
-                      <void property="internalName"> 
-                       <string>VALUE._col1</string> 
-                      </void> 
-                      <void property="tabAlias"> 
-                       <string>src3</string> 
-                      </void> 
-                      <void property="type"> 
-                       <object idref="PrimitiveTypeInfo0"/> 
-                      </void> 
-                      <void property="typeName"> 
-                       <string>string</string> 
-                      </void> 
-                     </object> 
-                    </void> 
-                   </object> 
-                  </void> 
-                 </object> 
-                </void> 
-               </object> 
-              </void> 
-             </object> 
+             <void method="add"> 
+              <object id="ReduceSinkOperator1" class="org.apache.hadoop.hive.ql.exec.ReduceSinkOperator"> 
+               <void property="columnExprMap"> 
+                <object class="java.util.HashMap"> 
+                 <void method="put"> 
+                  <string>VALUE._col1</string> 
+                  <object id="ExprNodeColumnDesc1" class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> 
+                   <void property="column"> 
+                    <string>value</string> 
+                   </void> 
+                   <void property="tabAlias"> 
+                    <string>src3</string> 
+                   </void> 
+                   <void property="typeInfo"> 
+                    <object idref="PrimitiveTypeInfo0"/> 
+                   </void> 
+                  </object> 
+                 </void> 
+                </object> 
+               </void> 
+               <void property="conf"> 
+                <object class="org.apache.hadoop.hive.ql.plan.ReduceSinkDesc"> 
+                 <void property="distinctColumnIndices"> 
+                  <object class="java.util.ArrayList"/> 
+                 </void> 
+                 <void property="keyCols"> 
+                  <object id="ArrayList1" class="java.util.ArrayList"> 
+                   <void method="add"> 
+                    <object class="org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc"> 
+                     <void property="children"> 
+                      <object class="java.util.ArrayList"> 
+                       <void method="add"> 
+                        <object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> 
+                         <void property="column"> 
+                          <string>key</string> 
+                         </void> 
+                         <void property="tabAlias"> 
+                          <string>src3</string> 
+                         </void> 
+                         <void property="typeInfo"> 
+                          <object idref="PrimitiveTypeInfo0"/> 
+                         </void> 
+                        </object> 
+                       </void> 
+                      </object> 
+                     </void> 
+                     <void property="genericUDF"> 
+                      <object class="org.apache.hadoop.hive.ql.udf.generic.GenericUDFBridge"> 
+                       <void property="udfClassName"> 
+                        <string>org.apache.hadoop.hive.ql.udf.UDFToDouble</string> 
+                       </void> 
+                       <void property="udfName"> 
+                        <string>UDFToDouble</string> 
+                       </void> 
+                      </object> 
+                     </void> 
+                     <void property="typeInfo"> 
+                      <object idref="PrimitiveTypeInfo1"/> 
+                     </void> 
+                    </object> 
+                   </void> 
+                  </object> 
+                 </void> 
+                 <void property="keySerializeInfo"> 
+                  <object id="TableDesc2" class="org.apache.hadoop.hive.ql.plan.TableDesc"> 
+                   <void property="inputFileFormatClass"> 
+                    <class>org.apache.hadoop.mapred.SequenceFileInputFormat</class> 
+                   </void> 
+                   <void property="outputFileFormatClass"> 
+                    <class>org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat</class> 
+                   </void> 
+                   <void property="properties"> 
+                    <object class="java.util.Properties"> 
+                     <void method="put"> 
+                      <string>columns</string> 
+                      <string>joinkey0</string> 
+                     </void> 
+                     <void method="put"> 
+                      <string>serialization.lib</string> 
+                      <string>org.apache.hadoop.hive.serde2.binarysortable.BinarySortableSerDe</string> 
+                     </void> 
+                     <void method="put"> 
+                      <string>serialization.sort.order</string> 
+                      <string>+</string> 
+                     </void> 
+                     <void method="put"> 
+                      <string>columns.types</string> 
+                      <string>double</string> 
+                     </void> 
+                    </object> 
+                   </void> 
+                  </object> 
+                 </void> 
+                 <void property="numDistributionKeys"> 
+                  <int>1</int> 
+                 </void> 
+                 <void property="numReducers"> 
+                  <int>-1</int> 
+                 </void> 
+                 <void property="outputKeyColumnNames"> 
+                  <object class="java.util.ArrayList"> 
+                   <void method="add"> 
+                    <string>reducesinkkey0</string> 
+                   </void> 
+                  </object> 
+                 </void> 
+                 <void property="outputValueColumnNames"> 
+                  <object class="java.util.ArrayList"> 
+                   <void method="add"> 
+                    <string>_col1</string> 
+                   </void> 
+                  </object> 
+                 </void> 
+                 <void property="partitionCols"> 
+                  <object idref="ArrayList1"/> 
+                 </void> 
+                 <void property="tag"> 
+                  <int>1</int> 
+                 </void> 
+                 <void property="valueCols"> 
+                  <object class="java.util.ArrayList"> 
+                   <void method="add"> 
+                    <object idref="ExprNodeColumnDesc1"/> 
+                   </void> 
+                  </object> 
+                 </void> 
+                 <void property="valueSerializeInfo"> 
+                  <object id="TableDesc3" class="org.apache.hadoop.hive.ql.plan.TableDesc"> 
+                   <void property="inputFileFormatClass"> 
+                    <class>org.apache.hadoop.mapred.SequenceFileInputFormat</class> 
+                   </void> 
+                   <void property="outputFileFormatClass"> 
+                    <class>org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat</class> 
+                   </void> 
+                   <void property="properties"> 
+                    <object class="java.util.Properties"> 
+                     <void method="put"> 
+                      <string>columns</string> 
+                      <string>_col1</string> 
+                     </void> 
+                     <void method="put"> 
+                      <string>serialization.lib</string> 
+                      <string>org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe</string> 
+                     </void> 
+                     <void method="put"> 
+                      <string>columns.types</string> 
+                      <string>string</string> 
+                     </void> 
+                     <void method="put"> 
+                      <string>escape.delim</string> 
+                      <string>\</string> 
+                     </void> 
+                    </object> 
+                   </void> 
+                  </object> 
+                 </void> 
+                </object> 
+               </void> 
+               <void property="inputAlias"> 
+                <string>src3</string> 
+               </void> 
+               <void property="operatorId"> 
+                <string>RS_7</string> 
+               </void> 
+               <void property="parentOperators"> 
+                <void method="add"> 
+                 <object idref="TableScanOperator1"/> 
+                </void> 
+               </void> 
+               <void property="schema"> 
+                <object class="org.apache.hadoop.hive.ql.exec.RowSchema"> 
+                 <void property="signature"> 
+                  <object class="java.util.ArrayList"> 
+                   <void method="add"> 
+                    <object class="org.apache.hadoop.hive.ql.exec.ColumnInfo"> 
+                     <void property="internalName"> 
+                      <string>VALUE._col1</string> 
+                     </void> 
+                     <void property="tabAlias"> 
+                      <string>src3</string> 
+                     </void> 
+                     <void property="type"> 
+                      <object idref="PrimitiveTypeInfo0"/> 
+                     </void> 
+                     <void property="typeName"> 
+                      <string>string</string> 
+                     </void> 
+                    </object> 
+                   </void> 
+                  </object> 
+                 </void> 
+                </object> 
+               </void> 
+              </object> 
+             </void> 
             </void> 
             <void property="conf"> 
              <object class="org.apache.hadoop.hive.ql.plan.TableScanDesc"> 
@@ -1157,200 +1149,88 @@
           <void property="reducer"> 
            <object id="JoinOperator0" class="org.apache.hadoop.hive.ql.exec.JoinOperator"> 
             <void property="childOperators"> 
-             <object class="java.util.ArrayList"> 
-              <void method="add"> 
-               <object id="SelectOperator0" class="org.apache.hadoop.hive.ql.exec.SelectOperator"> 
-                <void property="childOperators"> 
-                 <object class="java.util.ArrayList"> 
-                  <void method="add"> 
-                   <object class="org.apache.hadoop.hive.ql.exec.FileSinkOperator"> 
-                    <void property="conf"> 
-                     <object class="org.apache.hadoop.hive.ql.plan.FileSinkDesc"> 
-                      <void property="destTableId"> 
-                       <int>1</int> 
-                      </void> 
-                      <void property="dirName"> 
-                       #### A masked pattern was here #### 
-                      </void> 
-                      <void property="gatherStats"> 
-                       <boolean>true</boolean> 
-                      </void> 
-                      <void property="lbCtx"> 
-                       <object idref="ListBucketingCtx0"/> 
-                      </void> 
-                      <void property="maxStatsKeyPrefixLength"> 
-                       <int>150</int> 
-                      </void> 
-                      <void property="numFiles"> 
-                       <int>1</int> 
-                      </void> 
-                      <void property="statsAggPrefix"> 
-                       #### A masked pattern was here #### 
-                      </void> 
-                      <void property="statsCollectRawDataSize"> 
-                       <boolean>true</boolean> 
-                      </void> 
-                      <void property="tableInfo"> 
-                       <object idref="TableDesc0"/> 
-                      </void> 
-                      <void property="totalFiles"> 
-                       <int>1</int> 
-                      </void> 
-                     </object> 
-                    </void> 
-                    <void property="operatorId"> 
-                     <string>FS_10</string> 
-                    </void> 
-                    <void property="parentOperators"> 
-                     <object class="java.util.ArrayList"> 
-                      <void method="add"> 
-                       <object idref="SelectOperator0"/> 
-                      </void> 
-                     </object> 
+             <void method="add"> 
+              <object id="SelectOperator0" class="org.apache.hadoop.hive.ql.exec.SelectOperator"> 
+               <void property="childOperators"> 
+                <void method="add"> 
+                 <object class="org.apache.hadoop.hive.ql.exec.FileSinkOperator"> 
+                  <void property="conf"> 
+                   <object class="org.apache.hadoop.hive.ql.plan.FileSinkDesc"> 
+                    <void property="destTableId"> 
+                     <int>1</int> 
                     </void> 
-                    <void property="schema"> 
-                     <object class="org.apache.hadoop.hive.ql.exec.RowSchema"> 
-                      <void property="signature"> 
-                       <object class="java.util.ArrayList"> 
-                        <void method="add"> 
-                         <object class="org.apache.hadoop.hive.ql.exec.ColumnInfo"> 
-                          <void property="internalName"> 
-                           <string>key</string> 
-                          </void> 
-                          <void property="tabAlias"> 
-                           <string></string> 
-                          </void> 
-                          <void property="type"> 
-                           <object idref="PrimitiveTypeInfo0"/> 
-                          </void> 
-                          <void property="typeName"> 
-                           <string>string</string> 
-                          </void> 
-                         </object> 
-                        </void> 
-                        <void method="add"> 
-                         <object class="org.apache.hadoop.hive.ql.exec.ColumnInfo"> 
-                          <void property="internalName"> 
-                           <string>value</string> 
-                          </void> 
-                          <void property="tabAlias"> 
-                           <string></string> 
-                          </void> 
-                          <void property="type"> 
-                           <object idref="PrimitiveTypeInfo0"/> 
-                          </void> 
-                          <void property="typeName"> 
-                           <string>string</string> 
-                          </void> 
-                         </object> 
-                        </void> 
-                       </object> 
-                      </void> 
-                     </object> 
+                    <void property="dirName"> 
+                     #### A masked pattern was here #### 
                     </void> 
-                   </object> 
-                  </void> 
-                 </object> 
-                </void> 
-                <void property="columnExprMap"> 
-                 <object class="java.util.HashMap"> 
-                  <void method="put"> 
-                   <string>_col1</string> 
-                   <object id="ExprNodeColumnDesc2" class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> 
-                    <void property="column"> 
-                     <string>_col9</string> 
+                    <void property="gatherStats"> 
+                     <boolean>true</boolean> 
                     </void> 
-                    <void property="tabAlias"> 
-                     <string>src3</string> 
+                    <void property="lbCtx"> 
+                     <object idref="ListBucketingCtx0"/> 
                     </void> 
-                    <void property="typeInfo"> 
-                     <object idref="PrimitiveTypeInfo0"/> 
+                    <void property="maxStatsKeyPrefixLength"> 
+                     <int>150</int> 
                     </void> 
-                   </object> 
-                  </void> 
-                  <void method="put"> 
-                   <string>_col0</string> 
-                   <object id="ExprNodeColumnDesc3" class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> 
-                    <void property="column"> 
-                     <string>_col4</string> 
+                    <void property="numFiles"> 
+                     <int>1</int> 
                     </void> 
-                    <void property="tabAlias"> 
-                     <string>src1</string> 
+                    <void property="statsAggPrefix"> 
+                     #### A masked pattern was here #### 
                     </void> 
-                    <void property="typeInfo"> 
-                     <object idref="PrimitiveTypeInfo0"/> 
+                    <void property="statsCollectRawDataSize"> 
+                     <boolean>true</boolean> 
                     </void> 
-                   </object> 
-                  </void> 
-                 </object> 
-                </void> 
-                <void property="conf"> 
-                 <object class="org.apache.hadoop.hive.ql.plan.SelectDesc"> 
-                  <void property="colList"> 
-                   <object class="java.util.ArrayList"> 
-                    <void method="add"> 
-                     <object idref="ExprNodeColumnDesc3"/> 
+                    <void property="tableInfo"> 
+                     <object idref="TableDesc0"/> 
                     </void> 
-                    <void method="add"> 
-                     <object idref="ExprNodeColumnDesc2"/> 
+                    <void property="totalFiles"> 
+                     <int>1</int> 
                     </void> 
                    </object> 
                   </void> 
-                  <void property="outputColumnNames"> 
-                   <object class="java.util.ArrayList"> 
-                    <void method="add"> 
-                     <string>_col0</string> 
-                    </void> 
-                    <void method="add"> 
-                     <string>_col1</string> 
-                    </void> 
-                   </object> 
+                  <void property="operatorId"> 
+                   <string>FS_10</string> 
                   </void> 
-                 </object> 
-                </void> 
-                <void property="operatorId"> 
-                 <string>SEL_9</string> 
-                </void> 
-                <void property="parentOperators"> 
-                 <object class="java.util.ArrayList"> 
-                  <void method="add"> 
-                   <object idref="JoinOperator0"/> 
+                  <void property="parentOperators"> 
+                   <void method="add"> 
+                    <object idref="SelectOperator0"/> 
+                   </void> 
                   </void> 
-                 </object> 
-                </void> 
-                <void property="schema"> 
-                 <object class="org.apache.hadoop.hive.ql.exec.RowSchema"> 
-                  <void property="signature"> 
-                   <object class="java.util.ArrayList"> 
-                    <void method="add"> 
-                     <object class="org.apache.hadoop.hive.ql.exec.ColumnInfo"> 
-                      <void property="internalName"> 
-                       <string>_col0</string> 
-                      </void> 
-                      <void property="tabAlias"> 
-                       <string>src1</string> 
-                      </void> 
-                      <void property="type"> 
-                       <object idref="PrimitiveTypeInfo0"/> 
-                      </void> 
-                      <void property="typeName"> 
-                       <string>string</string> 
-                      </void> 
-                     </object> 
-                    </void> 
-                    <void method="add"> 
-                     <object class="org.apache.hadoop.hive.ql.exec.ColumnInfo"> 
-                      <void property="internalName"> 
-                       <string>_col1</string> 
-                      </void> 
-                      <void property="tabAlias"> 
-                       <string>src3</string> 
-                      </void> 
-                      <void property="type"> 
-                       <object idref="PrimitiveTypeInfo0"/> 
+                  <void property="schema"> 
+                   <object class="org.apache.hadoop.hive.ql.exec.RowSchema"> 
+                    <void property="signature"> 
+                     <object class="java.util.ArrayList"> 
+                      <void method="add"> 
+                       <object class="org.apache.hadoop.hive.ql.exec.ColumnInfo"> 
+                        <void property="internalName"> 
+                         <string>key</string> 
+                        </void> 
+                        <void property="tabAlias"> 
+                         <string></string> 
+                        </void> 
+                        <void property="type"> 
+                         <object idref="PrimitiveTypeInfo0"/> 
+                        </void> 
+                        <void property="typeName"> 
+                         <string>string</string> 
+                        </void> 
+                       </object> 
                       </void> 
-                      <void property="typeName"> 
-                       <string>string</string> 
+                      <void method="add"> 
+                       <object class="org.apache.hadoop.hive.ql.exec.ColumnInfo"> 
+                        <void property="internalName"> 
+                         <string>value</string> 
+                        </void> 
+                        <void property="tabAlias"> 
+                         <string></string> 
+                        </void> 
+                        <void property="type"> 
+                         <object idref="PrimitiveTypeInfo0"/> 
+                        </void> 
+                        <void property="typeName"> 
+                         <string>string</string> 
+                        </void> 
+                       </object> 
                       </void> 
                      </object> 
                     </void> 
@@ -1358,9 +1238,113 @@
                   </void> 
                  </object> 
                 </void> 
-               </object> 
-              </void> 
-             </object> 
+               </void> 
+               <void property="columnExprMap"> 
+                <object class="java.util.HashMap"> 
+                 <void method="put"> 
+                  <string>_col1</string> 
+                  <object id="ExprNodeColumnDesc2" class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> 
+                   <void property="column"> 
+                    <string>_col9</string> 
+                   </void> 
+                   <void property="tabAlias"> 
+                    <string>src3</string> 
+                   </void> 
+                   <void property="typeInfo"> 
+                    <object idref="PrimitiveTypeInfo0"/> 
+                   </void> 
+                  </object> 
+                 </void> 
+                 <void method="put"> 
+                  <string>_col0</string> 
+                  <object id="ExprNodeColumnDesc3" class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> 
+                   <void property="column"> 
+                    <string>_col4</string> 
+                   </void> 
+                   <void property="tabAlias"> 
+                    <string>src1</string> 
+                   </void> 
+                   <void property="typeInfo"> 
+                    <object idref="PrimitiveTypeInfo0"/> 
+                   </void> 
+                  </object> 
+                 </void> 
+                </object> 
+               </void> 
+               <void property="conf"> 
+                <object class="org.apache.hadoop.hive.ql.plan.SelectDesc"> 
+                 <void property="colList"> 
+                  <object class="java.util.ArrayList"> 
+                   <void method="add"> 
+                    <object idref="ExprNodeColumnDesc3"/> 
+                   </void> 
+                   <void method="add"> 
+                    <object idref="ExprNodeColumnDesc2"/> 
+                   </void> 
+                  </object> 
+                 </void> 
+                 <void property="outputColumnNames"> 
+                  <object class="java.util.ArrayList"> 
+                   <void method="add"> 
+                    <string>_col0</string> 
+                   </void> 
+                   <void method="add"> 
+                    <string>_col1</string> 
+                   </void> 
+                  </object> 
+                 </void> 
+                </object> 
+               </void> 
+               <void property="operatorId"> 
+                <string>SEL_9</string> 
+               </void> 
+               <void property="parentOperators"> 
+                <void method="add"> 
+                 <object idref="JoinOperator0"/> 
+                </void> 
+               </void> 
+               <void property="schema"> 
+                <object class="org.apache.hadoop.hive.ql.exec.RowSchema"> 
+                 <void property="signature"> 
+                  <object class="java.util.ArrayList"> 
+                   <void method="add"> 
+                    <object class="org.apache.hadoop.hive.ql.exec.ColumnInfo"> 
+                     <void property="internalName"> 
+                      <string>_col0</string> 
+                     </void> 
+                     <void property="tabAlias"> 
+                      <string>src1</string> 
+                     </void> 
+                     <void property="type"> 
+                      <object idref="PrimitiveTypeInfo0"/> 
+                     </void> 
+                     <void property="typeName"> 
+                      <string>string</string> 
+                     </void> 
+                    </object> 
+                   </void> 
+                   <void method="add"> 
+                    <object class="org.apache.hadoop.hive.ql.exec.ColumnInfo"> 
+                     <void property="internalName"> 
+                      <string>_col1</string> 
+                     </void> 
+                     <void property="tabAlias"> 
+                      <string>src3</string> 
+                     </void> 
+                     <void property="type"> 
+                      <object idref="PrimitiveTypeInfo0"/> 
+                     </void> 
+                     <void property="typeName"> 
+                      <string>string</string> 
+                     </void> 
+                    </object> 
+                   </void> 
+                  </object> 
+                 </void> 
+                </object> 
+               </void> 
+              </object> 
+             </void> 
             </void> 
             <void property="columnExprMap"> 
              <object class="java.util.HashMap"> 
@@ -1526,14 +1510,12 @@
              <string>JOIN_8</string> 
             </void> 
             <void property="parentOperators"> 
-             <object class="java.util.ArrayList"> 
-              <void method="add"> 
-               <object idref="ReduceSinkOperator0"/> 
-              </void> 
-              <void method="add"> 
-               <object idref="ReduceSinkOperator1"/> 
-              </void> 
-             </object> 
+             <void method="add"> 
+              <object idref="ReduceSinkOperator0"/> 
+             </void> 
+             <void method="add"> 
+              <object idref="ReduceSinkOperator1"/> 
+             </void> 
             </void> 
             <void property="posToAliasMap"> 
              <object class="java.util.HashMap"> 
@@ -1901,184 +1883,180 @@
        <string>src2</string> 
        <object id="TableScanOperator2" class="org.apache.hadoop.hive.ql.exec.TableScanOperator"> 
         <void property="childOperators"> 
-         <object class="java.util.ArrayList"> 
-          <void method="add"> 
-           <object id="ReduceSinkOperator2" class="org.apache.hadoop.hive.ql.exec.ReduceSinkOperator"> 
-            <void property="columnExprMap"> 
-             <object class="java.util.HashMap"> 
-              <void method="put"> 
-               <string>VALUE._col0</string> 
-               <object id="ExprNodeColumnDesc6" class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> 
-                <void property="column"> 
-                 <string>key</string> 
-                </void> 
-                <void property="tabAlias"> 
-                 <string>src2</string> 
-                </void> 
-                <void property="typeInfo"> 
-                 <object idref="PrimitiveTypeInfo0"/> 
-                </void> 
-               </object> 
-              </void> 
-             </object> 
-            </void> 
-            <void property="conf"> 
-             <object class="org.apache.hadoop.hive.ql.plan.ReduceSinkDesc"> 
-              <void property="distinctColumnIndices"> 
-               <object class="java.util.ArrayList"/> 
-              </void> 
-              <void property="keyCols"> 
-               <object id="ArrayList2" class="java.util.ArrayList"> 
-                <void method="add"> 
-                 <object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> 
-                  <void property="column"> 
-                   <string>key</string> 
-                  </void> 
-                  <void property="tabAlias"> 
-                   <string>src2</string> 
-                  </void> 
-                  <void property="typeInfo"> 
-                   <object idref="PrimitiveTypeInfo0"/> 
-                  </void> 
-                 </object> 
-                </void> 
-               </object> 
-              </void> 
-              <void property="keySerializeInfo"> 
-               <object class="org.apache.hadoop.hive.ql.plan.TableDesc"> 
-                <void property="inputFileFormatClass"> 
-                 <class>org.apache.hadoop.mapred.SequenceFileInputFormat</class> 
-                </void> 
-                <void property="outputFileFormatClass"> 
-                 <class>org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat</class> 
-                </void> 
-                <void property="properties"> 
-                 <object class="java.util.Properties"> 
-                  <void method="put"> 
-                   <string>columns</string> 
-                   <string>joinkey0</string> 
-                  </void> 
-                  <void method="put"> 
-                   <string>serialization.lib</string> 
-                   <string>org.apache.hadoop.hive.serde2.binarysortable.BinarySortableSerDe</string> 
-                  </void> 
-                  <void method="put"> 
-                   <string>serialization.sort.order</string> 
-                   <string>+</string> 
-                  </void> 
-                  <void method="put"> 
-                   <string>columns.types</string> 
-                   <string>string</string> 
-                  </void> 
-                 </object> 
-                </void> 
-               </object> 
-              </void> 
-              <void property="numDistributionKeys"> 
-               <int>1</int> 
-              </void> 
-              <void property="numReducers"> 
-               <int>-1</int> 
-              </void> 
-              <void property="outputKeyColumnNames"> 
-               <object class="java.util.ArrayList"> 
-                <void method="add"> 
-                 <string>reducesinkkey0</string> 
-                </void> 
-               </object> 
-              </void> 
-              <void property="outputValueColumnNames"> 
-               <object class="java.util.ArrayList"> 
-                <void method="add"> 
-                 <string>_col0</string> 
-                </void> 
-               </object> 
-              </void> 
-              <void property="partitionCols"> 
-               <object idref="ArrayList2"/> 
-              </void> 
-              <void property="tag"> 
-               <int>1</int> 
-              </void> 
-              <void property="valueCols"> 
-               <object class="java.util.ArrayList"> 
-                <void method="add"> 
-                 <object idref="ExprNodeColumnDesc6"/> 
-                </void> 
-               </object> 
-              </void> 
-              <void property="valueSerializeInfo"> 
-               <object id="TableDesc5" class="org.apache.hadoop.hive.ql.plan.TableDesc"> 
-                <void property="inputFileFormatClass"> 
-                 <class>org.apache.hadoop.mapred.SequenceFileInputFormat</class> 
-                </void> 
-                <void property="outputFileFormatClass"> 
-                 <class>org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat</class> 
-                </void> 
-                <void property="properties"> 
-                 <object class="java.util.Properties"> 
-                  <void method="put"> 
-                   <string>columns</string> 
-                   <string>_col0</string> 
-                  </void> 
-                  <void method="put"> 
-                   <string>serialization.lib</string> 
-                   <string>org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe</string> 
-                  </void> 
-                  <void method="put"> 
-                   <string>columns.types</string> 
-                   <string>string</string> 
-                  </void> 
-                  <void method="put"> 
-                   <string>escape.delim</string> 
-                   <string>\</string> 
-                  </void> 
-                 </object> 
-                </void> 
-               </object> 
-              </void> 
-             </object> 
-            </void> 
-            <void property="inputAlias"> 
-             <string>src2</string> 
-            </void> 
-            <void property="operatorId"> 
-             <string>RS_4</string> 
-            </void> 
-            <void property="parentOperators"> 
-             <object class="java.util.ArrayList"> 
-              <void method="add"> 
-               <object idref="TableScanOperator2"/> 
-              </void> 
-             </object> 
-            </void> 
-            <void property="schema"> 
-             <object class="org.apache.hadoop.hive.ql.exec.RowSchema"> 
-              <void property="signature"> 
-               <object class="java.util.ArrayList"> 
-                <void method="add"> 
-                 <object class="org.apache.hadoop.hive.ql.exec.ColumnInfo"> 
-                  <void property="internalName"> 
-                   <string>VALUE._col0</string> 
-                  </void> 
-                  <void property="tabAlias"> 
-                   <string>src2</string> 
-                  </void> 
-                  <void property="type"> 
-                   <object idref="PrimitiveTypeInfo0"/> 
-                  </void> 
-                  <void property="typeName"> 
-                   <string>string</string> 
-                  </void> 
-                 </object> 
-                </void> 
-               </object> 
-              </void> 
-             </object> 
+         <void method="add"> 
+          <object id="ReduceSinkOperator2" class="org.apache.hadoop.hive.ql.exec.ReduceSinkOperator"> 
+           <void property="columnExprMap"> 
+            <object class="java.util.HashMap"> 
+             <void method="put"> 
+              <string>VALUE._col0</string> 
+              <object id="ExprNodeColumnDesc6" class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> 
+               <void property="column"> 
+                <string>key</string> 
+               </void> 
+               <void property="tabAlias"> 
+                <string>src2</string> 
+               </void> 
+               <void property="typeInfo"> 
+                <object idref="PrimitiveTypeInfo0"/> 
+               </void> 
+              </object> 
+             </void> 
+            </object> 
+           </void> 
+           <void property="conf"> 
+            <object class="org.apache.hadoop.hive.ql.plan.ReduceSinkDesc"> 
+             <void property="distinctColumnIndices"> 
+              <object class="java.util.ArrayList"/> 
+             </void> 
+             <void property="keyCols"> 
+              <object id="ArrayList2" class="java.util.ArrayList"> 
+               <void method="add"> 
+                <object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> 
+                 <void property="column"> 
+                  <string>key</string> 
+                 </void> 
+                 <void property="tabAlias"> 
+                  <string>src2</string> 
+                 </void> 
+                 <void property="typeInfo"> 
+                  <object idref="PrimitiveTypeInfo0"/> 
+                 </void> 
+                </object> 
+               </void> 
+              </object> 
+             </void> 
+             <void property="keySerializeInfo"> 
+              <object class="org.apache.hadoop.hive.ql.plan.TableDesc"> 
+               <void property="inputFileFormatClass"> 
+                <class>org.apache.hadoop.mapred.SequenceFileInputFormat</class> 
+               </void> 
+               <void property="outputFileFormatClass"> 
+                <class>org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat</class> 
+               </void> 
+               <void property="properties"> 
+                <object class="java.util.Properties"> 
+                 <void method="put"> 
+                  <string>columns</string> 
+                  <string>joinkey0</string> 
+                 </void> 
+                 <void method="put"> 
+                  <string>serialization.lib</string> 
+                  <string>org.apache.hadoop.hive.serde2.binarysortable.BinarySortableSerDe</string> 
+                 </void> 
+                 <void method="put"> 
+                  <string>serialization.sort.order</string> 
+                  <string>+</string> 
+                 </void> 
+                 <void method="put"> 
+                  <string>columns.types</string> 
+                  <string>string</string> 
+                 </void> 
+                </object> 
+               </void> 
+              </object> 
+             </void> 
+             <void property="numDistributionKeys"> 
+              <int>1</int> 
+             </void> 
+             <void property="numReducers"> 
+              <int>-1</int> 
+             </void> 
+             <void property="outputKeyColumnNames"> 
+              <object class="java.util.ArrayList"> 
+               <void method="add"> 
+                <string>reducesinkkey0</string> 
+               </void> 
+              </object> 
+             </void> 
+             <void property="outputValueColumnNames"> 
+              <object class="java.util.ArrayList"> 
+               <void method="add"> 
+                <string>_col0</string> 
+               </void> 
+              </object> 
+             </void> 
+             <void property="partitionCols"> 
+              <object idref="ArrayList2"/> 
+             </void> 
+             <void property="tag"> 
+              <int>1</int> 
+             </void> 
+             <void property="valueCols"> 
+              <object class="java.util.ArrayList"> 
+               <void method="add"> 
+                <object idref="ExprNodeColumnDesc6"/> 
+               </void> 
+              </object> 
+             </void> 
+             <void property="valueSerializeInfo"> 
+              <object id="TableDesc5" class="org.apache.hadoop.hive.ql.plan.TableDesc"> 
+               <void property="inputFileFormatClass"> 
+                <class>org.apache.hadoop.mapred.SequenceFileInputFormat</class> 
+               </void> 
+               <void property="outputFileFormatClass"> 
+                <class>org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat</class> 
+               </void> 
+               <void property="properties"> 
+                <object class="java.util.Properties"> 
+                 <void method="put"> 
+                  <string>columns</string> 
+                  <string>_col0</string> 
+                 </void> 
+                 <void method="put"> 
+                  <string>serialization.lib</string> 
+                  <string>org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe</string> 
+                 </void> 
+                 <void method="put"> 
+                  <string>columns.types</string> 
+                  <string>string</string> 
+                 </void> 
+                 <void method="put"> 
+                  <string>escape.delim</string> 
+                  <string>\</string> 
+                 </void> 
+                </object> 
+               </void> 
+              </object> 
+             </void> 
+            </object> 
+           </void> 
+           <void property="inputAlias"> 
+            <string>src2</string> 
+           </void> 
+           <void property="operatorId"> 
+            <string>RS_4</string> 
+           </void> 
+           <void property="parentOperators"> 
+            <void method="add"> 
+             <object idref="TableScanOperator2"/> 
             </void> 
-           </object> 
-          </void> 
-         </object> 
+           </void> 
+           <void property="schema"> 
+            <object class="org.apache.hadoop.hive.ql.exec.RowSchema"> 
+             <void property="signature"> 
+              <object class="java.util.ArrayList"> 
+               <void method="add"> 
+                <object class="org.apache.hadoop.hive.ql.exec.ColumnInfo"> 
+                 <void property="internalName"> 
+                  <string>VALUE._col0</string> 
+                 </void> 
+                 <void property="tabAlias"> 
+                  <string>src2</string> 
+                 </void> 
+                 <void property="type"> 
+                  <object idref="PrimitiveTypeInfo0"/> 
+                 </void> 
+                 <void property="typeName"> 
+                  <string>string</string> 
+                 </void> 
+                </object> 
+               </void> 
+              </object> 
+             </void> 
+            </object> 
+           </void> 
+          </object> 
+         </void> 
         </void> 
         <void property="conf"> 
          <object class="org.apache.hadoop.hive.ql.plan.TableScanDesc"> 
@@ -2191,181 +2169,177 @@
        <string>src1</string> 
        <object id="TableScanOperator3" class="org.apache.hadoop.hive.ql.exec.TableScanOperator"> 
         <void property="childOperators"> 
-         <object class="java.util.ArrayList"> 
-          <void method="add"> 
-           <object id="ReduceSinkOperator3" class="org.apache.hadoop.hive.ql.exec.ReduceSinkOperator"> 
-            <void property="columnExprMap"> 
-             <object class="java.util.HashMap"> 
-              <void method="put"> 
-               <string>VALUE._col0</string> 
-               <object id="ExprNodeColumnDesc7" class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> 
-                <void property="column"> 
-                 <string>key</string> 
-                </void> 
-                <void property="tabAlias"> 
-                 <string>src1</string> 
-                </void> 
-                <void property="typeInfo"> 
-                 <object idref="PrimitiveTypeInfo0"/> 
-                </void> 
-               </object> 
-              </void> 
-             </object> 
-            </void> 
-            <void property="conf"> 
-             <object class="org.apache.hadoop.hive.ql.plan.ReduceSinkDesc"> 
-              <void property="distinctColumnIndices"> 
-               <object class="java.util.ArrayList"/> 
-              </void> 
-              <void property="keyCols"> 
-               <object id="ArrayList3" class="java.util.ArrayList"> 
-                <void method="add"> 
-                 <object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> 
-                  <void property="column"> 
-                   <string>key</string> 
-                  </void> 
-                  <void property="tabAlias"> 
-                   <string>src1</string> 
-                  </void> 
-                  <void property="typeInfo"> 
-                   <object idref="PrimitiveTypeInfo0"/> 
-                  </void> 
-                 </object> 
-                </void> 
-               </object> 
-              </void> 
-              <void property="keySerializeInfo"> 
-               <object id="TableDesc6" class="org.apache.hadoop.hive.ql.plan.TableDesc"> 
-                <void property="inputFileFormatClass"> 
-                 <class>org.apache.hadoop.mapred.SequenceFileInputFormat</class> 
-                </void> 
-                <void property="outputFileFormatClass"> 
-                 <class>org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat</class> 
-                </void> 
-                <void property="properties"> 
-                 <object class="java.util.Properties"> 
-                  <void method="put"> 
-                   <string>columns</string> 
-                   <string>joinkey0</string> 
-                  </void> 
-                  <void method="put"> 
-                   <string>serialization.lib</string> 
-                   <string>org.apache.hadoop.hive.serde2.binarysortable.BinarySortableSerDe</string> 
-                  </void> 
-                  <void method="put"> 
-                   <string>serialization.sort.order</string> 
-                   <string>+</string> 
-                  </void> 
-                  <void method="put"> 
-                   <string>columns.types</string> 
-                   <string>string</string> 
-                  </void> 
-                 </object> 
-                </void> 
-               </object> 
-              </void> 
-              <void property="numDistributionKeys"> 
-               <int>1</int> 
-              </void> 
-              <void property="numReducers"> 
-               <int>-1</int> 
-              </void> 
-              <void property="outputKeyColumnNames"> 
-               <object class="java.util.ArrayList"> 
-                <void method="add"> 
-                 <string>reducesinkkey0</string> 
-                </void> 
-               </object> 
-              </void> 
-              <void property="outputValueColumnNames"> 
-               <object class="java.util.ArrayList"> 
-                <void method="add"> 
-                 <string>_col0</string> 
-                </void> 
-               </object> 
-              </void> 
-              <void property="partitionCols"> 
-               <object idref="ArrayList3"/> 
-              </void> 
-              <void property="valueCols"> 
-               <object class="java.util.ArrayList"> 
-                <void method="add"> 
-                 <object idref="ExprNodeColumnDesc7"/> 
-                </void> 
-               </object> 
-              </void> 
-              <void property="valueSerializeInfo"> 
-               <object id="TableDesc7" class="org.apache.hadoop.hive.ql.plan.TableDesc"> 
-                <void property="inputFileFormatClass"> 
-                 <class>org.apache.hadoop.mapred.SequenceFileInputFormat</class> 
-                </void> 
-                <void property="outputFileFormatClass"> 
-                 <class>org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat</class> 
-                </void> 
-                <void property="properties"> 
-                 <object class="java.util.Properties"> 
-                  <void method="put"> 
-                   <string>columns</string> 
-                   <string>_col0</string> 
-                  </void> 
-                  <void method="put"> 
-                   <string>serialization.lib</string> 
-                   <string>org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe</string> 
-                  </void> 
-                  <void method="put"> 
-                   <string>columns.types</string> 
-                   <string>string</string> 
-                  </void> 
-                  <void method="put"> 
-                   <string>escape.delim</string> 
-                   <string>\</string> 
-                  </void> 
-                 </object> 
-                </void> 
-               </object> 
-              </void> 
-             </object> 
-            </void> 
-            <void property="inputAlias"> 
-             <string>src1</string> 
-            </void> 
-            <void property="operatorId"> 
-             <string>RS_3</string> 
-            </void> 
-            <void property="parentOperators"> 
-             <object class="java.util.ArrayList"> 
-              <void method="add"> 
-               <object idref="TableScanOperator3"/> 
-              </void> 
-             </object> 
-            </void> 
-            <void property="schema"> 
-             <object class="org.apache.hadoop.hive.ql.exec.RowSchema"> 
-              <void property="signature"> 
-               <object class="java.util.ArrayList"> 
-                <void method="add"> 
-                 <object class="org.apache.hadoop.hive.ql.exec.ColumnInfo"> 
-                  <void property="internalName"> 
-                   <string>VALUE._col0</string> 
-                  </void> 
-                  <void property="tabAlias"> 
-                   <string>src1</string> 
-                  </void> 
-                  <void property="type"> 
-                   <object idref="PrimitiveTypeInfo0"/> 
-                  </void> 
-                  <void property="typeName"> 
-                   <string>string</string> 
-                  </void> 
-                 </object> 
-                </void> 
-               </object> 
-              </void> 
-             </object> 
+         <void method="add"> 
+          <object id="ReduceSinkOperator3" class="org.apache.hadoop.hive.ql.exec.ReduceSinkOperator"> 
+           <void property="columnExprMap"> 
+            <object class="java.util.HashMap"> 
+             <void method="put"> 
+              <string>VALUE._col0</string> 
+              <object id="ExprNodeColumnDesc7" class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> 
+               <void property="column"> 
+                <string>key</string> 
+               </void> 
+               <void property="tabAlias"> 
+                <string>src1</string> 
+               </void> 
+               <void property="typeInfo"> 
+                <object idref="PrimitiveTypeInfo0"/> 
+               </void> 
+              </object> 
+             </void> 
+            </object> 
+           </void> 
+           <void property="conf"> 
+            <object class="org.apache.hadoop.hive.ql.plan.ReduceSinkDesc"> 
+             <void property="distinctColumnIndices"> 
+              <object class="java.util.ArrayList"/> 
+             </void> 
+             <void property="keyCols"> 
+              <object id="ArrayList3" class="java.util.ArrayList"> 
+               <void method="add"> 
+                <object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> 
+                 <void property="column"> 
+                  <string>key</string> 
+                 </void> 
+                 <void property="tabAlias"> 
+                  <string>src1</string> 
+                 </void> 
+                 <void property="typeInfo"> 
+                  <object idref="PrimitiveTypeInfo0"/> 
+                 </void> 
+                </object> 
+               </void> 
+              </object> 
+             </void> 
+             <void property="keySerializeInfo"> 
+              <object id="TableDesc6" class="org.apache.hadoop.hive.ql.plan.TableDesc"> 
+               <void property="inputFileFormatClass"> 
+                <class>org.apache.hadoop.mapred.SequenceFileInputFormat</class> 
+               </void> 
+               <void property="outputFileFormatClass"> 
+                <class>org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat</class> 
+               </void> 
+               <void property="properties"> 
+                <object class="java.util.Properties"> 
+                 <void method="put"> 
+                  <string>columns</string> 
+                  <string>joinkey0</string> 
+                 </void> 
+                 <void method="put"> 
+                  <string>serialization.lib</string> 
+                  <string>org.apache.hadoop.hive.serde2.binarysortable.BinarySortableSerDe</string> 
+                 </void> 
+                 <void method="put"> 
+                  <string>serialization.sort.order</string> 
+                  <string>+</string> 
+                 </void> 
+                 <void method="put"> 
+                  <string>columns.types</string> 
+                  <string>string</string> 
+                 </void> 
+                </object> 
+               </void> 
+              </object> 
+             </void> 
+             <void property="numDistributionKeys"> 
+              <int>1</int> 
+             </void> 
+             <void property="numReducers"> 
+              <int>-1</int> 
+             </void> 
+             <void property="outputKeyColumnNames"> 
+              <object class="java.util.ArrayList"> 
+               <void method="add"> 
+                <string>reducesinkkey0</string> 
+               </void> 
+              </object> 
+             </void> 
+             <void property="outputValueColumnNames"> 
+              <object class="java.util.ArrayList"> 
+               <void method="add"> 
+                <string>_col0</string> 
+               </void> 
+              </object> 
+             </void> 
+             <void property="partitionCols"> 
+              <object idref="ArrayList3"/> 
+             </void> 
+             <void property="valueCols"> 
+              <object class="java.util.ArrayList"> 
+               <void method="add"> 
+                <object idref="ExprNodeColumnDesc7"/> 
+               </void> 
+              </object> 
+             </void> 
+             <void property="valueSerializeInfo"> 
+              <object id="TableDesc7" class="org.apache.hadoop.hive.ql.plan.TableDesc"> 
+               <void property="inputFileFormatClass"> 
+                <class>org.apache.hadoop.mapred.SequenceFileInputFormat</class> 
+               </void> 
+               <void property="outputFileFormatClass"> 
+                <class>org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat</class> 
+               </void> 
+               <void property="properties"> 
+                <object class="java.util.Properties"> 
+                 <void method="put"> 
+                  <string>columns</string> 
+                  <string>_col0</string> 
+                 </void> 
+                 <void method="put"> 
+                  <string>serialization.lib</string> 
+                  <string>org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe</string> 
+                 </void> 
+                 <void method="put"> 
+                  <string>columns.types</string> 
+                  <string>string</string> 
+                 </void> 
+                 <void method="put"> 
+                  <string>escape.delim</string> 
+                  <string>\</string> 
+                 </void> 
+                </object> 
+               </void> 
+              </object> 
+             </void> 
+            </object> 
+           </void> 
+           <void property="inputAlias"> 
+            <string>src1</string> 
+           </void> 
+           <void property="operatorId"> 
+            <string>RS_3</string> 
+           </void> 
+           <void property="parentOperators"> 
+            <void method="add"> 
+             <object idref="TableScanOperator3"/> 
             </void> 
-           </object> 
-          </void> 
-         </object> 
+           </void> 
+           <void property="schema"> 
+            <object class="org.apache.hadoop.hive.ql.exec.RowSchema"> 
+             <void property="signature"> 
+              <object class="java.util.ArrayList"> 
+               <void method="add"> 
+                <object class="org.apache.hadoop.hive.ql.exec.ColumnInfo"> 
+                 <void property="internalName"> 
+                  <string>VALUE._col0</string> 
+                 </void> 
+                 <void property="tabAlias"> 
+                  <string>src1</string> 
+                 </void> 
+                 <void property="type"> 
+                  <object idref="PrimitiveTypeInfo0"/> 
+                 </void> 
+                 <void property="typeName"> 
+                  <string>string</string> 
+                 </void> 
+                </object> 
+               </void> 
+              </object> 
+             </void> 
+            </object> 
+           </void> 
+          </object> 
+         </void> 
         </void> 
         <void property="conf"> 
          <object class="org.apache.hadoop.hive.ql.plan.TableScanDesc"> 
@@ -2668,41 +2642,37 @@
       <void property="reducer"> 
        <object id="JoinOperator1" class="org.apache.hadoop.hive.ql.exec.JoinOperator"> 
         <void property="childOperators"> 
-         <object class="java.util.ArrayList"> 
-          <void method="add"> 
-           <object class="org.apache.hadoop.hive.ql.exec.FileSinkOperator"> 
-            <void property="conf"> 
-             <object class="org.apache.hadoop.hive.ql.plan.FileSinkDesc"> 
-              <void property="dirName"> 
-               #### A masked pattern was here #### 
-              </void> 
-              <void property="numFiles"> 
-               <int>1</int> 
-              </void> 
-              <void property="tableInfo"> 
-               <object idref="TableDesc4"/> 
-              </void> 
-              <void property="totalFiles"> 
-               <int>1</int> 
-              </void> 
-             </object> 
-            </void> 
-            <void property="operatorId"> 
-             <string>FS_11</string> 
-            </void> 
-            <void property="parentOperators"> 
-             <object class="java.util.ArrayList"> 
-              <void method="add"> 
-               <object idref="JoinOperator1"/> 
-              </void> 
-             </object> 
-            </void> 
-            <void property="schema"> 
-             <object idref="RowSchema0"/> 
+         <void method="add"> 
+          <object class="org.apache.hadoop.hive.ql.exec.FileSinkOperator"> 
+           <void property="conf"> 
+            <object class="org.apache.hadoop.hive.ql.plan.FileSinkDesc"> 
+             <void property="dirName"> 
+              #### A masked pattern was here #### 
+             </void> 
+             <void property="numFiles"> 
+              <int>1</int> 
+             </void> 
+             <void property="tableInfo"> 
+              <object idref="TableDesc4"/> 
+             </void> 
+             <void property="totalFiles"> 
+              <int>1</int> 
+             </void> 
+            </object> 
+           </void> 
+           <void property="operatorId"> 
+            <string>FS_11</string> 
+           </void> 
+           <void property="parentOperators"> 
+            <void method="add"> 
+             <object idref="JoinOperator1"/> 
             </void> 
-           </object> 
-          </void> 
-         </object> 
+           </void> 
+           <void property="schema"> 
+            <object idref="RowSchema0"/> 
+           </void> 
+          </object> 
+         </void> 
         </void> 
         <void property="columnExprMap"> 
          <object class="java.util.HashMap"> 
@@ -2852,14 +2822,12 @@
          <string>JOIN_5</string> 
         </void> 
         <void property="parentOperators"> 
-         <object class="java.util.ArrayList"> 
-          <void method="add"> 
-           <object idref="ReduceSinkOperator3"/> 
-          </void> 
-          <void method="add"> 
-           <object idref="ReduceSinkOperator2"/> 
-          </void> 
-         </object> 
+         <void method="add"> 
+          <object idref="ReduceSinkOperator3"/> 
+         </void> 
+         <void method="add"> 
+          <object idref="ReduceSinkOperator2"/> 
+         </void> 
         </void> 
         <void property="posToAliasMap"> 
          <object class="java.util.HashMap">