Index: ql/src/test/results/clientpositive/cast1.q.out =================================================================== --- ql/src/test/results/clientpositive/cast1.q.out (revision 747795) +++ ql/src/test/results/clientpositive/cast1.q.out (working copy) @@ -36,6 +36,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 747795) +++ ql/src/test/results/clientpositive/quote1.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 @@ -67,6 +68,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 747795) +++ 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/zshao/sync/apache-trunk-HIVE-292/build/ql/tmp/95316349/1574244180.10001 + /data/users/suresh/hive_external/build/ql/tmp/288823547/126799840.10001 Reduce Output Operator key expressions: expr: 0 @@ -80,6 +81,7 @@ type: bigint File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -96,7 +98,6 @@ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: dest1 - 1234 0 3.0 1234 10 1.0 1234 11 1.0 Index: ql/src/test/results/clientpositive/join2.q.out =================================================================== --- ql/src/test/results/clientpositive/join2.q.out (revision 747795) +++ 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 @@ -106,6 +107,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 747795) +++ ql/src/test/results/clientpositive/join6.q.out (working copy) @@ -88,6 +88,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 747795) +++ ql/src/test/results/clientpositive/input7.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/udf1.q.out =================================================================== --- ql/src/test/results/clientpositive/udf1.q.out (revision 747795) +++ 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 747795) +++ 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/input13.q.out =================================================================== --- ql/src/test/results/clientpositive/input13.q.out (revision 747795) +++ ql/src/test/results/clientpositive/input13.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 @@ -39,6 +40,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 @@ -54,6 +56,7 @@ type: string File Output Operator compressed: false + GlobalTableId: 3 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -69,6 +72,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/udf5.q.out =================================================================== --- ql/src/test/results/clientpositive/udf5.q.out (revision 747795) +++ 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/join16.q.out =================================================================== --- ql/src/test/results/clientpositive/join16.q.out (revision 747795) +++ 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 747795) +++ ql/src/test/results/clientpositive/input17.q.out (working copy) @@ -53,6 +53,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 747795) +++ 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: - /data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/tmp/478636139/58558573.10001 + /data/users/suresh/hive_external/build/ql/tmp/173094765/312984077.10001 Reduce Output Operator key expressions: expr: 0 @@ -70,6 +71,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 747795) +++ 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: - /data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/tmp/163387143/294575530.10001 + /data/users/suresh/hive_external/build/ql/tmp/1860802028/54191199.10001 Reduce Output Operator key expressions: expr: 0 @@ -70,6 +71,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/mapreduce3.q.out =================================================================== --- ql/src/test/results/clientpositive/mapreduce3.q.out (revision 747795) +++ ql/src/test/results/clientpositive/mapreduce3.q.out (working copy) @@ -46,6 +46,7 @@ Extract 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/mapreduce7.q.out =================================================================== --- ql/src/test/results/clientpositive/mapreduce7.q.out (revision 747795) +++ ql/src/test/results/clientpositive/mapreduce7.q.out (working copy) @@ -54,6 +54,7 @@ Extract 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 747795) +++ ql/src/test/results/clientpositive/input11_limit.q.out (working copy) @@ -34,6 +34,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 Index: ql/src/test/results/clientpositive/join21.q.out =================================================================== --- ql/src/test/results/clientpositive/join21.q.out (revision 747795) +++ 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 747795) +++ ql/src/test/results/clientpositive/sample4.q.out (working copy) @@ -18,7 +18,8 @@ type: string File Output Operator compressed: false - directory: /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/24294088/1535733768.10000.insclause-0 + GlobalTableId: 1 + directory: /data/users/suresh/hive_external/ql/../build/ql/tmp/352752249/345097786.10000.insclause-0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -32,14 +33,14 @@ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe 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-292/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.lazy.LazySimpleSerDe name: dest1 Needs Tagging: false Path -> Alias: - file:/data/users/zshao/sync/apache-trunk-HIVE-292/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-292/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 @@ -55,7 +56,7 @@ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe 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-292/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.lazy.LazySimpleSerDe name: srcbucket @@ -63,7 +64,7 @@ Move Operator tables: replace: true - source: /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/24294088/1535733768.10000.insclause-0 + source: /data/users/suresh/hive_external/ql/../build/ql/tmp/352752249/345097786.10000.insclause-0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -77,7 +78,7 @@ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe 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-292/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.lazy.LazySimpleSerDe name: dest1 Index: ql/src/test/results/clientpositive/groupby2_map.q.out =================================================================== --- ql/src/test/results/clientpositive/groupby2_map.q.out (revision 747795) +++ 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/zshao/sync/apache-trunk-HIVE-292/build/ql/tmp/303279525/67065402.10001 + /data/users/suresh/hive_external/build/ql/tmp/66695664/126238523.10001 Reduce Output Operator key expressions: expr: 0 @@ -92,6 +93,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 747795) +++ ql/src/test/results/clientpositive/sample8.q.out (working copy) @@ -48,12 +48,12 @@ type: string Needs Tagging: true Path -> Alias: - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/srcpart/hr=11/ds=2008-04-08 - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/srcpart/hr=12/ds=2008-04-08 - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/srcpart/hr=11/ds=2008-04-09 - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/srcpart/hr=12/ds=2008-04-09 + 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/zshao/sync/apache-trunk-HIVE-292/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=11/ds=2008-04-08 Partition partition values: ds 2008-04-08 @@ -72,10 +72,10 @@ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe 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-292/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.lazy.LazySimpleSerDe name: srcpart - file:/data/users/zshao/sync/apache-trunk-HIVE-292/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-08 Partition partition values: ds 2008-04-08 @@ -94,10 +94,10 @@ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe 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-292/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.lazy.LazySimpleSerDe name: srcpart - file:/data/users/zshao/sync/apache-trunk-HIVE-292/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=11/ds=2008-04-09 Partition partition values: ds 2008-04-09 @@ -116,10 +116,10 @@ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe 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-292/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.lazy.LazySimpleSerDe name: srcpart - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/srcpart/hr=12/ds=2008-04-09 + 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 +138,7 @@ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe 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-292/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.lazy.LazySimpleSerDe name: srcpart Reduce Operator Tree: @@ -164,7 +164,8 @@ type: string File Output Operator compressed: false - directory: /data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/tmp/28272118/25170648.10002 + GlobalTableId: 0 + directory: /data/users/suresh/hive_external/build/ql/tmp/532942841/982248112.10002 table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.mapred.SequenceFileOutputFormat @@ -177,7 +178,7 @@ Stage: Stage-2 Map Reduce Alias -> Map Operator Tree: - /data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/tmp/28272118/25170648.10002 + /data/users/suresh/hive_external/build/ql/tmp/532942841/982248112.10002 Reduce Output Operator key expressions: expr: 0 @@ -202,9 +203,9 @@ type: string Needs Tagging: false Path -> Alias: - /data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/tmp/28272118/25170648.10002 + /data/users/suresh/hive_external/build/ql/tmp/532942841/982248112.10002 Path -> Partition: - /data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/tmp/28272118/25170648.10002 + /data/users/suresh/hive_external/build/ql/tmp/532942841/982248112.10002 Partition input format: org.apache.hadoop.mapred.SequenceFileInputFormat @@ -218,7 +219,8 @@ Extract File Output Operator compressed: false - directory: /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/42160138.10001.insclause-0 + GlobalTableId: 0 + directory: /data/users/suresh/hive_external/ql/../build/ql/tmp/27678712.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 747795) +++ 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/zshao/sync/apache-trunk-HIVE-292/build/ql/tmp/632452177/1849231580.10001 + /data/users/suresh/hive_external/build/ql/tmp/102752904/333903439.10001 Reduce Output Operator key expressions: expr: 0 @@ -80,6 +81,7 @@ type: bigint File Output Operator compressed: false + GlobalTableId: 1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -96,7 +98,6 @@ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: dest1 - 1234 0 3.0 1234 10 1.0 1234 11 1.0 Index: ql/src/test/results/clientpositive/join1.q.out =================================================================== --- ql/src/test/results/clientpositive/join1.q.out (revision 747795) +++ ql/src/test/results/clientpositive/join1.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/join5.q.out =================================================================== --- ql/src/test/results/clientpositive/join5.q.out (revision 747795) +++ ql/src/test/results/clientpositive/join5.q.out (working copy) @@ -88,6 +88,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 747795) +++ 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 747795) +++ 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-292/build/ql/test/data/warehouse/src - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/srcpart/hr=12/ds=2008-04-08 + 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-292/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 @@ -69,10 +69,10 @@ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe 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-292/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.lazy.LazySimpleSerDe name: src - file:/data/users/zshao/sync/apache-trunk-HIVE-292/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-08 Partition partition values: ds 2008-04-08 @@ -91,7 +91,7 @@ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe 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-292/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.lazy.LazySimpleSerDe name: srcpart Reduce Operator Tree: @@ -113,7 +113,8 @@ type: string File Output Operator compressed: false - directory: /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/843147206.10000.insclause-0 + GlobalTableId: 1 + directory: /data/users/suresh/hive_external/ql/../build/ql/tmp/1684503332.10000.insclause-0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -127,7 +128,7 @@ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe 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-292/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.lazy.LazySimpleSerDe name: dest1 @@ -135,7 +136,7 @@ Move Operator tables: replace: true - source: /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/843147206.10000.insclause-0 + source: /data/users/suresh/hive_external/ql/../build/ql/tmp/1684503332.10000.insclause-0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -149,7 +150,7 @@ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe 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-292/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.lazy.LazySimpleSerDe name: dest1 Index: ql/src/test/results/clientpositive/binarysortable_1.q.out =================================================================== --- ql/src/test/results/clientpositive/binarysortable_1.q.out (revision 747795) +++ 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/1038847229/45592345.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 747795) +++ 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/input12.q.out =================================================================== --- ql/src/test/results/clientpositive/input12.q.out (revision 747795) +++ ql/src/test/results/clientpositive/input12.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 @@ -39,6 +40,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 @@ -54,6 +56,7 @@ type: string 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/udf4.q.out =================================================================== --- ql/src/test/results/clientpositive/udf4.q.out (revision 747795) +++ 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/join15.q.out =================================================================== --- ql/src/test/results/clientpositive/join15.q.out (revision 747795) +++ 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 747795) +++ 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/70974864/316512048.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 747795) +++ 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 747795) +++ 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 747795) +++ 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: - /data/users/zshao/sync/apache-trunk-HIVE-270/build/ql/tmp/50461607/40782581.10001 + /data/users/suresh/hive_external/build/ql/tmp/1587013653/168278742.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/input_part7.q.out =================================================================== --- ql/src/test/results/clientpositive/input_part7.q.out (revision 747795) +++ ql/src/test/results/clientpositive/input_part7.q.out (working copy) @@ -91,10 +91,10 @@ type: string Needs Tagging: false Path -> Alias: - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/srcpart/hr=11/ds=2008-04-08 - file:/data/users/zshao/sync/apache-trunk-HIVE-292/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-08 + 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-292/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=11/ds=2008-04-08 Partition partition values: ds 2008-04-08 @@ -113,10 +113,10 @@ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe 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-292/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.lazy.LazySimpleSerDe name: srcpart - file:/data/users/zshao/sync/apache-trunk-HIVE-292/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-08 Partition partition values: ds 2008-04-08 @@ -135,14 +135,15 @@ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe 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-292/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.lazy.LazySimpleSerDe name: srcpart Reduce Operator Tree: Extract File Output Operator compressed: false - directory: /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/69003835/150768080.10001.insclause-0 + GlobalTableId: 0 + directory: /data/users/suresh/hive_external/ql/../build/ql/tmp/1565954774/21907520.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/input1_limit.q.out =================================================================== --- ql/src/test/results/clientpositive/input1_limit.q.out (revision 747795) +++ 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 @@ -53,6 +54,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 @@ -78,7 +80,7 @@ Stage: Stage-2 Map Reduce Alias -> Map Operator Tree: - /data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/tmp/15356141/513972389.10002 + /data/users/suresh/hive_external/build/ql/tmp/613371753/59892183.10002 Reduce Output Operator sort order: tag: -1 @@ -92,12 +94,14 @@ Limit File Output Operator compressed: false + GlobalTableId: 2 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: dest2 + 86 val_86 27 val_27 98 val_98 Index: ql/src/test/results/clientpositive/input3_limit.q.out =================================================================== --- ql/src/test/results/clientpositive/input3_limit.q.out (revision 747795) +++ 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/zshao/sync/apache-trunk-HIVE-270/build/ql/tmp/4247336/336557500.10001 + /data/users/suresh/hive_external/build/ql/tmp/351284327/958627493.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 Index: ql/src/test/results/clientpositive/case_sensitivity.q.out =================================================================== --- ql/src/test/results/clientpositive/case_sensitivity.q.out (revision 747795) +++ 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 747795) +++ ql/src/test/results/clientpositive/mapreduce2.q.out (working copy) @@ -46,6 +46,7 @@ Extract 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 747795) +++ ql/src/test/results/clientpositive/mapreduce6.q.out (working copy) @@ -46,6 +46,7 @@ Extract 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 747795) +++ 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 747795) +++ 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 747795) +++ 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 747795) +++ 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/626454856/1350547095.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 747795) +++ 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/zshao/sync/apache-trunk-HIVE-292/build/ql/tmp/766792078/1062753384.10001 + /data/users/suresh/hive_external/build/ql/tmp/565749135/61062527.10001 Reduce Output Operator sort order: tag: -1 @@ -103,6 +104,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/sample7.q.out =================================================================== --- ql/src/test/results/clientpositive/sample7.q.out (revision 747795) +++ ql/src/test/results/clientpositive/sample7.q.out (working copy) @@ -26,7 +26,8 @@ type: string File Output Operator compressed: false - directory: /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/171100087/130839234.10000.insclause-0 + GlobalTableId: 1 + directory: /data/users/suresh/hive_external/ql/../build/ql/tmp/1494119520/1981029424.10000.insclause-0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -40,14 +41,14 @@ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe 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-292/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.lazy.LazySimpleSerDe name: dest1 Needs Tagging: false Path -> Alias: - file:/data/users/zshao/sync/apache-trunk-HIVE-292/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-292/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.lazy.LazySimpleSerDe 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-292/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.lazy.LazySimpleSerDe name: srcbucket @@ -71,7 +72,7 @@ Move Operator tables: replace: true - source: /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/171100087/130839234.10000.insclause-0 + source: /data/users/suresh/hive_external/ql/../build/ql/tmp/1494119520/1981029424.10000.insclause-0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -85,7 +86,7 @@ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe 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-292/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.lazy.LazySimpleSerDe name: dest1 Index: ql/src/test/results/clientpositive/join0.q.out =================================================================== --- ql/src/test/results/clientpositive/join0.q.out (revision 747795) +++ 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/291018297/138883565.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 747795) +++ 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/567040252/108440248.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/124737534/554653212.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/247667797/531125383.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/94432770/53306218.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 747795) +++ ql/src/test/results/clientpositive/join4.q.out (working copy) @@ -88,6 +88,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 747795) +++ 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_dynamicserde.q.out =================================================================== --- ql/src/test/results/clientpositive/input_dynamicserde.q.out (revision 747795) +++ 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/input_testxpath3.q.out =================================================================== --- ql/src/test/results/clientpositive/input_testxpath3.q.out (revision 747795) +++ 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_testsequencefile.q.out =================================================================== --- ql/src/test/results/clientpositive/input_testsequencefile.q.out (revision 747795) +++ ql/src/test/results/clientpositive/input_testsequencefile.q.out (working copy) @@ -18,6 +18,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/join8.q.out =================================================================== --- ql/src/test/results/clientpositive/join8.q.out (revision 747795) +++ ql/src/test/results/clientpositive/join8.q.out (working copy) @@ -92,6 +92,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/input9.q.out =================================================================== --- ql/src/test/results/clientpositive/input9.q.out (revision 747795) +++ ql/src/test/results/clientpositive/input9.q.out (working copy) @@ -26,6 +26,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/join10.q.out =================================================================== --- ql/src/test/results/clientpositive/join10.q.out (revision 747795) +++ 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 747795) +++ 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/zshao/sync/apache-trunk-HIVE-292/build/ql/tmp/866504261/124742303.10001 + /data/users/suresh/hive_external/build/ql/tmp/928139391/12887644.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/input11.q.out =================================================================== --- ql/src/test/results/clientpositive/input11.q.out (revision 747795) +++ ql/src/test/results/clientpositive/input11.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/noalias_subq1.q.out =================================================================== --- ql/src/test/results/clientpositive/noalias_subq1.q.out (revision 747795) +++ 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/input_testxpath.q.out =================================================================== --- ql/src/test/results/clientpositive/input_testxpath.q.out (revision 747795) +++ 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 747795) +++ ql/src/test/results/clientpositive/join14.q.out (working copy) @@ -74,6 +74,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 747795) +++ 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 747795) +++ ql/src/test/results/clientpositive/input_part2.q.out (working copy) @@ -26,7 +26,8 @@ type: string File Output Operator compressed: false - directory: /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/624854631/1444104961.10000.insclause-0 + GlobalTableId: 1 + directory: /data/users/suresh/hive_external/ql/../build/ql/tmp/592672360/455172239.10000.insclause-0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -40,7 +41,7 @@ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe 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-292/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.lazy.LazySimpleSerDe name: dest1 Filter Operator @@ -59,7 +60,8 @@ type: string File Output Operator compressed: false - directory: /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/624854631/1444104961.10001.insclause-1 + GlobalTableId: 2 + directory: /data/users/suresh/hive_external/ql/../build/ql/tmp/592672360/455172239.10001.insclause-1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -73,15 +75,15 @@ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe 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-292/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.lazy.LazySimpleSerDe name: dest2 Needs Tagging: false Path -> Alias: - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/srcpart/hr=12/ds=2008-04-08 - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/srcpart/hr=12/ds=2008-04-09 + 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/zshao/sync/apache-trunk-HIVE-292/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-08 Partition partition values: ds 2008-04-08 @@ -100,10 +102,10 @@ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe 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-292/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.lazy.LazySimpleSerDe name: srcpart - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/srcpart/hr=12/ds=2008-04-09 + 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 @@ -122,7 +124,7 @@ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe 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-292/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.lazy.LazySimpleSerDe name: srcpart @@ -130,7 +132,7 @@ Move Operator tables: replace: true - source: /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/624854631/1444104961.10000.insclause-0 + source: /data/users/suresh/hive_external/ql/../build/ql/tmp/592672360/455172239.10000.insclause-0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -144,11 +146,11 @@ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe 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-292/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.lazy.LazySimpleSerDe name: dest1 replace: true - source: /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/624854631/1444104961.10001.insclause-1 + source: /data/users/suresh/hive_external/ql/../build/ql/tmp/592672360/455172239.10001.insclause-1 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -162,7 +164,7 @@ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe 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-292/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.lazy.LazySimpleSerDe name: dest2 Index: ql/src/test/results/clientpositive/join18.q.out =================================================================== --- ql/src/test/results/clientpositive/join18.q.out (revision 747795) +++ 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/222176082/101446624.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/222176082/101446624.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/union2.q.out =================================================================== --- ql/src/test/results/clientpositive/union2.q.out (revision 747795) +++ 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/739806449/232428810.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/groupby3.q.out =================================================================== --- ql/src/test/results/clientpositive/groupby3.q.out (revision 747795) +++ 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/zshao/sync/apache-trunk-HIVE-292/build/ql/tmp/319898911/430849363.10001 + /data/users/suresh/hive_external/build/ql/tmp/383523376/581113300.10001 Reduce Output Operator sort order: tag: -1 @@ -81,6 +82,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/subq.q.out =================================================================== --- ql/src/test/results/clientpositive/subq.q.out (revision 747795) +++ 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/input_part6.q.out =================================================================== --- ql/src/test/results/clientpositive/input_part6.q.out (revision 747795) +++ 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 747795) +++ ql/src/test/results/clientpositive/mapreduce1.q.out (working copy) @@ -51,6 +51,7 @@ Extract 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 747795) +++ ql/src/test/results/clientpositive/mapreduce5.q.out (working copy) @@ -46,6 +46,7 @@ Extract 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 747795) +++ 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/39597410/96857706.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 747795) +++ ql/src/test/results/clientpositive/input20.q.out (working copy) @@ -54,6 +54,7 @@ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat 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 747795) +++ 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-292/build/ql/tmp/289413405/90604909.10001 + /data/users/suresh/hive_external/build/ql/tmp/80651290/173357897.10001 Reduce Output Operator key expressions: expr: 0 @@ -79,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/sample2.q.out =================================================================== --- ql/src/test/results/clientpositive/sample2.q.out (revision 747795) +++ ql/src/test/results/clientpositive/sample2.q.out (working copy) @@ -18,7 +18,8 @@ type: string File Output Operator compressed: false - directory: /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/950526520/398398485.10000.insclause-0 + GlobalTableId: 1 + directory: /data/users/suresh/hive_external/ql/../build/ql/tmp/285296283/100507889.10000.insclause-0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -32,14 +33,14 @@ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe 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-292/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.lazy.LazySimpleSerDe name: dest1 Needs Tagging: false Path -> Alias: - file:/data/users/zshao/sync/apache-trunk-HIVE-292/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-292/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 @@ -55,7 +56,7 @@ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe 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-292/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.lazy.LazySimpleSerDe name: srcbucket @@ -63,7 +64,7 @@ Move Operator tables: replace: true - source: /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/950526520/398398485.10000.insclause-0 + source: /data/users/suresh/hive_external/ql/../build/ql/tmp/285296283/100507889.10000.insclause-0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -77,7 +78,7 @@ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe 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-292/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.lazy.LazySimpleSerDe name: dest1 Index: ql/src/test/results/clientpositive/implicit_cast1.q.out =================================================================== --- ql/src/test/results/clientpositive/implicit_cast1.q.out (revision 747795) +++ 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 747795) +++ ql/src/test/results/clientpositive/sample6.q.out (working copy) @@ -22,7 +22,8 @@ type: string File Output Operator compressed: false - directory: /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/303271224/952284387.10000.insclause-0 + GlobalTableId: 1 + directory: /data/users/suresh/hive_external/ql/../build/ql/tmp/9261073/201358769.10000.insclause-0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -36,14 +37,14 @@ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe 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-292/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.lazy.LazySimpleSerDe name: dest1 Needs Tagging: false Path -> Alias: - file:/data/users/zshao/sync/apache-trunk-HIVE-292/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-292/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.lazy.LazySimpleSerDe 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-292/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.lazy.LazySimpleSerDe name: srcbucket @@ -67,7 +68,7 @@ Move Operator tables: replace: true - source: /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/303271224/952284387.10000.insclause-0 + source: /data/users/suresh/hive_external/ql/../build/ql/tmp/9261073/201358769.10000.insclause-0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -81,7 +82,7 @@ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe 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-292/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.lazy.LazySimpleSerDe name: dest1 Index: ql/src/test/results/clientpositive/groupby4_map.q.out =================================================================== --- ql/src/test/results/clientpositive/groupby4_map.q.out (revision 747795) +++ ql/src/test/results/clientpositive/groupby4_map.q.out (working copy) @@ -35,6 +35,7 @@ type: bigint 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 747795) +++ ql/src/test/results/clientpositive/join3.q.out (working copy) @@ -75,6 +75,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_testxpath2.q.out =================================================================== --- ql/src/test/results/clientpositive/input_testxpath2.q.out (revision 747795) +++ 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 747795) +++ ql/src/test/results/clientpositive/join7.q.out (working copy) @@ -123,6 +123,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 747795) +++ ql/src/test/results/clientpositive/input8.q.out (working copy) @@ -24,6 +24,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 747795) +++ 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 747795) +++ 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 747795) +++ 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 747795) +++ 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 747795) +++ ql/src/test/results/clientpositive/input14.q.out (working copy) @@ -49,6 +49,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 747795) +++ ql/src/test/results/clientpositive/input_part1.q.out (working copy) @@ -26,7 +26,8 @@ type: string File Output Operator compressed: false - directory: /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/10909570/5895329.10000.insclause-0 + GlobalTableId: 1 + directory: /data/users/suresh/hive_external/ql/../build/ql/tmp/86176150/198528042.10000.insclause-0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -40,14 +41,14 @@ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe 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-292/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.lazy.LazySimpleSerDe name: dest1 Needs Tagging: false Path -> Alias: - file:/data/users/zshao/sync/apache-trunk-HIVE-292/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-08 Path -> Partition: - file:/data/users/zshao/sync/apache-trunk-HIVE-292/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-08 Partition partition values: ds 2008-04-08 @@ -66,7 +67,7 @@ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe 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-292/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.lazy.LazySimpleSerDe name: srcpart @@ -74,7 +75,7 @@ Move Operator tables: replace: true - source: /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/10909570/5895329.10000.insclause-0 + source: /data/users/suresh/hive_external/ql/../build/ql/tmp/86176150/198528042.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.lazy.LazySimpleSerDe 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-292/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.lazy.LazySimpleSerDe name: dest1 Index: ql/src/test/results/clientpositive/join17.q.out =================================================================== --- ql/src/test/results/clientpositive/join17.q.out (revision 747795) +++ 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-292/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-292/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 @@ -58,7 +58,7 @@ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe 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-292/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.lazy.LazySimpleSerDe name: src Reduce Operator Tree: @@ -80,7 +80,8 @@ type: string File Output Operator compressed: false - directory: /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/125330382/360870831.10000.insclause-0 + GlobalTableId: 1 + directory: /data/users/suresh/hive_external/ql/../build/ql/tmp/1798908065/135704638.10000.insclause-0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -94,7 +95,7 @@ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe 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-292/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.lazy.LazySimpleSerDe name: dest1 @@ -102,7 +103,7 @@ Move Operator tables: replace: true - source: /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/125330382/360870831.10000.insclause-0 + source: /data/users/suresh/hive_external/ql/../build/ql/tmp/1798908065/135704638.10000.insclause-0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -116,7 +117,7 @@ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe 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-292/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.lazy.LazySimpleSerDe name: dest1 Index: ql/src/test/results/clientpositive/input18.q.out =================================================================== --- ql/src/test/results/clientpositive/input18.q.out (revision 747795) +++ ql/src/test/results/clientpositive/input18.q.out (working copy) @@ -53,6 +53,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 747795) +++ 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: - /data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/tmp/10545978/83610443.10001 + /data/users/suresh/hive_external/build/ql/tmp/1095000566/646137573.10001 Reduce Output Operator key expressions: expr: 0 @@ -77,6 +78,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 747795) +++ 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 747795) +++ 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: - /data/users/zshao/sync/apache-trunk-HIVE-270/build/ql/tmp/594382705/10780360.10001 + /data/users/suresh/hive_external/build/ql/tmp/571947566/230310881.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 747795) +++ 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 747795) +++ 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 747795) +++ ql/src/test/results/clientpositive/mapreduce4.q.out (working copy) @@ -51,6 +51,7 @@ Extract 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/mapreduce8.q.out =================================================================== --- ql/src/test/results/clientpositive/mapreduce8.q.out (revision 747795) +++ ql/src/test/results/clientpositive/mapreduce8.q.out (working copy) @@ -57,6 +57,7 @@ Extract 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 747795) +++ ql/src/test/results/clientpositive/sample1.q.out (working copy) @@ -30,7 +30,8 @@ type: string File Output Operator compressed: false - directory: /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/425042360/865491434.10000.insclause-0 + GlobalTableId: 1 + directory: /data/users/suresh/hive_external/ql/../build/ql/tmp/96438088/738268075.10000.insclause-0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -44,14 +45,14 @@ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe 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-292/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.lazy.LazySimpleSerDe name: dest1 Needs Tagging: false Path -> Alias: - file:/data/users/zshao/sync/apache-trunk-HIVE-292/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=11/ds=2008-04-08 Path -> Partition: - file:/data/users/zshao/sync/apache-trunk-HIVE-292/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=11/ds=2008-04-08 Partition partition values: ds 2008-04-08 @@ -70,7 +71,7 @@ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe 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-292/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.lazy.LazySimpleSerDe name: srcpart @@ -78,7 +79,7 @@ Move Operator tables: replace: true - source: /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/425042360/865491434.10000.insclause-0 + source: /data/users/suresh/hive_external/ql/../build/ql/tmp/96438088/738268075.10000.insclause-0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -92,7 +93,7 @@ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe 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-292/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.lazy.LazySimpleSerDe name: dest1 Index: ql/src/test/results/clientpositive/groupby1_map.q.out =================================================================== --- ql/src/test/results/clientpositive/groupby1_map.q.out (revision 747795) +++ 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: - /data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/tmp/580217776/833275504.10001 + /data/users/suresh/hive_external/build/ql/tmp/254971752/163185664.10001 Reduce Output Operator key expressions: expr: 0 @@ -77,6 +78,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 747795) +++ ql/src/test/results/clientpositive/sample5.q.out (working copy) @@ -22,7 +22,8 @@ type: string File Output Operator compressed: false - directory: /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/445074016/46841016.10000.insclause-0 + GlobalTableId: 1 + directory: /data/users/suresh/hive_external/ql/../build/ql/tmp/39418037/95228957.10000.insclause-0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -36,14 +37,14 @@ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe 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-292/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.lazy.LazySimpleSerDe name: dest1 Needs Tagging: false Path -> Alias: - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/srcbucket + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcbucket Path -> Partition: - file:/data/users/zshao/sync/apache-trunk-HIVE-292/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 @@ -59,7 +60,7 @@ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe 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-292/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.lazy.LazySimpleSerDe name: srcbucket @@ -67,7 +68,7 @@ Move Operator tables: replace: true - source: /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/445074016/46841016.10000.insclause-0 + source: /data/users/suresh/hive_external/ql/../build/ql/tmp/39418037/95228957.10000.insclause-0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat @@ -81,7 +82,7 @@ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe 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-292/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.lazy.LazySimpleSerDe name: dest1 Index: ql/src/test/results/clientpositive/groupby1_limit.q.out =================================================================== --- ql/src/test/results/clientpositive/groupby1_limit.q.out (revision 747795) +++ 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-292/build/ql/tmp/23529028/381361795.10001 + /data/users/suresh/hive_external/build/ql/tmp/290739125/10234530.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-292/build/ql/tmp/23529028/381361795.10002 + /data/users/suresh/hive_external/build/ql/tmp/290739125/10234530.10002 Reduce Output Operator sort order: tag: -1 @@ -94,6 +96,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 Index: ql/src/test/results/clientpositive/groupby5_map.q.out =================================================================== --- ql/src/test/results/clientpositive/groupby5_map.q.out (revision 747795) +++ ql/src/test/results/clientpositive/groupby5_map.q.out (working copy) @@ -38,6 +38,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/compiler/plan/join2.q.xml =================================================================== --- ql/src/test/results/compiler/plan/join2.q.xml (revision 747795) +++ ql/src/test/results/compiler/plan/join2.q.xml (working copy) @@ -35,7 +35,7 @@ true - /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/1372738136.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/221360850.10000.insclause-0 @@ -88,7 +88,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/dest1 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest1 @@ -551,7 +551,7 @@ - /data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/tmp/1398982247/30641865.10001 + /data/users/suresh/hive_external/build/ql/tmp/2016049730/69131460.10001 @@ -1162,7 +1162,7 @@ - /data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/tmp/1398982247/30641865.10001 + /data/users/suresh/hive_external/build/ql/tmp/2016049730/69131460.10001 $INTNAME @@ -1170,7 +1170,7 @@ - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src src3 @@ -1182,7 +1182,7 @@ - /data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/tmp/1398982247/30641865.10001 + /data/users/suresh/hive_external/build/ql/tmp/2016049730/69131460.10001 @@ -1190,7 +1190,7 @@ - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src @@ -1246,7 +1246,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src @@ -1271,8 +1271,11 @@ + + 1 + - /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/1372738136.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/221360850.10000.insclause-0 @@ -1538,7 +1541,7 @@ - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src src2 @@ -1553,7 +1556,7 @@ - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src @@ -1609,7 +1612,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-292/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 747795) +++ ql/src/test/results/compiler/plan/input2.q.xml (working copy) @@ -31,7 +31,7 @@ true - /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/658702358/146689636.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/353070602/333927627.10000.insclause-0 @@ -84,7 +84,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/dest1 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest1 @@ -104,7 +104,7 @@ true - /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/658702358/146689636.10001.insclause-1 + /data/users/suresh/hive_external/ql/../build/ql/tmp/353070602/333927627.10001.insclause-1 @@ -157,7 +157,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/dest2 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest2 @@ -186,7 +186,7 @@ true - /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/658702358/146689636.10002.insclause-2 + /data/users/suresh/hive_external/ql/../build/ql/tmp/353070602/333927627.10002.insclause-2 @@ -243,7 +243,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/dest3 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest3 @@ -286,8 +286,11 @@ + + 1 + - /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/658702358/146689636.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/353070602/333927627.10000.insclause-0 @@ -546,8 +549,11 @@ + + 2 + - /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/658702358/146689636.10001.insclause-1 + /data/users/suresh/hive_external/ql/../build/ql/tmp/353070602/333927627.10001.insclause-1 @@ -888,8 +894,11 @@ + + 3 + - /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/658702358/146689636.10002.insclause-2 + /data/users/suresh/hive_external/ql/../build/ql/tmp/353070602/333927627.10002.insclause-2 @@ -1112,7 +1121,7 @@ - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src src @@ -1124,7 +1133,7 @@ - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src @@ -1180,7 +1189,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-292/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 747795) +++ ql/src/test/results/compiler/plan/join3.q.xml (working copy) @@ -31,7 +31,7 @@ true - /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/31305467.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/525641633.10000.insclause-0 @@ -84,7 +84,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/dest1 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest1 @@ -754,7 +754,7 @@ - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src src2 @@ -772,7 +772,7 @@ - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src @@ -828,7 +828,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src @@ -853,8 +853,11 @@ + + 1 + - /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/31305467.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/525641633.10000.insclause-0 Index: ql/src/test/results/compiler/plan/input3.q.xml =================================================================== --- ql/src/test/results/compiler/plan/input3.q.xml (revision 747795) +++ ql/src/test/results/compiler/plan/input3.q.xml (working copy) @@ -28,7 +28,7 @@ true - /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/374455279/297135950.10003.insclause-3 + /data/users/suresh/hive_external/ql/../build/ql/tmp/109967648/395369916.10003.insclause-3 ../../../../build/contrib/hive/ql/test/data/warehouse/dest4.out @@ -48,7 +48,7 @@ true - /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/374455279/297135950.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/109967648/395369916.10000.insclause-0 @@ -101,7 +101,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/dest1 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest1 @@ -121,7 +121,7 @@ true - /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/374455279/297135950.10001.insclause-1 + /data/users/suresh/hive_external/ql/../build/ql/tmp/109967648/395369916.10001.insclause-1 @@ -174,7 +174,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/dest2 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest2 @@ -203,7 +203,7 @@ true - /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/374455279/297135950.10002.insclause-2 + /data/users/suresh/hive_external/ql/../build/ql/tmp/109967648/395369916.10002.insclause-2 @@ -260,7 +260,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/dest3 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest3 @@ -303,8 +303,11 @@ + + 1 + - /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/374455279/297135950.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/109967648/395369916.10000.insclause-0 @@ -563,8 +566,11 @@ + + 2 + - /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/374455279/297135950.10001.insclause-1 + /data/users/suresh/hive_external/ql/../build/ql/tmp/109967648/395369916.10001.insclause-1 @@ -905,8 +911,11 @@ + + 3 + - /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/374455279/297135950.10002.insclause-2 + /data/users/suresh/hive_external/ql/../build/ql/tmp/109967648/395369916.10002.insclause-2 @@ -1247,8 +1256,11 @@ + + 4 + - /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/374455279/297135950.10003.insclause-3 + /data/users/suresh/hive_external/ql/../build/ql/tmp/109967648/395369916.10003.insclause-3 @@ -1473,7 +1485,7 @@ - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src src @@ -1485,7 +1497,7 @@ - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src @@ -1541,7 +1553,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-292/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 747795) +++ ql/src/test/results/compiler/plan/input4.q.xml (working copy) @@ -31,7 +31,7 @@ true - /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/881929024/614130622.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/442019283/212854063.10000.insclause-0 @@ -84,7 +84,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/dest1 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest1 @@ -475,7 +475,7 @@ - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src tmap:src @@ -487,7 +487,7 @@ - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src @@ -543,7 +543,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src @@ -572,8 +572,11 @@ + + 1 + - /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/881929024/614130622.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/442019283/212854063.10000.insclause-0 Index: ql/src/test/results/compiler/plan/input5.q.xml =================================================================== --- ql/src/test/results/compiler/plan/input5.q.xml (revision 747795) +++ ql/src/test/results/compiler/plan/input5.q.xml (working copy) @@ -31,7 +31,7 @@ true - /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/189543713.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/185387849.10000.insclause-0 @@ -84,7 +84,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/dest1 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest1 @@ -609,7 +609,7 @@ - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/src_thrift + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src_thrift tmap:src_thrift @@ -621,7 +621,7 @@ - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/src_thrift + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src_thrift @@ -681,7 +681,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/src_thrift + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src_thrift @@ -706,8 +706,11 @@ + + 1 + - /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/189543713.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/185387849.10000.insclause-0 Index: ql/src/test/results/compiler/plan/input6.q.xml =================================================================== --- ql/src/test/results/compiler/plan/input6.q.xml (revision 747795) +++ ql/src/test/results/compiler/plan/input6.q.xml (working copy) @@ -31,7 +31,7 @@ true - /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/267308598/510367048.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/1206033809/95359217.10000.insclause-0 @@ -84,7 +84,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-292/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/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/267308598/510367048.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/1206033809/95359217.10000.insclause-0 @@ -319,7 +322,7 @@ - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/src1 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src1 src1 @@ -331,7 +334,7 @@ - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/src1 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src1 @@ -387,7 +390,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-292/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 747795) +++ ql/src/test/results/compiler/plan/input7.q.xml (working copy) @@ -31,7 +31,7 @@ true - /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/143269220.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/476338895.10000.insclause-0 @@ -84,7 +84,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-292/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/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/143269220.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/476338895.10000.insclause-0 @@ -307,7 +310,7 @@ - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/src1 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src1 src1 @@ -319,7 +322,7 @@ - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/src1 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src1 @@ -375,7 +378,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-292/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 747795) +++ ql/src/test/results/compiler/plan/input_testsequencefile.q.xml (working copy) @@ -31,7 +31,7 @@ true - /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/376067338/60005233.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/1199194298/706147922.10000.insclause-0 @@ -84,7 +84,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/dest4_sequencefile + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest4_sequencefile @@ -123,8 +123,11 @@ + + 1 + - /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/376067338/60005233.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/1199194298/706147922.10000.insclause-0 @@ -255,7 +258,7 @@ - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src src @@ -267,7 +270,7 @@ - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src @@ -323,7 +326,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-292/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/union.q.xml =================================================================== --- ql/src/test/results/compiler/plan/union.q.xml (revision 747795) +++ ql/src/test/results/compiler/plan/union.q.xml (working copy) @@ -28,7 +28,7 @@ true - /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/83128511/25205679.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/230352535/187245660.10000.insclause-0 ../build/ql/test/data/warehouse/union.out @@ -78,8 +78,11 @@ + + 1 + - /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/83128511/25205679.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/230352535/187245660.10000.insclause-0 @@ -690,7 +693,7 @@ - file:/data/users/zshao/sync/apache-trunk-HIVE-292/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/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src @@ -761,7 +764,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-292/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 747795) +++ ql/src/test/results/compiler/plan/input9.q.xml (working copy) @@ -31,7 +31,7 @@ true - /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/171676269.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/735172418.10000.insclause-0 @@ -84,7 +84,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/dest1 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest1 @@ -131,8 +131,11 @@ + + 1 + - /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/171676269.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/735172418.10000.insclause-0 @@ -382,7 +385,7 @@ - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/src1 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src1 src1 @@ -394,7 +397,7 @@ - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/src1 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src1 @@ -450,7 +453,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-292/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/groupby1.q.xml =================================================================== --- ql/src/test/results/compiler/plan/groupby1.q.xml (revision 747795) +++ ql/src/test/results/compiler/plan/groupby1.q.xml (working copy) @@ -35,7 +35,7 @@ true - /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/3832508/94288076.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/76192888/698552852.10000.insclause-0 @@ -88,7 +88,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/dest1 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest1 @@ -122,7 +122,7 @@ - /data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/tmp/3832508/94288076.10001 + /data/users/suresh/hive_external/build/ql/tmp/76192888/698552852.10001 @@ -246,7 +246,7 @@ - /data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/tmp/3832508/94288076.10001 + /data/users/suresh/hive_external/build/ql/tmp/76192888/698552852.10001 @@ -695,10 +695,10 @@ - /data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/tmp/3832508/94288076.10001 + /data/users/suresh/hive_external/build/ql/tmp/76192888/698552852.10001 - /data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/tmp/3832508/94288076.10001 + /data/users/suresh/hive_external/build/ql/tmp/76192888/698552852.10001 @@ -707,7 +707,7 @@ - /data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/tmp/3832508/94288076.10001 + /data/users/suresh/hive_external/build/ql/tmp/76192888/698552852.10001 @@ -728,8 +728,11 @@ + + 1 + - /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/3832508/94288076.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/76192888/698552852.10000.insclause-0 @@ -955,7 +958,7 @@ - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src src @@ -967,7 +970,7 @@ - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src @@ -1023,7 +1026,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-292/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 747795) +++ ql/src/test/results/compiler/plan/subq.q.xml (working copy) @@ -28,7 +28,7 @@ true - /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/46472807/242639424.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/1072006580/138859692.10000.insclause-0 ../build/ql/test/data/warehouse/union.out @@ -74,8 +74,11 @@ + + 1 + - /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/46472807/242639424.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/1072006580/138859692.10000.insclause-0 @@ -430,7 +433,7 @@ - file:/data/users/zshao/sync/apache-trunk-HIVE-292/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/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src @@ -498,7 +501,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-292/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 747795) +++ ql/src/test/results/compiler/plan/case_sensitivity.q.xml (working copy) @@ -31,7 +31,7 @@ true - /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/1261061735.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/87328864.10000.insclause-0 @@ -84,7 +84,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/dest1 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest1 @@ -131,8 +131,11 @@ + + 1 + - /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/1261061735.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/87328864.10000.insclause-0 @@ -530,7 +533,7 @@ - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/src_thrift + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src_thrift src_thrift @@ -542,7 +545,7 @@ - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/src_thrift + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src_thrift @@ -602,7 +605,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-292/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 747795) +++ ql/src/test/results/compiler/plan/sample2.q.xml (working copy) @@ -31,7 +31,7 @@ true - /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/158143647/19880045.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/153476667/1012198465.10000.insclause-0 @@ -84,7 +84,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-292/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/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/158143647/19880045.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/153476667/1012198465.10000.insclause-0 @@ -258,7 +261,7 @@ - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/srcbucket/kv1.txt + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcbucket/kv1.txt s @@ -270,7 +273,7 @@ - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/srcbucket/kv1.txt + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcbucket/kv1.txt @@ -330,7 +333,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-292/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 747795) +++ ql/src/test/results/compiler/plan/sample3.q.xml (working copy) @@ -31,7 +31,7 @@ true - /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/362417800/1298736006.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/869603607/810851794.10000.insclause-0 @@ -84,7 +84,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-292/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/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/362417800/1298736006.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/869603607/810851794.10000.insclause-0 @@ -443,7 +446,7 @@ - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/srcbucket + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcbucket s @@ -455,7 +458,7 @@ - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/srcbucket + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcbucket @@ -515,7 +518,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-292/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 747795) +++ ql/src/test/results/compiler/plan/sample4.q.xml (working copy) @@ -31,7 +31,7 @@ true - /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/637806170/200924363.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/12243774/33069345.10000.insclause-0 @@ -84,7 +84,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-292/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/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/637806170/200924363.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/12243774/33069345.10000.insclause-0 @@ -258,7 +261,7 @@ - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/srcbucket/kv1.txt + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcbucket/kv1.txt s @@ -270,7 +273,7 @@ - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/srcbucket/kv1.txt + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcbucket/kv1.txt @@ -330,7 +333,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-292/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 747795) +++ ql/src/test/results/compiler/plan/sample5.q.xml (working copy) @@ -31,7 +31,7 @@ true - /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/1281636920/855112172.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/28394925/6001732.10000.insclause-0 @@ -84,7 +84,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-292/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/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/1281636920/855112172.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/28394925/6001732.10000.insclause-0 @@ -430,7 +433,7 @@ - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/srcbucket + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcbucket s @@ -442,7 +445,7 @@ - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/srcbucket + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcbucket @@ -502,7 +505,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-292/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 747795) +++ ql/src/test/results/compiler/plan/sample6.q.xml (working copy) @@ -31,7 +31,7 @@ true - /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/178457491/743576201.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/544634939/1106389744.10000.insclause-0 @@ -84,7 +84,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-292/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/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/178457491/743576201.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/544634939/1106389744.10000.insclause-0 @@ -430,7 +433,7 @@ - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/srcbucket/kv1.txt + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcbucket/kv1.txt s @@ -442,7 +445,7 @@ - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/srcbucket/kv1.txt + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcbucket/kv1.txt @@ -502,7 +505,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-292/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 747795) +++ ql/src/test/results/compiler/plan/sample7.q.xml (working copy) @@ -31,7 +31,7 @@ true - /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/353480016/1067577190.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/538031371/754386428.10000.insclause-0 @@ -84,7 +84,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/dest1 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest1 @@ -131,8 +131,11 @@ + + 1 + - /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/353480016/1067577190.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/538031371/754386428.10000.insclause-0 @@ -555,7 +558,7 @@ - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/srcbucket/kv1.txt + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcbucket/kv1.txt s @@ -567,7 +570,7 @@ - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/srcbucket/kv1.txt + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/srcbucket/kv1.txt @@ -627,7 +630,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-292/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 747795) +++ ql/src/test/results/compiler/plan/join1.q.xml (working copy) @@ -31,7 +31,7 @@ true - /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/129851762.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/237620817.10000.insclause-0 @@ -84,7 +84,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/dest1 + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/dest1 @@ -534,7 +534,7 @@ - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src src2 @@ -549,7 +549,7 @@ - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src @@ -605,7 +605,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src @@ -630,8 +630,11 @@ + + 1 + - /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/129851762.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/237620817.10000.insclause-0 Index: ql/src/test/results/compiler/plan/input1.q.xml =================================================================== --- ql/src/test/results/compiler/plan/input1.q.xml (revision 747795) +++ ql/src/test/results/compiler/plan/input1.q.xml (working copy) @@ -31,7 +31,7 @@ true - /data/users/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/697528137/282404521.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/18709124/21218607.10000.insclause-0 @@ -84,7 +84,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-292/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/zshao/sync/apache-trunk-HIVE-292/ql/../build/ql/tmp/697528137/282404521.10000.insclause-0 + /data/users/suresh/hive_external/ql/../build/ql/tmp/18709124/21218607.10000.insclause-0 @@ -388,7 +391,7 @@ - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src src @@ -400,7 +403,7 @@ - file:/data/users/zshao/sync/apache-trunk-HIVE-292/build/ql/test/data/warehouse/src + file:/data/users/suresh/hive_external/build/ql/test/data/warehouse/src @@ -456,7 +459,7 @@ location - file:/data/users/zshao/sync/apache-trunk-HIVE-292/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 747795) +++ 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 747795) +++ ql/src/java/org/apache/hadoop/hive/ql/exec/FileSinkOperator.java (working copy) @@ -28,6 +28,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; @@ -51,6 +52,13 @@ 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; + + } transient protected boolean autoDelete = false; private void commit() throws IOException { @@ -88,6 +96,7 @@ serializer = (Serializer)conf.getTableInfo().getDeserializerClass().newInstance(); serializer.initialize(null, conf.getTableInfo().getProperties()); + JobConf jc; if(hconf instanceof JobConf) { jc = (JobConf)hconf; @@ -96,6 +105,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(Utilities.toTempPath(conf.getDirName()), Utilities.getTaskId(hconf)); outPath = new Path(Utilities.toTempPath(conf.getDirName()), Utilities.toTempPath(Utilities.getTaskId(hconf))); @@ -177,6 +194,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 747795) +++ 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 747795) +++ 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 747795) +++ 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 747795) +++ ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java (working copy) @@ -81,6 +81,7 @@ private List loadFileWork; private QB qb; private ASTNode ast; + private int destTableId; private static class Phase1Ctx { String dest; @@ -98,7 +99,11 @@ this.loadTableWork = new ArrayList(); this.loadFileWork = new ArrayList(); opParseCtx = new HashMap, OpParseContext>(); + this.destTableId = 1; + + } + @Override protected void reset() { @@ -108,6 +113,8 @@ this.loadFileWork.clear(); this.topOps.clear(); this.topSelOps.clear(); + this.destTableId = 1; + this.idToTableNameMap.clear(); qb = null; ast = null; } @@ -121,11 +128,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") @@ -2028,14 +2037,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 @@ -2050,6 +2067,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; } @@ -2071,7 +2092,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), @@ -2087,7 +2113,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: " @@ -3252,9 +3278,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 747795) +++ 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 747795) +++ 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,