hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From c..@apache.org
Subject svn commit: r1236489 [2/7] - in /hive/trunk/ql/src/test: queries/clientpositive/ results/clientpositive/
Date Fri, 27 Jan 2012 01:41:37 GMT
Modified: hive/trunk/ql/src/test/queries/clientpositive/merge3.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/merge3.q?rev=1236489&r1=1236488&r2=1236489&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/merge3.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/merge3.q Fri Jan 27 01:41:35 2012
@@ -20,7 +20,7 @@ select key, value from merge_src;
 create table merge_src2 as 
 select key, value from merge_src;
 
-select * from merge_src2;
+select * from merge_src2 ORDER BY key ASC, value ASC;
 describe formatted merge_src2;
 
 create table merge_src_part2 like merge_src_part;
@@ -37,7 +37,7 @@ where ds is not null;
 
 show partitions merge_src_part2;
 
-select * from merge_src_part2 where ds is not null;
+select * from merge_src_part2 where ds is not null ORDER BY key ASC, value ASC;
 
 drop table merge_src_part2;
 
@@ -54,4 +54,4 @@ select key, value, ds;
 
 show partitions merge_src_part2;
 
-select * from merge_src_part2 where ds is not null;
+select * from merge_src_part2 where ds is not null ORDER BY key ASC, value ASC;

Modified: hive/trunk/ql/src/test/queries/clientpositive/rcfile_columnar.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/rcfile_columnar.q?rev=1236489&r1=1236488&r2=1236489&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/rcfile_columnar.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/rcfile_columnar.q Fri Jan 27 01:41:35 2012
@@ -10,6 +10,6 @@ FROM src
 INSERT OVERWRITE TABLE columnTable SELECT src.key, src.value LIMIT 10;
 describe columnTable;
 
-SELECT columnTable.* FROM columnTable;
+SELECT columnTable.* FROM columnTable ORDER BY key ASC, value ASC;
 
 

Modified: hive/trunk/ql/src/test/queries/clientpositive/rcfile_lazydecompress.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/rcfile_lazydecompress.q?rev=1236489&r1=1236488&r2=1236489&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/rcfile_lazydecompress.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/rcfile_lazydecompress.q Fri Jan 27 01:41:35 2012
@@ -4,11 +4,11 @@ CREATE table rcfileTableLazyDecompress (
 FROM src
 INSERT OVERWRITE TABLE rcfileTableLazyDecompress SELECT src.key, src.value LIMIT 10;
 
-SELECT key, value FROM rcfileTableLazyDecompress where key > 238;
+SELECT key, value FROM rcfileTableLazyDecompress where key > 238 ORDER BY key ASC, value ASC;
 
-SELECT key, value FROM rcfileTableLazyDecompress where key > 238 and key < 400;
+SELECT key, value FROM rcfileTableLazyDecompress where key > 238 and key < 400 ORDER BY key ASC, value ASC;
 
-SELECT key, count(1) FROM rcfileTableLazyDecompress where key > 238 group by key;
+SELECT key, count(1) FROM rcfileTableLazyDecompress where key > 238 group by key ORDER BY key ASC;
 
 set mapred.output.compress=true;
 set hive.exec.compress.output=true;
@@ -16,11 +16,11 @@ set hive.exec.compress.output=true;
 FROM src
 INSERT OVERWRITE TABLE rcfileTableLazyDecompress SELECT src.key, src.value LIMIT 10;
 
-SELECT key, value FROM rcfileTableLazyDecompress where key > 238;
+SELECT key, value FROM rcfileTableLazyDecompress where key > 238 ORDER BY key ASC, value ASC;
 
-SELECT key, value FROM rcfileTableLazyDecompress where key > 238 and key < 400;
+SELECT key, value FROM rcfileTableLazyDecompress where key > 238 and key < 400 ORDER BY key ASC, value ASC;
 
-SELECT key, count(1) FROM rcfileTableLazyDecompress where key > 238 group by key;
+SELECT key, count(1) FROM rcfileTableLazyDecompress where key > 238 group by key ORDER BY key ASC;
 
 set mapred.output.compress=false;
 set hive.exec.compress.output=false;

Modified: hive/trunk/ql/src/test/queries/clientpositive/rcfile_union.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/rcfile_union.q?rev=1236489&r1=1236488&r2=1236489&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/rcfile_union.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/rcfile_union.q Fri Jan 27 01:41:35 2012
@@ -10,5 +10,5 @@ INSERT OVERWRITE TABLE rcfile_unionTable
 SELECT * FROM (
 SELECT b AS cola FROM rcfile_unionTable
 UNION ALL
-SELECT c AS cola FROM rcfile_unionTable) s;
+SELECT c AS cola FROM rcfile_unionTable) s ORDER BY cola ASC;
 

