Index: ql/src/test/results/clientpositive/cast1.q.out =================================================================== --- ql/src/test/results/clientpositive/cast1.q.out (revision 742964) +++ ql/src/test/results/clientpositive/cast1.q.out (working copy) @@ -52,6 +52,7 @@ type: int File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/quote1.q.out =================================================================== --- ql/src/test/results/clientpositive/quote1.q.out (revision 742964) +++ ql/src/test/results/clientpositive/quote1.q.out (working copy) @@ -28,6 +28,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -73,6 +74,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/notable_alias2.q.out =================================================================== --- ql/src/test/results/clientpositive/notable_alias2.q.out (revision 742964) +++ ql/src/test/results/clientpositive/notable_alias2.q.out (working copy) @@ -41,6 +41,7 @@ mode: partial1 File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.mapred.SequenceFileOutputFormat @@ -49,7 +50,7 @@ Stage: Stage-2 Map Reduce Alias -> Map Operator Tree: - /data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/tmp/903914190/338096343.10001 + /data/users/suresh/hive_external/build/ql/tmp/469216093/1439919461.10001 Reduce Output Operator key expressions: expr: 0 @@ -88,6 +89,7 @@ type: double File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/join2.q.out =================================================================== --- ql/src/test/results/clientpositive/join2.q.out (revision 742964) +++ ql/src/test/results/clientpositive/join2.q.out (working copy) @@ -53,6 +53,7 @@ 1 {VALUE.0} File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.mapred.SequenceFileOutputFormat @@ -112,6 +113,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/join6.q.out =================================================================== --- ql/src/test/results/clientpositive/join6.q.out (revision 742964) +++ ql/src/test/results/clientpositive/join6.q.out (working copy) @@ -98,6 +98,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/input7.q.out =================================================================== --- ql/src/test/results/clientpositive/input7.q.out (revision 742964) +++ ql/src/test/results/clientpositive/input7.q.out (working copy) @@ -28,6 +28,7 @@ type: int File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/udf1.q.out =================================================================== --- ql/src/test/results/clientpositive/udf1.q.out (revision 742964) +++ ql/src/test/results/clientpositive/udf1.q.out (working copy) @@ -56,6 +56,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/join12.q.out =================================================================== --- ql/src/test/results/clientpositive/join12.q.out (revision 742964) +++ ql/src/test/results/clientpositive/join12.q.out (working copy) @@ -97,6 +97,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/udf5.q.out =================================================================== --- ql/src/test/results/clientpositive/udf5.q.out (revision 742964) +++ ql/src/test/results/clientpositive/udf5.q.out (working copy) @@ -31,6 +31,7 @@ type: int File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/input13.q.out =================================================================== --- ql/src/test/results/clientpositive/input13.q.out (revision 742964) +++ ql/src/test/results/clientpositive/input13.q.out (working copy) @@ -28,6 +28,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -51,6 +52,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 2 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -70,6 +72,7 @@ type: int File Output Operator compressed: false + GlobalTableId: 3 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -85,6 +88,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 4 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/join16.q.out =================================================================== --- ql/src/test/results/clientpositive/join16.q.out (revision 742964) +++ ql/src/test/results/clientpositive/join16.q.out (working copy) @@ -80,6 +80,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/input17.q.out =================================================================== --- ql/src/test/results/clientpositive/input17.q.out (revision 742964) +++ ql/src/test/results/clientpositive/input17.q.out (working copy) @@ -59,6 +59,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/groupby1.q.out =================================================================== --- ql/src/test/results/clientpositive/groupby1.q.out (revision 742964) +++ ql/src/test/results/clientpositive/groupby1.q.out (working copy) @@ -33,6 +33,7 @@ mode: partial1 File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.mapred.SequenceFileOutputFormat @@ -41,7 +42,7 @@ Stage: Stage-2 Map Reduce Alias -> Map Operator Tree: - /tmp/hive-zshao/67494501/106593589.10001 + /data/users/suresh/hive_external/build/ql/tmp/287994644/628135548.10001 Reduce Output Operator key expressions: expr: 0 @@ -76,6 +77,7 @@ type: double File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/groupby5.q.out =================================================================== --- ql/src/test/results/clientpositive/groupby5.q.out (revision 742964) +++ ql/src/test/results/clientpositive/groupby5.q.out (working copy) @@ -33,6 +33,7 @@ mode: partial1 File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.mapred.SequenceFileOutputFormat @@ -41,7 +42,7 @@ Stage: Stage-2 Map Reduce Alias -> Map Operator Tree: - /tmp/hive-zshao/350108858/95672649.10001 + /data/users/suresh/hive_external/build/ql/tmp/99653115/640125307.10001 Reduce Output Operator key expressions: expr: 0 @@ -76,6 +77,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/mapreduce3.q.out =================================================================== --- ql/src/test/results/clientpositive/mapreduce3.q.out (revision 742964) +++ ql/src/test/results/clientpositive/mapreduce3.q.out (working copy) @@ -56,6 +56,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/input11_limit.q.out =================================================================== --- ql/src/test/results/clientpositive/input11_limit.q.out (revision 742964) +++ ql/src/test/results/clientpositive/input11_limit.q.out (working copy) @@ -40,6 +40,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/join21.q.out =================================================================== --- ql/src/test/results/clientpositive/join21.q.out (revision 742964) +++ ql/src/test/results/clientpositive/join21.q.out (working copy) @@ -91,6 +91,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/sample4.q.out =================================================================== --- ql/src/test/results/clientpositive/sample4.q.out (revision 742964) +++ ql/src/test/results/clientpositive/sample4.q.out (working copy) @@ -24,7 +24,8 @@ type: string File Output Operator compressed: false - directory: /tmp/hive-zshao/134470671/579412318.10000.insclause-0 + GlobalTableId: 1 + directory: /data/users/suresh/hive_external/ql/../build/ql/tmp/789968954/248071171.10000.insclause-0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -37,14 +38,14 @@ serialization.lib org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat - location file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/dest1 + location file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest1 serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe name: dest1 Needs Tagging: false Path -> Alias: - file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/srcbucket/kv1.txt + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcbucket/kv1.txt Path -> Partition: - file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/srcbucket/kv1.txt + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcbucket/kv1.txt Partition input format: org.apache.hadoop.mapred.TextInputFormat @@ -59,7 +60,7 @@ serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat - location file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/srcbucket + location file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcbucket serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe name: srcbucket @@ -67,7 +68,7 @@ Move Operator tables: replace: true - source: /tmp/hive-zshao/134470671/579412318.10000.insclause-0 + source: /data/users/suresh/hive_external/ql/../build/ql/tmp/789968954/248071171.10000.insclause-0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -80,7 +81,7 @@ serialization.lib org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat - location file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/dest1 + location file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest1 serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe name: dest1 Index: ql/src/test/results/clientpositive/groupby2_map.q.out =================================================================== --- ql/src/test/results/clientpositive/groupby2_map.q.out (revision 742964) +++ ql/src/test/results/clientpositive/groupby2_map.q.out (working copy) @@ -50,6 +50,7 @@ mode: partial2 File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.mapred.SequenceFileOutputFormat @@ -58,7 +59,7 @@ Stage: Stage-2 Map Reduce Alias -> Map Operator Tree: - /data/users/athusoo/commits/hive_trunk_ws3/build/ql/tmp/435212851/489689211.10001 + /data/users/suresh/hive_external/build/ql/tmp/1256925605/630138017.10001 Reduce Output Operator key expressions: expr: 0 @@ -100,6 +101,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/sample8.q.out =================================================================== --- ql/src/test/results/clientpositive/sample8.q.out (revision 742964) +++ ql/src/test/results/clientpositive/sample8.q.out (working copy) @@ -48,12 +48,12 @@ type: string Needs Tagging: true Path -> Alias: - file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 - file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 - file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11 - file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcpart/hr=11/ds=2008-04-08 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcpart/hr=12/ds=2008-04-08 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcpart/hr=11/ds=2008-04-09 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcpart/hr=12/ds=2008-04-09 Path -> Partition: - file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcpart/hr=11/ds=2008-04-08 Partition partition values: ds 2008-04-08 @@ -71,10 +71,10 @@ serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat - location file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/srcpart + location file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcpart serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe name: srcpart - file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcpart/hr=12/ds=2008-04-08 Partition partition values: ds 2008-04-08 @@ -92,10 +92,10 @@ serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat - location file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/srcpart + location file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcpart serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe name: srcpart - file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcpart/hr=11/ds=2008-04-09 Partition partition values: ds 2008-04-09 @@ -113,10 +113,10 @@ serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat - location file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/srcpart + location file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcpart serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe name: srcpart - file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcpart/hr=12/ds=2008-04-09 Partition partition values: ds 2008-04-09 @@ -134,7 +134,7 @@ serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat - location file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/srcpart + location file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcpart serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe name: srcpart Reduce Operator Tree: @@ -160,7 +160,8 @@ type: string File Output Operator compressed: false - directory: /data/users/pchakka/workspace/oshive/build/ql/tmp/502758895/785997617.10002 + GlobalTableId: 0 + directory: /data/users/suresh/hive_external/build/ql/tmp/600356981/235571489.10002 table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.mapred.SequenceFileOutputFormat @@ -173,7 +174,7 @@ Stage: Stage-2 Map Reduce Alias -> Map Operator Tree: - /data/users/pchakka/workspace/oshive/build/ql/tmp/502758895/785997617.10002 + /data/users/suresh/hive_external/build/ql/tmp/600356981/235571489.10002 Reduce Output Operator key expressions: expr: 0 @@ -198,9 +199,9 @@ type: string Needs Tagging: false Path -> Alias: - /data/users/pchakka/workspace/oshive/build/ql/tmp/502758895/785997617.10002 + /data/users/suresh/hive_external/build/ql/tmp/600356981/235571489.10002 Path -> Partition: - /data/users/pchakka/workspace/oshive/build/ql/tmp/502758895/785997617.10002 + /data/users/suresh/hive_external/build/ql/tmp/600356981/235571489.10002 Partition input format: org.apache.hadoop.mapred.SequenceFileInputFormat @@ -214,7 +215,8 @@ Extract File Output Operator compressed: false - directory: /data/users/pchakka/workspace/oshive/ql/../build/ql/tmp/67235665.10001.insclause-0 + GlobalTableId: 0 + directory: /data/users/suresh/hive_external/ql/../build/ql/tmp/16563792.10001.insclause-0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/notable_alias1.q.out =================================================================== --- ql/src/test/results/clientpositive/notable_alias1.q.out (revision 742964) +++ ql/src/test/results/clientpositive/notable_alias1.q.out (working copy) @@ -41,6 +41,7 @@ mode: partial1 File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.mapred.SequenceFileOutputFormat @@ -49,7 +50,7 @@ Stage: Stage-2 Map Reduce Alias -> Map Operator Tree: - /data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/tmp/562761632/249466954.10001 + /data/users/suresh/hive_external/build/ql/tmp/1153174700/532978610.10001 Reduce Output Operator key expressions: expr: 0 @@ -88,6 +89,7 @@ type: double File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/join1.q.out =================================================================== --- ql/src/test/results/clientpositive/join1.q.out (revision 742964) +++ ql/src/test/results/clientpositive/join1.q.out (working copy) @@ -62,6 +62,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/join5.q.out =================================================================== --- ql/src/test/results/clientpositive/join5.q.out (revision 742964) +++ ql/src/test/results/clientpositive/join5.q.out (working copy) @@ -98,6 +98,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/input6.q.out =================================================================== --- ql/src/test/results/clientpositive/input6.q.out (revision 742964) +++ ql/src/test/results/clientpositive/input6.q.out (working copy) @@ -22,6 +22,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/join9.q.out =================================================================== --- ql/src/test/results/clientpositive/join9.q.out (revision 742964) +++ ql/src/test/results/clientpositive/join9.q.out (working copy) @@ -51,10 +51,10 @@ type: string Needs Tagging: true Path -> Alias: - file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/src - file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcpart/hr=12/ds=2008-04-08 Path -> Partition: - file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src Partition input format: org.apache.hadoop.mapred.TextInputFormat @@ -68,10 +68,10 @@ serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat - location file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/src + location file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe name: src - file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcpart/hr=12/ds=2008-04-08 Partition partition values: ds 2008-04-08 @@ -89,7 +89,7 @@ serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat - location file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/srcpart + location file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcpart serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe name: srcpart Reduce Operator Tree: @@ -117,7 +117,8 @@ type: string File Output Operator compressed: false - directory: /tmp/hive-zshao/1146110304.10000.insclause-0 + GlobalTableId: 1 + directory: /data/users/suresh/hive_external/ql/../build/ql/tmp/334297154.10000.insclause-0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -130,7 +131,7 @@ serialization.lib org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat - location file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/dest1 + location file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest1 serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe name: dest1 @@ -138,7 +139,7 @@ Move Operator tables: replace: true - source: /tmp/hive-zshao/1146110304.10000.insclause-0 + source: /data/users/suresh/hive_external/ql/../build/ql/tmp/334297154.10000.insclause-0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -151,7 +152,7 @@ serialization.lib org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat - location file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/dest1 + location file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest1 serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe name: dest1 Index: ql/src/test/results/clientpositive/binarysortable_1.q.out =================================================================== --- ql/src/test/results/clientpositive/binarysortable_1.q.out (revision 742964) +++ ql/src/test/results/clientpositive/binarysortable_1.q.out (working copy) @@ -33,6 +33,7 @@ mode: partial1 File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.mapred.SequenceFileOutputFormat @@ -41,7 +42,7 @@ Stage: Stage-2 Map Reduce Alias -> Map Operator Tree: - /data/users/zshao/sync/apache-trunk-HIVE-264/build/ql/tmp/33512536/104684401.10002 + /data/users/suresh/hive_external/build/ql/tmp/541952217/255370713.10002 Reduce Output Operator key expressions: expr: 0 @@ -76,6 +77,7 @@ type: double File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/join11.q.out =================================================================== --- ql/src/test/results/clientpositive/join11.q.out (revision 742964) +++ ql/src/test/results/clientpositive/join11.q.out (working copy) @@ -70,6 +70,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/udf4.q.out =================================================================== --- ql/src/test/results/clientpositive/udf4.q.out (revision 742964) +++ ql/src/test/results/clientpositive/udf4.q.out (working copy) @@ -53,6 +53,7 @@ type: int File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/input12.q.out =================================================================== --- ql/src/test/results/clientpositive/input12.q.out (revision 742964) +++ ql/src/test/results/clientpositive/input12.q.out (working copy) @@ -28,6 +28,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -51,6 +52,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 2 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -70,6 +72,7 @@ type: int File Output Operator compressed: false + GlobalTableId: 3 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/join15.q.out =================================================================== --- ql/src/test/results/clientpositive/join15.q.out (revision 742964) +++ ql/src/test/results/clientpositive/join15.q.out (working copy) @@ -58,6 +58,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/udf8.q.out =================================================================== --- ql/src/test/results/clientpositive/udf8.q.out (revision 742964) +++ ql/src/test/results/clientpositive/udf8.q.out (working copy) @@ -29,6 +29,7 @@ mode: partial1 File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.mapred.SequenceFileOutputFormat @@ -37,7 +38,7 @@ Stage: Stage-2 Map Reduce Alias -> Map Operator Tree: - /data/users/athusoo/commits/hive_trunk_ws2/build/ql/tmp/181599227/280831237.10002 + /data/users/suresh/hive_external/build/ql/tmp/309143928/46568798.10002 Reduce Output Operator sort order: tag: -1 @@ -65,6 +66,7 @@ type: bigint File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/udf_json.q.out =================================================================== --- ql/src/test/results/clientpositive/udf_json.q.out (revision 742964) +++ ql/src/test/results/clientpositive/udf_json.q.out (working copy) @@ -16,6 +16,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/join19.q.out =================================================================== --- ql/src/test/results/clientpositive/join19.q.out (revision 742964) +++ ql/src/test/results/clientpositive/join19.q.out (working copy) @@ -117,6 +117,7 @@ 2 {VALUE.0} {VALUE.1} File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.mapred.SequenceFileOutputFormat @@ -219,6 +220,7 @@ 2 {VALUE.0} {VALUE.1} File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.mapred.SequenceFileOutputFormat @@ -307,6 +309,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -331,6 +334,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/groupby4.q.out =================================================================== --- ql/src/test/results/clientpositive/groupby4.q.out (revision 742964) +++ ql/src/test/results/clientpositive/groupby4.q.out (working copy) @@ -32,6 +32,7 @@ mode: partial1 File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.mapred.SequenceFileOutputFormat @@ -40,7 +41,7 @@ Stage: Stage-2 Map Reduce Alias -> Map Operator Tree: - /tmp/hive-zshao/1491006708/287075280.10001 + /data/users/suresh/hive_external/build/ql/tmp/119853533/190668112.10001 Reduce Output Operator key expressions: expr: 0 @@ -62,6 +63,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/input1_limit.q.out =================================================================== --- ql/src/test/results/clientpositive/input1_limit.q.out (revision 742964) +++ ql/src/test/results/clientpositive/input1_limit.q.out (working copy) @@ -44,6 +44,7 @@ Limit File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.mapred.SequenceFileOutputFormat @@ -59,6 +60,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -84,7 +86,7 @@ Stage: Stage-2 Map Reduce Alias -> Map Operator Tree: - /data/users/zshao/sync/apache-trunk-HIVE-105/build/ql/tmp/1425158066/374907939.10002 + /data/users/suresh/hive_external/build/ql/tmp/1397870202/131633029.10002 Reduce Output Operator sort order: tag: -1 @@ -104,6 +106,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 2 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/input3_limit.q.out =================================================================== --- ql/src/test/results/clientpositive/input3_limit.q.out (revision 742964) +++ ql/src/test/results/clientpositive/input3_limit.q.out (working copy) @@ -44,6 +44,7 @@ Limit File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.mapred.SequenceFileOutputFormat @@ -52,7 +53,7 @@ Stage: Stage-2 Map Reduce Alias -> Map Operator Tree: - /data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/156027535/510873534.10001 + /data/users/suresh/hive_external/build/ql/tmp/441001993/743309592.10001 Reduce Output Operator sort order: tag: -1 @@ -66,6 +67,7 @@ Limit File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -83,23 +85,23 @@ name: t2 +100 val_101 +104 val_105 +104 val_105 +104 val_104 +104 val_104 +103 val_103 +103 val_103 +102 val_103 +101 val_102 0 val_0 +100 val_101 +100 val_100 +100 val_100 +10 val_11 +10 val_10 +1 val_2 +0 val_1 +0 val_1 0 val_0 0 val_0 -0 val_1 -0 val_1 -1 val_2 -10 val_10 -10 val_11 -100 val_100 -100 val_100 -100 val_101 -100 val_101 -101 val_102 -102 val_103 -103 val_103 -103 val_103 -104 val_104 -104 val_104 -104 val_105 -104 val_105 Index: ql/src/test/results/clientpositive/case_sensitivity.q.out =================================================================== --- ql/src/test/results/clientpositive/case_sensitivity.q.out (revision 742964) +++ ql/src/test/results/clientpositive/case_sensitivity.q.out (working copy) @@ -28,6 +28,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/mapreduce2.q.out =================================================================== --- ql/src/test/results/clientpositive/mapreduce2.q.out (revision 742964) +++ ql/src/test/results/clientpositive/mapreduce2.q.out (working copy) @@ -56,6 +56,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/mapreduce6.q.out =================================================================== --- ql/src/test/results/clientpositive/mapreduce6.q.out (revision 742964) +++ ql/src/test/results/clientpositive/mapreduce6.q.out (working copy) @@ -56,6 +56,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/join20.q.out =================================================================== --- ql/src/test/results/clientpositive/join20.q.out (revision 742964) +++ ql/src/test/results/clientpositive/join20.q.out (working copy) @@ -87,6 +87,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -257,6 +258,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/input21.q.out =================================================================== --- ql/src/test/results/clientpositive/input21.q.out (revision 742964) +++ ql/src/test/results/clientpositive/input21.q.out (working copy) @@ -42,6 +42,7 @@ Extract File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/sample3.q.out =================================================================== --- ql/src/test/results/clientpositive/sample3.q.out (revision 742964) +++ ql/src/test/results/clientpositive/sample3.q.out (working copy) @@ -24,6 +24,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/groupby2_limit.q.out =================================================================== --- ql/src/test/results/clientpositive/groupby2_limit.q.out (revision 742964) +++ ql/src/test/results/clientpositive/groupby2_limit.q.out (working copy) @@ -33,6 +33,7 @@ mode: partial1 File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.mapred.SequenceFileOutputFormat @@ -41,7 +42,7 @@ Stage: Stage-2 Map Reduce Alias -> Map Operator Tree: - /tmp/hive-zshao/42329253/238260652.10002 + /data/users/suresh/hive_external/build/ql/tmp/810621181/1857143373.10002 Reduce Output Operator key expressions: expr: 0 @@ -71,6 +72,7 @@ Limit File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/groupby3_map.q.out =================================================================== --- ql/src/test/results/clientpositive/groupby3_map.q.out (revision 742964) +++ ql/src/test/results/clientpositive/groupby3_map.q.out (working copy) @@ -57,6 +57,7 @@ mode: partial2 File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.mapred.SequenceFileOutputFormat @@ -65,7 +66,7 @@ Stage: Stage-2 Map Reduce Alias -> Map Operator Tree: - /data/users/athusoo/commits/hive_trunk_ws2/build/ql/tmp/1134254033/650040203.10001 + /data/users/suresh/hive_external/build/ql/tmp/2001246423/596210812.10001 Reduce Output Operator sort order: tag: -1 @@ -115,6 +116,7 @@ type: double File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/sample7.q.out =================================================================== --- ql/src/test/results/clientpositive/sample7.q.out (revision 742964) +++ ql/src/test/results/clientpositive/sample7.q.out (working copy) @@ -32,7 +32,8 @@ type: string File Output Operator compressed: false - directory: /data/users/athusoo/apacheprojects/hive_local_ws3/ql/../build/ql/tmp/390012861/922014023.10000.insclause-0 + GlobalTableId: 1 + directory: /data/users/suresh/hive_external/ql/../build/ql/tmp/589833729/551510608.10000.insclause-0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -45,14 +46,14 @@ serialization.lib org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat - location file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/dest1 + location file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest1 serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe name: dest1 Needs Tagging: false Path -> Alias: - file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/srcbucket/kv1.txt + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcbucket/kv1.txt Path -> Partition: - file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/srcbucket/kv1.txt + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcbucket/kv1.txt Partition input format: org.apache.hadoop.mapred.TextInputFormat @@ -67,7 +68,7 @@ serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat - location file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/srcbucket + location file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcbucket serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe name: srcbucket @@ -75,7 +76,7 @@ Move Operator tables: replace: true - source: /data/users/athusoo/apacheprojects/hive_local_ws3/ql/../build/ql/tmp/390012861/922014023.10000.insclause-0 + source: /data/users/suresh/hive_external/ql/../build/ql/tmp/589833729/551510608.10000.insclause-0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -88,7 +89,7 @@ serialization.lib org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat - location file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/dest1 + location file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest1 serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe name: dest1 Index: ql/src/test/results/clientpositive/join0.q.out =================================================================== --- ql/src/test/results/clientpositive/join0.q.out (revision 742964) +++ ql/src/test/results/clientpositive/join0.q.out (working copy) @@ -67,6 +67,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.mapred.SequenceFileOutputFormat @@ -75,7 +76,7 @@ Stage: Stage-2 Map Reduce Alias -> Map Operator Tree: - /data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/tmp/143976251/534107059.10002 + /data/users/suresh/hive_external/build/ql/tmp/170971306/792928555.10002 Reduce Output Operator key expressions: expr: 0 @@ -101,6 +102,7 @@ Extract File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/cluster.q.out =================================================================== --- ql/src/test/results/clientpositive/cluster.q.out (revision 742964) +++ ql/src/test/results/clientpositive/cluster.q.out (working copy) @@ -38,6 +38,7 @@ Extract File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -88,6 +89,7 @@ Extract File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -138,6 +140,7 @@ Extract File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -188,6 +191,7 @@ Extract File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -238,6 +242,7 @@ Extract File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -288,6 +293,7 @@ Extract File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -338,6 +344,7 @@ Extract File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -394,6 +401,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -469,6 +477,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.mapred.SequenceFileOutputFormat @@ -477,7 +486,7 @@ Stage: Stage-2 Map Reduce Alias -> Map Operator Tree: - /data/users/athusoo/commits/hive_trunk_ws2/build/ql/tmp/268129150/10750666.10002 + /data/users/suresh/hive_external/build/ql/tmp/529723192/436582290.10002 Reduce Output Operator key expressions: expr: 1 @@ -498,6 +507,7 @@ Extract File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -573,6 +583,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.mapred.SequenceFileOutputFormat @@ -581,7 +592,7 @@ Stage: Stage-2 Map Reduce Alias -> Map Operator Tree: - /data/users/athusoo/commits/hive_trunk_ws2/build/ql/tmp/223878920/107499083.10002 + /data/users/suresh/hive_external/build/ql/tmp/365114924/104582958.10002 Reduce Output Operator key expressions: expr: 1 @@ -604,6 +615,7 @@ Extract File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -679,6 +691,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.mapred.SequenceFileOutputFormat @@ -687,7 +700,7 @@ Stage: Stage-2 Map Reduce Alias -> Map Operator Tree: - /data/users/athusoo/commits/hive_trunk_ws2/build/ql/tmp/273045729/75938714.10002 + /data/users/suresh/hive_external/build/ql/tmp/1713503799/1671460661.10002 Reduce Output Operator key expressions: expr: 0 @@ -710,6 +723,7 @@ Extract File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -785,6 +799,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.mapred.SequenceFileOutputFormat @@ -793,7 +808,7 @@ Stage: Stage-2 Map Reduce Alias -> Map Operator Tree: - /data/users/athusoo/commits/hive_trunk_ws2/build/ql/tmp/294539045/192652633.10002 + /data/users/suresh/hive_external/build/ql/tmp/1099370210/528822702.10002 Reduce Output Operator key expressions: expr: 0 @@ -814,6 +829,7 @@ Extract File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -901,6 +917,7 @@ Extract File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/join4.q.out =================================================================== --- ql/src/test/results/clientpositive/join4.q.out (revision 742964) +++ ql/src/test/results/clientpositive/join4.q.out (working copy) @@ -98,6 +98,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/input5.q.out =================================================================== --- ql/src/test/results/clientpositive/input5.q.out (revision 742964) +++ ql/src/test/results/clientpositive/input5.q.out (working copy) @@ -51,6 +51,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/input_testxpath3.q.out =================================================================== --- ql/src/test/results/clientpositive/input_testxpath3.q.out (revision 742964) +++ ql/src/test/results/clientpositive/input_testxpath3.q.out (working copy) @@ -24,6 +24,7 @@ type: array File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/input_dynamicserde.q.out =================================================================== --- ql/src/test/results/clientpositive/input_dynamicserde.q.out (revision 742964) +++ ql/src/test/results/clientpositive/input_dynamicserde.q.out (working copy) @@ -36,6 +36,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/join8.q.out =================================================================== --- ql/src/test/results/clientpositive/join8.q.out (revision 742964) +++ ql/src/test/results/clientpositive/join8.q.out (working copy) @@ -102,6 +102,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/input_testsequencefile.q.out =================================================================== --- ql/src/test/results/clientpositive/input_testsequencefile.q.out (revision 742964) +++ ql/src/test/results/clientpositive/input_testsequencefile.q.out (working copy) @@ -24,6 +24,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.mapred.SequenceFileOutputFormat Index: ql/src/test/results/clientpositive/input9.q.out =================================================================== --- ql/src/test/results/clientpositive/input9.q.out (revision 742964) +++ ql/src/test/results/clientpositive/input9.q.out (working copy) @@ -32,6 +32,7 @@ type: int File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/join10.q.out =================================================================== --- ql/src/test/results/clientpositive/join10.q.out (revision 742964) +++ ql/src/test/results/clientpositive/join10.q.out (working copy) @@ -66,6 +66,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/udf3.q.out =================================================================== --- ql/src/test/results/clientpositive/udf3.q.out (revision 742964) +++ ql/src/test/results/clientpositive/udf3.q.out (working copy) @@ -32,6 +32,7 @@ mode: partial1 File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.mapred.SequenceFileOutputFormat @@ -40,7 +41,7 @@ Stage: Stage-2 Map Reduce Alias -> Map Operator Tree: - /data/users/athusoo/commits/hive_trunk_ws2/build/ql/tmp/461551864/1010092958.10001 + /data/users/suresh/hive_external/build/ql/tmp/127810028/957559972.10001 Reduce Output Operator sort order: tag: -1 @@ -78,6 +79,7 @@ type: int File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/noalias_subq1.q.out =================================================================== --- ql/src/test/results/clientpositive/noalias_subq1.q.out (revision 742964) +++ ql/src/test/results/clientpositive/noalias_subq1.q.out (working copy) @@ -26,6 +26,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/input11.q.out =================================================================== --- ql/src/test/results/clientpositive/input11.q.out (revision 742964) +++ ql/src/test/results/clientpositive/input11.q.out (working copy) @@ -28,6 +28,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/input_testxpath.q.out =================================================================== --- ql/src/test/results/clientpositive/input_testxpath.q.out (revision 742964) +++ ql/src/test/results/clientpositive/input_testxpath.q.out (working copy) @@ -28,6 +28,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/join14.q.out =================================================================== --- ql/src/test/results/clientpositive/join14.q.out (revision 742964) +++ ql/src/test/results/clientpositive/join14.q.out (working copy) @@ -80,6 +80,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/udf7.q.out =================================================================== --- ql/src/test/results/clientpositive/udf7.q.out (revision 742964) +++ ql/src/test/results/clientpositive/udf7.q.out (working copy) @@ -65,6 +65,7 @@ type: double File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/input_part2.q.out =================================================================== --- ql/src/test/results/clientpositive/input_part2.q.out (revision 742964) +++ ql/src/test/results/clientpositive/input_part2.q.out (working copy) @@ -36,7 +36,8 @@ type: string File Output Operator compressed: false - directory: /data/users/athusoo/apacheprojects/hive_local_ws3/ql/../build/ql/tmp/108623150/305040120.10000.insclause-0 + GlobalTableId: 1 + directory: /data/users/suresh/hive_external/ql/../build/ql/tmp/242701691/10134878.10000.insclause-0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -49,7 +50,7 @@ serialization.lib org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat - location file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/dest1 + location file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest1 serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe name: dest1 Filter Operator @@ -78,7 +79,8 @@ type: string File Output Operator compressed: false - directory: /data/users/athusoo/apacheprojects/hive_local_ws3/ql/../build/ql/tmp/108623150/305040120.10001.insclause-1 + GlobalTableId: 2 + directory: /data/users/suresh/hive_external/ql/../build/ql/tmp/242701691/10134878.10001.insclause-1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -91,15 +93,15 @@ serialization.lib org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat - location file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/dest2 + location file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest2 serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe name: dest2 Needs Tagging: false Path -> Alias: - file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 - file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcpart/hr=12/ds=2008-04-08 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcpart/hr=12/ds=2008-04-09 Path -> Partition: - file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcpart/hr=12/ds=2008-04-08 Partition partition values: ds 2008-04-08 @@ -117,10 +119,10 @@ serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat - location file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/srcpart + location file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcpart serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe name: srcpart - file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcpart/hr=12/ds=2008-04-09 Partition partition values: ds 2008-04-09 @@ -138,7 +140,7 @@ serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat - location file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/srcpart + location file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcpart serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe name: srcpart @@ -146,7 +148,7 @@ Move Operator tables: replace: true - source: /data/users/athusoo/apacheprojects/hive_local_ws3/ql/../build/ql/tmp/108623150/305040120.10000.insclause-0 + source: /data/users/suresh/hive_external/ql/../build/ql/tmp/242701691/10134878.10000.insclause-0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -159,11 +161,11 @@ serialization.lib org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat - location file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/dest1 + location file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest1 serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe name: dest1 replace: true - source: /data/users/athusoo/apacheprojects/hive_local_ws3/ql/../build/ql/tmp/108623150/305040120.10001.insclause-1 + source: /data/users/suresh/hive_external/ql/../build/ql/tmp/242701691/10134878.10001.insclause-1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -176,7 +178,7 @@ serialization.lib org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat - location file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/dest2 + location file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest2 serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe name: dest2 Index: ql/src/test/results/clientpositive/join18.q.out =================================================================== --- ql/src/test/results/clientpositive/join18.q.out (revision 742964) +++ ql/src/test/results/clientpositive/join18.q.out (working copy) @@ -38,6 +38,7 @@ mode: partial1 File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.mapred.SequenceFileOutputFormat @@ -46,7 +47,7 @@ Stage: Stage-2 Map Reduce Alias -> Map Operator Tree: - /tmp/hive-zshao/356667681/95990945.10002 + /data/users/suresh/hive_external/build/ql/tmp/54808731/11270645.10002 Reduce Output Operator key expressions: expr: 0 @@ -75,6 +76,7 @@ type: bigint File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.mapred.SequenceFileOutputFormat @@ -116,6 +118,7 @@ type: bigint File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -153,6 +156,7 @@ type: bigint File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -183,6 +187,7 @@ mode: partial1 File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.mapred.SequenceFileOutputFormat @@ -191,7 +196,7 @@ Stage: Stage-5 Map Reduce Alias -> Map Operator Tree: - /tmp/hive-zshao/356667681/95990945.10004 + /data/users/suresh/hive_external/build/ql/tmp/54808731/11270645.10004 Reduce Output Operator key expressions: expr: 0 @@ -220,6 +225,7 @@ type: bigint File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.mapred.SequenceFileOutputFormat Index: ql/src/test/results/clientpositive/subq.q.out =================================================================== --- ql/src/test/results/clientpositive/subq.q.out (revision 742964) +++ ql/src/test/results/clientpositive/subq.q.out (working copy) @@ -28,6 +28,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/groupby3.q.out =================================================================== --- ql/src/test/results/clientpositive/groupby3.q.out (revision 742964) +++ ql/src/test/results/clientpositive/groupby3.q.out (working copy) @@ -35,6 +35,7 @@ mode: partial1 File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.mapred.SequenceFileOutputFormat @@ -43,7 +44,7 @@ Stage: Stage-2 Map Reduce Alias -> Map Operator Tree: - /data/users/athusoo/commits/hive_trunk_ws2/build/ql/tmp/156149158/223155059.10001 + /data/users/suresh/hive_external/build/ql/tmp/1191604849/22577791.10001 Reduce Output Operator sort order: tag: -1 @@ -93,6 +94,7 @@ type: double File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/union2.q.out =================================================================== --- ql/src/test/results/clientpositive/union2.q.out (revision 742964) +++ ql/src/test/results/clientpositive/union2.q.out (working copy) @@ -49,6 +49,7 @@ mode: partial1 File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.mapred.SequenceFileOutputFormat @@ -57,7 +58,7 @@ Stage: Stage-2 Map Reduce Alias -> Map Operator Tree: - /tmp/hive-zshao/175321401/121204523.10002 + /data/users/suresh/hive_external/build/ql/tmp/560780136/131469903.10002 Reduce Output Operator sort order: tag: -1 @@ -75,6 +76,7 @@ type: bigint File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/input_part6.q.out =================================================================== --- ql/src/test/results/clientpositive/input_part6.q.out (revision 742964) +++ ql/src/test/results/clientpositive/input_part6.q.out (working copy) @@ -27,6 +27,7 @@ Limit File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/mapreduce1.q.out =================================================================== --- ql/src/test/results/clientpositive/mapreduce1.q.out (revision 742964) +++ ql/src/test/results/clientpositive/mapreduce1.q.out (working copy) @@ -61,6 +61,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/mapreduce5.q.out =================================================================== --- ql/src/test/results/clientpositive/mapreduce5.q.out (revision 742964) +++ ql/src/test/results/clientpositive/mapreduce5.q.out (working copy) @@ -56,6 +56,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/subq2.q.out =================================================================== --- ql/src/test/results/clientpositive/subq2.q.out (revision 742964) +++ ql/src/test/results/clientpositive/subq2.q.out (working copy) @@ -37,6 +37,7 @@ mode: partial1 File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.mapred.SequenceFileOutputFormat @@ -45,7 +46,7 @@ Stage: Stage-2 Map Reduce Alias -> Map Operator Tree: - /data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/tmp/217677179/137363579.10002 + /data/users/suresh/hive_external/build/ql/tmp/133408716/187707568.10002 Reduce Output Operator key expressions: expr: 0 @@ -84,6 +85,7 @@ type: bigint File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/input20.q.out =================================================================== --- ql/src/test/results/clientpositive/input20.q.out (revision 742964) +++ ql/src/test/results/clientpositive/input20.q.out (working copy) @@ -60,6 +60,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/input14_limit.q.out =================================================================== --- ql/src/test/results/clientpositive/input14_limit.q.out (revision 742964) +++ ql/src/test/results/clientpositive/input14_limit.q.out (working copy) @@ -41,6 +41,7 @@ Limit File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.mapred.SequenceFileOutputFormat @@ -49,7 +50,7 @@ Stage: Stage-2 Map Reduce Alias -> Map Operator Tree: - /data/users/zshao/sync/apache-trunk-HIVE-105/build/ql/tmp/360702650/134814302.10001 + /data/users/suresh/hive_external/build/ql/tmp/123043324/51243109.10001 Reduce Output Operator key expressions: expr: 0 @@ -85,6 +86,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/sample2.q.out =================================================================== --- ql/src/test/results/clientpositive/sample2.q.out (revision 742964) +++ ql/src/test/results/clientpositive/sample2.q.out (working copy) @@ -24,7 +24,8 @@ type: string File Output Operator compressed: false - directory: /tmp/hive-zshao/427867399/126053246.10000.insclause-0 + GlobalTableId: 1 + directory: /data/users/suresh/hive_external/ql/../build/ql/tmp/910988872/819850289.10000.insclause-0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -37,14 +38,14 @@ serialization.lib org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat - location file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/dest1 + location file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest1 serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe name: dest1 Needs Tagging: false Path -> Alias: - file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/srcbucket/kv1.txt + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcbucket/kv1.txt Path -> Partition: - file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/srcbucket/kv1.txt + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcbucket/kv1.txt Partition input format: org.apache.hadoop.mapred.TextInputFormat @@ -59,7 +60,7 @@ serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat - location file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/srcbucket + location file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcbucket serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe name: srcbucket @@ -67,7 +68,7 @@ Move Operator tables: replace: true - source: /tmp/hive-zshao/427867399/126053246.10000.insclause-0 + source: /data/users/suresh/hive_external/ql/../build/ql/tmp/910988872/819850289.10000.insclause-0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -80,7 +81,7 @@ serialization.lib org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat - location file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/dest1 + location file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest1 serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe name: dest1 Index: ql/src/test/results/clientpositive/implicit_cast1.q.out =================================================================== --- ql/src/test/results/clientpositive/implicit_cast1.q.out (revision 742964) +++ ql/src/test/results/clientpositive/implicit_cast1.q.out (working copy) @@ -22,6 +22,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/sample6.q.out =================================================================== --- ql/src/test/results/clientpositive/sample6.q.out (revision 742964) +++ ql/src/test/results/clientpositive/sample6.q.out (working copy) @@ -28,7 +28,8 @@ type: string File Output Operator compressed: false - directory: /tmp/hive-zshao/25298408/261228818.10000.insclause-0 + GlobalTableId: 1 + directory: /data/users/suresh/hive_external/ql/../build/ql/tmp/386238508/480413900.10000.insclause-0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -41,14 +42,14 @@ serialization.lib org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat - location file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/dest1 + location file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest1 serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe name: dest1 Needs Tagging: false Path -> Alias: - file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/srcbucket/kv1.txt + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcbucket/kv1.txt Path -> Partition: - file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/srcbucket/kv1.txt + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcbucket/kv1.txt Partition input format: org.apache.hadoop.mapred.TextInputFormat @@ -63,7 +64,7 @@ serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat - location file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/srcbucket + location file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcbucket serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe name: srcbucket @@ -71,7 +72,7 @@ Move Operator tables: replace: true - source: /tmp/hive-zshao/25298408/261228818.10000.insclause-0 + source: /data/users/suresh/hive_external/ql/../build/ql/tmp/386238508/480413900.10000.insclause-0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -84,7 +85,7 @@ serialization.lib org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat - location file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/dest1 + location file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest1 serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe name: dest1 Index: ql/src/test/results/clientpositive/groupby4_map.q.out =================================================================== --- ql/src/test/results/clientpositive/groupby4_map.q.out (revision 742964) +++ ql/src/test/results/clientpositive/groupby4_map.q.out (working copy) @@ -39,6 +39,7 @@ type: int File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/join3.q.out =================================================================== --- ql/src/test/results/clientpositive/join3.q.out (revision 742964) +++ ql/src/test/results/clientpositive/join3.q.out (working copy) @@ -81,6 +81,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -97,7 +98,6 @@ serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe name: dest1 - 0 val_0 0 val_0 0 val_0 Index: ql/src/test/results/clientpositive/input_testxpath2.q.out =================================================================== --- ql/src/test/results/clientpositive/input_testxpath2.q.out (revision 742964) +++ ql/src/test/results/clientpositive/input_testxpath2.q.out (working copy) @@ -32,6 +32,7 @@ type: int File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/join7.q.out =================================================================== --- ql/src/test/results/clientpositive/join7.q.out (revision 742964) +++ ql/src/test/results/clientpositive/join7.q.out (working copy) @@ -137,6 +137,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/input8.q.out =================================================================== --- ql/src/test/results/clientpositive/input8.q.out (revision 742964) +++ ql/src/test/results/clientpositive/input8.q.out (working copy) @@ -32,6 +32,7 @@ type: double File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/union.q.out =================================================================== --- ql/src/test/results/clientpositive/union.q.out (revision 742964) +++ ql/src/test/results/clientpositive/union.q.out (working copy) @@ -28,6 +28,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -50,6 +51,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/udf2.q.out =================================================================== --- ql/src/test/results/clientpositive/udf2.q.out (revision 742964) +++ ql/src/test/results/clientpositive/udf2.q.out (working copy) @@ -28,6 +28,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/join13.q.out =================================================================== --- ql/src/test/results/clientpositive/join13.q.out (revision 742964) +++ ql/src/test/results/clientpositive/join13.q.out (working copy) @@ -65,6 +65,7 @@ 1 {VALUE.0} {VALUE.1} File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.mapred.SequenceFileOutputFormat @@ -132,6 +133,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/udf6.q.out =================================================================== --- ql/src/test/results/clientpositive/udf6.q.out (revision 742964) +++ ql/src/test/results/clientpositive/udf6.q.out (working copy) @@ -17,6 +17,7 @@ type: int File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -60,6 +61,7 @@ type: smallint File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/input14.q.out =================================================================== --- ql/src/test/results/clientpositive/input14.q.out (revision 742964) +++ ql/src/test/results/clientpositive/input14.q.out (working copy) @@ -55,6 +55,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/input_part1.q.out =================================================================== --- ql/src/test/results/clientpositive/input_part1.q.out (revision 742964) +++ ql/src/test/results/clientpositive/input_part1.q.out (working copy) @@ -36,7 +36,8 @@ type: string File Output Operator compressed: false - directory: /data/users/athusoo/apacheprojects/hive_local_ws3/ql/../build/ql/tmp/1332023401/49833095.10000.insclause-0 + GlobalTableId: 1 + directory: /data/users/suresh/hive_external/ql/../build/ql/tmp/510598000/1684451.10000.insclause-0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -49,14 +50,14 @@ serialization.lib org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat - location file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/dest1 + location file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest1 serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe name: dest1 Needs Tagging: false Path -> Alias: - file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcpart/hr=12/ds=2008-04-08 Path -> Partition: - file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcpart/hr=12/ds=2008-04-08 Partition partition values: ds 2008-04-08 @@ -74,7 +75,7 @@ serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat - location file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/srcpart + location file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcpart serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe name: srcpart @@ -82,7 +83,7 @@ Move Operator tables: replace: true - source: /data/users/athusoo/apacheprojects/hive_local_ws3/ql/../build/ql/tmp/1332023401/49833095.10000.insclause-0 + source: /data/users/suresh/hive_external/ql/../build/ql/tmp/510598000/1684451.10000.insclause-0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -95,7 +96,7 @@ serialization.lib org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat - location file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/dest1 + location file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest1 serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe name: dest1 Index: ql/src/test/results/clientpositive/join17.q.out =================================================================== --- ql/src/test/results/clientpositive/join17.q.out (revision 742964) +++ ql/src/test/results/clientpositive/join17.q.out (working copy) @@ -41,9 +41,9 @@ type: string Needs Tagging: true Path -> Alias: - file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src Path -> Partition: - file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src Partition input format: org.apache.hadoop.mapred.TextInputFormat @@ -57,7 +57,7 @@ serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat - location file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/src + location file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe name: src Reduce Operator Tree: @@ -89,7 +89,8 @@ type: string File Output Operator compressed: false - directory: /tmp/hive-zshao/58811470/801571048.10000.insclause-0 + GlobalTableId: 1 + directory: /data/users/suresh/hive_external/ql/../build/ql/tmp/1666847863/537139557.10000.insclause-0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -102,7 +103,7 @@ serialization.lib org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat - location file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/dest1 + location file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest1 serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe name: dest1 @@ -110,7 +111,7 @@ Move Operator tables: replace: true - source: /tmp/hive-zshao/58811470/801571048.10000.insclause-0 + source: /data/users/suresh/hive_external/ql/../build/ql/tmp/1666847863/537139557.10000.insclause-0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -123,7 +124,7 @@ serialization.lib org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat - location file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/dest1 + location file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest1 serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe name: dest1 Index: ql/src/test/results/clientpositive/input18.q.out =================================================================== --- ql/src/test/results/clientpositive/input18.q.out (revision 742964) +++ ql/src/test/results/clientpositive/input18.q.out (working copy) @@ -59,6 +59,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/groupby2.q.out =================================================================== --- ql/src/test/results/clientpositive/groupby2.q.out (revision 742964) +++ ql/src/test/results/clientpositive/groupby2.q.out (working copy) @@ -35,6 +35,7 @@ mode: partial1 File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.mapred.SequenceFileOutputFormat @@ -43,7 +44,7 @@ Stage: Stage-2 Map Reduce Alias -> Map Operator Tree: - /tmp/hive-zshao/75837910/35360202.10001 + /data/users/suresh/hive_external/build/ql/tmp/22651021/176133507.10001 Reduce Output Operator key expressions: expr: 0 @@ -85,6 +86,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/input_part5.q.out =================================================================== --- ql/src/test/results/clientpositive/input_part5.q.out (revision 742964) +++ ql/src/test/results/clientpositive/input_part5.q.out (working copy) @@ -26,6 +26,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/groupby6.q.out =================================================================== --- ql/src/test/results/clientpositive/groupby6.q.out (revision 742964) +++ ql/src/test/results/clientpositive/groupby6.q.out (working copy) @@ -32,6 +32,7 @@ mode: partial1 File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.mapred.SequenceFileOutputFormat @@ -40,7 +41,7 @@ Stage: Stage-2 Map Reduce Alias -> Map Operator Tree: - /tmp/hive-zshao/454201677/52450507.10001 + /data/users/suresh/hive_external/build/ql/tmp/130654017/38623935.10001 Reduce Output Operator key expressions: expr: 0 @@ -62,6 +63,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/input2_limit.q.out =================================================================== --- ql/src/test/results/clientpositive/input2_limit.q.out (revision 742964) +++ ql/src/test/results/clientpositive/input2_limit.q.out (working copy) @@ -23,6 +23,7 @@ Limit File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/sort.q.out =================================================================== --- ql/src/test/results/clientpositive/sort.q.out (revision 742964) +++ ql/src/test/results/clientpositive/sort.q.out (working copy) @@ -31,6 +31,7 @@ Extract File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/mapreduce4.q.out =================================================================== --- ql/src/test/results/clientpositive/mapreduce4.q.out (revision 742964) +++ ql/src/test/results/clientpositive/mapreduce4.q.out (working copy) @@ -61,6 +61,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/sample1.q.out =================================================================== --- ql/src/test/results/clientpositive/sample1.q.out (revision 742964) +++ ql/src/test/results/clientpositive/sample1.q.out (working copy) @@ -40,7 +40,8 @@ type: string File Output Operator compressed: false - directory: /tmp/hive-zshao/860547727/34027035.10000.insclause-0 + GlobalTableId: 1 + directory: /data/users/suresh/hive_external/ql/../build/ql/tmp/36911224/134412222.10000.insclause-0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -53,14 +54,14 @@ serialization.lib org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat - location file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/dest1 + location file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest1 serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe name: dest1 Needs Tagging: false Path -> Alias: - file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcpart/hr=11/ds=2008-04-08 Path -> Partition: - file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcpart/hr=11/ds=2008-04-08 Partition partition values: ds 2008-04-08 @@ -78,7 +79,7 @@ serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat - location file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/srcpart + location file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcpart serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe name: srcpart @@ -86,7 +87,7 @@ Move Operator tables: replace: true - source: /tmp/hive-zshao/860547727/34027035.10000.insclause-0 + source: /data/users/suresh/hive_external/ql/../build/ql/tmp/36911224/134412222.10000.insclause-0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -99,7 +100,7 @@ serialization.lib org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat - location file:/data/users/zshao/sync/apache-trunk-HIVE-104/build/ql/test/data/warehouse/dest1 + location file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest1 serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe name: dest1 Index: ql/src/test/results/clientpositive/groupby1_map.q.out =================================================================== --- ql/src/test/results/clientpositive/groupby1_map.q.out (revision 742964) +++ ql/src/test/results/clientpositive/groupby1_map.q.out (working copy) @@ -40,6 +40,7 @@ mode: partial2 File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.mapred.SequenceFileOutputFormat @@ -48,7 +49,7 @@ Stage: Stage-2 Map Reduce Alias -> Map Operator Tree: - /tmp/hive-zshao/632752964/335784834.10001 + /data/users/suresh/hive_external/build/ql/tmp/481410220/55014088.10001 Reduce Output Operator key expressions: expr: 0 @@ -83,6 +84,7 @@ type: double File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/sample5.q.out =================================================================== --- ql/src/test/results/clientpositive/sample5.q.out (revision 742964) +++ ql/src/test/results/clientpositive/sample5.q.out (working copy) @@ -28,7 +28,8 @@ type: string File Output Operator compressed: false - directory: /data/users/athusoo/commits/hive_trunk_ws1/ql/../build/ql/tmp/379123596/110097939.10000.insclause-0 + GlobalTableId: 1 + directory: /data/users/suresh/hive_external/ql/../build/ql/tmp/96466847/907253021.10000.insclause-0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -41,14 +42,14 @@ serialization.lib org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat - location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest1 + location file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest1 serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe name: dest1 Needs Tagging: false Path -> Alias: - file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcbucket + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcbucket Path -> Partition: - file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcbucket + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcbucket Partition input format: org.apache.hadoop.mapred.TextInputFormat @@ -63,7 +64,7 @@ serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat - location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcbucket + location file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcbucket serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe name: srcbucket @@ -71,7 +72,7 @@ Move Operator tables: replace: true - source: /data/users/athusoo/commits/hive_trunk_ws1/ql/../build/ql/tmp/379123596/110097939.10000.insclause-0 + source: /data/users/suresh/hive_external/ql/../build/ql/tmp/96466847/907253021.10000.insclause-0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -84,7 +85,7 @@ serialization.lib org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe file.inputformat org.apache.hadoop.mapred.TextInputFormat file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat - location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest1 + location file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest1 serde: org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe name: dest1 Index: ql/src/test/results/clientpositive/groupby1_limit.q.out =================================================================== --- ql/src/test/results/clientpositive/groupby1_limit.q.out (revision 742964) +++ ql/src/test/results/clientpositive/groupby1_limit.q.out (working copy) @@ -34,6 +34,7 @@ mode: partial1 File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.mapred.SequenceFileOutputFormat @@ -42,7 +43,7 @@ Stage: Stage-2 Map Reduce Alias -> Map Operator Tree: - /data/users/zshao/sync/apache-trunk-HIVE-105/build/ql/tmp/228651165/7195775.10001 + /data/users/suresh/hive_external/build/ql/tmp/57991286/85734426.10001 Reduce Output Operator key expressions: expr: 0 @@ -72,6 +73,7 @@ Limit File Output Operator compressed: false + GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.mapred.SequenceFileOutputFormat @@ -80,7 +82,7 @@ Stage: Stage-3 Map Reduce Alias -> Map Operator Tree: - /data/users/zshao/sync/apache-trunk-HIVE-105/build/ql/tmp/228651165/7195775.10002 + /data/users/suresh/hive_external/build/ql/tmp/57991286/85734426.10002 Reduce Output Operator sort order: tag: -1 @@ -100,6 +102,7 @@ type: double File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/clientpositive/groupby5_map.q.out =================================================================== --- ql/src/test/results/clientpositive/groupby5_map.q.out (revision 742964) +++ ql/src/test/results/clientpositive/groupby5_map.q.out (working copy) @@ -42,6 +42,7 @@ type: int File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat Index: ql/src/test/results/compiler/plan/join2.q.xml =================================================================== --- ql/src/test/results/compiler/plan/join2.q.xml (revision 742964) +++ ql/src/test/results/compiler/plan/join2.q.xml (working copy) @@ -35,7 +35,7 @@ true - /data/users/zshao/sync/apache-trunk-HIVE-105/ql/../build/ql/tmp/281327083.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/322362397.10000.insclause-0 @@ -84,7 +84,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-105/build/ql/test/data/warehouse/dest1 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest1 @@ -547,7 +547,7 @@ - /data/users/zshao/sync/apache-trunk-HIVE-105/build/ql/tmp/803620680/67460703.10001 + /data/users/suresh/hive_external/build/ql/tmp/103034080/965001958.10001 @@ -1158,7 +1158,7 @@ - /data/users/zshao/sync/apache-trunk-HIVE-105/build/ql/tmp/803620680/67460703.10001 + /data/users/suresh/hive_external/build/ql/tmp/103034080/965001958.10001 $INTNAME @@ -1166,7 +1166,7 @@ - file:/data/users/zshao/sync/apache-trunk-HIVE-105/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src src3 @@ -1178,7 +1178,7 @@ - /data/users/zshao/sync/apache-trunk-HIVE-105/build/ql/tmp/803620680/67460703.10001 + /data/users/suresh/hive_external/build/ql/tmp/103034080/965001958.10001 @@ -1186,7 +1186,7 @@ - file:/data/users/zshao/sync/apache-trunk-HIVE-105/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src @@ -1238,7 +1238,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-105/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src @@ -1263,8 +1263,11 @@ + + 1 + - /data/users/zshao/sync/apache-trunk-HIVE-105/ql/../build/ql/tmp/281327083.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/322362397.10000.insclause-0 @@ -1530,7 +1533,7 @@ - file:/data/users/zshao/sync/apache-trunk-HIVE-105/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src src2 @@ -1545,7 +1548,7 @@ - file:/data/users/zshao/sync/apache-trunk-HIVE-105/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src @@ -1597,7 +1600,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-105/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src Index: ql/src/test/results/compiler/plan/input2.q.xml =================================================================== --- ql/src/test/results/compiler/plan/input2.q.xml (revision 742964) +++ ql/src/test/results/compiler/plan/input2.q.xml (working copy) @@ -31,7 +31,7 @@ true - /data/users/athusoo/apacheprojects/hive_local_ws3/ql/../build/ql/tmp/238674319/24398083.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/122027813/896843.10000.insclause-0 @@ -80,7 +80,7 @@ location - file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/dest1 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest1 @@ -100,7 +100,7 @@ true - /data/users/athusoo/apacheprojects/hive_local_ws3/ql/../build/ql/tmp/238674319/24398083.10001.insclause-1 + /data/users/suresh/hive_external/ql/../build/ql/tmp/122027813/896843.10001.insclause-1 @@ -149,7 +149,7 @@ location - file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/dest2 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest2 @@ -178,7 +178,7 @@ true - /data/users/athusoo/apacheprojects/hive_local_ws3/ql/../build/ql/tmp/238674319/24398083.10002.insclause-2 + /data/users/suresh/hive_external/ql/../build/ql/tmp/122027813/896843.10002.insclause-2 @@ -231,7 +231,7 @@ location - file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/dest3 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest3 @@ -274,8 +274,11 @@ + + 1 + - /data/users/athusoo/apacheprojects/hive_local_ws3/ql/../build/ql/tmp/238674319/24398083.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/122027813/896843.10000.insclause-0 @@ -534,8 +537,11 @@ + + 2 + - /data/users/athusoo/apacheprojects/hive_local_ws3/ql/../build/ql/tmp/238674319/24398083.10001.insclause-1 + /data/users/suresh/hive_external/ql/../build/ql/tmp/122027813/896843.10001.insclause-1 @@ -876,8 +882,11 @@ + + 3 + - /data/users/athusoo/apacheprojects/hive_local_ws3/ql/../build/ql/tmp/238674319/24398083.10002.insclause-2 + /data/users/suresh/hive_external/ql/../build/ql/tmp/122027813/896843.10002.insclause-2 @@ -1100,7 +1109,7 @@ - file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src src @@ -1112,7 +1121,7 @@ - file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src @@ -1164,7 +1173,7 @@ location - file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src Index: ql/src/test/results/compiler/plan/join3.q.xml =================================================================== --- ql/src/test/results/compiler/plan/join3.q.xml (revision 742964) +++ ql/src/test/results/compiler/plan/join3.q.xml (working copy) @@ -31,7 +31,7 @@ true - /data/users/njain/hive1/hive/ql/../build/ql/tmp/101117165.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/360962060.10000.insclause-0 @@ -80,7 +80,7 @@ location - file:/data/users/njain/hive1/hive/build/ql/test/data/warehouse/dest1 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest1 @@ -750,7 +750,7 @@ - file:/data/users/njain/hive1/hive/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src src2 @@ -768,7 +768,7 @@ - file:/data/users/njain/hive1/hive/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src @@ -820,7 +820,7 @@ location - file:/data/users/njain/hive1/hive/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src @@ -845,8 +845,11 @@ + + 1 + - /data/users/njain/hive1/hive/ql/../build/ql/tmp/101117165.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/360962060.10000.insclause-0 Index: ql/src/test/results/compiler/plan/input3.q.xml =================================================================== --- ql/src/test/results/compiler/plan/input3.q.xml (revision 742964) +++ ql/src/test/results/compiler/plan/input3.q.xml (working copy) @@ -28,7 +28,7 @@ true - /data/users/athusoo/apacheprojects/hive_local_ws3/ql/../build/ql/tmp/48576025/763323393.10003.insclause-3 + /data/users/suresh/hive_external/ql/../build/ql/tmp/73465941/255492444.10003.insclause-3 ../../../../build/contrib/hive/ql/test/data/warehouse/dest4.out @@ -48,7 +48,7 @@ true - /data/users/athusoo/apacheprojects/hive_local_ws3/ql/../build/ql/tmp/48576025/763323393.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/73465941/255492444.10000.insclause-0 @@ -97,7 +97,7 @@ location - file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/dest1 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest1 @@ -117,7 +117,7 @@ true - /data/users/athusoo/apacheprojects/hive_local_ws3/ql/../build/ql/tmp/48576025/763323393.10001.insclause-1 + /data/users/suresh/hive_external/ql/../build/ql/tmp/73465941/255492444.10001.insclause-1 @@ -166,7 +166,7 @@ location - file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/dest2 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest2 @@ -195,7 +195,7 @@ true - /data/users/athusoo/apacheprojects/hive_local_ws3/ql/../build/ql/tmp/48576025/763323393.10002.insclause-2 + /data/users/suresh/hive_external/ql/../build/ql/tmp/73465941/255492444.10002.insclause-2 @@ -248,7 +248,7 @@ location - file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/dest3 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest3 @@ -291,8 +291,11 @@ + + 1 + - /data/users/athusoo/apacheprojects/hive_local_ws3/ql/../build/ql/tmp/48576025/763323393.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/73465941/255492444.10000.insclause-0 @@ -551,8 +554,11 @@ + + 2 + - /data/users/athusoo/apacheprojects/hive_local_ws3/ql/../build/ql/tmp/48576025/763323393.10001.insclause-1 + /data/users/suresh/hive_external/ql/../build/ql/tmp/73465941/255492444.10001.insclause-1 @@ -893,8 +899,11 @@ + + 3 + - /data/users/athusoo/apacheprojects/hive_local_ws3/ql/../build/ql/tmp/48576025/763323393.10002.insclause-2 + /data/users/suresh/hive_external/ql/../build/ql/tmp/73465941/255492444.10002.insclause-2 @@ -1235,8 +1244,11 @@ + + 4 + - /data/users/athusoo/apacheprojects/hive_local_ws3/ql/../build/ql/tmp/48576025/763323393.10003.insclause-3 + /data/users/suresh/hive_external/ql/../build/ql/tmp/73465941/255492444.10003.insclause-3 @@ -1461,7 +1473,7 @@ - file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src src @@ -1473,7 +1485,7 @@ - file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src @@ -1525,7 +1537,7 @@ location - file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src Index: ql/src/test/results/compiler/plan/input4.q.xml =================================================================== --- ql/src/test/results/compiler/plan/input4.q.xml (revision 742964) +++ ql/src/test/results/compiler/plan/input4.q.xml (working copy) @@ -31,7 +31,7 @@ true - /data/users/zshao/sync/apache-trunk-HIVE-105/ql/../build/ql/tmp/117678603/347916488.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/1327677968/510783108.10000.insclause-0 @@ -80,7 +80,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-105/build/ql/test/data/warehouse/dest1 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest1 @@ -471,7 +471,7 @@ - file:/data/users/zshao/sync/apache-trunk-HIVE-105/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src tmap:src @@ -483,7 +483,7 @@ - file:/data/users/zshao/sync/apache-trunk-HIVE-105/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src @@ -535,7 +535,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-105/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src @@ -564,8 +564,11 @@ + + 1 + - /data/users/zshao/sync/apache-trunk-HIVE-105/ql/../build/ql/tmp/117678603/347916488.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/1327677968/510783108.10000.insclause-0 Index: ql/src/test/results/compiler/plan/input5.q.xml =================================================================== --- ql/src/test/results/compiler/plan/input5.q.xml (revision 742964) +++ ql/src/test/results/compiler/plan/input5.q.xml (working copy) @@ -31,7 +31,7 @@ true - /data/users/zshao/sync/apache-trunk-HIVE-105/ql/../build/ql/tmp/768672036.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/60338757.10000.insclause-0 @@ -80,7 +80,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-105/build/ql/test/data/warehouse/dest1 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest1 @@ -605,7 +605,7 @@ - file:/data/users/zshao/sync/apache-trunk-HIVE-105/build/ql/test/data/warehouse/src_thrift + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src_thrift tmap:src_thrift @@ -617,7 +617,7 @@ - file:/data/users/zshao/sync/apache-trunk-HIVE-105/build/ql/test/data/warehouse/src_thrift + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src_thrift @@ -673,7 +673,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-105/build/ql/test/data/warehouse/src_thrift + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src_thrift @@ -698,8 +698,11 @@ + + 1 + - /data/users/zshao/sync/apache-trunk-HIVE-105/ql/../build/ql/tmp/768672036.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/60338757.10000.insclause-0 Index: ql/src/test/results/compiler/plan/input6.q.xml =================================================================== --- ql/src/test/results/compiler/plan/input6.q.xml (revision 742964) +++ ql/src/test/results/compiler/plan/input6.q.xml (working copy) @@ -31,7 +31,7 @@ true - /tmp/hive-njain/545048490/63016941.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/3457478/413082893.10000.insclause-0 @@ -80,7 +80,7 @@ location - file:/home/njain/workspace/hadoophive/trunk/build/ql/test/data/warehouse/dest1 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest1 @@ -123,8 +123,11 @@ + + 1 + - /tmp/hive-njain/545048490/63016941.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/3457478/413082893.10000.insclause-0 @@ -315,7 +318,7 @@ - file:/home/njain/workspace/hadoophive/trunk/build/ql/test/data/warehouse/src1 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src1 src1 @@ -327,7 +330,7 @@ - file:/home/njain/workspace/hadoophive/trunk/build/ql/test/data/warehouse/src1 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src1 @@ -379,7 +382,7 @@ location - file:/home/njain/workspace/hadoophive/trunk/build/ql/test/data/warehouse/src1 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src1 Index: ql/src/test/results/compiler/plan/input7.q.xml =================================================================== --- ql/src/test/results/compiler/plan/input7.q.xml (revision 742964) +++ ql/src/test/results/compiler/plan/input7.q.xml (working copy) @@ -31,7 +31,7 @@ true - /tmp/hive-njain/1794861784.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/227264982.10000.insclause-0 @@ -80,7 +80,7 @@ location - file:/home/njain/workspace/hadoophive/trunk/build/ql/test/data/warehouse/dest1 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest1 @@ -123,8 +123,11 @@ + + 1 + - /tmp/hive-njain/1794861784.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/227264982.10000.insclause-0 @@ -303,7 +306,7 @@ - file:/home/njain/workspace/hadoophive/trunk/build/ql/test/data/warehouse/src1 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src1 src1 @@ -315,7 +318,7 @@ - file:/home/njain/workspace/hadoophive/trunk/build/ql/test/data/warehouse/src1 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src1 @@ -367,7 +370,7 @@ location - file:/home/njain/workspace/hadoophive/trunk/build/ql/test/data/warehouse/src1 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src1 Index: ql/src/test/results/compiler/plan/input_testsequencefile.q.xml =================================================================== --- ql/src/test/results/compiler/plan/input_testsequencefile.q.xml (revision 742964) +++ ql/src/test/results/compiler/plan/input_testsequencefile.q.xml (working copy) @@ -31,7 +31,7 @@ true - /tmp/hive-njain/380325162/471311562.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/452124454/366753270.10000.insclause-0 @@ -80,7 +80,7 @@ location - file:/home/njain/workspace/hadoophive/trunk/build/ql/test/data/warehouse/dest4_sequencefile + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest4_sequencefile @@ -119,8 +119,11 @@ + + 1 + - /tmp/hive-njain/380325162/471311562.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/452124454/366753270.10000.insclause-0 @@ -251,7 +254,7 @@ - file:/home/njain/workspace/hadoophive/trunk/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src src @@ -263,7 +266,7 @@ - file:/home/njain/workspace/hadoophive/trunk/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src @@ -315,7 +318,7 @@ location - file:/home/njain/workspace/hadoophive/trunk/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src Index: ql/src/test/results/compiler/plan/input9.q.xml =================================================================== --- ql/src/test/results/compiler/plan/input9.q.xml (revision 742964) +++ ql/src/test/results/compiler/plan/input9.q.xml (working copy) @@ -31,7 +31,7 @@ true - /data/users/athusoo/apacheprojects/hive_local_ws3/ql/../build/ql/tmp/902483168.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/378999624.10000.insclause-0 @@ -80,7 +80,7 @@ location - file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/dest1 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest1 @@ -127,8 +127,11 @@ + + 1 + - /data/users/athusoo/apacheprojects/hive_local_ws3/ql/../build/ql/tmp/902483168.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/378999624.10000.insclause-0 @@ -378,7 +381,7 @@ - file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/src1 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src1 src1 @@ -390,7 +393,7 @@ - file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/src1 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src1 @@ -442,7 +445,7 @@ location - file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/src1 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src1 Index: ql/src/test/results/compiler/plan/union.q.xml =================================================================== --- ql/src/test/results/compiler/plan/union.q.xml (revision 742964) +++ ql/src/test/results/compiler/plan/union.q.xml (working copy) @@ -28,7 +28,7 @@ true - /data/users/athusoo/apacheprojects/hive_local_ws3/ql/../build/ql/tmp/323358384/1524460804.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/1058753128/757436823.10000.insclause-0 ../build/ql/test/data/warehouse/union.out @@ -78,8 +78,11 @@ + + 1 + - /data/users/athusoo/apacheprojects/hive_local_ws3/ql/../build/ql/tmp/323358384/1524460804.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/1058753128/757436823.10000.insclause-0 @@ -690,7 +693,7 @@ - file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src null-subquery1:unioninput-subquery1:src @@ -705,7 +708,7 @@ - file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src @@ -757,7 +760,7 @@ location - file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src Index: ql/src/test/results/compiler/plan/groupby1.q.xml =================================================================== --- ql/src/test/results/compiler/plan/groupby1.q.xml (revision 742964) +++ ql/src/test/results/compiler/plan/groupby1.q.xml (working copy) @@ -35,7 +35,7 @@ true - /data/users/athusoo/commits/hive_trunk_ws2/ql/../build/ql/tmp/568109016/211707412.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/207865168/1140573653.10000.insclause-0 @@ -84,7 +84,7 @@ location - file:/data/users/athusoo/commits/hive_trunk_ws2/build/ql/test/data/warehouse/dest1 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest1 @@ -118,7 +118,7 @@ - /data/users/athusoo/commits/hive_trunk_ws2/build/ql/tmp/568109016/211707412.10001 + /data/users/suresh/hive_external/build/ql/tmp/207865168/1140573653.10001 @@ -242,7 +242,7 @@ - /data/users/athusoo/commits/hive_trunk_ws2/build/ql/tmp/568109016/211707412.10001 + /data/users/suresh/hive_external/build/ql/tmp/207865168/1140573653.10001 @@ -691,10 +691,10 @@ - /data/users/athusoo/commits/hive_trunk_ws2/build/ql/tmp/568109016/211707412.10001 + /data/users/suresh/hive_external/build/ql/tmp/207865168/1140573653.10001 - /data/users/athusoo/commits/hive_trunk_ws2/build/ql/tmp/568109016/211707412.10001 + /data/users/suresh/hive_external/build/ql/tmp/207865168/1140573653.10001 @@ -703,7 +703,7 @@ - /data/users/athusoo/commits/hive_trunk_ws2/build/ql/tmp/568109016/211707412.10001 + /data/users/suresh/hive_external/build/ql/tmp/207865168/1140573653.10001 @@ -724,8 +724,11 @@ + + 1 + - /data/users/athusoo/commits/hive_trunk_ws2/ql/../build/ql/tmp/568109016/211707412.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/207865168/1140573653.10000.insclause-0 @@ -951,7 +954,7 @@ - file:/data/users/athusoo/commits/hive_trunk_ws2/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src src @@ -963,7 +966,7 @@ - file:/data/users/athusoo/commits/hive_trunk_ws2/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src @@ -1015,7 +1018,7 @@ location - file:/data/users/athusoo/commits/hive_trunk_ws2/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src Index: ql/src/test/results/compiler/plan/subq.q.xml =================================================================== --- ql/src/test/results/compiler/plan/subq.q.xml (revision 742964) +++ ql/src/test/results/compiler/plan/subq.q.xml (working copy) @@ -28,7 +28,7 @@ true - /data/users/athusoo/apacheprojects/hive_local_ws3/ql/../build/ql/tmp/538025002/104579387.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/111717338/1620178451.10000.insclause-0 ../build/ql/test/data/warehouse/union.out @@ -74,8 +74,11 @@ + + 1 + - /data/users/athusoo/apacheprojects/hive_local_ws3/ql/../build/ql/tmp/538025002/104579387.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/111717338/1620178451.10000.insclause-0 @@ -430,7 +433,7 @@ - file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src unioninput:src @@ -442,7 +445,7 @@ - file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src @@ -494,7 +497,7 @@ location - file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src Index: ql/src/test/results/compiler/plan/case_sensitivity.q.xml =================================================================== --- ql/src/test/results/compiler/plan/case_sensitivity.q.xml (revision 742964) +++ ql/src/test/results/compiler/plan/case_sensitivity.q.xml (working copy) @@ -31,7 +31,7 @@ true - /tmp/hive-njain/1375367896.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/1204664525.10000.insclause-0 @@ -80,7 +80,7 @@ location - file:/home/njain/workspace/hadoophive/trunk/build/ql/test/data/warehouse/dest1 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest1 @@ -127,8 +127,11 @@ + + 1 + - /tmp/hive-njain/1375367896.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/1204664525.10000.insclause-0 @@ -526,7 +529,7 @@ - file:/home/njain/workspace/hadoophive/trunk/build/ql/test/data/warehouse/src_thrift + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src_thrift src_thrift @@ -538,7 +541,7 @@ - file:/home/njain/workspace/hadoophive/trunk/build/ql/test/data/warehouse/src_thrift + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src_thrift @@ -594,7 +597,7 @@ location - file:/home/njain/workspace/hadoophive/trunk/build/ql/test/data/warehouse/src_thrift + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src_thrift Index: ql/src/test/results/compiler/plan/sample2.q.xml =================================================================== --- ql/src/test/results/compiler/plan/sample2.q.xml (revision 742964) +++ ql/src/test/results/compiler/plan/sample2.q.xml (working copy) @@ -31,7 +31,7 @@ true - /tmp/hive-njain/20107464/1379933163.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/657380513/1172545351.10000.insclause-0 @@ -80,7 +80,7 @@ location - file:/home/njain/workspace/hadoophive/trunk/build/ql/test/data/warehouse/dest1 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest1 @@ -119,8 +119,11 @@ + + 1 + - /tmp/hive-njain/20107464/1379933163.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/657380513/1172545351.10000.insclause-0 @@ -254,7 +257,7 @@ - file:/home/njain/workspace/hadoophive/trunk/build/ql/test/data/warehouse/srcbucket/kv1.txt + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcbucket/kv1.txt s @@ -266,7 +269,7 @@ - file:/home/njain/workspace/hadoophive/trunk/build/ql/test/data/warehouse/srcbucket/kv1.txt + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcbucket/kv1.txt @@ -322,7 +325,7 @@ location - file:/home/njain/workspace/hadoophive/trunk/build/ql/test/data/warehouse/srcbucket + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcbucket Index: ql/src/test/results/compiler/plan/sample3.q.xml =================================================================== --- ql/src/test/results/compiler/plan/sample3.q.xml (revision 742964) +++ ql/src/test/results/compiler/plan/sample3.q.xml (working copy) @@ -31,7 +31,7 @@ true - /tmp/hive-njain/1789469168/381631340.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/634104411/247803629.10000.insclause-0 @@ -80,7 +80,7 @@ location - file:/home/njain/workspace/hadoophive/trunk/build/ql/test/data/warehouse/dest1 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest1 @@ -123,8 +123,11 @@ + + 1 + - /tmp/hive-njain/1789469168/381631340.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/634104411/247803629.10000.insclause-0 @@ -439,7 +442,7 @@ - file:/home/njain/workspace/hadoophive/trunk/build/ql/test/data/warehouse/srcbucket + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcbucket s @@ -451,7 +454,7 @@ - file:/home/njain/workspace/hadoophive/trunk/build/ql/test/data/warehouse/srcbucket + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcbucket @@ -507,7 +510,7 @@ location - file:/home/njain/workspace/hadoophive/trunk/build/ql/test/data/warehouse/srcbucket + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcbucket Index: ql/src/test/results/compiler/plan/sample4.q.xml =================================================================== --- ql/src/test/results/compiler/plan/sample4.q.xml (revision 742964) +++ ql/src/test/results/compiler/plan/sample4.q.xml (working copy) @@ -31,7 +31,7 @@ true - /tmp/hive-njain/1853542808/45744403.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/478032662/81251355.10000.insclause-0 @@ -80,7 +80,7 @@ location - file:/home/njain/workspace/hadoophive/trunk/build/ql/test/data/warehouse/dest1 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest1 @@ -119,8 +119,11 @@ + + 1 + - /tmp/hive-njain/1853542808/45744403.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/478032662/81251355.10000.insclause-0 @@ -254,7 +257,7 @@ - file:/home/njain/workspace/hadoophive/trunk/build/ql/test/data/warehouse/srcbucket/kv1.txt + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcbucket/kv1.txt s @@ -266,7 +269,7 @@ - file:/home/njain/workspace/hadoophive/trunk/build/ql/test/data/warehouse/srcbucket/kv1.txt + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcbucket/kv1.txt @@ -322,7 +325,7 @@ location - file:/home/njain/workspace/hadoophive/trunk/build/ql/test/data/warehouse/srcbucket + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcbucket Index: ql/src/test/results/compiler/plan/sample5.q.xml =================================================================== --- ql/src/test/results/compiler/plan/sample5.q.xml (revision 742964) +++ ql/src/test/results/compiler/plan/sample5.q.xml (working copy) @@ -31,7 +31,7 @@ true - /tmp/hive-njain/824806517/591440948.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/35136710/1744311583.10000.insclause-0 @@ -80,7 +80,7 @@ location - file:/home/njain/workspace/hadoophive/trunk/build/ql/test/data/warehouse/dest1 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest1 @@ -123,8 +123,11 @@ + + 1 + - /tmp/hive-njain/824806517/591440948.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/35136710/1744311583.10000.insclause-0 @@ -426,7 +429,7 @@ - file:/home/njain/workspace/hadoophive/trunk/build/ql/test/data/warehouse/srcbucket + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcbucket s @@ -438,7 +441,7 @@ - file:/home/njain/workspace/hadoophive/trunk/build/ql/test/data/warehouse/srcbucket + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcbucket @@ -494,7 +497,7 @@ location - file:/home/njain/workspace/hadoophive/trunk/build/ql/test/data/warehouse/srcbucket + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcbucket Index: ql/src/test/results/compiler/plan/sample6.q.xml =================================================================== --- ql/src/test/results/compiler/plan/sample6.q.xml (revision 742964) +++ ql/src/test/results/compiler/plan/sample6.q.xml (working copy) @@ -31,7 +31,7 @@ true - /tmp/hive-njain/814020855/624762724.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/1314885408/757198424.10000.insclause-0 @@ -80,7 +80,7 @@ location - file:/home/njain/workspace/hadoophive/trunk/build/ql/test/data/warehouse/dest1 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest1 @@ -123,8 +123,11 @@ + + 1 + - /tmp/hive-njain/814020855/624762724.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/1314885408/757198424.10000.insclause-0 @@ -426,7 +429,7 @@ - file:/home/njain/workspace/hadoophive/trunk/build/ql/test/data/warehouse/srcbucket/kv1.txt + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcbucket/kv1.txt s @@ -438,7 +441,7 @@ - file:/home/njain/workspace/hadoophive/trunk/build/ql/test/data/warehouse/srcbucket/kv1.txt + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcbucket/kv1.txt @@ -494,7 +497,7 @@ location - file:/home/njain/workspace/hadoophive/trunk/build/ql/test/data/warehouse/srcbucket + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcbucket Index: ql/src/test/results/compiler/plan/sample7.q.xml =================================================================== --- ql/src/test/results/compiler/plan/sample7.q.xml (revision 742964) +++ ql/src/test/results/compiler/plan/sample7.q.xml (working copy) @@ -31,7 +31,7 @@ true - /data/users/athusoo/apacheprojects/hive_local_ws3/ql/../build/ql/tmp/1538040054/309610911.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/269820751/51881308.10000.insclause-0 @@ -80,7 +80,7 @@ location - file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/dest1 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest1 @@ -127,8 +127,11 @@ + + 1 + - /data/users/athusoo/apacheprojects/hive_local_ws3/ql/../build/ql/tmp/1538040054/309610911.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/269820751/51881308.10000.insclause-0 @@ -551,7 +554,7 @@ - file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/srcbucket/kv1.txt + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcbucket/kv1.txt s @@ -563,7 +566,7 @@ - file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/srcbucket/kv1.txt + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcbucket/kv1.txt @@ -619,7 +622,7 @@ location - file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/srcbucket + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcbucket Index: ql/src/test/results/compiler/plan/join1.q.xml =================================================================== --- ql/src/test/results/compiler/plan/join1.q.xml (revision 742964) +++ ql/src/test/results/compiler/plan/join1.q.xml (working copy) @@ -31,7 +31,7 @@ true - /data/users/zshao/sync/apache-trunk-HIVE-105/ql/../build/ql/tmp/707993971.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/31882983.10000.insclause-0 @@ -80,7 +80,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-105/build/ql/test/data/warehouse/dest1 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest1 @@ -530,7 +530,7 @@ - file:/data/users/zshao/sync/apache-trunk-HIVE-105/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src src2 @@ -545,7 +545,7 @@ - file:/data/users/zshao/sync/apache-trunk-HIVE-105/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src @@ -597,7 +597,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-105/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src @@ -622,8 +622,11 @@ + + 1 + - /data/users/zshao/sync/apache-trunk-HIVE-105/ql/../build/ql/tmp/707993971.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/31882983.10000.insclause-0 Index: ql/src/test/results/compiler/plan/input1.q.xml =================================================================== --- ql/src/test/results/compiler/plan/input1.q.xml (revision 742964) +++ ql/src/test/results/compiler/plan/input1.q.xml (working copy) @@ -31,7 +31,7 @@ true - /data/users/athusoo/apacheprojects/hive_local_ws3/ql/../build/ql/tmp/265277901/92421267.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/409012947/257617461.10000.insclause-0 @@ -80,7 +80,7 @@ location - file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/dest1 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest1 @@ -123,8 +123,11 @@ + + 1 + - /data/users/athusoo/apacheprojects/hive_local_ws3/ql/../build/ql/tmp/265277901/92421267.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/409012947/257617461.10000.insclause-0 @@ -384,7 +387,7 @@ - file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src src @@ -396,7 +399,7 @@ - file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src @@ -448,7 +451,7 @@ location - file:/data/users/athusoo/apacheprojects/hive_local_ws3/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src Index: ql/src/java/org/apache/hadoop/hive/ql/optimizer/ColumnPruner.java =================================================================== --- ql/src/java/org/apache/hadoop/hive/ql/optimizer/ColumnPruner.java (revision 742964) +++ ql/src/java/org/apache/hadoop/hive/ql/optimizer/ColumnPruner.java (working copy) @@ -140,6 +140,8 @@ if ((!pctx.getTopOps().containsValue(op)) && (!pctx.getTopSelOps().containsValue(op))) iter.remove(); } + pctx.setDestTableId(1); + pctx.getIdToTableNameMap().clear(); } /** Index: ql/src/java/org/apache/hadoop/hive/ql/exec/FileSinkOperator.java =================================================================== --- ql/src/java/org/apache/hadoop/hive/ql/exec/FileSinkOperator.java (revision 742964) +++ ql/src/java/org/apache/hadoop/hive/ql/exec/FileSinkOperator.java (working copy) @@ -27,6 +27,7 @@ import org.apache.hadoop.hive.ql.metadata.HiveException; import org.apache.hadoop.hive.ql.plan.fileSinkDesc; +import org.apache.hadoop.hive.ql.exec.FilterOperator.Counter; import org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat; import org.apache.hadoop.hive.serde.Constants; import org.apache.hadoop.hive.serde2.SerDeException; @@ -50,6 +51,14 @@ transient protected Path finalPath; transient protected Serializer serializer; transient protected BytesWritable commonKey = new BytesWritable(); + transient protected TableIdEnum tabIdEnum = null; + transient private LongWritable row_count; + public static enum TableIdEnum { + + TABLE_ID_1_ROWCOUNT, TABLE_ID_2_ROWCOUNT, TABLE_ID_3_ROWCOUNT, TABLE_ID_4_ROWCOUNT, TABLE_ID_5_ROWCOUNT, TABLE_ID_6_ROWCOUNT, TABLE_ID_7_ROWCOUNT, TABLE_ID_8_ROWCOUNT, TABLE_ID_9_ROWCOUNT, TABLE_ID_10_ROWCOUNT, TABLE_ID_11_ROWCOUNT, TABLE_ID_12_ROWCOUNT, TABLE_ID_13_ROWCOUNT, TABLE_ID_14_ROWCOUNT, TABLE_ID_15_ROWCOUNT; + + } + private void commit() throws IOException { fs.rename(outPath, finalPath); @@ -82,6 +91,7 @@ serializer = (Serializer)conf.getTableInfo().getDeserializerClass().newInstance(); serializer.initialize(null, conf.getTableInfo().getProperties()); + JobConf jc; if(hconf instanceof JobConf) { jc = (JobConf)hconf; @@ -90,6 +100,14 @@ jc = new JobConf(hconf, ExecDriver.class); } + int id = conf.getDestTableId(); + if ((id != 0) && (id <= TableIdEnum.values().length)){ + String enumName = "TABLE_ID_"+String.valueOf(id)+"_ROWCOUNT"; + tabIdEnum = TableIdEnum.valueOf(enumName); + row_count = new LongWritable(); + statsMap.put(tabIdEnum, row_count); + + } fs = FileSystem.get(hconf); finalPath = new Path(conf.getDirName(), Utilities.getTaskId(hconf)); outPath = new Path(conf.getDirName(), "_tmp."+Utilities.getTaskId(hconf)); @@ -159,6 +177,10 @@ reporter.progress(); // user SerDe to serialize r, and write it out recordValue = serializer.serialize(row, rowInspector); + if (row_count != null){ + row_count.set(row_count.get()+ 1); + } + outWriter.write(recordValue); } catch (IOException e) { throw new HiveException (e); Index: ql/src/java/org/apache/hadoop/hive/ql/plan/fileSinkDesc.java =================================================================== --- ql/src/java/org/apache/hadoop/hive/ql/plan/fileSinkDesc.java (revision 742964) +++ ql/src/java/org/apache/hadoop/hive/ql/plan/fileSinkDesc.java (working copy) @@ -26,18 +26,32 @@ private String dirName; private tableDesc tableInfo; private boolean compressed; + private int destTableId; + public fileSinkDesc() { } public fileSinkDesc( final String dirName, final tableDesc tableInfo, - final boolean compressed) { + final boolean compressed, int destTableId) { this.dirName = dirName; this.tableInfo = tableInfo; this.compressed = compressed; + this.destTableId = destTableId; } + public fileSinkDesc( + final String dirName, + final tableDesc tableInfo, + final boolean compressed) { + + this.dirName = dirName; + this.tableInfo = tableInfo; + this.compressed = compressed; + this.destTableId = 0; + } + @explain(displayName="directory", normalExplain=false) public String getDirName() { return this.dirName; @@ -62,4 +76,13 @@ public void setCompressed(boolean compressed) { this.compressed = compressed; } + + @explain(displayName="GlobalTableId") + public int getDestTableId() { + return destTableId; + } + + public void setDestTableId(int destTableId) { + this.destTableId = destTableId; + } } Index: ql/src/java/org/apache/hadoop/hive/ql/history/HiveHistory.java =================================================================== --- ql/src/java/org/apache/hadoop/hive/ql/history/HiveHistory.java (revision 742964) +++ ql/src/java/org/apache/hadoop/hive/ql/history/HiveHistory.java (working copy) @@ -53,11 +53,15 @@ private LogHelper console; + private Map idToTableMap = null; + // Job Hash Map private HashMap queryInfoMap = new HashMap(); // Task Hash Map private HashMap taskInfoMap = new HashMap(); + + private HashMap rowCountMap = new HashMap(); private static final String DELIMITER = " "; @@ -67,14 +71,18 @@ public static enum Keys { SESSION_ID, QUERY_ID, TASK_ID, QUERY_RET_CODE, QUERY_NUM_TASKS, QUERY_STRING, TIME, - TASK_RET_CODE, TASK_NAME, TASK_HADOOP_ID, TASK_HADOOP_PROGRESS, TASK_COUNTERS, TASK_NUM_REDUCERS + TASK_RET_CODE, TASK_NAME, TASK_HADOOP_ID, TASK_HADOOP_PROGRESS, TASK_COUNTERS, TASK_NUM_REDUCERS, ROWS_INSERTED }; private static final String KEY = "(\\w+)"; private static final String VALUE = "[[^\"]?]+"; // anything but a " in "" + private static final String ROW_COUNT_PATTERN = "TABLE_ID_(\\d+)_ROWCOUNT"; private static final Pattern pattern = Pattern.compile(KEY + "=" + "\"" + VALUE + "\""); + + private static final Pattern rowCountPattern = Pattern.compile(ROW_COUNT_PATTERN); + // temp buffer for parsed dataa private static Map parseBuffer = new HashMap(); @@ -190,7 +198,7 @@ } Random randGen = new Random(); histFileName = conf_file_loc + "/hive_job_log_" + ss.getSessionId() - +"_" + randGen.nextInt() + ".txt"; + +"_" + Math.abs(randGen.nextInt()) + ".txt"; console.printInfo("Hive history file=" + histFileName); histStream = new PrintWriter(histFileName); @@ -299,6 +307,7 @@ */ public void setTaskCounters(String queryId, String taskId, RunningJob rj) { String id = queryId + ":" + taskId; + StringBuilder sb1 = new StringBuilder(""); TaskInfo ti = taskInfoMap.get(id); if (ti == null) return; @@ -318,15 +327,39 @@ sb.append(counter.getDisplayName()); sb.append(':'); sb.append(counter.getCounter()); + String tab = getRowCountTableName(counter.getDisplayName()); + if (tab != null){ + if (sb1.length() > 0) + sb1.append(","); + sb1.append(tab); + sb1.append('~'); + sb1.append(counter.getCounter()); + rowCountMap.put(tab, counter.getCounter()); + + + } } } + + } catch (Exception e) { e.printStackTrace(); } - taskInfoMap.get(id).hm.put(Keys.TASK_COUNTERS.name(), sb.toString()); + if (sb1.length()>0) + { + taskInfoMap.get(id).hm.put(Keys.ROWS_INSERTED.name(), sb1.toString()); + queryInfoMap.get(queryId).hm.put(Keys.ROWS_INSERTED.name(), sb1.toString()); + } + if (sb.length() > 0) + taskInfoMap.get(id).hm.put(Keys.TASK_COUNTERS.name(), sb.toString()); } + public void printRowCount(){ + for (String tab: rowCountMap.keySet()){ + console.printInfo(rowCountMap.get(tab)+" Rows loaded to "+ tab); + } + } /** * Called at the end of Job. A Job is sql query. * @@ -391,5 +424,31 @@ log(RecordTypes.TaskProgress, ti.hm); } + + /** + * Set the table to id map + * @param map + */ + public void setIdToTableMap(Map map){ + idToTableMap = map; + } + /** + * Returns table name for the counter name + * @param name + * @return tableName + */ + String getRowCountTableName(String name){ + if (idToTableMap == null) return null; + Matcher m = rowCountPattern.matcher(name); + + if (m.find()){ + String tuple = m.group(1); + return idToTableMap.get(tuple); + } + return null; + + } + + } Index: ql/src/java/org/apache/hadoop/hive/ql/parse/BaseSemanticAnalyzer.java =================================================================== --- ql/src/java/org/apache/hadoop/hive/ql/parse/BaseSemanticAnalyzer.java (revision 742964) +++ ql/src/java/org/apache/hadoop/hive/ql/parse/BaseSemanticAnalyzer.java (working copy) @@ -46,7 +46,9 @@ protected final LogHelper console; protected Context ctx; - + protected HashMap idToTableNameMap; + + public BaseSemanticAnalyzer(HiveConf conf) throws SemanticException { try { this.conf = conf; @@ -59,11 +61,18 @@ Random rand = new Random(); this.randomid = Math.abs(rand.nextInt()%rand.nextInt()); this.pathid = 10000; + this.idToTableNameMap = new HashMap(); } catch (Exception e) { throw new SemanticException (e); } } + + public HashMap getIdToTableNameMap() { + return idToTableNameMap; + } + + public abstract void analyzeInternal(ASTNode ast, Context ctx) throws SemanticException; public void analyze(ASTNode ast, Context ctx) throws SemanticException { Index: ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java =================================================================== --- ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java (revision 742964) +++ ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java (working copy) @@ -80,6 +80,7 @@ private List loadFileWork; private QB qb; private ASTNode ast; + private int destTableId; private static class Phase1Ctx { String dest; @@ -97,7 +98,11 @@ this.loadTableWork = new ArrayList(); this.loadFileWork = new ArrayList(); opParseCtx = new HashMap, OpParseContext>(); + this.destTableId = 1; + + } + @Override protected void reset() { @@ -107,6 +112,8 @@ this.loadFileWork.clear(); this.topOps.clear(); this.topSelOps.clear(); + this.destTableId = 1; + this.idToTableNameMap.clear(); qb = null; ast = null; } @@ -120,11 +127,13 @@ loadTableWork = pctx.getLoadTableWork(); loadFileWork = pctx.getLoadFileWork(); ctx = pctx.getContext(); + destTableId = pctx.getDestTableId(); + idToTableNameMap = pctx.getIdToTableNameMap(); } public ParseContext getParseContext() { return new ParseContext(conf, qb, ast, aliasToPruner, aliasToSamplePruner, topOps, - topSelOps, opParseCtx, loadTableWork, loadFileWork, ctx); + topSelOps, opParseCtx, loadTableWork, loadFileWork, ctx, idToTableNameMap, destTableId); } @SuppressWarnings("nls") @@ -2027,14 +2036,22 @@ // create a temporary directory name and chain it to the plan String dest_path = null; tableDesc table_desc = null; + + int currentTableId = 0; Integer dest_type = qb.getMetaData().getDestTypeForAlias(dest); switch (dest_type.intValue()) { case QBMetaData.DEST_TABLE: { + + Table dest_tab = qb.getMetaData().getDestTableForAlias(dest); table_desc = Utilities.getTableDesc(dest_tab); + + this.idToTableNameMap.put( String.valueOf(this.destTableId), dest_tab.getName()); + currentTableId = this.destTableId; + this.destTableId ++; dest_path = dest_tab.getPath().toString(); // Create the work for moving the table @@ -2049,6 +2066,10 @@ Table dest_tab = dest_part.getTable(); table_desc = Utilities.getTableDesc(dest_tab); dest_path = dest_part.getPath()[0].toString(); + this.idToTableNameMap.put( String.valueOf(this.destTableId), dest_tab.getName()); + currentTableId = this.destTableId; + this.destTableId ++; + this.loadTableWork.add(new loadTableDesc(queryTmpdir, table_desc, dest_part.getSpec())); break; } @@ -2070,7 +2091,12 @@ else cols = cols.concat(nm[0] + "." + nm[1]); } - + if (!dest_path.startsWith(this.scratchDir+File.separator)) + { + this.idToTableNameMap.put( String.valueOf(this.destTableId), dest_path); + currentTableId = this.destTableId; + this.destTableId ++; + } this.loadFileWork.add(new loadFileDesc(queryTmpdir, dest_path, (dest_type.intValue() == QBMetaData.DEST_DFS_FILE), cols)); table_desc = PlanUtils.getDefaultTableDesc(Integer.toString(Utilities.ctrlaCode), @@ -2086,7 +2112,7 @@ Operator output = putOpInsertMap( OperatorFactory.getAndMakeChild( new fileSinkDesc(queryTmpdir, table_desc, - conf.getBoolVar(HiveConf.ConfVars.COMPRESSRESULT)), + conf.getBoolVar(HiveConf.ConfVars.COMPRESSRESULT), currentTableId), new RowSchema(inputRR.getColumnInfos()), input), inputRR); LOG.debug("Created FileSink Plan for clause: " + dest + "dest_path: " @@ -3250,9 +3276,10 @@ LOG.info("Completed getting MetaData in Semantic Analysis"); genPlan(qb); + ParseContext pCtx = new ParseContext(conf, qb, ast, aliasToPruner, aliasToSamplePruner, topOps, - topSelOps, opParseCtx, loadTableWork, loadFileWork, ctx); + topSelOps, opParseCtx, loadTableWork, loadFileWork, ctx, idToTableNameMap, destTableId); Optimizer optm = new Optimizer(); optm.setPctx(pCtx); Index: ql/src/java/org/apache/hadoop/hive/ql/parse/ParseContext.java =================================================================== --- ql/src/java/org/apache/hadoop/hive/ql/parse/ParseContext.java (revision 742964) +++ ql/src/java/org/apache/hadoop/hive/ql/parse/ParseContext.java (working copy) @@ -50,6 +50,8 @@ private List loadFileWork; private Context ctx; private HiveConf conf; + private HashMap idToTableNameMap; + private int destTableId; /** * @param qb @@ -79,7 +81,7 @@ HashMap> topSelOps, HashMap, OpParseContext> opParseCtx, List loadTableWork, List loadFileWork, - Context ctx) { + Context ctx, HashMap idToTableNameMap, int destTableId) { this.conf = conf; this.qb = qb; this.ast = ast; @@ -91,6 +93,8 @@ this.topOps = topOps; this.topSelOps = topSelOps; this.ctx = ctx; + this.idToTableNameMap = idToTableNameMap; + this.destTableId = destTableId; } /** @@ -260,4 +264,22 @@ public void setLoadFileWork(List loadFileWork) { this.loadFileWork = loadFileWork; } + + public HashMap getIdToTableNameMap() { + return idToTableNameMap; + } + + public void setIdToTableNameMap(HashMap idToTableNameMap) { + this.idToTableNameMap = idToTableNameMap; + } + + public int getDestTableId() { + return destTableId; + } + + public void setDestTableId(int destTableId) { + this.destTableId = destTableId; + } + + } Index: ql/src/java/org/apache/hadoop/hive/ql/Driver.java =================================================================== --- ql/src/java/org/apache/hadoop/hive/ql/Driver.java (revision 742964) +++ ql/src/java/org/apache/hadoop/hive/ql/Driver.java (working copy) @@ -197,10 +197,11 @@ if (jobs > 0) { console.printInfo("Total MapReduce jobs = " + jobs); } - if (SessionState.get() != null) + if (SessionState.get() != null){ SessionState.get().getHiveHistory().setQueryProperty(queryId, Keys.QUERY_NUM_TASKS, String.valueOf(jobs)); - + SessionState.get().getHiveHistory().setIdToTableMap(sem.getIdToTableNameMap()); + } String jobname = Utilities.abbreviate(command, maxlen - 6); int curJob = 0; for (Task rootTask : sem.getRootTasks()) { @@ -263,9 +264,11 @@ } } } - if (SessionState.get() != null) + if (SessionState.get() != null){ SessionState.get().getHiveHistory().setQueryProperty(queryId, Keys.QUERY_RET_CODE, String.valueOf(0)); + SessionState.get().getHiveHistory().printRowCount(); + } } catch (SemanticException e) { if (SessionState.get() != null) SessionState.get().getHiveHistory().setQueryProperty(queryId,