You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by na...@apache.org on 2010/08/19 03:13:45 UTC
svn commit: r986995 - in /hadoop/hive/trunk: CHANGES.txt
hbase-handler/src/test/results/hbase_bulk.m.out
hbase-handler/src/test/results/hbase_joins.q.out
hbase-handler/src/test/results/hbase_queries.q.out
Author: namit
Date: Thu Aug 19 01:13:45 2010
New Revision: 986995
URL: http://svn.apache.org/viewvc?rev=986995&view=rev
Log:
HIVE-1563. tests broken
(John Sichi via namit)
Modified:
hadoop/hive/trunk/CHANGES.txt
hadoop/hive/trunk/hbase-handler/src/test/results/hbase_bulk.m.out
hadoop/hive/trunk/hbase-handler/src/test/results/hbase_joins.q.out
hadoop/hive/trunk/hbase-handler/src/test/results/hbase_queries.q.out
Modified: hadoop/hive/trunk/CHANGES.txt
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/CHANGES.txt?rev=986995&r1=986994&r2=986995&view=diff
==============================================================================
--- hadoop/hive/trunk/CHANGES.txt (original)
+++ hadoop/hive/trunk/CHANGES.txt Thu Aug 19 01:13:45 2010
@@ -160,6 +160,9 @@ Trunk - Unreleased
HIVE-1556. tests broken
(namit via Ning Zhang)
+ HIVE-1563. tests broken
+ (John Sichi via namit)
+
TESTS
HIVE-1464. improve test query performance
Modified: hadoop/hive/trunk/hbase-handler/src/test/results/hbase_bulk.m.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/hbase-handler/src/test/results/hbase_bulk.m.out?rev=986995&r1=986994&r2=986995&view=diff
==============================================================================
--- hadoop/hive/trunk/hbase-handler/src/test/results/hbase_bulk.m.out (original)
+++ hadoop/hive/trunk/hbase-handler/src/test/results/hbase_bulk.m.out Thu Aug 19 01:13:45 2010
@@ -69,7 +69,7 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@hbpartition
POSTHOOK: Lineage: hbpartition.part_break SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
- 1 1 139 hdfs://localhost:57034/tmp/hbpartitions
+ 1 1 139 hdfs://localhost.localdomain:33778/tmp/hbpartitions
PREHOOK: query: -- this should produce three files in /tmp/hbsort/cf
-- include some trailing blanks and nulls to make sure we handle them correctly
insert overwrite table hbsort
@@ -98,7 +98,7 @@ POSTHOOK: Lineage: hbpartition.part_brea
POSTHOOK: Lineage: hbsort.key SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: hbsort.val EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: hbsort.val2 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
- 1 3 23227 hdfs://localhost:57034/tmp/hbsort/cf
+ 1 3 23227 hdfs://localhost.localdomain:33778/tmp/hbsort/cf
PREHOOK: query: -- To get the files out to your local filesystem for loading into
-- HBase, run mkdir -p /tmp/blah/cf, then uncomment and
-- semicolon-terminate the line below before running this test:
@@ -106,6 +106,8 @@ PREHOOK: query: -- To get the files out
drop table hbsort
PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@hbsort
+PREHOOK: Output: default@hbsort
POSTHOOK: query: -- To get the files out to your local filesystem for loading into
-- HBase, run mkdir -p /tmp/blah/cf, then uncomment and
-- semicolon-terminate the line below before running this test:
@@ -113,6 +115,7 @@ POSTHOOK: query: -- To get the files out
drop table hbsort
POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@hbsort
POSTHOOK: Output: default@hbsort
POSTHOOK: Lineage: hbpartition.part_break SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: hbsort.key SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
@@ -120,8 +123,11 @@ POSTHOOK: Lineage: hbsort.val EXPRESSION
POSTHOOK: Lineage: hbsort.val2 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
PREHOOK: query: drop table hbpartition
PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@hbpartition
+PREHOOK: Output: default@hbpartition
POSTHOOK: query: drop table hbpartition
POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@hbpartition
POSTHOOK: Output: default@hbpartition
POSTHOOK: Lineage: hbpartition.part_break SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: hbsort.key SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
Modified: hadoop/hive/trunk/hbase-handler/src/test/results/hbase_joins.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/hbase-handler/src/test/results/hbase_joins.q.out?rev=986995&r1=986994&r2=986995&view=diff
==============================================================================
--- hadoop/hive/trunk/hbase-handler/src/test/results/hbase_joins.q.out (original)
+++ hadoop/hive/trunk/hbase-handler/src/test/results/hbase_joins.q.out Thu Aug 19 01:13:45 2010
@@ -88,115 +88,124 @@ ON (u.country = c.key)
PREHOOK: type: QUERY
PREHOOK: Input: default@users
PREHOOK: Input: default@countries
-PREHOOK: Output: file:/Users/jsichi/open/hive-trunk/build/hbase-handler/scratchdir/hive_2010-03-23_12-31-19_117_4712777556867957470/10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-18_16-24-35_518_6582730260204141679/-mr-10000
POSTHOOK: query: SELECT u.key, u.country, c.name, c.key FROM users u JOIN countries c
ON (u.country = c.key)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@users
POSTHOOK: Input: default@countries
-POSTHOOK: Output: file:/Users/jsichi/open/hive-trunk/build/hbase-handler/scratchdir/hive_2010-03-23_12-31-19_117_4712777556867957470/10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-18_16-24-35_518_6582730260204141679/-mr-10000
user1 USA United States USA
PREHOOK: query: SELECT u.key, u.country, c.name, c.key FROM users u JOIN countries c
ON (u.country = c.country)
PREHOOK: type: QUERY
PREHOOK: Input: default@users
PREHOOK: Input: default@countries
-PREHOOK: Output: file:/Users/jsichi/open/hive-trunk/build/hbase-handler/scratchdir/hive_2010-03-23_12-31-25_489_4149172260159935049/10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-18_16-24-39_508_6031616226903764593/-mr-10000
POSTHOOK: query: SELECT u.key, u.country, c.name, c.key FROM users u JOIN countries c
ON (u.country = c.country)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@users
POSTHOOK: Input: default@countries
-POSTHOOK: Output: file:/Users/jsichi/open/hive-trunk/build/hbase-handler/scratchdir/hive_2010-03-23_12-31-25_489_4149172260159935049/10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-18_16-24-39_508_6031616226903764593/-mr-10000
user1 USA United States USA
PREHOOK: query: SELECT u.key, u.country, c.name, c.key FROM users u JOIN countries c
ON (u.country_id = c.country_id)
PREHOOK: type: QUERY
PREHOOK: Input: default@users
PREHOOK: Input: default@countries
-PREHOOK: Output: file:/Users/jsichi/open/hive-trunk/build/hbase-handler/scratchdir/hive_2010-03-23_12-31-32_285_599526889736525802/10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-18_16-24-43_394_7124445524751329949/-mr-10000
POSTHOOK: query: SELECT u.key, u.country, c.name, c.key FROM users u JOIN countries c
ON (u.country_id = c.country_id)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@users
POSTHOOK: Input: default@countries
-POSTHOOK: Output: file:/Users/jsichi/open/hive-trunk/build/hbase-handler/scratchdir/hive_2010-03-23_12-31-32_285_599526889736525802/10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-18_16-24-43_394_7124445524751329949/-mr-10000
PREHOOK: query: SELECT u.key, u.state, s.name FROM users u JOIN states s
ON (u.state = s.key)
PREHOOK: type: QUERY
PREHOOK: Input: default@users
PREHOOK: Input: default@states
-PREHOOK: Output: file:/Users/jsichi/open/hive-trunk/build/hbase-handler/scratchdir/hive_2010-03-23_12-31-38_500_2952626450057612534/10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-18_16-24-47_258_669944869681282290/-mr-10000
POSTHOOK: query: SELECT u.key, u.state, s.name FROM users u JOIN states s
ON (u.state = s.key)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@users
POSTHOOK: Input: default@states
-POSTHOOK: Output: file:/Users/jsichi/open/hive-trunk/build/hbase-handler/scratchdir/hive_2010-03-23_12-31-38_500_2952626450057612534/10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-18_16-24-47_258_669944869681282290/-mr-10000
user1 IA Iowa
PREHOOK: query: SELECT u.key, u.country, c.name, c.key FROM users u JOIN countries c
ON (u.country = c.key)
PREHOOK: type: QUERY
PREHOOK: Input: default@users
PREHOOK: Input: default@countries
-PREHOOK: Output: file:/Users/jsichi/open/hive-trunk/build/hbase-handler/scratchdir/hive_2010-03-23_12-31-45_911_3744508358740860232/10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-18_16-24-51_124_1283622353907376927/-mr-10000
POSTHOOK: query: SELECT u.key, u.country, c.name, c.key FROM users u JOIN countries c
ON (u.country = c.key)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@users
POSTHOOK: Input: default@countries
-POSTHOOK: Output: file:/Users/jsichi/open/hive-trunk/build/hbase-handler/scratchdir/hive_2010-03-23_12-31-45_911_3744508358740860232/10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-18_16-24-51_124_1283622353907376927/-mr-10000
user1 USA United States USA
PREHOOK: query: SELECT u.key, u.country, c.name, c.key FROM users u JOIN countries c
ON (u.country = c.country)
PREHOOK: type: QUERY
PREHOOK: Input: default@users
PREHOOK: Input: default@countries
-PREHOOK: Output: file:/Users/jsichi/open/hive-trunk/build/hbase-handler/scratchdir/hive_2010-03-23_12-31-52_375_497455375799515705/10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-18_16-24-55_006_4907179709145458200/-mr-10000
POSTHOOK: query: SELECT u.key, u.country, c.name, c.key FROM users u JOIN countries c
ON (u.country = c.country)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@users
POSTHOOK: Input: default@countries
-POSTHOOK: Output: file:/Users/jsichi/open/hive-trunk/build/hbase-handler/scratchdir/hive_2010-03-23_12-31-52_375_497455375799515705/10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-18_16-24-55_006_4907179709145458200/-mr-10000
user1 USA United States USA
PREHOOK: query: SELECT u.key, u.country, c.name, c.key FROM users u JOIN countries c
ON (u.country_id = c.country_id)
PREHOOK: type: QUERY
PREHOOK: Input: default@users
PREHOOK: Input: default@countries
-PREHOOK: Output: file:/Users/jsichi/open/hive-trunk/build/hbase-handler/scratchdir/hive_2010-03-23_12-31-59_778_6209720937134856434/10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-18_16-24-59_926_3403340219286631512/-mr-10000
POSTHOOK: query: SELECT u.key, u.country, c.name, c.key FROM users u JOIN countries c
ON (u.country_id = c.country_id)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@users
POSTHOOK: Input: default@countries
-POSTHOOK: Output: file:/Users/jsichi/open/hive-trunk/build/hbase-handler/scratchdir/hive_2010-03-23_12-31-59_778_6209720937134856434/10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-18_16-24-59_926_3403340219286631512/-mr-10000
PREHOOK: query: SELECT u.key, u.state, s.name FROM users u JOIN states s
ON (u.state = s.key)
PREHOOK: type: QUERY
PREHOOK: Input: default@users
PREHOOK: Input: default@states
-PREHOOK: Output: file:/Users/jsichi/open/hive-trunk/build/hbase-handler/scratchdir/hive_2010-03-23_12-32-06_717_1044214443379190261/10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-18_16-25-03_662_70234471203920991/-mr-10000
POSTHOOK: query: SELECT u.key, u.state, s.name FROM users u JOIN states s
ON (u.state = s.key)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@users
POSTHOOK: Input: default@states
-POSTHOOK: Output: file:/Users/jsichi/open/hive-trunk/build/hbase-handler/scratchdir/hive_2010-03-23_12-32-06_717_1044214443379190261/10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-18_16-25-03_662_70234471203920991/-mr-10000
user1 IA Iowa
PREHOOK: query: DROP TABLE users
PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@users
+PREHOOK: Output: default@users
POSTHOOK: query: DROP TABLE users
POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@users
POSTHOOK: Output: default@users
PREHOOK: query: DROP TABLE states
PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@states
+PREHOOK: Output: default@states
POSTHOOK: query: DROP TABLE states
POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@states
POSTHOOK: Output: default@states
PREHOOK: query: DROP TABLE countries
PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@countries
+PREHOOK: Output: default@countries
POSTHOOK: query: DROP TABLE countries
POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@countries
POSTHOOK: Output: default@countries
Modified: hadoop/hive/trunk/hbase-handler/src/test/results/hbase_queries.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/hbase-handler/src/test/results/hbase_queries.q.out?rev=986995&r1=986994&r2=986995&view=diff
==============================================================================
--- hadoop/hive/trunk/hbase-handler/src/test/results/hbase_queries.q.out (original)
+++ hadoop/hive/trunk/hbase-handler/src/test/results/hbase_queries.q.out Thu Aug 19 01:13:45 2010
@@ -20,15 +20,15 @@ POSTHOOK: type: DESCTABLE
key int from deserializer
value string from deserializer
-Detailed Table Information Table(tableName:hbase_table_1, dbName:default, owner:jsichi, createTime:1275701453, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:int, comment:null), FieldSchema(name:value, type:string, comment:null)], location:file:/Users/jsichi/open/hive-trunk/build/hbase-handler/test/data/warehouse/hbase_table_1, inputFormat:org.apache.hadoop.hive.hbase.HiveHBaseTableInputFormat, outputFormat:org.apache.hadoop.hive.hbase.HiveHBaseTableOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.hbase.HBaseSerDe, parameters:{serialization.format=1,hbase.columns.mapping=cf:string}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{hbase.table.name=hbase_table_0,transient_lastDdlTime=1275701453,storage_handler=org.apache.hadoop.hive.hbase.HBaseStorageHandler}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
+Detailed Table Information Table(tableName:hbase_table_1, dbName:default, owner:jsichi, createTime:1282173927, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:int, comment:null), FieldSchema(name:value, type:string, comment:null)], location:pfile:/data/users/jsichi/open/hive-trunk/build/hbase-handler/test/data/warehouse/hbase_table_1, inputFormat:org.apache.hadoop.hive.hbase.HiveHBaseTableInputFormat, outputFormat:org.apache.hadoop.hive.hbase.HiveHBaseTableOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.hbase.HBaseSerDe, parameters:{serialization.format=1, hbase.columns.mapping=cf:string}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{hbase.table.name=hbase_table_0, transient_lastDdlTime=1282173927, storage_handler=org.apache.hadoop.hive.hbase.HBaseStorageHandler}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: select * from hbase_table_1
PREHOOK: type: QUERY
PREHOOK: Input: default@hbase_table_1
-PREHOOK: Output: file:/Users/jsichi/open/hive-trunk/build/hbase-handler/scratchdir/hive_2010-06-04_18-30-53_641_2055476877709930223/10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-18_16-25-27_525_1549744759045649155/-mr-10000
POSTHOOK: query: select * from hbase_table_1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@hbase_table_1
-POSTHOOK: Output: file:/Users/jsichi/open/hive-trunk/build/hbase-handler/scratchdir/hive_2010-06-04_18-30-53_641_2055476877709930223/10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-18_16-25-27_525_1549744759045649155/-mr-10000
PREHOOK: query: EXPLAIN FROM src INSERT OVERWRITE TABLE hbase_table_1 SELECT * WHERE (key%2)=0
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN FROM src INSERT OVERWRITE TABLE hbase_table_1 SELECT * WHERE (key%2)=0
@@ -198,7 +198,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/Users/jsichi/open/hive-trunk/build/hbase-handler/scratchdir/hive_2010-06-04_18-30-58_979_3715749119451606580/10002
+ file:/tmp/jsichi/hive_2010-08-18_16-25-31_035_4609595925459515104/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -237,7 +237,7 @@ ORDER BY key, value LIMIT 20
PREHOOK: type: QUERY
PREHOOK: Input: default@hbase_table_1
PREHOOK: Input: default@src
-PREHOOK: Output: file:/Users/jsichi/open/hive-trunk/build/hbase-handler/scratchdir/hive_2010-06-04_18-30-59_568_2312221566109156178/10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-18_16-25-31_205_3758488585778891870/-mr-10000
POSTHOOK: query: SELECT Y.*
FROM
(SELECT hbase_table_1.* FROM hbase_table_1) x
@@ -248,7 +248,7 @@ ORDER BY key, value LIMIT 20
POSTHOOK: type: QUERY
POSTHOOK: Input: default@hbase_table_1
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/Users/jsichi/open/hive-trunk/build/hbase-handler/scratchdir/hive_2010-06-04_18-30-59_568_2312221566109156178/10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-18_16-25-31_205_3758488585778891870/-mr-10000
0 val_0
0 val_0
0 val_0
@@ -382,7 +382,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/Users/jsichi/open/hive-trunk/build/hbase-handler/scratchdir/hive_2010-06-04_18-31-09_126_1520524795989354098/10002
+ file:/tmp/jsichi/hive_2010-08-18_16-25-39_199_9206397980280656193/-mr-10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -420,7 +420,7 @@ ORDER BY key,value
PREHOOK: type: QUERY
PREHOOK: Input: default@hbase_table_2
PREHOOK: Input: default@hbase_table_1
-PREHOOK: Output: file:/Users/jsichi/open/hive-trunk/build/hbase-handler/scratchdir/hive_2010-06-04_18-31-09_724_1064526582883750401/10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-18_16-25-39_390_6285199586703567793/-mr-10000
POSTHOOK: query: SELECT Y.*
FROM
(SELECT hbase_table_1.* FROM hbase_table_1 WHERE hbase_table_1.key > 100) x
@@ -431,7 +431,7 @@ ORDER BY key,value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@hbase_table_2
POSTHOOK: Input: default@hbase_table_1
-POSTHOOK: Output: file:/Users/jsichi/open/hive-trunk/build/hbase-handler/scratchdir/hive_2010-06-04_18-31-09_724_1064526582883750401/10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-18_16-25-39_390_6285199586703567793/-mr-10000
104 val_104
114 val_114
116 val_116
@@ -462,48 +462,48 @@ PREHOOK: query: select * from (select co
PREHOOK: type: QUERY
PREHOOK: Input: default@empty_hbase_table
PREHOOK: Input: default@empty_normal_table
-PREHOOK: Output: file:/Users/jsichi/open/hive-trunk/build/hbase-handler/scratchdir/hive_2010-06-04_18-31-22_759_8050475277590845570/10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-18_16-25-50_518_3658678318133495310/-mr-10000
POSTHOOK: query: select * from (select count(1) as c from empty_normal_table union all select count(1) as c from empty_hbase_table) x order by c
POSTHOOK: type: QUERY
POSTHOOK: Input: default@empty_hbase_table
POSTHOOK: Input: default@empty_normal_table
-POSTHOOK: Output: file:/Users/jsichi/open/hive-trunk/build/hbase-handler/scratchdir/hive_2010-06-04_18-31-22_759_8050475277590845570/10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-18_16-25-50_518_3658678318133495310/-mr-10000
0
0
PREHOOK: query: select * from (select count(1) c from empty_normal_table union all select count(1) as c from hbase_table_1) x order by c
PREHOOK: type: QUERY
PREHOOK: Input: default@empty_normal_table
PREHOOK: Input: default@hbase_table_1
-PREHOOK: Output: file:/Users/jsichi/open/hive-trunk/build/hbase-handler/scratchdir/hive_2010-06-04_18-31-35_831_2260230480112269198/10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-18_16-26-17_084_9167375564007367329/-mr-10000
POSTHOOK: query: select * from (select count(1) c from empty_normal_table union all select count(1) as c from hbase_table_1) x order by c
POSTHOOK: type: QUERY
POSTHOOK: Input: default@empty_normal_table
POSTHOOK: Input: default@hbase_table_1
-POSTHOOK: Output: file:/Users/jsichi/open/hive-trunk/build/hbase-handler/scratchdir/hive_2010-06-04_18-31-35_831_2260230480112269198/10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-18_16-26-17_084_9167375564007367329/-mr-10000
0
155
PREHOOK: query: select * from (select count(1) c from src union all select count(1) as c from empty_hbase_table) x order by c
PREHOOK: type: QUERY
PREHOOK: Input: default@empty_hbase_table
PREHOOK: Input: default@src
-PREHOOK: Output: file:/Users/jsichi/open/hive-trunk/build/hbase-handler/scratchdir/hive_2010-06-04_18-31-49_528_2637853571948769392/10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-18_16-26-26_377_966123060596040797/-mr-10000
POSTHOOK: query: select * from (select count(1) c from src union all select count(1) as c from empty_hbase_table) x order by c
POSTHOOK: type: QUERY
POSTHOOK: Input: default@empty_hbase_table
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/Users/jsichi/open/hive-trunk/build/hbase-handler/scratchdir/hive_2010-06-04_18-31-49_528_2637853571948769392/10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-18_16-26-26_377_966123060596040797/-mr-10000
0
500
PREHOOK: query: select * from (select count(1) c from src union all select count(1) as c from hbase_table_1) x order by c
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Input: default@hbase_table_1
-PREHOOK: Output: file:/Users/jsichi/open/hive-trunk/build/hbase-handler/scratchdir/hive_2010-06-04_18-32-04_353_4852346326893233759/10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-18_16-26-35_671_2780181685990528166/-mr-10000
POSTHOOK: query: select * from (select count(1) c from src union all select count(1) as c from hbase_table_1) x order by c
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Input: default@hbase_table_1
-POSTHOOK: Output: file:/Users/jsichi/open/hive-trunk/build/hbase-handler/scratchdir/hive_2010-06-04_18-32-04_353_4852346326893233759/10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-18_16-26-35_671_2780181685990528166/-mr-10000
155
500
PREHOOK: query: CREATE TABLE hbase_table_3(key int, value string, count int)
@@ -703,20 +703,20 @@ POSTHOOK: Output: default@hbase_table_3
PREHOOK: query: select count(1) from hbase_table_3
PREHOOK: type: QUERY
PREHOOK: Input: default@hbase_table_3
-PREHOOK: Output: file:/Users/jsichi/open/hive-trunk/build/hbase-handler/scratchdir/hive_2010-06-04_18-32-31_358_2608877383903639679/10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-18_16-26-55_167_90595836337066043/-mr-10000
POSTHOOK: query: select count(1) from hbase_table_3
POSTHOOK: type: QUERY
POSTHOOK: Input: default@hbase_table_3
-POSTHOOK: Output: file:/Users/jsichi/open/hive-trunk/build/hbase-handler/scratchdir/hive_2010-06-04_18-32-31_358_2608877383903639679/10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-18_16-26-55_167_90595836337066043/-mr-10000
155
PREHOOK: query: select * from hbase_table_3 order by key, value limit 5
PREHOOK: type: QUERY
PREHOOK: Input: default@hbase_table_3
-PREHOOK: Output: file:/Users/jsichi/open/hive-trunk/build/hbase-handler/scratchdir/hive_2010-06-04_18-32-37_318_9069569910503378173/10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-18_16-26-58_706_203500985498924230/-mr-10000
POSTHOOK: query: select * from hbase_table_3 order by key, value limit 5
POSTHOOK: type: QUERY
POSTHOOK: Input: default@hbase_table_3
-POSTHOOK: Output: file:/Users/jsichi/open/hive-trunk/build/hbase-handler/scratchdir/hive_2010-06-04_18-32-37_318_9069569910503378173/10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-18_16-26-58_706_203500985498924230/-mr-10000
0 val_0 3
2 val_2 1
4 val_4 1
@@ -725,11 +725,11 @@ POSTHOOK: Output: file:/Users/jsichi/ope
PREHOOK: query: select key, count from hbase_table_3 order by key, count desc limit 5
PREHOOK: type: QUERY
PREHOOK: Input: default@hbase_table_3
-PREHOOK: Output: file:/Users/jsichi/open/hive-trunk/build/hbase-handler/scratchdir/hive_2010-06-04_18-32-42_797_4415526076675408910/10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-18_16-27-02_230_8846971062758664211/-mr-10000
POSTHOOK: query: select key, count from hbase_table_3 order by key, count desc limit 5
POSTHOOK: type: QUERY
POSTHOOK: Input: default@hbase_table_3
-POSTHOOK: Output: file:/Users/jsichi/open/hive-trunk/build/hbase-handler/scratchdir/hive_2010-06-04_18-32-42_797_4415526076675408910/10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-18_16-27-02_230_8846971062758664211/-mr-10000
0 3
2 1
4 1
@@ -765,11 +765,11 @@ POSTHOOK: Output: default@hbase_table_4
PREHOOK: query: SELECT * FROM hbase_table_4 ORDER BY key
PREHOOK: type: QUERY
PREHOOK: Input: default@hbase_table_4
-PREHOOK: Output: file:/Users/jsichi/open/hive-trunk/build/hbase-handler/scratchdir/hive_2010-06-04_18-32-54_472_3690760905908161841/10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-18_16-27-10_988_7755611253183514631/-mr-10000
POSTHOOK: query: SELECT * FROM hbase_table_4 ORDER BY key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@hbase_table_4
-POSTHOOK: Output: file:/Users/jsichi/open/hive-trunk/build/hbase-handler/scratchdir/hive_2010-06-04_18-32-54_472_3690760905908161841/10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-18_16-27-10_988_7755611253183514631/-mr-10000
98 val_98 99 100
100 val_100 101 102
PREHOOK: query: DROP TABLE hbase_table_5
@@ -790,11 +790,11 @@ POSTHOOK: Output: default@hbase_table_5
PREHOOK: query: SELECT * FROM hbase_table_5 ORDER BY key
PREHOOK: type: QUERY
PREHOOK: Input: default@hbase_table_5
-PREHOOK: Output: file:/Users/jsichi/open/hive-trunk/build/hbase-handler/scratchdir/hive_2010-06-04_18-32-59_042_9212792964735101793/10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-18_16-27-14_698_7762836144438891670/-mr-10000
POSTHOOK: query: SELECT * FROM hbase_table_5 ORDER BY key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@hbase_table_5
-POSTHOOK: Output: file:/Users/jsichi/open/hive-trunk/build/hbase-handler/scratchdir/hive_2010-06-04_18-32-59_042_9212792964735101793/10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-18_16-27-14_698_7762836144438891670/-mr-10000
98 {"b":"val_98","c":"99"}
100 {"b":"val_100","c":"101"}
PREHOOK: query: DROP TABLE hbase_table_6
@@ -827,11 +827,11 @@ POSTHOOK: Output: default@hbase_table_6
PREHOOK: query: SELECT * FROM hbase_table_6 ORDER BY key
PREHOOK: type: QUERY
PREHOOK: Input: default@hbase_table_6
-PREHOOK: Output: file:/Users/jsichi/open/hive-trunk/build/hbase-handler/scratchdir/hive_2010-06-04_18-33-11_147_8600250585578678749/10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-18_16-27-23_588_6722865455199798152/-mr-10000
POSTHOOK: query: SELECT * FROM hbase_table_6 ORDER BY key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@hbase_table_6
-POSTHOOK: Output: file:/Users/jsichi/open/hive-trunk/build/hbase-handler/scratchdir/hive_2010-06-04_18-33-11_147_8600250585578678749/10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-18_16-27-23_588_6722865455199798152/-mr-10000
98 {"val_98":"98"}
100 {"val_100":"100"}
PREHOOK: query: DROP TABLE hbase_table_7
@@ -866,11 +866,11 @@ POSTHOOK: Output: default@hbase_table_7
PREHOOK: query: SELECT * FROM hbase_table_7 ORDER BY key
PREHOOK: type: QUERY
PREHOOK: Input: default@hbase_table_7
-PREHOOK: Output: file:/Users/jsichi/open/hive-trunk/build/hbase-handler/scratchdir/hive_2010-06-04_18-33-21_772_1338432731952755766/10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-18_16-27-32_378_331084097550140091/-mr-10000
POSTHOOK: query: SELECT * FROM hbase_table_7 ORDER BY key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@hbase_table_7
-POSTHOOK: Output: file:/Users/jsichi/open/hive-trunk/build/hbase-handler/scratchdir/hive_2010-06-04_18-33-21_772_1338432731952755766/10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-18_16-27-32_378_331084097550140091/-mr-10000
{"VAL_98":"99.0","val_98":"98"} 98
{"VAL_100":"101.0","val_100":"100"} 100
PREHOOK: query: DROP TABLE hbase_table_8
@@ -903,60 +903,90 @@ POSTHOOK: Output: default@hbase_table_8
PREHOOK: query: SELECT * FROM hbase_table_8 ORDER BY key
PREHOOK: type: QUERY
PREHOOK: Input: default@hbase_table_8
-PREHOOK: Output: file:/Users/jsichi/open/hive-trunk/build/hbase-handler/scratchdir/hive_2010-06-04_18-33-33_336_3377730421928251638/10000
+PREHOOK: Output: file:/tmp/jsichi/hive_2010-08-18_16-27-41_278_4692141557051029281/-mr-10000
POSTHOOK: query: SELECT * FROM hbase_table_8 ORDER BY key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@hbase_table_8
-POSTHOOK: Output: file:/Users/jsichi/open/hive-trunk/build/hbase-handler/scratchdir/hive_2010-06-04_18-33-33_336_3377730421928251638/10000
+POSTHOOK: Output: file:/tmp/jsichi/hive_2010-08-18_16-27-41_278_4692141557051029281/-mr-10000
98 val_98 99 100
100 val_100 101 102
PREHOOK: query: DROP TABLE hbase_table_1
PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@hbase_table_1
+PREHOOK: Output: default@hbase_table_1
POSTHOOK: query: DROP TABLE hbase_table_1
POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@hbase_table_1
POSTHOOK: Output: default@hbase_table_1
PREHOOK: query: DROP TABLE hbase_table_2
PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@hbase_table_2
+PREHOOK: Output: default@hbase_table_2
POSTHOOK: query: DROP TABLE hbase_table_2
POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@hbase_table_2
POSTHOOK: Output: default@hbase_table_2
PREHOOK: query: DROP TABLE hbase_table_3
PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@hbase_table_3
+PREHOOK: Output: default@hbase_table_3
POSTHOOK: query: DROP TABLE hbase_table_3
POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@hbase_table_3
POSTHOOK: Output: default@hbase_table_3
PREHOOK: query: DROP TABLE hbase_table_4
PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@hbase_table_4
+PREHOOK: Output: default@hbase_table_4
POSTHOOK: query: DROP TABLE hbase_table_4
POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@hbase_table_4
POSTHOOK: Output: default@hbase_table_4
PREHOOK: query: DROP TABLE hbase_table_5
PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@hbase_table_5
+PREHOOK: Output: default@hbase_table_5
POSTHOOK: query: DROP TABLE hbase_table_5
POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@hbase_table_5
POSTHOOK: Output: default@hbase_table_5
PREHOOK: query: DROP TABLE hbase_table_6
PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@hbase_table_6
+PREHOOK: Output: default@hbase_table_6
POSTHOOK: query: DROP TABLE hbase_table_6
POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@hbase_table_6
POSTHOOK: Output: default@hbase_table_6
PREHOOK: query: DROP TABLE hbase_table_7
PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@hbase_table_7
+PREHOOK: Output: default@hbase_table_7
POSTHOOK: query: DROP TABLE hbase_table_7
POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@hbase_table_7
POSTHOOK: Output: default@hbase_table_7
PREHOOK: query: DROP TABLE hbase_table_8
PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@hbase_table_8
+PREHOOK: Output: default@hbase_table_8
POSTHOOK: query: DROP TABLE hbase_table_8
POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@hbase_table_8
POSTHOOK: Output: default@hbase_table_8
PREHOOK: query: DROP TABLE empty_hbase_table
PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@empty_hbase_table
+PREHOOK: Output: default@empty_hbase_table
POSTHOOK: query: DROP TABLE empty_hbase_table
POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@empty_hbase_table
POSTHOOK: Output: default@empty_hbase_table
PREHOOK: query: DROP TABLE empty_normal_table
PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@empty_normal_table
+PREHOOK: Output: default@empty_normal_table
POSTHOOK: query: DROP TABLE empty_normal_table
POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@empty_normal_table
POSTHOOK: Output: default@empty_normal_table