Modified: hive/trunk/ql/src/test/queries/clientpositive/sample10.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/sample10.q?rev=1236489&r1=1236488&r2=1236489&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/sample10.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/sample10.q Fri Jan 27 01:41:35 2012
@@ -14,12 +14,12 @@ create table srcpartbucket (key string, 
 insert overwrite table srcpartbucket partition(ds, hr) select * from srcpart where ds is not null and key < 10;
 
 explain extended
-select ds, count(1) from srcpartbucket tablesample (bucket 1 out of 4 on key) where ds is not null group by ds;
+select ds, count(1) from srcpartbucket tablesample (bucket 1 out of 4 on key) where ds is not null group by ds ORDER BY ds ASC;
 
-select ds, count(1) from srcpartbucket tablesample (bucket 1 out of 4 on key) where ds is not null group by ds;
+select ds, count(1) from srcpartbucket tablesample (bucket 1 out of 4 on key) where ds is not null group by ds ORDER BY ds ASC;
 
-select ds, count(1) from srcpartbucket tablesample (bucket 1 out of 2 on key) where ds is not null group by ds;
+select ds, count(1) from srcpartbucket tablesample (bucket 1 out of 2 on key) where ds is not null group by ds ORDER BY ds ASC;
 
-select * from srcpartbucket where ds is not null;
+select * from srcpartbucket where ds is not null ORDER BY key ASC, value ASC, ds ASC, hr ASC;
 
 

Modified: hive/trunk/ql/src/test/queries/clientpositive/udf_sentences.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udf_sentences.q?rev=1236489&r1=1236488&r2=1236489&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udf_sentences.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udf_sentences.q Fri Jan 27 01:41:35 2012
@@ -4,7 +4,7 @@ INSERT OVERWRITE TABLE sent_tmp
 SELECT explode(sentences(unhex("486976652065737420756E20657863656C6C656E74206F7574696C20706F7572206C65732072657175C3AA74657320646520646F6E6EC3A965732C20657420706575742DC3AA74726520706C757320706F6C7976616C656E7420717565206C612074726164756374696F6E206175746F6D61746971756521206C6120706F6E6374756174696F6E206D756C7469706C65732C206465732070687261736573206D616C20666F726DC3A96573202E2E2E20636F6E667573696F6E202D20657420706F757274616E742063652055444620666F6E6374696F6E6E6520656E636F72652121"), "fr")) AS val FROM src LIMIT 3;
 INSERT OVERWRITE TABLE sent_tmp2
 SELECT explode(val) AS val FROM sent_tmp;
-SELECT hex(val) FROM sent_tmp2;
+SELECT hex(val) AS value FROM sent_tmp2 ORDER BY value ASC;
 
 DROP TABLE sent_tmp;
 DROP TABLE sent_tmp2;
@@ -15,8 +15,8 @@ INSERT OVERWRITE TABLE sent_tmp
 SELECT explode(sentences(unhex("48697665206973742065696E2061757367657A656963686E65746573205765726B7A6575672066C3BC7220646965204162667261676520766F6E20446174656E2C20756E64207669656C6C6569636874207669656C736569746967657220616C7320646965206D61736368696E656C6C6520C39C6265727365747A756E6721204D756C7469706C652C207363686C6563687420676562696C646574656E2053C3A4747A65202E2E2E205665727765636873656C756E6720496E74657270756E6B74696F6E202D20756E6420646F636820697374206469657365205544462066756E6B74696F6E6965727420696D6D6572206E6F63682121"), "de")) AS val FROM src LIMIT 3;
 INSERT OVERWRITE TABLE sent_tmp2
 SELECT explode(val) AS val FROM sent_tmp;
-SELECT hex(val) FROM sent_tmp2;
+SELECT hex(val) AS value FROM sent_tmp2 ORDER BY value ASC;
 
 
 
-SELECT sentences("Hive is an excellent tool for data querying\; and perhaps more versatile than machine translation!! Multiple, ill-formed sentences...confounding punctuation--and yet this UDF still works!!!!") FROM src LIMIT 1;
+SELECT sentences("Hive is an excellent tool for data querying\; and perhaps more versatile than machine translation!! Multiple, ill-formed sentences...confounding punctuation--and yet this UDF still works!!!!") AS value FROM src ORDER BY value ASC LIMIT 1;

Modified: hive/trunk/ql/src/test/queries/clientpositive/union24.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/union24.q?rev=1236489&r1=1236488&r2=1236489&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/union24.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/union24.q Fri Jan 27 01:41:35 2012
@@ -18,7 +18,7 @@ select s.key, s.count from (
   union all
   select key, count(1) as count from src5 where key < 10 group by key
 )s
-order by s.key;
+order by s.key ASC, s.count ASC;
 
 select s.key, s.count from (
   select key, count from src2  where key < 10
@@ -29,7 +29,7 @@ select s.key, s.count from (
   union all
   select key, count(1) as count from src5 where key < 10 group by key
 )s
-order by s.key;
+order by s.key ASC, s.count ASC;
 
 explain extended
 select s.key, s.count from (
@@ -39,7 +39,7 @@ select s.key, s.count from (
   union all
   select a.key as key, b.count as count from src4 a join src5 b on a.key=b.key where a.key < 10
 )s
-order by s.key;
+order by s.key ASC, s.count ASC;
 
 select s.key, s.count from (
   select key, count from src2  where key < 10
@@ -48,7 +48,7 @@ select s.key, s.count from (
   union all
   select a.key as key, b.count as count from src4 a join src5 b on a.key=b.key where a.key < 10
 )s
-order by s.key;
+order by s.key ASC, s.count ASC;
 
 explain extended
 select s.key, s.count from (
@@ -58,7 +58,7 @@ select s.key, s.count from (
   union all
   select a.key as key, count(1) as count from src4 a join src5 b on a.key=b.key where a.key < 10 group by a.key
 )s
-order by s.key;
+order by s.key ASC, s.count ASC;
 
 select s.key, s.count from (
   select key, count from src2  where key < 10
@@ -67,4 +67,4 @@ select s.key, s.count from (
   union all
   select a.key as key, count(1) as count from src4 a join src5 b on a.key=b.key where a.key < 10 group by a.key
 )s
-order by s.key;
+order by s.key ASC, s.count ASC;

Modified: hive/trunk/ql/src/test/results/clientpositive/columnarserde_create_shortcut.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/columnarserde_create_shortcut.q.out?rev=1236489&r1=1236488&r2=1236489&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/columnarserde_create_shortcut.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/columnarserde_create_shortcut.q.out Fri Jan 27 01:41:35 2012
@@ -96,11 +96,11 @@ POSTHOOK: Lineage: columnarserde_create_
 POSTHOOK: Lineage: columnarserde_create_shortcut.c SIMPLE [(src_thrift)src_thrift.FieldSchema(name:mstringstring, type:map<string,string>, comment:from deserializer), ]
 POSTHOOK: Lineage: columnarserde_create_shortcut.d SIMPLE [(src_thrift)src_thrift.FieldSchema(name:aint, type:int, comment:from deserializer), ]
 POSTHOOK: Lineage: columnarserde_create_shortcut.e SIMPLE [(src_thrift)src_thrift.FieldSchema(name:astring, type:string, comment:from deserializer), ]
-PREHOOK: query: SELECT columnarserde_create_shortcut.* FROM columnarserde_create_shortcut DISTRIBUTE BY 1
+PREHOOK: query: SELECT columnarserde_create_shortcut.* FROM columnarserde_create_shortcut CLUSTER BY 1
 PREHOOK: type: QUERY
 PREHOOK: Input: default@columnarserde_create_shortcut
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT columnarserde_create_shortcut.* FROM columnarserde_create_shortcut DISTRIBUTE BY 1
+POSTHOOK: query: SELECT columnarserde_create_shortcut.* FROM columnarserde_create_shortcut CLUSTER BY 1
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@columnarserde_create_shortcut
 #### A masked pattern was here ####
@@ -120,11 +120,11 @@ POSTHOOK: Lineage: columnarserde_create_
 [8,16,24]	["80","800","8000"]	{"key_8":"value_8"}	1638581578	record_8
 [9,18,27]	["90","900","9000"]	{"key_9":"value_9"}	336964413	record_9
 null	null	null	0	NULL
-PREHOOK: query: SELECT columnarserde_create_shortcut.a[0], columnarserde_create_shortcut.b[0], columnarserde_create_shortcut.c['key2'], columnarserde_create_shortcut.d, columnarserde_create_shortcut.e FROM columnarserde_create_shortcut DISTRIBUTE BY 1
+PREHOOK: query: SELECT columnarserde_create_shortcut.a[0], columnarserde_create_shortcut.b[0], columnarserde_create_shortcut.c['key2'], columnarserde_create_shortcut.d, columnarserde_create_shortcut.e FROM columnarserde_create_shortcut CLUSTER BY 1
 PREHOOK: type: QUERY
 PREHOOK: Input: default@columnarserde_create_shortcut
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT columnarserde_create_shortcut.a[0], columnarserde_create_shortcut.b[0], columnarserde_create_shortcut.c['key2'], columnarserde_create_shortcut.d, columnarserde_create_shortcut.e FROM columnarserde_create_shortcut DISTRIBUTE BY 1
+POSTHOOK: query: SELECT columnarserde_create_shortcut.a[0], columnarserde_create_shortcut.b[0], columnarserde_create_shortcut.c['key2'], columnarserde_create_shortcut.d, columnarserde_create_shortcut.e FROM columnarserde_create_shortcut CLUSTER BY 1
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@columnarserde_create_shortcut
 #### A masked pattern was here ####
@@ -184,11 +184,11 @@ POSTHOOK: Lineage: columnshortcuttable.k
 POSTHOOK: Lineage: columnshortcuttable.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 key	string	
 value	string	
-PREHOOK: query: SELECT columnShortcutTable.* FROM columnShortcutTable
+PREHOOK: query: SELECT columnShortcutTable.* FROM columnShortcutTable ORDER BY key ASC, value ASC
 PREHOOK: type: QUERY
 PREHOOK: Input: default@columnshortcuttable
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT columnShortcutTable.* FROM columnShortcutTable
+POSTHOOK: query: SELECT columnShortcutTable.* FROM columnShortcutTable ORDER BY key ASC, value ASC
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@columnshortcuttable
 #### A masked pattern was here ####
@@ -199,16 +199,16 @@ POSTHOOK: Lineage: columnarserde_create_
 POSTHOOK: Lineage: columnarserde_create_shortcut.e SIMPLE [(src_thrift)src_thrift.FieldSchema(name:astring, type:string, comment:from deserializer), ]
 POSTHOOK: Lineage: columnshortcuttable.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: columnshortcuttable.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-238	val_238
-86	val_86
-311	val_311
-27	val_27
 165	val_165
-409	val_409
+238	val_238
 255	val_255
+27	val_27
 278	val_278
-98	val_98
+311	val_311
+409	val_409
 484	val_484
+86	val_86
+98	val_98
 PREHOOK: query: ALTER TABLE columnShortcutTable ADD COLUMNS (c string)
 PREHOOK: type: ALTERTABLE_ADDCOLS
 PREHOOK: Input: default@columnshortcuttable
@@ -224,11 +224,11 @@ POSTHOOK: Lineage: columnarserde_create_
 POSTHOOK: Lineage: columnarserde_create_shortcut.e SIMPLE [(src_thrift)src_thrift.FieldSchema(name:astring, type:string, comment:from deserializer), ]
 POSTHOOK: Lineage: columnshortcuttable.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: columnshortcuttable.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: SELECT columnShortcutTable.* FROM columnShortcutTable
+PREHOOK: query: SELECT columnShortcutTable.* FROM columnShortcutTable ORDER BY key ASC, value ASC
 PREHOOK: type: QUERY
 PREHOOK: Input: default@columnshortcuttable
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT columnShortcutTable.* FROM columnShortcutTable
+POSTHOOK: query: SELECT columnShortcutTable.* FROM columnShortcutTable ORDER BY key ASC, value ASC
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@columnshortcuttable
 #### A masked pattern was here ####
@@ -239,16 +239,16 @@ POSTHOOK: Lineage: columnarserde_create_
 POSTHOOK: Lineage: columnarserde_create_shortcut.e SIMPLE [(src_thrift)src_thrift.FieldSchema(name:astring, type:string, comment:from deserializer), ]
 POSTHOOK: Lineage: columnshortcuttable.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: columnshortcuttable.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-238	val_238	NULL
-86	val_86	NULL
-311	val_311	NULL
-27	val_27	NULL
 165	val_165	NULL
-409	val_409	NULL
+238	val_238	NULL
 255	val_255	NULL
+27	val_27	NULL
 278	val_278	NULL
-98	val_98	NULL
+311	val_311	NULL
+409	val_409	NULL
 484	val_484	NULL
+86	val_86	NULL
+98	val_98	NULL
 PREHOOK: query: ALTER TABLE columnShortcutTable REPLACE COLUMNS (key int)
 PREHOOK: type: ALTERTABLE_REPLACECOLS
 PREHOOK: Input: default@columnshortcuttable
@@ -264,11 +264,11 @@ POSTHOOK: Lineage: columnarserde_create_
 POSTHOOK: Lineage: columnarserde_create_shortcut.e SIMPLE [(src_thrift)src_thrift.FieldSchema(name:astring, type:string, comment:from deserializer), ]
 POSTHOOK: Lineage: columnshortcuttable.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: columnshortcuttable.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: SELECT columnShortcutTable.* FROM columnShortcutTable
+PREHOOK: query: SELECT columnShortcutTable.* FROM columnShortcutTable ORDER BY key ASC
 PREHOOK: type: QUERY
 PREHOOK: Input: default@columnshortcuttable
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT columnShortcutTable.* FROM columnShortcutTable
+POSTHOOK: query: SELECT columnShortcutTable.* FROM columnShortcutTable ORDER BY key ASC
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@columnshortcuttable
 #### A masked pattern was here ####
@@ -279,13 +279,13 @@ POSTHOOK: Lineage: columnarserde_create_
 POSTHOOK: Lineage: columnarserde_create_shortcut.e SIMPLE [(src_thrift)src_thrift.FieldSchema(name:astring, type:string, comment:from deserializer), ]
 POSTHOOK: Lineage: columnshortcuttable.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: columnshortcuttable.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-238
-86
-311
 27
+86
+98
 165
-409
+238
 255
 278
-98
+311
+409
 484

Modified: hive/trunk/ql/src/test/results/clientpositive/combine1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/combine1.q.out?rev=1236489&r1=1236488&r2=1236489&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/combine1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/combine1.q.out Fri Jan 27 01:41:35 2012
@@ -15,513 +15,513 @@ POSTHOOK: Input: default@src
 POSTHOOK: Output: default@combine1_1
 POSTHOOK: Lineage: combine1_1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: combine1_1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: select key, value from combine1_1
+PREHOOK: query: select key, value from combine1_1 ORDER BY key ASC, value ASC
 PREHOOK: type: QUERY
 PREHOOK: Input: default@combine1_1
 #### A masked pattern was here ####
-POSTHOOK: query: select key, value from combine1_1
+POSTHOOK: query: select key, value from combine1_1 ORDER BY key ASC, value ASC
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@combine1_1
 #### A masked pattern was here ####
 POSTHOOK: Lineage: combine1_1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: combine1_1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-238	val_238
-86	val_86
-311	val_311
-27	val_27
-165	val_165
-409	val_409
-255	val_255
-278	val_278
-98	val_98
-484	val_484
-265	val_265
-193	val_193
-401	val_401
-150	val_150
-273	val_273
-224	val_224
-369	val_369
-66	val_66
+0	val_0
+0	val_0
+0	val_0
+10	val_10
+100	val_100
+100	val_100
+103	val_103
+103	val_103
+104	val_104
+104	val_104
+105	val_105
+11	val_11
+111	val_111
+113	val_113
+113	val_113
+114	val_114
+116	val_116
+118	val_118
+118	val_118
+119	val_119
+119	val_119
+119	val_119
+12	val_12
+12	val_12
+120	val_120
+120	val_120
+125	val_125
+125	val_125
+126	val_126
 128	val_128
-213	val_213
-146	val_146
-406	val_406
-429	val_429
-374	val_374
-152	val_152
-469	val_469
+128	val_128
+128	val_128
+129	val_129
+129	val_129
+131	val_131
+133	val_133
+134	val_134
+134	val_134
+136	val_136
+137	val_137
+137	val_137
+138	val_138
+138	val_138
+138	val_138
+138	val_138
+143	val_143
 145	val_145
-495	val_495
-37	val_37
-327	val_327
-281	val_281
-277	val_277
-209	val_209
+146	val_146
+146	val_146
+149	val_149
+149	val_149
 15	val_15
-82	val_82
-403	val_403
-166	val_166
-417	val_417
-430	val_430
-252	val_252
-292	val_292
-219	val_219
-287	val_287
+15	val_15
+150	val_150
+152	val_152
+152	val_152
 153	val_153
-193	val_193
-338	val_338
-446	val_446
-459	val_459
-394	val_394
-237	val_237
-482	val_482
-174	val_174
-413	val_413
-494	val_494
-207	val_207
-199	val_199
-466	val_466
-208	val_208
-174	val_174
-399	val_399
-396	val_396
-247	val_247
-417	val_417
-489	val_489
+155	val_155
+156	val_156
+157	val_157
+158	val_158
+160	val_160
 162	val_162
-377	val_377
-397	val_397
-309	val_309
-365	val_365
-266	val_266
-439	val_439
-342	val_342
-367	val_367
-325	val_325
+163	val_163
+164	val_164
+164	val_164
+165	val_165
+165	val_165
+166	val_166
 167	val_167
-195	val_195
-475	val_475
+167	val_167
+167	val_167
+168	val_168
+169	val_169
+169	val_169
+169	val_169
+169	val_169
 17	val_17
-113	val_113
-155	val_155
-203	val_203
-339	val_339
-0	val_0
-455	val_455
-128	val_128
-311	val_311
-316	val_316
-57	val_57
-302	val_302
-205	val_205
-149	val_149
-438	val_438
-345	val_345
-129	val_129
 170	val_170
+172	val_172
+172	val_172
+174	val_174
+174	val_174
+175	val_175
+175	val_175
+176	val_176
+176	val_176
+177	val_177
+178	val_178
+179	val_179
+179	val_179
+18	val_18
+18	val_18
+180	val_180
+181	val_181
+183	val_183
+186	val_186
+187	val_187
+187	val_187
+187	val_187
+189	val_189
+19	val_19
+190	val_190
+191	val_191
+191	val_191
+192	val_192
+193	val_193
+193	val_193
+193	val_193
+194	val_194
+195	val_195
+195	val_195
+196	val_196
+197	val_197
+197	val_197
+199	val_199
+199	val_199
+199	val_199
+2	val_2
 20	val_20
-489	val_489
-157	val_157
-378	val_378
-221	val_221
-92	val_92
-111	val_111
-47	val_47
-72	val_72
-4	val_4
-280	val_280
-35	val_35
-427	val_427
-277	val_277
+200	val_200
+200	val_200
+201	val_201
+202	val_202
+203	val_203
+203	val_203
+205	val_205
+205	val_205
+207	val_207
+207	val_207
 208	val_208
-356	val_356
-399	val_399
-169	val_169
-382	val_382
-498	val_498
-125	val_125
-386	val_386
-437	val_437
-469	val_469
-192	val_192
-286	val_286
-187	val_187
-176	val_176
-54	val_54
-459	val_459
-51	val_51
-138	val_138
-103	val_103
-239	val_239
+208	val_208
+208	val_208
+209	val_209
+209	val_209
 213	val_213
+213	val_213
+214	val_214
 216	val_216
-430	val_430
-278	val_278
-176	val_176
-289	val_289
+216	val_216
+217	val_217
+217	val_217
+218	val_218
+219	val_219
+219	val_219
 221	val_221
-65	val_65
-318	val_318
-332	val_332
-311	val_311
-275	val_275
-137	val_137
-241	val_241
-83	val_83
-333	val_333
-180	val_180
-284	val_284
-12	val_12
+221	val_221
+222	val_222
+223	val_223
+223	val_223
+224	val_224
+224	val_224
+226	val_226
+228	val_228
+229	val_229
+229	val_229
 230	val_230
-181	val_181
-67	val_67
-260	val_260
-404	val_404
-384	val_384
-489	val_489
-353	val_353
-373	val_373
-272	val_272
-138	val_138
-217	val_217
-84	val_84
-348	val_348
-466	val_466
-58	val_58
-8	val_8
-411	val_411
 230	val_230
-208	val_208
-348	val_348
+230	val_230
+230	val_230
+230	val_230
+233	val_233
+233	val_233
+235	val_235
+237	val_237
+237	val_237
+238	val_238
+238	val_238
+239	val_239
+239	val_239
 24	val_24
-463	val_463
-431	val_431
-179	val_179
-172	val_172
-42	val_42
-129	val_129
-158	val_158
-119	val_119
-496	val_496
-0	val_0
-322	val_322
-197	val_197
-468	val_468
-393	val_393
-454	val_454
-100	val_100
-298	val_298
-199	val_199
-191	val_191
-418	val_418
-96	val_96
+24	val_24
+241	val_241
+242	val_242
+242	val_242
+244	val_244
+247	val_247
+248	val_248
+249	val_249
+252	val_252
+255	val_255
+255	val_255
+256	val_256
+256	val_256
+257	val_257
+258	val_258
 26	val_26
-165	val_165
-327	val_327
-230	val_230
-205	val_205
-120	val_120
-131	val_131
-51	val_51
-404	val_404
-43	val_43
-436	val_436
-156	val_156
-469	val_469
-468	val_468
-308	val_308
-95	val_95
-196	val_196
-288	val_288
-481	val_481
-457	val_457
-98	val_98
+26	val_26
+260	val_260
+262	val_262
+263	val_263
+265	val_265
+265	val_265
+266	val_266
+27	val_27
+272	val_272
+272	val_272
+273	val_273
+273	val_273
+273	val_273
+274	val_274
+275	val_275
+277	val_277
+277	val_277
+277	val_277
+277	val_277
+278	val_278
+278	val_278
+28	val_28
+280	val_280
+280	val_280
+281	val_281
+281	val_281
 282	val_282
-197	val_197
-187	val_187
-318	val_318
-318	val_318
-409	val_409
-470	val_470
-137	val_137
-369	val_369
-316	val_316
-169	val_169
-413	val_413
-85	val_85
-77	val_77
-0	val_0
-490	val_490
-87	val_87
-364	val_364
-179	val_179
-118	val_118
-134	val_134
-395	val_395
 282	val_282
-138	val_138
-238	val_238
-419	val_419
-15	val_15
-118	val_118
-72	val_72
-90	val_90
-307	val_307
-19	val_19
-435	val_435
-10	val_10
-277	val_277
-273	val_273
+283	val_283
+284	val_284
+285	val_285
+286	val_286
+287	val_287
+288	val_288
+288	val_288
+289	val_289
+291	val_291
+292	val_292
+296	val_296
+298	val_298
+298	val_298
+298	val_298
+30	val_30
+302	val_302
+305	val_305
 306	val_306
-224	val_224
+307	val_307
+307	val_307
+308	val_308
 309	val_309
-389	val_389
+309	val_309
+310	val_310
+311	val_311
+311	val_311
+311	val_311
+315	val_315
+316	val_316
+316	val_316
+316	val_316
+317	val_317
+317	val_317
+318	val_318
+318	val_318
+318	val_318
+321	val_321
+321	val_321
+322	val_322
+322	val_322
+323	val_323
+325	val_325
+325	val_325
 327	val_327
-242	val_242
-369	val_369
-392	val_392
-272	val_272
+327	val_327
+327	val_327
+33	val_33
 331	val_331
-401	val_401
-242	val_242
-452	val_452
-177	val_177
-226	val_226
-5	val_5
-497	val_497
-402	val_402
-396	val_396
-317	val_317
-395	val_395
-58	val_58
-35	val_35
+331	val_331
+332	val_332
+333	val_333
+333	val_333
+335	val_335
 336	val_336
-95	val_95
-11	val_11
-168	val_168
+338	val_338
+339	val_339
 34	val_34
-229	val_229
-233	val_233
-143	val_143
-472	val_472
-322	val_322
-498	val_498
-160	val_160
-195	val_195
-42	val_42
-321	val_321
-430	val_430
-119	val_119
-489	val_489
-458	val_458
-78	val_78
-76	val_76
-41	val_41
-223	val_223
-492	val_492
-149	val_149
-449	val_449
-218	val_218
-228	val_228
-138	val_138
-453	val_453
-30	val_30
-209	val_209
-64	val_64
-468	val_468
-76	val_76
-74	val_74
+341	val_341
+342	val_342
 342	val_342
-69	val_69
-230	val_230
-33	val_33
-368	val_368
-103	val_103
-296	val_296
-113	val_113
-216	val_216
-367	val_367
 344	val_344
-167	val_167
-274	val_274
-219	val_219
-239	val_239
-485	val_485
-116	val_116
-223	val_223
-256	val_256
-263	val_263
-70	val_70
-487	val_487
-480	val_480
-401	val_401
-288	val_288
-191	val_191
-5	val_5
-244	val_244
-438	val_438
-128	val_128
-467	val_467
-432	val_432
-202	val_202
-316	val_316
-229	val_229
-469	val_469
-463	val_463
-280	val_280
-2	val_2
+344	val_344
+345	val_345
+348	val_348
+348	val_348
+348	val_348
+348	val_348
+348	val_348
 35	val_35
-283	val_283
-331	val_331
-235	val_235
-80	val_80
-44	val_44
-193	val_193
-321	val_321
-335	val_335
-104	val_104
-466	val_466
+35	val_35
+35	val_35
+351	val_351
+353	val_353
+353	val_353
+356	val_356
+360	val_360
+362	val_362
+364	val_364
+365	val_365
 366	val_366
-175	val_175
-403	val_403
-483	val_483
-53	val_53
-105	val_105
-257	val_257
-406	val_406
-409	val_409
-190	val_190
-406	val_406
+367	val_367
+367	val_367
+368	val_368
+369	val_369
+369	val_369
+369	val_369
+37	val_37
+37	val_37
+373	val_373
+374	val_374
+375	val_375
+377	val_377
+378	val_378
+379	val_379
+382	val_382
+382	val_382
+384	val_384
+384	val_384
+384	val_384
+386	val_386
+389	val_389
+392	val_392
+393	val_393
+394	val_394
+395	val_395
+395	val_395
+396	val_396
+396	val_396
+396	val_396
+397	val_397
+397	val_397
+399	val_399
+399	val_399
+4	val_4
+400	val_400
 401	val_401
-114	val_114
-258	val_258
-90	val_90
-203	val_203
-262	val_262
-348	val_348
+401	val_401
+401	val_401
+401	val_401
+401	val_401
+402	val_402
+403	val_403
+403	val_403
+403	val_403
+404	val_404
+404	val_404
+406	val_406
+406	val_406
+406	val_406
+406	val_406
+407	val_407
+409	val_409
+409	val_409
+409	val_409
+41	val_41
+411	val_411
+413	val_413
+413	val_413
+414	val_414
+414	val_414
+417	val_417
+417	val_417
+417	val_417
+418	val_418
+419	val_419
+42	val_42
+42	val_42
+421	val_421
 424	val_424
-12	val_12
-396	val_396
-201	val_201
-217	val_217
-164	val_164
+424	val_424
+427	val_427
+429	val_429
+429	val_429
+43	val_43
+430	val_430
+430	val_430
+430	val_430
 431	val_431
-454	val_454
-478	val_478
-298	val_298
-125	val_125
 431	val_431
-164	val_164
-424	val_424
-187	val_187
-382	val_382
-5	val_5
-70	val_70
-397	val_397
-480	val_480
-291	val_291
-24	val_24
-351	val_351
-255	val_255
-104	val_104
-70	val_70
-163	val_163
+431	val_431
+432	val_432
+435	val_435
+436	val_436
+437	val_437
+438	val_438
+438	val_438
 438	val_438
-119	val_119
-414	val_414
-200	val_200
-491	val_491
-237	val_237
 439	val_439
-360	val_360
-248	val_248
-479	val_479
-305	val_305
-417	val_417
-199	val_199
-444	val_444
-120	val_120
-429	val_429
-169	val_169
+439	val_439
+44	val_44
 443	val_443
-323	val_323
-325	val_325
-277	val_277
-230	val_230
-478	val_478
-178	val_178
-468	val_468
-310	val_310
-317	val_317
-333	val_333
-493	val_493
+444	val_444
+446	val_446
+448	val_448
+449	val_449
+452	val_452
+453	val_453
+454	val_454
+454	val_454
+454	val_454
+455	val_455
+457	val_457
+458	val_458
+458	val_458
+459	val_459
+459	val_459
 460	val_460
-207	val_207
-249	val_249
-265	val_265
-480	val_480
-83	val_83
-136	val_136
-353	val_353
-172	val_172
-214	val_214
 462	val_462
-233	val_233
-406	val_406
-133	val_133
-175	val_175
-189	val_189
-454	val_454
-375	val_375
-401	val_401
-421	val_421
-407	val_407
-384	val_384
-256	val_256
-26	val_26
-134	val_134
-67	val_67
-384	val_384
-379	val_379
-18	val_18
 462	val_462
+463	val_463
+463	val_463
+466	val_466
+466	val_466
+466	val_466
+467	val_467
+468	val_468
+468	val_468
+468	val_468
+468	val_468
+469	val_469
+469	val_469
+469	val_469
+469	val_469
+469	val_469
+47	val_47
+470	val_470
+472	val_472
+475	val_475
+477	val_477
+478	val_478
+478	val_478
+479	val_479
+480	val_480
+480	val_480
+480	val_480
+481	val_481
+482	val_482
+483	val_483
+484	val_484
+485	val_485
+487	val_487
+489	val_489
+489	val_489
+489	val_489
+489	val_489
+490	val_490
+491	val_491
 492	val_492
-100	val_100
-298	val_298
-9	val_9
-341	val_341
+492	val_492
+493	val_493
+494	val_494
+495	val_495
+496	val_496
+497	val_497
 498	val_498
-146	val_146
-458	val_458
-362	val_362
-186	val_186
-285	val_285
-348	val_348
-167	val_167
-18	val_18
-273	val_273
-183	val_183
-281	val_281
-344	val_344
-97	val_97
-469	val_469
-315	val_315
+498	val_498
+498	val_498
+5	val_5
+5	val_5
+5	val_5
+51	val_51
+51	val_51
+53	val_53
+54	val_54
+57	val_57
+58	val_58
+58	val_58
+64	val_64
+65	val_65
+66	val_66
+67	val_67
+67	val_67
+69	val_69
+70	val_70
+70	val_70
+70	val_70
+72	val_72
+72	val_72
+74	val_74
+76	val_76
+76	val_76
+77	val_77
+78	val_78
+8	val_8
+80	val_80
+82	val_82
+83	val_83
+83	val_83
 84	val_84
-28	val_28
-37	val_37
-448	val_448
-152	val_152
-348	val_348
-307	val_307
-194	val_194
-414	val_414
-477	val_477
-222	val_222
-126	val_126
+84	val_84
+85	val_85
+86	val_86
+87	val_87
+9	val_9
 90	val_90
-169	val_169
-403	val_403
-400	val_400
-200	val_200
+90	val_90
+90	val_90
+92	val_92
+95	val_95
+95	val_95
+96	val_96
+97	val_97
 97	val_97
+98	val_98
+98	val_98

Modified: hive/trunk/ql/src/test/results/clientpositive/global_limit.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/global_limit.q.out?rev=1236489&r1=1236488&r2=1236489&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/global_limit.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/global_limit.q.out Fri Jan 27 01:41:35 2012
@@ -46,261 +46,261 @@ create table gl_tgt as select key from g
 POSTHOOK: type: CREATETABLE_AS_SELECT
 POSTHOOK: Input: default@gl_src1
 POSTHOOK: Output: default@gl_tgt
-PREHOOK: query: select * from gl_tgt
+PREHOOK: query: select * from gl_tgt ORDER BY key ASC
 PREHOOK: type: QUERY
 PREHOOK: Input: default@gl_tgt
 #### A masked pattern was here ####
-POSTHOOK: query: select * from gl_tgt
+POSTHOOK: query: select * from gl_tgt ORDER BY key ASC
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@gl_tgt
 #### A masked pattern was here ####
 165
 PREHOOK: query: -- need two files
-select 'x', split(value,',') from gl_src1 limit 20
+select 'x' as key_new , split(value,',') as value_new from gl_src1 ORDER BY key_new ASC, value_new[0] ASC limit 20
 PREHOOK: type: QUERY
 PREHOOK: Input: default@gl_src1
 #### A masked pattern was here ####
 POSTHOOK: query: -- need two files
-select 'x', split(value,',') from gl_src1 limit 20
+select 'x' as key_new , split(value,',') as value_new from gl_src1 ORDER BY key_new ASC, value_new[0] ASC limit 20
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@gl_src1
 #### A masked pattern was here ####
-x	["val_165"]
-x	["val_484"]
-x	["val_150"]
-x	["val_224"]
-x	["val_66"]
-x	["val_213"]
-x	["val_374"]
-x	["val_495"]
-x	["val_37"]
-x	["val_327"]
-x	["val_15"]
-x	["val_338"]
-x	["val_459"]
-x	["val_466"]
-x	["val_396"]
-x	["val_309"]
-x	["val_367"]
 x	["val_0"]
-x	["val_455"]
-x	["val_316"]
+x	["val_0"]
+x	["val_0"]
+x	["val_0"]
+x	["val_0"]
+x	["val_0"]
+x	["val_0"]
+x	["val_0"]
+x	["val_0"]
+x	["val_103"]
+x	["val_103"]
+x	["val_103"]
+x	["val_103"]
+x	["val_103"]
+x	["val_103"]
+x	["val_11"]
+x	["val_11"]
+x	["val_11"]
+x	["val_114"]
+x	["val_114"]
 PREHOOK: query: -- no sufficient files
-select key, value, split(value,',') from gl_src1 limit 30
+select key, value, split(value,',') as value_new from gl_src1 ORDER BY key ASC, value ASC, value_new[0] ASC limit 30
 PREHOOK: type: QUERY
 PREHOOK: Input: default@gl_src1
 #### A masked pattern was here ####
 POSTHOOK: query: -- no sufficient files
-select key, value, split(value,',') from gl_src1 limit 30
+select key, value, split(value,',') as value_new from gl_src1 ORDER BY key ASC, value ASC, value_new[0] ASC limit 30
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@gl_src1
 #### A masked pattern was here ####
-165	val_165	["val_165"]
-484	val_484	["val_484"]
-150	val_150	["val_150"]
-224	val_224	["val_224"]
-66	val_66	["val_66"]
-213	val_213	["val_213"]
-374	val_374	["val_374"]
-495	val_495	["val_495"]
-37	val_37	["val_37"]
-327	val_327	["val_327"]
-15	val_15	["val_15"]
-338	val_338	["val_338"]
-459	val_459	["val_459"]
-466	val_466	["val_466"]
-396	val_396	["val_396"]
-309	val_309	["val_309"]
-367	val_367	["val_367"]
 0	val_0	["val_0"]
-455	val_455	["val_455"]
-316	val_316	["val_316"]
-345	val_345	["val_345"]
-129	val_129	["val_129"]
-378	val_378	["val_378"]
+0	val_0	["val_0"]
+0	val_0	["val_0"]
+0	val_0	["val_0"]
+0	val_0	["val_0"]
+0	val_0	["val_0"]
+0	val_0	["val_0"]
+0	val_0	["val_0"]
+0	val_0	["val_0"]
+4	val_4	["val_4"]
 4	val_4	["val_4"]
-356	val_356	["val_356"]
-169	val_169	["val_169"]
-125	val_125	["val_125"]
-437	val_437	["val_437"]
-286	val_286	["val_286"]
-187	val_187	["val_187"]
+4	val_4	["val_4"]
+8	val_8	["val_8"]
+8	val_8	["val_8"]
+8	val_8	["val_8"]
+11	val_11	["val_11"]
+11	val_11	["val_11"]
+11	val_11	["val_11"]
+15	val_15	["val_15"]
+15	val_15	["val_15"]
+15	val_15	["val_15"]
+15	val_15	["val_15"]
+15	val_15	["val_15"]
+15	val_15	["val_15"]
+19	val_19	["val_19"]
+19	val_19	["val_19"]
+19	val_19	["val_19"]
+26	val_26	["val_26"]
+26	val_26	["val_26"]
+26	val_26	["val_26"]
 PREHOOK: query: -- need all files
-select key from gl_src1 limit 100
+select key from gl_src1 ORDER BY key ASC limit 100
 PREHOOK: type: QUERY
 PREHOOK: Input: default@gl_src1
 #### A masked pattern was here ####
 POSTHOOK: query: -- need all files
-select key from gl_src1 limit 100
+select key from gl_src1 ORDER BY key ASC limit 100
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@gl_src1
 #### A masked pattern was here ####
-165
-484
-150
-224
-66
-213
-374
-495
-37
-327
-15
-338
-459
-466
-396
-309
-367
 0
-455
-316
-345
-129
-378
+0
+0
+0
+0
+0
+0
+0
+0
+4
+4
 4
-356
-169
-125
-437
-286
-187
-176
-459
-51
-103
-239
-213
-176
-275
-260
-404
-217
-84
-466
 8
-411
-172
-129
-158
-0
+8
+8
+11
+11
+11
+15
+15
+15
+15
+15
+15
+19
+19
+19
 26
-165
-327
+26
+26
+26
+26
+26
+33
+33
+33
+37
+37
+37
+37
+37
+37
+44
+44
+44
 51
-404
-95
-282
-187
-316
-169
+51
+51
+51
+51
+51
+66
+66
+66
 77
-0
-118
-282
-419
-15
-118
-19
-224
-309
-389
-327
-242
-392
-242
-396
+77
+77
+80
+80
+80
+84
+84
+84
+84
+84
+84
+95
+95
+95
+95
+95
 95
-11
-143
-228
-33
 103
-367
-239
-480
-202
-316
-235
-80
-44
-466
-257
-190
+103
+103
+103
+103
+103
 114
-396
-217
+114
+114
+118
+118
+118
+118
+118
+118
 125
-187
-480
-491
-305
-PREHOOK: query: select key from gl_src1 limit 30
-PREHOOK: type: QUERY
-PREHOOK: Input: default@gl_src1
-#### A masked pattern was here ####
-POSTHOOK: query: select key from gl_src1 limit 30
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@gl_src1
-#### A masked pattern was here ####
-165
-484
-150
-224
-66
-213
-374
-495
-37
-327
-15
-338
-459
-466
-396
-309
-367
-0
-455
-316
-345
-129
-378
-4
-356
-169
 125
-437
-286
-187
-PREHOOK: query: -- not qualified cases
-select key, count(1) from gl_src1 group by key order by key limit 5
-PREHOOK: type: QUERY
-PREHOOK: Input: default@gl_src1
-#### A masked pattern was here ####
-POSTHOOK: query: -- not qualified cases
-select key, count(1) from gl_src1 group by key order by key limit 5
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@gl_src1
-#### A masked pattern was here ####
-0	9
-4	3
-8	3
-11	3
-15	6
-PREHOOK: query: select distinct key from gl_src1 limit 10
+125
+125
+125
+125
+129
+129
+129
+129
+129
+129
+136
+PREHOOK: query: select key from gl_src1 ORDER BY key ASC limit 30
 PREHOOK: type: QUERY
 PREHOOK: Input: default@gl_src1
 #### A masked pattern was here ####
-POSTHOOK: query: select distinct key from gl_src1 limit 10
+POSTHOOK: query: select key from gl_src1 ORDER BY key ASC limit 30
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@gl_src1
 #### A masked pattern was here ####
 0
-4
-8
-11
-15
+0
+0
+0
+0
+0
+0
+0
+0
+4
+4
+4
+8
+8
+8
+11
+11
+11
+15
+15
+15
+15
+15
+15
+19
+19
+19
+26
+26
+26
+PREHOOK: query: -- not qualified cases
+select key, count(1) from gl_src1 group by key ORDER BY key ASC limit 5
+PREHOOK: type: QUERY
+PREHOOK: Input: default@gl_src1
+#### A masked pattern was here ####
+POSTHOOK: query: -- not qualified cases
+select key, count(1) from gl_src1 group by key ORDER BY key ASC limit 5
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@gl_src1
+#### A masked pattern was here ####
+0	9
+4	3
+8	3
+11	3
+15	6
+PREHOOK: query: select distinct key from gl_src1 ORDER BY key ASC limit 10
+PREHOOK: type: QUERY
+PREHOOK: Input: default@gl_src1
+#### A masked pattern was here ####
+POSTHOOK: query: select distinct key from gl_src1 ORDER BY key ASC limit 10
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@gl_src1
+#### A masked pattern was here ####
+0
+4
+8
+11
+15
 19
 26
 33
@@ -316,771 +316,771 @@ POSTHOOK: Input: default@gl_src1
 #### A masked pattern was here ####
 354
 PREHOOK: query: select transform(*) using "tr _ \n" as t from
-(select "a_a_a_a_a_a_" from gl_src1 limit 100) subq
+(select "a_a_a_a_a_a_" from gl_src1 limit 100) subq ORDER BY t
 PREHOOK: type: QUERY
 PREHOOK: Input: default@gl_src1
 #### A masked pattern was here ####
 POSTHOOK: query: select transform(*) using "tr _ \n" as t from
-(select "a_a_a_a_a_a_" from gl_src1 limit 100) subq
+(select "a_a_a_a_a_a_" from gl_src1 limit 100) subq ORDER BY t
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@gl_src1
 #### A masked pattern was here ####
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
 a
 a
 a
 a
 a
 a
-
-PREHOOK: query: select key from (select * from (select key,value from gl_src1)t1 limit 10)t2 limit 2000
+PREHOOK: query: select key from (select * from (select key,value from gl_src1)t1 limit 10)t2 ORDER BY key ASC limit 2000
 PREHOOK: type: QUERY
 PREHOOK: Input: default@gl_src1
 #### A masked pattern was here ####
-POSTHOOK: query: select key from (select * from (select key,value from gl_src1)t1 limit 10)t2 limit 2000
+POSTHOOK: query: select key from (select * from (select key,value from gl_src1)t1 limit 10)t2 ORDER BY key ASC limit 2000
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@gl_src1
 #### A masked pattern was here ####
+37
+66
+150
 165
-484
-150
-224
-66
 213
+224
+327
 374
+484
 495
-37
-327
 PREHOOK: query: -- complicated queries
-select key from (select * from (select key,value from gl_src1 limit 10)t1 )t2
+select key from (select * from (select key,value from gl_src1 limit 10)t1 )t2 ORDER BY key ASC
 PREHOOK: type: QUERY
 PREHOOK: Input: default@gl_src1
 #### A masked pattern was here ####
 POSTHOOK: query: -- complicated queries
-select key from (select * from (select key,value from gl_src1 limit 10)t1 )t2
+select key from (select * from (select key,value from gl_src1 limit 10)t1 )t2 ORDER BY key ASC
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@gl_src1
 #### A masked pattern was here ####
-165
-484
-150
-224
+37
 66
+150
+165
 213
+224
+327
 374
+484
 495
-37
-327
-PREHOOK: query: select key from (select * from (select key,value from gl_src1)t1 limit 10)t2
+PREHOOK: query: select key from (select * from (select key,value from gl_src1)t1 limit 10)t2 ORDER BY key ASC
 PREHOOK: type: QUERY
 PREHOOK: Input: default@gl_src1
 #### A masked pattern was here ####
-POSTHOOK: query: select key from (select * from (select key,value from gl_src1)t1 limit 10)t2
+POSTHOOK: query: select key from (select * from (select key,value from gl_src1)t1 limit 10)t2 ORDER BY key ASC
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@gl_src1
 #### A masked pattern was here ####
-165
-484
-150
-224
+37
 66
+150
+165
 213
+224
+327
 374
+484
 495
-37
-327
 PREHOOK: query: insert overwrite table gl_tgt select key+1 from (select * from (select key,value from gl_src1)t1)t2 limit 10
 PREHOOK: type: QUERY
 PREHOOK: Input: default@gl_src1
@@ -1090,25 +1090,25 @@ POSTHOOK: type: QUERY
 POSTHOOK: Input: default@gl_src1
 POSTHOOK: Output: default@gl_tgt
 POSTHOOK: Lineage: gl_tgt.key EXPRESSION [(gl_src1)gl_src1.FieldSchema(name:key, type:int, comment:null), ]
-PREHOOK: query: select * from gl_tgt
+PREHOOK: query: select * from gl_tgt ORDER BY key ASC
 PREHOOK: type: QUERY
 PREHOOK: Input: default@gl_tgt
 #### A masked pattern was here ####
-POSTHOOK: query: select * from gl_tgt
+POSTHOOK: query: select * from gl_tgt ORDER BY key ASC
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@gl_tgt
 #### A masked pattern was here ####
 POSTHOOK: Lineage: gl_tgt.key EXPRESSION [(gl_src1)gl_src1.FieldSchema(name:key, type:int, comment:null), ]
-166
-485
-151
-225
+38
 67
+151
+166
 214
+225
+328
 375
+485
 496
-38
-328
 PREHOOK: query: -- empty table
 create table gl_src2 (key int, value string) stored as textfile
 PREHOOK: type: CREATETABLE
@@ -1117,11 +1117,11 @@ create table gl_src2 (key int, value str
 POSTHOOK: type: CREATETABLE
 POSTHOOK: Output: default@gl_src2
 POSTHOOK: Lineage: gl_tgt.key EXPRESSION [(gl_src1)gl_src1.FieldSchema(name:key, type:int, comment:null), ]
-PREHOOK: query: select key from gl_src2 limit 10
+PREHOOK: query: select key from gl_src2 ORDER BY key ASC limit 10
 PREHOOK: type: QUERY
 PREHOOK: Input: default@gl_src2
 #### A masked pattern was here ####
-POSTHOOK: query: select key from gl_src2 limit 10
+POSTHOOK: query: select key from gl_src2 ORDER BY key ASC limit 10
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@gl_src2
 #### A masked pattern was here ####
@@ -1164,69 +1164,69 @@ POSTHOOK: query: load data local inpath 
 POSTHOOK: type: LOAD
 POSTHOOK: Output: default@gl_src_part1@p=12
 POSTHOOK: Lineage: gl_tgt.key EXPRESSION [(gl_src1)gl_src1.FieldSchema(name:key, type:int, comment:null), ]
-PREHOOK: query: select key from gl_src_part1 where p like '1%' limit 10
+PREHOOK: query: select key from gl_src_part1 where p like '1%' ORDER BY key ASC limit 10
 PREHOOK: type: QUERY
 PREHOOK: Input: default@gl_src_part1@p=11
 PREHOOK: Input: default@gl_src_part1@p=12
 #### A masked pattern was here ####
-POSTHOOK: query: select key from gl_src_part1 where p like '1%' limit 10
+POSTHOOK: query: select key from gl_src_part1 where p like '1%' ORDER BY key ASC limit 10
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@gl_src_part1@p=11
 POSTHOOK: Input: default@gl_src_part1@p=12
 #### A masked pattern was here ####
 POSTHOOK: Lineage: gl_tgt.key EXPRESSION [(gl_src1)gl_src1.FieldSchema(name:key, type:int, comment:null), ]
-27
-409
-265
-401
-166
-430
-287
-207
-199
-247
-PREHOOK: query: select key from gl_src_part1 where p='11' limit 10
+0
+0
+0
+0
+0
+0
+0
+0
+0
+4
+PREHOOK: query: select key from gl_src_part1 where p='11' ORDER BY key ASC limit 10
 PREHOOK: type: QUERY
 PREHOOK: Input: default@gl_src_part1@p=11
 #### A masked pattern was here ####
-POSTHOOK: query: select key from gl_src_part1 where p='11' limit 10
+POSTHOOK: query: select key from gl_src_part1 where p='11' ORDER BY key ASC limit 10
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@gl_src_part1@p=11
 #### A masked pattern was here ####
 POSTHOOK: Lineage: gl_tgt.key EXPRESSION [(gl_src1)gl_src1.FieldSchema(name:key, type:int, comment:null), ]
+5
+5
+5
+9
+12
+12
 27
-409
-265
-401
-166
-430
-287
-207
-199
-247
-PREHOOK: query: select key from gl_src_part1 where p='12' limit 10
+30
+34
+41
+PREHOOK: query: select key from gl_src_part1 where p='12' ORDER BY key ASC limit 10
 PREHOOK: type: QUERY
 PREHOOK: Input: default@gl_src_part1@p=12
 #### A masked pattern was here ####
-POSTHOOK: query: select key from gl_src_part1 where p='12' limit 10
+POSTHOOK: query: select key from gl_src_part1 where p='12' ORDER BY key ASC limit 10
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@gl_src_part1@p=12
 #### A masked pattern was here ####
 POSTHOOK: Lineage: gl_tgt.key EXPRESSION [(gl_src1)gl_src1.FieldSchema(name:key, type:int, comment:null), ]
-165
-484
-150
-224
-66
-213
-374
-495
-37
-327
-PREHOOK: query: select key from gl_src_part1 where p='13' limit 10
+0
+0
+0
+0
+0
+0
+0
+0
+0
+4
+PREHOOK: query: select key from gl_src_part1 where p='13' ORDER BY key ASC limit 10
 PREHOOK: type: QUERY
 #### A masked pattern was here ####
-POSTHOOK: query: select key from gl_src_part1 where p='13' limit 10
+POSTHOOK: query: select key from gl_src_part1 where p='13' ORDER BY key ASC limit 10
 POSTHOOK: type: QUERY
 #### A masked pattern was here ####
 POSTHOOK: Lineage: gl_tgt.key EXPRESSION [(gl_src1)gl_src1.FieldSchema(name:key, type:int, comment:null), ]
@@ -1238,378 +1238,378 @@ POSTHOOK: type: ALTERTABLE_ADDPARTS
 POSTHOOK: Input: default@gl_src_part1
 POSTHOOK: Output: default@gl_src_part1@p=13
 POSTHOOK: Lineage: gl_tgt.key EXPRESSION [(gl_src1)gl_src1.FieldSchema(name:key, type:int, comment:null), ]
-PREHOOK: query: select key from gl_src_part1 where p='13' limit 10
+PREHOOK: query: select key from gl_src_part1 where p='13' ORDER BY key ASC limit 10
 PREHOOK: type: QUERY
 PREHOOK: Input: default@gl_src_part1@p=13
 #### A masked pattern was here ####
-POSTHOOK: query: select key from gl_src_part1 where p='13' limit 10
+POSTHOOK: query: select key from gl_src_part1 where p='13' ORDER BY key ASC limit 10
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@gl_src_part1@p=13
 #### A masked pattern was here ####
 POSTHOOK: Lineage: gl_tgt.key EXPRESSION [(gl_src1)gl_src1.FieldSchema(name:key, type:int, comment:null), ]
-PREHOOK: query: select key from gl_src_part1 where p='12' limit 1000
+PREHOOK: query: select key from gl_src_part1 where p='12' ORDER BY key ASC limit 1000
 PREHOOK: type: QUERY
 PREHOOK: Input: default@gl_src_part1@p=12
 #### A masked pattern was here ####
-POSTHOOK: query: select key from gl_src_part1 where p='12' limit 1000
+POSTHOOK: query: select key from gl_src_part1 where p='12' ORDER BY key ASC limit 1000
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@gl_src_part1@p=12
 #### A masked pattern was here ####
 POSTHOOK: Lineage: gl_tgt.key EXPRESSION [(gl_src1)gl_src1.FieldSchema(name:key, type:int, comment:null), ]
-165
-484
-150
-224
-66
-213
-374
-495
-37
-327
-15
-338
-459
-466
-396
-309
-367
 0
-455
-316
-345
-129
-378
+0
+0
+0
+0
+0
+0
+0
+0
+4
+4
 4
-356
-169
-125
-437
-286
-187
-176
-459
-51
-103
-239
-213
-176
-275
-260
-404
-217
-84
-466
 8
-411
-172
-129
-158
-0
+8
+8
+11
+11
+11
+15
+15
+15
+15
+15
+15
+19
+19
+19
 26
-165
-327
+26
+26
+26
+26
+26
+33
+33
+33
+37
+37
+37
+37
+37
+37
+44
+44
+44
 51
-404
-95
-282
-187
-316
-169
+51
+51
+51
+51
+51
+66
+66
+66
 77
-0
-118
-282
-419
-15
-118
-19
-224
-309
-389
-327
-242
-392
-242
-396
+77
+77
+80
+80
+80
+84
+84
+84
+84
+84
+84
+95
+95
+95
+95
+95
 95
-11
-143
-228
-33
 103
-367
-239
-480
-202
-316
-235
-80
-44
-466
-257
-190
+103
+103
+103
+103
+103
 114
-396
-217
+114
+114
+118
+118
+118
+118
+118
+118
 125
-187
-480
-491
-305
-444
-169
-323
-480
-136
-172
-462
-26
-462
-341
-183
-84
-37
-448
-194
-477
-169
-400
-165
-484
-150
-224
-66
-213
-374
-495
-37
-327
-15
-338
-459
-466
-396
-309
-367
-0
-455
-316
-345
-129
-378
-4
-356
-169
 125
-437
-286
-187
-176
-459
-51
-103
-239
-213
-176
-275
-260
-404
-217
-84
-466
-8
-411
-172
+125
+125
+125
+125
+129
 129
+129
+129
+129
+129
+136
+136
+136
+143
+143
+143
+150
+150
+150
+158
+158
 158
-0
-26
 165
-327
-51
-404
-95
-282
-187
-316
+165
+165
+165
+165
+165
+169
+169
+169
+169
+169
+169
+169
+169
+169
+169
 169
-77
-0
-118
-282
-419
-15
-118
-19
-224
-309
-389
-327
-242
-392
-242
-396
-95
-11
-143
-228
-33
-103
-367
-239
-480
-202
-316
-235
-80
-44
-466
-257
-190
-114
-396
-217
-125
-187
-480
-491
-305
-444
 169
-323
-480
-136
 172
-462
-26
-462
-341
+172
+172
+172
+172
+172
+176
+176
+176
+176
+176
+176
 183
-84
-37
-448
+183
+183
+187
+187
+187
+187
+187
+187
+187
+187
+187
+190
+190
+190
 194
-477
-169
-400
-165
-484
-150
-224
-66
+194
+194
+202
+202
+202
+213
+213
+213
+213
 213
-374
-495
-37
-327
-15
-338
-459
-466
-396
-309
-367
-0
-455
-316
-345
-129
-378
-4
-356
-169
-125
-437
-286
-187
-176
-459
-51
-103
-239
 213
-176
-275
-260
-404
 217
-84
-466
-8
-411
-172
-129
-158
-0
-26
-165
-327
-51
-404
-95
+217
+217
+217
+217
+217
+224
+224
+224
+224
+224
+224
+228
+228
+228
+235
+235
+235
+239
+239
+239
+239
+239
+239
+242
+242
+242
+242
+242
+242
+257
+257
+257
+260
+260
+260
+275
+275
+275
 282
-187
-316
-169
-77
-0
-118
 282
-419
-15
-118
-19
-224
+282
+282
+282
+282
+286
+286
+286
+305
+305
+305
 309
-389
+309
+309
+309
+309
+309
+316
+316
+316
+316
+316
+316
+316
+316
+316
+323
+323
+323
 327
-242
+327
+327
+327
+327
+327
+327
+327
+327
+338
+338
+338
+341
+341
+341
+345
+345
+345
+356
+356
+356
+367
+367
+367
+367
+367
+367
+374
+374
+374
+378
+378
+378
+389
+389
+389
+392
+392
 392
-242
 396
-95
-11
-143
-228
-33
-103
-367
-239
-480
-202
-316
-235
-80
-44
-466
-257
-190
-114
 396
-217
-125
-187
-480
-491
-305
+396
+396
+396
+396
+396
+396
+396
+400
+400
+400
+404
+404
+404
+404
+404
+404
+411
+411
+411
+419
+419
+419
+437
+437
+437
 444
-169
-323
-480
-136
-172
+444
+444
+448
+448
+448
+455
+455
+455
+459
+459
+459
+459
+459
+459
 462
-26
 462
-341
-183
-84
-37
-448
-194
+462
+462
+462
+462
+466
+466
+466
+466
+466
+466
+466
+466
+466
 477
-169
-400
+477
+477
+480
+480
+480
+480
+480
+480
+480
+480
+480
+484
+484
+484
+491
+491
+491
+495
+495
+495
 PREHOOK: query: drop table gl_src1
 PREHOOK: type: DROPTABLE
 PREHOOK: Input: default@gl_src1

Modified: hive/trunk/ql/src/test/results/clientpositive/groupby1_limit.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby1_limit.q.out?rev=1236489&r1=1236488&r2=1236489&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby1_limit.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby1_limit.q.out Fri Jan 27 01:41:35 2012
@@ -133,11 +133,11 @@ POSTHOOK: Input: default@src
 POSTHOOK: Output: default@dest1
 POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: dest1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: SELECT dest1.* FROM dest1
+PREHOOK: query: SELECT dest1.* FROM dest1 ORDER BY dest1.key ASC , dest1.value ASC
 PREHOOK: type: QUERY
 PREHOOK: Input: default@dest1
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT dest1.* FROM dest1
+POSTHOOK: query: SELECT dest1.* FROM dest1 ORDER BY dest1.key ASC , dest1.value ASC
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@dest1
 #### A masked pattern was here ####

Modified: hive/trunk/ql/src/test/results/clientpositive/input11_limit.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input11_limit.q.out?rev=1236489&r1=1236488&r2=1236489&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input11_limit.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input11_limit.q.out Fri Jan 27 01:41:35 2012
@@ -91,23 +91,23 @@ POSTHOOK: Input: default@src
 POSTHOOK: Output: default@dest1
 POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: dest1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: SELECT dest1.* FROM dest1
+PREHOOK: query: SELECT dest1.* FROM dest1 ORDER BY dest1.key ASC, dest1.value ASC
 PREHOOK: type: QUERY
 PREHOOK: Input: default@dest1
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT dest1.* FROM dest1
+POSTHOOK: query: SELECT dest1.* FROM dest1 ORDER BY dest1.key ASC, dest1.value ASC
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@dest1
 #### A masked pattern was here ####
 POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: dest1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-86	val_86
-27	val_27
-98	val_98
-66	val_66
-37	val_37
+0	val_0
 15	val_15
-82	val_82
 17	val_17
-0	val_0
+27	val_27
+37	val_37
 57	val_57
+66	val_66
+82	val_82
+86	val_86
+98	val_98

Modified: hive/trunk/ql/src/test/results/clientpositive/input1_limit.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input1_limit.q.out?rev=1236489&r1=1236488&r2=1236489&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input1_limit.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input1_limit.q.out Fri Jan 27 01:41:35 2012
@@ -169,11 +169,11 @@ POSTHOOK: Lineage: dest1.key EXPRESSION 
 POSTHOOK: Lineage: dest1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 POSTHOOK: Lineage: dest2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: dest2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: SELECT dest1.* FROM dest1
+PREHOOK: query: SELECT dest1.* FROM dest1 ORDER BY dest1.key ASC, dest1.value ASC
 PREHOOK: type: QUERY
 PREHOOK: Input: default@dest1
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT dest1.* FROM dest1
+POSTHOOK: query: SELECT dest1.* FROM dest1 ORDER BY dest1.key ASC, dest1.value ASC
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@dest1
 #### A masked pattern was here ####
@@ -181,21 +181,21 @@ POSTHOOK: Lineage: dest1.key EXPRESSION 
 POSTHOOK: Lineage: dest1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 POSTHOOK: Lineage: dest2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: dest2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-86	val_86
-27	val_27
-98	val_98
-66	val_66
-37	val_37
+0	val_0
 15	val_15
-82	val_82
 17	val_17
-0	val_0
+27	val_27
+37	val_37
 57	val_57
-PREHOOK: query: SELECT dest2.* FROM dest2
+66	val_66
+82	val_82
+86	val_86
+98	val_98
+PREHOOK: query: SELECT dest2.* FROM dest2 ORDER BY dest2.key ASC, dest2.value ASC
 PREHOOK: type: QUERY
 PREHOOK: Input: default@dest2
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT dest2.* FROM dest2
+POSTHOOK: query: SELECT dest2.* FROM dest2 ORDER BY dest2.key ASC, dest2.value ASC
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@dest2
 #### A masked pattern was here ####
@@ -203,8 +203,8 @@ POSTHOOK: Lineage: dest1.key EXPRESSION 
 POSTHOOK: Lineage: dest1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 POSTHOOK: Lineage: dest2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: dest2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-86	val_86
 27	val_27
-98	val_98
-66	val_66
 37	val_37
+66	val_66
+86	val_86
+98	val_98

Modified: hive/trunk/ql/src/test/results/clientpositive/input_lazyserde.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input_lazyserde.q.out?rev=1236489&r1=1236488&r2=1236489&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input_lazyserde.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input_lazyserde.q.out Fri Jan 27 01:41:35 2012
@@ -108,11 +108,11 @@ POSTHOOK: Lineage: dest1.b SIMPLE [(src_
 POSTHOOK: Lineage: dest1.c SIMPLE [(src_thrift)src_thrift.FieldSchema(name:mstringstring, type:map<string,string>, comment:from deserializer), ]
 POSTHOOK: Lineage: dest1.d SIMPLE [(src_thrift)src_thrift.FieldSchema(name:aint, type:int, comment:from deserializer), ]
 POSTHOOK: Lineage: dest1.e SIMPLE [(src_thrift)src_thrift.FieldSchema(name:astring, type:string, comment:from deserializer), ]
-PREHOOK: query: SELECT dest1.* FROM dest1 DISTRIBUTE BY 1
+PREHOOK: query: SELECT dest1.* FROM dest1 CLUSTER BY 1
 PREHOOK: type: QUERY
 PREHOOK: Input: default@dest1
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT dest1.* FROM dest1 DISTRIBUTE BY 1
+POSTHOOK: query: SELECT dest1.* FROM dest1 CLUSTER BY 1
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@dest1
 #### A masked pattern was here ####
@@ -132,11 +132,11 @@ POSTHOOK: Lineage: dest1.e SIMPLE [(src_
 [8,16,24]	["80","800","8000"]	{"key_8":"value_8"}	1638581578	record_8
 [9,18,27]	["90","900","9000"]	{"key_9":"value_9"}	336964413	record_9
 null	null	null	0	NULL
-PREHOOK: query: SELECT dest1.a[0], dest1.b[0], dest1.c['key2'], dest1.d, dest1.e FROM dest1 DISTRIBUTE BY 1
+PREHOOK: query: SELECT dest1.a[0], dest1.b[0], dest1.c['key2'], dest1.d, dest1.e FROM dest1 CLUSTER BY 1
 PREHOOK: type: QUERY
 PREHOOK: Input: default@dest1
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT dest1.a[0], dest1.b[0], dest1.c['key2'], dest1.d, dest1.e FROM dest1 DISTRIBUTE BY 1
+POSTHOOK: query: SELECT dest1.a[0], dest1.b[0], dest1.c['key2'], dest1.d, dest1.e FROM dest1 CLUSTER BY 1
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@dest1
 #### A masked pattern was here ####
@@ -193,11 +193,11 @@ POSTHOOK: Lineage: dest1.b SIMPLE [(src_
 POSTHOOK: Lineage: dest1.c SIMPLE [(src_thrift)src_thrift.FieldSchema(name:mstringstring, type:map<string,string>, comment:from deserializer), ]
 POSTHOOK: Lineage: dest1.d SIMPLE [(src_thrift)src_thrift.FieldSchema(name:aint, type:int, comment:from deserializer), ]
 POSTHOOK: Lineage: dest1.e SIMPLE [(src_thrift)src_thrift.FieldSchema(name:astring, type:string, comment:from deserializer), ]
-PREHOOK: query: SELECT * from dest1
+PREHOOK: query: SELECT * from dest1 ORDER BY 1 ASC
 PREHOOK: type: QUERY
 PREHOOK: Input: default@dest1
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT * from dest1
+POSTHOOK: query: SELECT * from dest1 ORDER BY 1 ASC
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@dest1
 #### A masked pattern was here ####
@@ -258,11 +258,11 @@ POSTHOOK: Lineage: dest1.b SIMPLE [(src_
 POSTHOOK: Lineage: dest1.c SIMPLE [(src_thrift)src_thrift.FieldSchema(name:mstringstring, type:map<string,string>, comment:from deserializer), ]
 POSTHOOK: Lineage: dest1.d SIMPLE [(src_thrift)src_thrift.FieldSchema(name:aint, type:int, comment:from deserializer), ]
 POSTHOOK: Lineage: dest1.e SIMPLE [(src_thrift)src_thrift.FieldSchema(name:astring, type:string, comment:from deserializer), ]
-PREHOOK: query: SELECT * from dest1
+PREHOOK: query: SELECT * from dest1 ORDER BY 1 ASC
 PREHOOK: type: QUERY
 PREHOOK: Input: default@dest1
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT * from dest1
+POSTHOOK: query: SELECT * from dest1 ORDER BY 1 ASC
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@dest1
 #### A masked pattern was here ####

Modified: hive/trunk/ql/src/test/results/clientpositive/join18_multi_distinct.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join18_multi_distinct.q.out?rev=1236489&r1=1236488&r2=1236489&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join18_multi_distinct.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join18_multi_distinct.q.out Fri Jan 27 01:41:35 2012
@@ -10,7 +10,7 @@ PREHOOK: query: EXPLAIN
   count(distinct(src2.key)) AS value2
   FROM src1 src2 group by src2.key
  ) b 
- ON (a.key = b.key)
+ ON (a.key = b.key) ORDER BY a.key ASC, a.value ASC, b.key ASC, b.value1 ASC, b.value2 ASC
 PREHOOK: type: QUERY
 POSTHOOK: query: EXPLAIN
  SELECT a.key, a.value, b.key, b.value1,  b.value2
@@ -24,15 +24,16 @@ POSTHOOK: query: EXPLAIN
   count(distinct(src2.key)) AS value2
   FROM src1 src2 group by src2.key
  ) b 
- ON (a.key = b.key)
+ ON (a.key = b.key) ORDER BY a.key ASC, a.value ASC, b.key ASC, b.value1 ASC, b.value2 ASC
 POSTHOOK: type: QUERY
 ABSTRACT SYNTAX TREE:
-  (TOK_QUERY (TOK_FROM (TOK_FULLOUTERJOIN (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src) src1)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL src1) key) key) (TOK_SELEXPR (TOK_FUNCTION count (. (TOK_TABLE_OR_COL src1) value)) value)) (TOK_GROUPBY (. (TOK_TABLE_OR_COL src1) key)))) a) (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src1) src2)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL src2) key) key) (TOK_SELEXPR (TOK_FUNCTIONDI count (. (TOK_TABLE_OR_COL src2) value)) value1) (TOK_SELEXPR (TOK_FUNCTIONDI count (. (TOK_TABLE_OR_COL src2) key)) value2)) (TOK_GROUPBY (. (TOK_TABLE_OR_COL src2) key)))) b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL a) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL a) value)) (TOK_SELEXPR (. (TOK_T
 ABLE_OR_COL b) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL b) value1)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL b) value2)))))
