Index: ql/src/test/results/clientpositive/sample_islocalmode_hook.q.out =================================================================== --- ql/src/test/results/clientpositive/sample_islocalmode_hook.q.out (revision 1156861) +++ ql/src/test/results/clientpositive/sample_islocalmode_hook.q.out (working copy) @@ -53,12 +53,12 @@ POSTHOOK: Lineage: sih_i_part PARTITION(p=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: sih_i_part PARTITION(p=3).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: sih_i_part PARTITION(p=3).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -PREHOOK: query: create table sih_src as select key, value from sih_i_part +PREHOOK: query: create table sih_src as select key, value from sih_i_part order by key, value PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@sih_i_part@p=1 PREHOOK: Input: default@sih_i_part@p=2 PREHOOK: Input: default@sih_i_part@p=3 -POSTHOOK: query: create table sih_src as select key, value from sih_i_part +POSTHOOK: query: create table sih_src as select key, value from sih_i_part order by key, value POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@sih_i_part@p=1 POSTHOOK: Input: default@sih_i_part@p=2 @@ -70,10 +70,10 @@ POSTHOOK: Lineage: sih_i_part PARTITION(p=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: sih_i_part PARTITION(p=3).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: sih_i_part PARTITION(p=3).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -PREHOOK: query: create table sih_src2 as select key, value from sih_src +PREHOOK: query: create table sih_src2 as select key, value from sih_src order by key, value PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@sih_src -POSTHOOK: query: create table sih_src2 as select key, value from sih_src +POSTHOOK: query: create table sih_src2 as select key, value from sih_src order by key, value POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@sih_src POSTHOOK: Output: default@sih_src2 @@ -87,21 +87,21 @@ select count(1) from sih_src tablesample(1 percent) PREHOOK: type: QUERY PREHOOK: Input: default@sih_src -PREHOOK: Output: file:/data/users/kevinwilfong/trunk/VENDOR.hive/trunk/build/ql/scratchdir/hive_2011-07-22_10-31-00_619_5856650519690274700/-mr-10000 -500 +PREHOOK: Output: file:/data/users/kevinwilfong/apache-hive/build/ql/scratchdir/hive_2011-08-11_17-10-00_693_3227548457798321805/-mr-10000 +1500 PREHOOK: query: -- sample two tables select count(1) from sih_src tablesample(1 percent)a join sih_src2 tablesample(1 percent)b on a.key = b.key PREHOOK: type: QUERY PREHOOK: Input: default@sih_src PREHOOK: Input: default@sih_src2 -PREHOOK: Output: file:/data/users/kevinwilfong/trunk/VENDOR.hive/trunk/build/ql/scratchdir/hive_2011-07-22_10-31-04_069_8883954538684297085/-mr-10000 -0 +PREHOOK: Output: file:/data/users/kevinwilfong/apache-hive/build/ql/scratchdir/hive_2011-08-11_17-10-04_098_4179330255877825485/-mr-10000 +3084 PREHOOK: query: -- sample split, running locally limited by max bytes select count(1) from sih_src tablesample(1 percent) PREHOOK: type: QUERY PREHOOK: Input: default@sih_src -PREHOOK: Output: file:/data/users/kevinwilfong/trunk/VENDOR.hive/trunk/build/ql/scratchdir/hive_2011-07-22_10-31-10_389_1530285320067549321/-mr-10000 -500 +PREHOOK: Output: file:/data/users/kevinwilfong/apache-hive/build/ql/scratchdir/hive_2011-08-11_17-10-10_321_4607906318677973124/-mr-10000 +1500 PREHOOK: query: drop table sih_i_part PREHOOK: type: DROPTABLE PREHOOK: Input: default@sih_i_part Index: ql/src/test/queries/clientpositive/sample_islocalmode_hook.q =================================================================== --- ql/src/test/queries/clientpositive/sample_islocalmode_hook.q (revision 1156861) +++ ql/src/test/queries/clientpositive/sample_islocalmode_hook.q (working copy) @@ -15,8 +15,8 @@ insert overwrite table sih_i_part partition (p='1') select key, value from src; insert overwrite table sih_i_part partition (p='2') select key+10000, value from src; insert overwrite table sih_i_part partition (p='3') select key+20000, value from src; -create table sih_src as select key, value from sih_i_part; -create table sih_src2 as select key, value from sih_src; +create table sih_src as select key, value from sih_i_part order by key, value; +create table sih_src2 as select key, value from sih_src order by key, value; set hive.exec.post.hooks = org.apache.hadoop.hive.ql.hooks.VerifyIsLocalModeHook ; set mapred.job.tracker=does.notexist.com:666;