+  (TOK_QUERY (TOK_FROM (TOK_FULLOUTERJOIN (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src) src1)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL src1) key) key) (TOK_SELEXPR (TOK_FUNCTION count (. (TOK_TABLE_OR_COL src1) value)) value)) (TOK_GROUPBY (. (TOK_TABLE_OR_COL src1) key)))) a) (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src1) src2)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL src2) key) key) (TOK_SELEXPR (TOK_FUNCTIONDI count (. (TOK_TABLE_OR_COL src2) value)) value1) (TOK_SELEXPR (TOK_FUNCTIONDI count (. (TOK_TABLE_OR_COL src2) key)) value2)) (TOK_GROUPBY (. (TOK_TABLE_OR_COL src2) key)))) b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL a) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL a) value)) (TOK_SELEXPR (. (TOK_T
 ABLE_OR_COL b) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL b) value1)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL b) value2))) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL a) key)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL a) value)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL b) key)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL b) value1)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL b) value2)))))
 
 STAGE DEPENDENCIES:
   Stage-1 is a root stage
-  Stage-2 depends on stages: Stage-1, Stage-3
-  Stage-3 is a root stage
+  Stage-2 depends on stages: Stage-1, Stage-4
+  Stage-3 depends on stages: Stage-2
+  Stage-4 is a root stage
   Stage-0 is a root stage
 
 STAGE PLANS:
@@ -165,12 +166,50 @@ STAGE PLANS:
               compressed: false
               GlobalTableId: 0
               table:
-                  input format: org.apache.hadoop.mapred.TextInputFormat
-                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+                  input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+                  output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
 
   Stage: Stage-3
     Map Reduce
       Alias -> Map Operator Tree:
+#### A masked pattern was here ####
+            Reduce Output Operator
+              key expressions:
+                    expr: _col0
+                    type: string
+                    expr: _col1
+                    type: bigint
+                    expr: _col2
+                    type: string
+                    expr: _col3
+                    type: bigint
+                    expr: _col4
+                    type: bigint
+              sort order: +++++
+              tag: -1
+              value expressions:
+                    expr: _col0
+                    type: string
+                    expr: _col1
+                    type: bigint
+                    expr: _col2
+                    type: string
+                    expr: _col3
+                    type: bigint
+                    expr: _col4
+                    type: bigint
+      Reduce Operator Tree:
+        Extract
+          File Output Operator
+            compressed: false
+            GlobalTableId: 0
+            table:
+                input format: org.apache.hadoop.mapred.TextInputFormat
+                output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+
+  Stage: Stage-4
+    Map Reduce
+      Alias -> Map Operator Tree:
         a:src1 
           TableScan
             alias: src1
@@ -242,7 +281,7 @@ PREHOOK: query: SELECT a.key, a.value, b
   count(distinct(src2.key)) AS value2
   FROM src1 src2 group by src2.key
  ) b 
- ON (a.key = b.key)
+ ON (a.key = b.key) ORDER BY a.key ASC, a.value ASC, b.key ASC, b.value1 ASC, b.value2 ASC
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Input: default@src1
@@ -258,7 +297,7 @@ POSTHOOK: query: SELECT a.key, a.value, 
   count(distinct(src2.key)) AS value2
   FROM src1 src2 group by src2.key
  ) b 
- ON (a.key = b.key)
+ ON (a.key = b.key) ORDER BY a.key ASC, a.value ASC, b.key ASC, b.value1 ASC, b.value2 ASC
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Input: default@src1
@@ -267,6 +306,24 @@ NULL	NULL		1	0
 NULL	NULL		1	0
 NULL	NULL		1	0
 NULL	NULL		1	1
+NULL	NULL	val_146	1	0
+NULL	NULL	val_150	1	0
+NULL	NULL	val_165	1	0
+NULL	NULL	val_193	1	0
+NULL	NULL	val_213	1	0
+NULL	NULL	val_238	1	0
+NULL	NULL	val_255	1	0
+NULL	NULL	val_265	1	0
+NULL	NULL	val_27	1	0
+NULL	NULL	val_273	1	0
+NULL	NULL	val_278	1	0
+NULL	NULL	val_311	1	0
+NULL	NULL	val_401	1	0
+NULL	NULL	val_406	1	0
+NULL	NULL	val_409	1	0
+NULL	NULL	val_484	1	0
+NULL	NULL	val_66	1	0
+NULL	NULL	val_98	1	0
 0	3	NULL	NULL	NULL
 10	1	NULL	NULL	NULL
 100	2	NULL	NULL	NULL
@@ -576,21 +633,3 @@ NULL	NULL		1	1
 96	1	NULL	NULL	NULL
 97	2	NULL	NULL	NULL
 98	2	98	0	1
-NULL	NULL	val_146	1	0
-NULL	NULL	val_150	1	0
-NULL	NULL	val_165	1	0
-NULL	NULL	val_193	1	0
-NULL	NULL	val_213	1	0
-NULL	NULL	val_238	1	0
-NULL	NULL	val_255	1	0
-NULL	NULL	val_265	1	0
-NULL	NULL	val_27	1	0
-NULL	NULL	val_273	1	0
-NULL	NULL	val_278	1	0
-NULL	NULL	val_311	1	0
-NULL	NULL	val_401	1	0
-NULL	NULL	val_406	1	0
-NULL	NULL	val_409	1	0
-NULL	NULL	val_484	1	0
-NULL	NULL	val_66	1	0
-NULL	NULL	val_98	1	0



Mime
View raw message