hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From hashut...@apache.org
Subject svn commit: r1537540 [5/10] - in /hive/trunk: ./ ql/src/java/org/apache/hadoop/hive/ql/parse/ ql/src/test/queries/clientpositive/ ql/src/test/results/clientpositive/
Date Thu, 31 Oct 2013 16:00:41 GMT
Modified: hive/trunk/ql/src/test/results/clientpositive/partition_date2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/partition_date2.q.out?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/partition_date2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/partition_date2.q.out Thu Oct 31 16:00:36 2013
@@ -8,7 +8,7 @@ POSTHOOK: query: create table partition_
 POSTHOOK: type: CREATETABLE
 POSTHOOK: Output: default@partition_date2_1
 PREHOOK: query: -- test date literal syntax
-from (select * from src limit 1) x
+from (select * from src tablesample (1 rows)) x
 insert overwrite table partition_date2_1 partition(dt=date '2000-01-01', region=1) select *
 insert overwrite table partition_date2_1 partition(dt=date '2000-01-01', region=2) select *
 insert overwrite table partition_date2_1 partition(dt=date '1999-01-01', region=2) select *
@@ -18,7 +18,7 @@ PREHOOK: Output: default@partition_date2
 PREHOOK: Output: default@partition_date2_1@dt=2000-01-01/region=1
 PREHOOK: Output: default@partition_date2_1@dt=2000-01-01/region=2
 POSTHOOK: query: -- test date literal syntax
-from (select * from src limit 1) x
+from (select * from src tablesample (1 rows)) x
 insert overwrite table partition_date2_1 partition(dt=date '2000-01-01', region=1) select *
 insert overwrite table partition_date2_1 partition(dt=date '2000-01-01', region=2) select *
 insert overwrite table partition_date2_1 partition(dt=date '1999-01-01', region=2) select *
@@ -80,13 +80,13 @@ POSTHOOK: Lineage: partition_date2_1 PAR
 238	val_238	2000-01-01	2
 PREHOOK: query: -- insert overwrite
 insert overwrite table partition_date2_1 partition(dt=date '2000-01-01', region=2) 
-  select 'changed_key', 'changed_value' from src limit 2
+  select 'changed_key', 'changed_value' from src tablesample (2 rows)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@partition_date2_1@dt=2000-01-01/region=2
 POSTHOOK: query: -- insert overwrite
 insert overwrite table partition_date2_1 partition(dt=date '2000-01-01', region=2) 
-  select 'changed_key', 'changed_value' from src limit 2
+  select 'changed_key', 'changed_value' from src tablesample (2 rows)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@partition_date2_1@dt=2000-01-01/region=2
@@ -390,12 +390,12 @@ region              	int                
 	 	 
 #### A masked pattern was here ####
 PREHOOK: query: insert overwrite table partition_date2_1 partition(dt=date '1980-01-02', region=3)
-  select * from src limit 2
+  select * from src tablesample (2 rows)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@partition_date2_1@dt=1980-01-02/region=3
 POSTHOOK: query: insert overwrite table partition_date2_1 partition(dt=date '1980-01-02', region=3)
-  select * from src limit 2
+  select * from src tablesample (2 rows)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@partition_date2_1@dt=1980-01-02/region=3

Modified: hive/trunk/ql/src/test/results/clientpositive/partition_decode_name.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/partition_decode_name.q.out?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/partition_decode_name.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/partition_decode_name.q.out Thu Oct 31 16:00:36 2013
@@ -1,17 +1,17 @@
 PREHOOK: query: create table sc as select * 
-from (select '2011-01-11', '2011-01-11+14:18:26' from src limit 1 
+from (select '2011-01-11', '2011-01-11+14:18:26' from src tablesample (1 rows)
       union all 
-      select '2011-01-11', '2011-01-11+15:18:26' from src limit 1 
+      select '2011-01-11', '2011-01-11+15:18:26' from src tablesample (1 rows)
       union all 
-      select '2011-01-11', '2011-01-11+16:18:26' from src limit 1 ) s
+      select '2011-01-11', '2011-01-11+16:18:26' from src tablesample (1 rows) ) s
 PREHOOK: type: CREATETABLE_AS_SELECT
 PREHOOK: Input: default@src
 POSTHOOK: query: create table sc as select * 
-from (select '2011-01-11', '2011-01-11+14:18:26' from src limit 1 
+from (select '2011-01-11', '2011-01-11+14:18:26' from src tablesample (1 rows)
       union all 
-      select '2011-01-11', '2011-01-11+15:18:26' from src limit 1 
+      select '2011-01-11', '2011-01-11+15:18:26' from src tablesample (1 rows)
       union all 
-      select '2011-01-11', '2011-01-11+16:18:26' from src limit 1 ) s
+      select '2011-01-11', '2011-01-11+16:18:26' from src tablesample (1 rows) ) s
 POSTHOOK: type: CREATETABLE_AS_SELECT
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@sc

Modified: hive/trunk/ql/src/test/results/clientpositive/partition_special_char.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/partition_special_char.q.out?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/partition_special_char.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/partition_special_char.q.out Thu Oct 31 16:00:36 2013
@@ -1,17 +1,17 @@
 PREHOOK: query: create table sc as select * 
-from (select '2011-01-11', '2011-01-11+14:18:26' from src limit 1 
+from (select '2011-01-11', '2011-01-11+14:18:26' from src tablesample (1 rows)
       union all 
-      select '2011-01-11', '2011-01-11+15:18:26' from src limit 1 
+      select '2011-01-11', '2011-01-11+15:18:26' from src tablesample (1 rows)
       union all 
-      select '2011-01-11', '2011-01-11+16:18:26' from src limit 1 ) s
+      select '2011-01-11', '2011-01-11+16:18:26' from src tablesample (1 rows) ) s
 PREHOOK: type: CREATETABLE_AS_SELECT
 PREHOOK: Input: default@src
 POSTHOOK: query: create table sc as select * 
-from (select '2011-01-11', '2011-01-11+14:18:26' from src limit 1 
+from (select '2011-01-11', '2011-01-11+14:18:26' from src tablesample (1 rows)
       union all 
-      select '2011-01-11', '2011-01-11+15:18:26' from src limit 1 
+      select '2011-01-11', '2011-01-11+15:18:26' from src tablesample (1 rows)
       union all 
-      select '2011-01-11', '2011-01-11+16:18:26' from src limit 1 ) s
+      select '2011-01-11', '2011-01-11+16:18:26' from src tablesample (1 rows) ) s
 POSTHOOK: type: CREATETABLE_AS_SELECT
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@sc

Modified: hive/trunk/ql/src/test/results/clientpositive/partition_varchar1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/partition_varchar1.q.out?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/partition_varchar1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/partition_varchar1.q.out Thu Oct 31 16:00:36 2013
@@ -8,24 +8,24 @@ POSTHOOK: query: create table partition_
 POSTHOOK: type: CREATETABLE
 POSTHOOK: Output: default@partition_varchar_1
 PREHOOK: query: insert overwrite table partition_varchar_1 partition(dt='2000-01-01', region=1)
-  select * from src limit 10
+  select * from src tablesample (10 rows)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@partition_varchar_1@dt=2000-01-01/region=1
 POSTHOOK: query: insert overwrite table partition_varchar_1 partition(dt='2000-01-01', region=1)
-  select * from src limit 10
+  select * from src tablesample (10 rows)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@partition_varchar_1@dt=2000-01-01/region=1
 POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=1).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 PREHOOK: query: insert overwrite table partition_varchar_1 partition(dt='2000-01-01', region=2)
-  select * from src limit 5
+  select * from src tablesample (5 rows)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@partition_varchar_1@dt=2000-01-01/region=2
 POSTHOOK: query: insert overwrite table partition_varchar_1 partition(dt='2000-01-01', region=2)
-  select * from src limit 5
+  select * from src tablesample (5 rows)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@partition_varchar_1@dt=2000-01-01/region=2
@@ -34,12 +34,12 @@ POSTHOOK: Lineage: partition_varchar_1 P
 POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=2).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 PREHOOK: query: insert overwrite table partition_varchar_1 partition(dt='2013-08-08', region=1)
-  select * from src limit 20
+  select * from src tablesample (20 rows)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@partition_varchar_1@dt=2013-08-08/region=1
 POSTHOOK: query: insert overwrite table partition_varchar_1 partition(dt='2013-08-08', region=1)
-  select * from src limit 20
+  select * from src tablesample (20 rows)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@partition_varchar_1@dt=2013-08-08/region=1
@@ -50,12 +50,12 @@ POSTHOOK: Lineage: partition_varchar_1 P
 POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=1).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 PREHOOK: query: insert overwrite table partition_varchar_1 partition(dt='2013-08-08', region=10)
-  select * from src limit 11
+  select * from src tablesample (11 rows)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@partition_varchar_1@dt=2013-08-08/region=10
 POSTHOOK: query: insert overwrite table partition_varchar_1 partition(dt='2013-08-08', region=10)
-  select * from src limit 11
+  select * from src tablesample (11 rows)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@partition_varchar_1@dt=2013-08-08/region=10

Modified: hive/trunk/ql/src/test/results/clientpositive/ppd_union_view.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppd_union_view.q.out?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ppd_union_view.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ppd_union_view.q.out Thu Oct 31 16:00:36 2013
@@ -12,24 +12,24 @@ POSTHOOK: query: create table t1_new (ke
 POSTHOOK: type: CREATETABLE
 POSTHOOK: Output: default@t1_new
 PREHOOK: query: insert overwrite table t1_new partition (ds = '2011-10-15')
-select 'key1', 'value1' from src limit 1
+select 'key1', 'value1' from src tablesample (1 rows)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@t1_new@ds=2011-10-15
 POSTHOOK: query: insert overwrite table t1_new partition (ds = '2011-10-15')
-select 'key1', 'value1' from src limit 1
+select 'key1', 'value1' from src tablesample (1 rows)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@t1_new@ds=2011-10-15
 POSTHOOK: Lineage: t1_new PARTITION(ds=2011-10-15).key SIMPLE []
 POSTHOOK: Lineage: t1_new PARTITION(ds=2011-10-15).value SIMPLE []
 PREHOOK: query: insert overwrite table t1_new partition (ds = '2011-10-16')
-select 'key2', 'value2' from src limit 1
+select 'key2', 'value2' from src tablesample (1 rows)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@t1_new@ds=2011-10-16
 POSTHOOK: query: insert overwrite table t1_new partition (ds = '2011-10-16')
-select 'key2', 'value2' from src limit 1
+select 'key2', 'value2' from src tablesample (1 rows)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@t1_new@ds=2011-10-16
@@ -47,12 +47,12 @@ POSTHOOK: Lineage: t1_new PARTITION(ds=2
 POSTHOOK: Lineage: t1_new PARTITION(ds=2011-10-16).key SIMPLE []
 POSTHOOK: Lineage: t1_new PARTITION(ds=2011-10-16).value SIMPLE []
 PREHOOK: query: insert overwrite table t1_old partition (ds = '2011-10-13')
-select 'keymap3', 'value3' from src limit 1
+select 'keymap3', 'value3' from src tablesample (1 rows)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@t1_old@ds=2011-10-13
 POSTHOOK: query: insert overwrite table t1_old partition (ds = '2011-10-13')
-select 'keymap3', 'value3' from src limit 1
+select 'keymap3', 'value3' from src tablesample (1 rows)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@t1_old@ds=2011-10-13
@@ -63,12 +63,12 @@ POSTHOOK: Lineage: t1_new PARTITION(ds=2
 POSTHOOK: Lineage: t1_old PARTITION(ds=2011-10-13).keymap SIMPLE []
 POSTHOOK: Lineage: t1_old PARTITION(ds=2011-10-13).value SIMPLE []
 PREHOOK: query: insert overwrite table t1_old partition (ds = '2011-10-14')
-select 'keymap4', 'value4' from src limit 1
+select 'keymap4', 'value4' from src tablesample (1 rows)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@t1_old@ds=2011-10-14
 POSTHOOK: query: insert overwrite table t1_old partition (ds = '2011-10-14')
-select 'keymap4', 'value4' from src limit 1
+select 'keymap4', 'value4' from src tablesample (1 rows)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@t1_old@ds=2011-10-14
@@ -94,12 +94,12 @@ POSTHOOK: Lineage: t1_old PARTITION(ds=2
 POSTHOOK: Lineage: t1_old PARTITION(ds=2011-10-14).keymap SIMPLE []
 POSTHOOK: Lineage: t1_old PARTITION(ds=2011-10-14).value SIMPLE []
 PREHOOK: query: insert overwrite table t1_mapping partition (ds = '2011-10-13')
-select 'key3', 'keymap3' from src limit 1
+select 'key3', 'keymap3' from src tablesample (1 rows)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@t1_mapping@ds=2011-10-13
 POSTHOOK: query: insert overwrite table t1_mapping partition (ds = '2011-10-13')
-select 'key3', 'keymap3' from src limit 1
+select 'key3', 'keymap3' from src tablesample (1 rows)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@t1_mapping@ds=2011-10-13
@@ -114,12 +114,12 @@ POSTHOOK: Lineage: t1_old PARTITION(ds=2
 POSTHOOK: Lineage: t1_old PARTITION(ds=2011-10-14).keymap SIMPLE []
 POSTHOOK: Lineage: t1_old PARTITION(ds=2011-10-14).value SIMPLE []
 PREHOOK: query: insert overwrite table t1_mapping partition (ds = '2011-10-14')
-select 'key4', 'keymap4' from src limit 1
+select 'key4', 'keymap4' from src tablesample (1 rows)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@t1_mapping@ds=2011-10-14
 POSTHOOK: query: insert overwrite table t1_mapping partition (ds = '2011-10-14')
-select 'key4', 'keymap4' from src limit 1
+select 'key4', 'keymap4' from src tablesample (1 rows)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@t1_mapping@ds=2011-10-14

Modified: hive/trunk/ql/src/test/results/clientpositive/ppr_pushdown.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppr_pushdown.q.out?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ppr_pushdown.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ppr_pushdown.q.out Thu Oct 31 16:00:36 2013
@@ -59,41 +59,41 @@ POSTHOOK: query: alter table ppr_test ad
 POSTHOOK: type: ALTERTABLE_ADDPARTS
 POSTHOOK: Input: default@ppr_test
 POSTHOOK: Output: default@ppr_test@ds=12%2A4
-PREHOOK: query: insert overwrite table ppr_test partition(ds = '1234') select * from (select '1234' from src limit 1 union all select 'abcd' from src limit 1) s
+PREHOOK: query: insert overwrite table ppr_test partition(ds = '1234') select * from (select '1234' from src tablesample (1 rows) union all select 'abcd' from src tablesample (1 rows)) s
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@ppr_test@ds=1234
-POSTHOOK: query: insert overwrite table ppr_test partition(ds = '1234') select * from (select '1234' from src limit 1 union all select 'abcd' from src limit 1) s
+POSTHOOK: query: insert overwrite table ppr_test partition(ds = '1234') select * from (select '1234' from src tablesample (1 rows) union all select 'abcd' from src tablesample (1 rows)) s
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@ppr_test@ds=1234
 POSTHOOK: Lineage: ppr_test PARTITION(ds=1234).key EXPRESSION []
-PREHOOK: query: insert overwrite table ppr_test partition(ds = '1224') select * from (select '1224' from src limit 1 union all select 'abcd' from src limit 1) s
+PREHOOK: query: insert overwrite table ppr_test partition(ds = '1224') select * from (select '1224' from src tablesample (1 rows) union all select 'abcd' from src tablesample (1 rows)) s
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@ppr_test@ds=1224
-POSTHOOK: query: insert overwrite table ppr_test partition(ds = '1224') select * from (select '1224' from src limit 1 union all select 'abcd' from src limit 1) s
+POSTHOOK: query: insert overwrite table ppr_test partition(ds = '1224') select * from (select '1224' from src tablesample (1 rows) union all select 'abcd' from src tablesample (1 rows)) s
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@ppr_test@ds=1224
 POSTHOOK: Lineage: ppr_test PARTITION(ds=1224).key EXPRESSION []
 POSTHOOK: Lineage: ppr_test PARTITION(ds=1234).key EXPRESSION []
-PREHOOK: query: insert overwrite table ppr_test partition(ds = '1214') select * from (select '1214' from src limit 1 union all select 'abcd' from src limit 1) s
+PREHOOK: query: insert overwrite table ppr_test partition(ds = '1214') select * from (select '1214' from src tablesample (1 rows) union all select 'abcd' from src tablesample (1 rows)) s
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@ppr_test@ds=1214
-POSTHOOK: query: insert overwrite table ppr_test partition(ds = '1214') select * from (select '1214' from src limit 1 union all select 'abcd' from src limit 1) s
+POSTHOOK: query: insert overwrite table ppr_test partition(ds = '1214') select * from (select '1214' from src tablesample (1 rows) union all select 'abcd' from src tablesample (1 rows)) s
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@ppr_test@ds=1214
 POSTHOOK: Lineage: ppr_test PARTITION(ds=1214).key EXPRESSION []
 POSTHOOK: Lineage: ppr_test PARTITION(ds=1224).key EXPRESSION []
 POSTHOOK: Lineage: ppr_test PARTITION(ds=1234).key EXPRESSION []
-PREHOOK: query: insert overwrite table ppr_test partition(ds = '12+4') select * from (select '12+4' from src limit 1 union all select 'abcd' from src limit 1) s
+PREHOOK: query: insert overwrite table ppr_test partition(ds = '12+4') select * from (select '12+4' from src tablesample (1 rows) union all select 'abcd' from src tablesample (1 rows)) s
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@ppr_test@ds=12+4
-POSTHOOK: query: insert overwrite table ppr_test partition(ds = '12+4') select * from (select '12+4' from src limit 1 union all select 'abcd' from src limit 1) s
+POSTHOOK: query: insert overwrite table ppr_test partition(ds = '12+4') select * from (select '12+4' from src tablesample (1 rows) union all select 'abcd' from src tablesample (1 rows)) s
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@ppr_test@ds=12+4
@@ -101,11 +101,11 @@ POSTHOOK: Lineage: ppr_test PARTITION(ds
 POSTHOOK: Lineage: ppr_test PARTITION(ds=1214).key EXPRESSION []
 POSTHOOK: Lineage: ppr_test PARTITION(ds=1224).key EXPRESSION []
 POSTHOOK: Lineage: ppr_test PARTITION(ds=1234).key EXPRESSION []
-PREHOOK: query: insert overwrite table ppr_test partition(ds = '12.4') select * from (select '12.4' from src limit 1 union all select 'abcd' from src limit 1) s
+PREHOOK: query: insert overwrite table ppr_test partition(ds = '12.4') select * from (select '12.4' from src tablesample (1 rows) union all select 'abcd' from src tablesample (1 rows)) s
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@ppr_test@ds=12.4
-POSTHOOK: query: insert overwrite table ppr_test partition(ds = '12.4') select * from (select '12.4' from src limit 1 union all select 'abcd' from src limit 1) s
+POSTHOOK: query: insert overwrite table ppr_test partition(ds = '12.4') select * from (select '12.4' from src tablesample (1 rows) union all select 'abcd' from src tablesample (1 rows)) s
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@ppr_test@ds=12.4
@@ -114,11 +114,11 @@ POSTHOOK: Lineage: ppr_test PARTITION(ds
 POSTHOOK: Lineage: ppr_test PARTITION(ds=1214).key EXPRESSION []
 POSTHOOK: Lineage: ppr_test PARTITION(ds=1224).key EXPRESSION []
 POSTHOOK: Lineage: ppr_test PARTITION(ds=1234).key EXPRESSION []
-PREHOOK: query: insert overwrite table ppr_test partition(ds = '12:4') select * from (select '12:4' from src limit 1 union all select 'abcd' from src limit 1) s
+PREHOOK: query: insert overwrite table ppr_test partition(ds = '12:4') select * from (select '12:4' from src tablesample (1 rows) union all select 'abcd' from src tablesample (1 rows)) s
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@ppr_test@ds=12%3A4
-POSTHOOK: query: insert overwrite table ppr_test partition(ds = '12:4') select * from (select '12:4' from src limit 1 union all select 'abcd' from src limit 1) s
+POSTHOOK: query: insert overwrite table ppr_test partition(ds = '12:4') select * from (select '12:4' from src tablesample (1 rows) union all select 'abcd' from src tablesample (1 rows)) s
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@ppr_test@ds=12%3A4
@@ -128,11 +128,11 @@ POSTHOOK: Lineage: ppr_test PARTITION(ds
 POSTHOOK: Lineage: ppr_test PARTITION(ds=1224).key EXPRESSION []
 POSTHOOK: Lineage: ppr_test PARTITION(ds=1234).key EXPRESSION []
 POSTHOOK: Lineage: ppr_test PARTITION(ds=12:4).key EXPRESSION []
-PREHOOK: query: insert overwrite table ppr_test partition(ds = '12%4') select * from (select '12%4' from src limit 1 union all select 'abcd' from src limit 1) s
+PREHOOK: query: insert overwrite table ppr_test partition(ds = '12%4') select * from (select '12%4' from src tablesample (1 rows) union all select 'abcd' from src tablesample (1 rows)) s
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@ppr_test@ds=12%254
-POSTHOOK: query: insert overwrite table ppr_test partition(ds = '12%4') select * from (select '12%4' from src limit 1 union all select 'abcd' from src limit 1) s
+POSTHOOK: query: insert overwrite table ppr_test partition(ds = '12%4') select * from (select '12%4' from src tablesample (1 rows) union all select 'abcd' from src tablesample (1 rows)) s
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@ppr_test@ds=12%254
@@ -143,11 +143,11 @@ POSTHOOK: Lineage: ppr_test PARTITION(ds
 POSTHOOK: Lineage: ppr_test PARTITION(ds=1224).key EXPRESSION []
 POSTHOOK: Lineage: ppr_test PARTITION(ds=1234).key EXPRESSION []
 POSTHOOK: Lineage: ppr_test PARTITION(ds=12:4).key EXPRESSION []
-PREHOOK: query: insert overwrite table ppr_test partition(ds = '12*4') select * from (select '12*4' from src limit 1 union all select 'abcd' from src limit 1) s
+PREHOOK: query: insert overwrite table ppr_test partition(ds = '12*4') select * from (select '12*4' from src tablesample (1 rows) union all select 'abcd' from src tablesample (1 rows)) s
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@ppr_test@ds=12%2A4
-POSTHOOK: query: insert overwrite table ppr_test partition(ds = '12*4') select * from (select '12*4' from src limit 1 union all select 'abcd' from src limit 1) s
+POSTHOOK: query: insert overwrite table ppr_test partition(ds = '12*4') select * from (select '12*4' from src tablesample (1 rows) union all select 'abcd' from src tablesample (1 rows)) s
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@ppr_test@ds=12%2A4

Modified: hive/trunk/ql/src/test/results/clientpositive/ppr_pushdown2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppr_pushdown2.q.out?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ppr_pushdown2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ppr_pushdown2.q.out Thu Oct 31 16:00:36 2013
@@ -3,20 +3,20 @@ PREHOOK: type: CREATETABLE
 POSTHOOK: query: create table ppr_test (key string) partitioned by (ds string)
 POSTHOOK: type: CREATETABLE
 POSTHOOK: Output: default@ppr_test
-PREHOOK: query: insert overwrite table ppr_test partition(ds='2') select '2' from src limit 1
+PREHOOK: query: insert overwrite table ppr_test partition(ds='2') select '2' from src tablesample (1 rows)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@ppr_test@ds=2
-POSTHOOK: query: insert overwrite table ppr_test partition(ds='2') select '2' from src limit 1
+POSTHOOK: query: insert overwrite table ppr_test partition(ds='2') select '2' from src tablesample (1 rows)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@ppr_test@ds=2
 POSTHOOK: Lineage: ppr_test PARTITION(ds=2).key SIMPLE []
-PREHOOK: query: insert overwrite table ppr_test partition(ds='22') select '22' from src limit 1
+PREHOOK: query: insert overwrite table ppr_test partition(ds='22') select '22' from src tablesample (1 rows)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@ppr_test@ds=22
-POSTHOOK: query: insert overwrite table ppr_test partition(ds='22') select '22' from src limit 1
+POSTHOOK: query: insert overwrite table ppr_test partition(ds='22') select '22' from src tablesample (1 rows)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@ppr_test@ds=22
@@ -55,22 +55,22 @@ POSTHOOK: type: CREATETABLE
 POSTHOOK: Output: default@ppr_test2
 POSTHOOK: Lineage: ppr_test PARTITION(ds=22).key SIMPLE []
 POSTHOOK: Lineage: ppr_test PARTITION(ds=2).key SIMPLE []
-PREHOOK: query: insert overwrite table ppr_test2 partition(ds='1', s='2') select '1' from src limit 1
+PREHOOK: query: insert overwrite table ppr_test2 partition(ds='1', s='2') select '1' from src tablesample (1 rows)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@ppr_test2@ds=1/s=2
-POSTHOOK: query: insert overwrite table ppr_test2 partition(ds='1', s='2') select '1' from src limit 1
+POSTHOOK: query: insert overwrite table ppr_test2 partition(ds='1', s='2') select '1' from src tablesample (1 rows)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@ppr_test2@ds=1/s=2
 POSTHOOK: Lineage: ppr_test PARTITION(ds=22).key SIMPLE []
 POSTHOOK: Lineage: ppr_test PARTITION(ds=2).key SIMPLE []
 POSTHOOK: Lineage: ppr_test2 PARTITION(ds=1,s=2).key SIMPLE []
-PREHOOK: query: insert overwrite table ppr_test2 partition(ds='2', s='1') select '2' from src limit 1
+PREHOOK: query: insert overwrite table ppr_test2 partition(ds='2', s='1') select '2' from src tablesample (1 rows)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@ppr_test2@ds=2/s=1
-POSTHOOK: query: insert overwrite table ppr_test2 partition(ds='2', s='1') select '2' from src limit 1
+POSTHOOK: query: insert overwrite table ppr_test2 partition(ds='2', s='1') select '2' from src tablesample (1 rows)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@ppr_test2@ds=2/s=1
@@ -117,11 +117,11 @@ POSTHOOK: Lineage: ppr_test PARTITION(ds
 POSTHOOK: Lineage: ppr_test PARTITION(ds=2).key SIMPLE []
 POSTHOOK: Lineage: ppr_test2 PARTITION(ds=1,s=2).key SIMPLE []
 POSTHOOK: Lineage: ppr_test2 PARTITION(ds=2,s=1).key SIMPLE []
-PREHOOK: query: insert overwrite table ppr_test3 partition(col='1', ol='2', l = '3') select '1' from src limit 1
+PREHOOK: query: insert overwrite table ppr_test3 partition(col='1', ol='2', l = '3') select '1' from src tablesample (1 rows)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@ppr_test3@col=1/ol=2/l=3
-POSTHOOK: query: insert overwrite table ppr_test3 partition(col='1', ol='2', l = '3') select '1' from src limit 1
+POSTHOOK: query: insert overwrite table ppr_test3 partition(col='1', ol='2', l = '3') select '1' from src tablesample (1 rows)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@ppr_test3@col=1/ol=2/l=3
@@ -130,11 +130,11 @@ POSTHOOK: Lineage: ppr_test PARTITION(ds
 POSTHOOK: Lineage: ppr_test2 PARTITION(ds=1,s=2).key SIMPLE []
 POSTHOOK: Lineage: ppr_test2 PARTITION(ds=2,s=1).key SIMPLE []
 POSTHOOK: Lineage: ppr_test3 PARTITION(col=1,ol=2,l=3).key SIMPLE []
-PREHOOK: query: insert overwrite table ppr_test3 partition(col='1', ol='1', l = '2') select '2' from src limit 1
+PREHOOK: query: insert overwrite table ppr_test3 partition(col='1', ol='1', l = '2') select '2' from src tablesample (1 rows)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@ppr_test3@col=1/ol=1/l=2
-POSTHOOK: query: insert overwrite table ppr_test3 partition(col='1', ol='1', l = '2') select '2' from src limit 1
+POSTHOOK: query: insert overwrite table ppr_test3 partition(col='1', ol='1', l = '2') select '2' from src tablesample (1 rows)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@ppr_test3@col=1/ol=1/l=2
@@ -144,11 +144,11 @@ POSTHOOK: Lineage: ppr_test2 PARTITION(d
 POSTHOOK: Lineage: ppr_test2 PARTITION(ds=2,s=1).key SIMPLE []
 POSTHOOK: Lineage: ppr_test3 PARTITION(col=1,ol=1,l=2).key SIMPLE []
 POSTHOOK: Lineage: ppr_test3 PARTITION(col=1,ol=2,l=3).key SIMPLE []
-PREHOOK: query: insert overwrite table ppr_test3 partition(col='1', ol='2', l = '1') select '3' from src limit 1
+PREHOOK: query: insert overwrite table ppr_test3 partition(col='1', ol='2', l = '1') select '3' from src tablesample (1 rows)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@ppr_test3@col=1/ol=2/l=1
-POSTHOOK: query: insert overwrite table ppr_test3 partition(col='1', ol='2', l = '1') select '3' from src limit 1
+POSTHOOK: query: insert overwrite table ppr_test3 partition(col='1', ol='2', l = '1') select '3' from src tablesample (1 rows)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@ppr_test3@col=1/ol=2/l=1

Modified: hive/trunk/ql/src/test/results/clientpositive/quote2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/quote2.q.out?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/quote2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/quote2.q.out Thu Oct 31 16:00:36 2013
@@ -32,69 +32,58 @@ ABSTRACT SYNTAX TREE:
   (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR 'abc') (TOK_SELEXPR "abc") (TOK_SELEXPR 'abc\'') (TOK_SELEXPR "abc\"") (TOK_SELEXPR 'abc\\') (TOK_SELEXPR "abc\\") (TOK_SELEXPR 'abc\\\'') (TOK_SELEXPR "abc\\\"") (TOK_SELEXPR 'abc\\\\') (TOK_SELEXPR "abc\\\\") (TOK_SELEXPR 'abc\\\\\'') (TOK_SELEXPR "abc\\\\\"") (TOK_SELEXPR 'abc\\\\\\') (TOK_SELEXPR "abc\\\\\\") (TOK_SELEXPR 'abc""""\\') (TOK_SELEXPR "abc''''\\") (TOK_SELEXPR "awk '{print NR\"\\t\"$0}'") (TOK_SELEXPR 'tab\ttab') (TOK_SELEXPR "tab\ttab")) (TOK_LIMIT 1)))
 
 STAGE DEPENDENCIES:
-  Stage-1 is a root stage
   Stage-0 is a root stage
 
 STAGE PLANS:
-  Stage: Stage-1
-    Map Reduce
-      Alias -> Map Operator Tree:
-        src 
-          TableScan
-            alias: src
-            Select Operator
-              expressions:
-                    expr: 'abc'
-                    type: string
-                    expr: 'abc'
-                    type: string
-                    expr: 'abc''
-                    type: string
-                    expr: 'abc"'
-                    type: string
-                    expr: 'abc\'
-                    type: string
-                    expr: 'abc\'
-                    type: string
-                    expr: 'abc\''
-                    type: string
-                    expr: 'abc\"'
-                    type: string
-                    expr: 'abc\\'
-                    type: string
-                    expr: 'abc\\'
-                    type: string
-                    expr: 'abc\\''
-                    type: string
-                    expr: 'abc\\"'
-                    type: string
-                    expr: 'abc\\\'
-                    type: string
-                    expr: 'abc\\\'
-                    type: string
-                    expr: 'abc""""\'
-                    type: string
-                    expr: 'abc''''\'
-                    type: string
-                    expr: 'awk '{print NR"\t"$0}''
-                    type: string
-                    expr: 'tab	tab'
-                    type: string
-                    expr: 'tab	tab'
-                    type: string
-              outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18
-              Limit
-                File Output Operator
-                  compressed: false
-                  GlobalTableId: 0
-                  table:
-                      input format: org.apache.hadoop.mapred.TextInputFormat
-                      output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                      serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
   Stage: Stage-0
     Fetch Operator
       limit: 1
+      Processor Tree:
+        TableScan
+          alias: src
+          Select Operator
+            expressions:
+                  expr: 'abc'
+                  type: string
+                  expr: 'abc'
+                  type: string
+                  expr: 'abc''
+                  type: string
+                  expr: 'abc"'
+                  type: string
+                  expr: 'abc\'
+                  type: string
+                  expr: 'abc\'
+                  type: string
+                  expr: 'abc\''
+                  type: string
+                  expr: 'abc\"'
+                  type: string
+                  expr: 'abc\\'
+                  type: string
+                  expr: 'abc\\'
+                  type: string
+                  expr: 'abc\\''
+                  type: string
+                  expr: 'abc\\"'
+                  type: string
+                  expr: 'abc\\\'
+                  type: string
+                  expr: 'abc\\\'
+                  type: string
+                  expr: 'abc""""\'
+                  type: string
+                  expr: 'abc''''\'
+                  type: string
+                  expr: 'awk '{print NR"\t"$0}''
+                  type: string
+                  expr: 'tab	tab'
+                  type: string
+                  expr: 'tab	tab'
+                  type: string
+            outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18
+            Limit
+              ListSink
 
 
 PREHOOK: query: SELECT

Modified: hive/trunk/ql/src/test/results/clientpositive/str_to_map.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/str_to_map.q.out?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/str_to_map.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/str_to_map.q.out Thu Oct 31 16:00:36 2013
@@ -17,33 +17,22 @@ ABSTRACT SYNTAX TREE:
   (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR ([ (TOK_FUNCTION str_to_map 'a=1,b=2,c=3' ',' '=') 'a'))) (TOK_LIMIT 3)))
 
 STAGE DEPENDENCIES:
-  Stage-1 is a root stage
   Stage-0 is a root stage
 
 STAGE PLANS:
-  Stage: Stage-1
-    Map Reduce
-      Alias -> Map Operator Tree:
-        src 
-          TableScan
-            alias: src
-            Select Operator
-              expressions:
-                    expr: str_to_map('a=1,b=2,c=3',',','=')['a']
-                    type: string
-              outputColumnNames: _col0
-              Limit
-                File Output Operator
-                  compressed: false
-                  GlobalTableId: 0
-                  table:
-                      input format: org.apache.hadoop.mapred.TextInputFormat
-                      output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                      serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
   Stage: Stage-0
     Fetch Operator
       limit: 3
+      Processor Tree:
+        TableScan
+          alias: src
+          Select Operator
+            expressions:
+                  expr: str_to_map('a=1,b=2,c=3',',','=')['a']
+                  type: string
+            outputColumnNames: _col0
+            Limit
+              ListSink
 
 
 PREHOOK: query: select str_to_map('a=1,b=2,c=3',',','=')['a'] from src limit 3
@@ -65,33 +54,22 @@ ABSTRACT SYNTAX TREE:
   (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION str_to_map 'a:1,b:2,c:3'))) (TOK_LIMIT 3)))
 
 STAGE DEPENDENCIES:
-  Stage-1 is a root stage
   Stage-0 is a root stage
 
 STAGE PLANS:
-  Stage: Stage-1
-    Map Reduce
-      Alias -> Map Operator Tree:
-        src 
-          TableScan
-            alias: src
-            Select Operator
-              expressions:
-                    expr: str_to_map('a:1,b:2,c:3')
-                    type: map<string,string>
-              outputColumnNames: _col0
-              Limit
-                File Output Operator
-                  compressed: false
-                  GlobalTableId: 0
-                  table:
-                      input format: org.apache.hadoop.mapred.TextInputFormat
-                      output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                      serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
   Stage: Stage-0
     Fetch Operator
       limit: 3
+      Processor Tree:
+        TableScan
+          alias: src
+          Select Operator
+            expressions:
+                  expr: str_to_map('a:1,b:2,c:3')
+                  type: map<string,string>
+            outputColumnNames: _col0
+            Limit
+              ListSink
 
 
 PREHOOK: query: select str_to_map('a:1,b:2,c:3') from src limit 3
@@ -113,33 +91,22 @@ ABSTRACT SYNTAX TREE:
   (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION str_to_map 'a:1,b:2,c:3' ',' ':'))) (TOK_LIMIT 3)))
 
 STAGE DEPENDENCIES:
-  Stage-1 is a root stage
   Stage-0 is a root stage
 
 STAGE PLANS:
-  Stage: Stage-1
-    Map Reduce
-      Alias -> Map Operator Tree:
-        src 
-          TableScan
-            alias: src
-            Select Operator
-              expressions:
-                    expr: str_to_map('a:1,b:2,c:3',',',':')
-                    type: map<string,string>
-              outputColumnNames: _col0
-              Limit
-                File Output Operator
-                  compressed: false
-                  GlobalTableId: 0
-                  table:
-                      input format: org.apache.hadoop.mapred.TextInputFormat
-                      output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                      serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
   Stage: Stage-0
     Fetch Operator
       limit: 3
+      Processor Tree:
+        TableScan
+          alias: src
+          Select Operator
+            expressions:
+                  expr: str_to_map('a:1,b:2,c:3',',',':')
+                  type: map<string,string>
+            outputColumnNames: _col0
+            Limit
+              ListSink
 
 
 PREHOOK: query: select str_to_map('a:1,b:2,c:3',',',':') from src limit 3
@@ -224,10 +191,10 @@ PREHOOK: query: drop table tbl_s2m
 PREHOOK: type: DROPTABLE
 POSTHOOK: query: drop table tbl_s2m
 POSTHOOK: type: DROPTABLE
-PREHOOK: query: create table tbl_s2m as select 'ABC=CC_333=444' as t from src limit 3
+PREHOOK: query: create table tbl_s2m as select 'ABC=CC_333=444' as t from src tablesample (3 rows)
 PREHOOK: type: CREATETABLE_AS_SELECT
 PREHOOK: Input: default@src
-POSTHOOK: query: create table tbl_s2m as select 'ABC=CC_333=444' as t from src limit 3
+POSTHOOK: query: create table tbl_s2m as select 'ABC=CC_333=444' as t from src tablesample (3 rows)
 POSTHOOK: type: CREATETABLE_AS_SELECT
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@tbl_s2m

Modified: hive/trunk/ql/src/test/results/clientpositive/test_boolean_whereclause.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/test_boolean_whereclause.q.out?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/test_boolean_whereclause.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/test_boolean_whereclause.q.out Thu Oct 31 16:00:36 2013
@@ -3,11 +3,11 @@ PREHOOK: type: CREATETABLE
 POSTHOOK: query: create table if not exists test_boolean(dummy tinyint)
 POSTHOOK: type: CREATETABLE
 POSTHOOK: Output: default@test_boolean
-PREHOOK: query: insert overwrite table test_boolean  select 1 from src limit 1
+PREHOOK: query: insert overwrite table test_boolean  select 1 from src tablesample (1 rows)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@test_boolean
-POSTHOOK: query: insert overwrite table test_boolean  select 1 from src limit 1
+POSTHOOK: query: insert overwrite table test_boolean  select 1 from src tablesample (1 rows)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@test_boolean

Modified: hive/trunk/ql/src/test/results/clientpositive/timestamp_1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/timestamp_1.q.out?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/timestamp_1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/timestamp_1.q.out Thu Oct 31 16:00:36 2013
@@ -15,13 +15,13 @@ POSTHOOK: query: alter table timestamp_1
 POSTHOOK: type: ALTERTABLE_SERIALIZER
 POSTHOOK: Input: default@timestamp_1
 POSTHOOK: Output: default@timestamp_1
-PREHOOK: query: insert overwrite table timestamp_1 
-  select cast('2011-01-01 01:01:01' as timestamp) from src limit 1
+PREHOOK: query: insert overwrite table timestamp_1
+  select cast('2011-01-01 01:01:01' as timestamp) from src tablesample (1 rows)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@timestamp_1
-POSTHOOK: query: insert overwrite table timestamp_1 
-  select cast('2011-01-01 01:01:01' as timestamp) from src limit 1
+POSTHOOK: query: insert overwrite table timestamp_1
+  select cast('2011-01-01 01:01:01' as timestamp) from src tablesample (1 rows)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@timestamp_1
@@ -107,12 +107,12 @@ POSTHOOK: Input: default@timestamp_1
 POSTHOOK: Lineage: timestamp_1.t EXPRESSION []
 2011-01-01 01:01:01
 PREHOOK: query: insert overwrite table timestamp_1
-  select '2011-01-01 01:01:01' from src limit 1
+  select '2011-01-01 01:01:01' from src tablesample (1 rows)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@timestamp_1
 POSTHOOK: query: insert overwrite table timestamp_1
-  select '2011-01-01 01:01:01' from src limit 1
+  select '2011-01-01 01:01:01' from src tablesample (1 rows)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@timestamp_1
@@ -207,12 +207,12 @@ POSTHOOK: Lineage: timestamp_1.t EXPRESS
 POSTHOOK: Lineage: timestamp_1.t EXPRESSION []
 2011-01-01 01:01:01
 PREHOOK: query: insert overwrite table timestamp_1
-  select '2011-01-01 01:01:01.1' from src limit 1
+  select '2011-01-01 01:01:01.1' from src tablesample (1 rows)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@timestamp_1
 POSTHOOK: query: insert overwrite table timestamp_1
-  select '2011-01-01 01:01:01.1' from src limit 1
+  select '2011-01-01 01:01:01.1' from src tablesample (1 rows)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@timestamp_1
@@ -316,12 +316,12 @@ POSTHOOK: Lineage: timestamp_1.t EXPRESS
 POSTHOOK: Lineage: timestamp_1.t EXPRESSION []
 2011-01-01 01:01:01.1
 PREHOOK: query: insert overwrite table timestamp_1
-  select '2011-01-01 01:01:01.0001' from src limit 1
+  select '2011-01-01 01:01:01.0001' from src tablesample (1 rows)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@timestamp_1
 POSTHOOK: query: insert overwrite table timestamp_1
-  select '2011-01-01 01:01:01.0001' from src limit 1
+  select '2011-01-01 01:01:01.0001' from src tablesample (1 rows)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@timestamp_1
@@ -434,12 +434,12 @@ POSTHOOK: Lineage: timestamp_1.t EXPRESS
 POSTHOOK: Lineage: timestamp_1.t EXPRESSION []
 2011-01-01 01:01:01.0001
 PREHOOK: query: insert overwrite table timestamp_1
-  select '2011-01-01 01:01:01.000100000' from src limit 1
+  select '2011-01-01 01:01:01.000100000' from src tablesample (1 rows)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@timestamp_1
 POSTHOOK: query: insert overwrite table timestamp_1
-  select '2011-01-01 01:01:01.000100000' from src limit 1
+  select '2011-01-01 01:01:01.000100000' from src tablesample (1 rows)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@timestamp_1
@@ -561,12 +561,12 @@ POSTHOOK: Lineage: timestamp_1.t EXPRESS
 POSTHOOK: Lineage: timestamp_1.t EXPRESSION []
 2011-01-01 01:01:01.0001
 PREHOOK: query: insert overwrite table timestamp_1
-  select '2011-01-01 01:01:01.001000011' from src limit 1
+  select '2011-01-01 01:01:01.001000011' from src tablesample (1 rows)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@timestamp_1
 POSTHOOK: query: insert overwrite table timestamp_1
-  select '2011-01-01 01:01:01.001000011' from src limit 1
+  select '2011-01-01 01:01:01.001000011' from src tablesample (1 rows)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@timestamp_1

Modified: hive/trunk/ql/src/test/results/clientpositive/timestamp_2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/timestamp_2.q.out?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/timestamp_2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/timestamp_2.q.out Thu Oct 31 16:00:36 2013
@@ -15,13 +15,13 @@ POSTHOOK: query: alter table timestamp_2
 POSTHOOK: type: ALTERTABLE_SERIALIZER
 POSTHOOK: Input: default@timestamp_2
 POSTHOOK: Output: default@timestamp_2
-PREHOOK: query: insert overwrite table timestamp_2 
-  select cast('2011-01-01 01:01:01' as timestamp) from src limit 1
+PREHOOK: query: insert overwrite table timestamp_2
+  select cast('2011-01-01 01:01:01' as timestamp) from src tablesample (1 rows)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@timestamp_2
-POSTHOOK: query: insert overwrite table timestamp_2 
-  select cast('2011-01-01 01:01:01' as timestamp) from src limit 1
+POSTHOOK: query: insert overwrite table timestamp_2
+  select cast('2011-01-01 01:01:01' as timestamp) from src tablesample (1 rows)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@timestamp_2
@@ -107,12 +107,12 @@ POSTHOOK: Input: default@timestamp_2
 POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
 2011-01-01 01:01:01
 PREHOOK: query: insert overwrite table timestamp_2
-  select '2011-01-01 01:01:01' from src limit 1
+  select '2011-01-01 01:01:01' from src tablesample (1 rows)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@timestamp_2
 POSTHOOK: query: insert overwrite table timestamp_2
-  select '2011-01-01 01:01:01' from src limit 1
+  select '2011-01-01 01:01:01' from src tablesample (1 rows)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@timestamp_2
@@ -207,12 +207,12 @@ POSTHOOK: Lineage: timestamp_2.t EXPRESS
 POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
 2011-01-01 01:01:01
 PREHOOK: query: insert overwrite table timestamp_2
-  select '2011-01-01 01:01:01.1' from src limit 1
+  select '2011-01-01 01:01:01.1' from src tablesample (1 rows)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@timestamp_2
 POSTHOOK: query: insert overwrite table timestamp_2
-  select '2011-01-01 01:01:01.1' from src limit 1
+  select '2011-01-01 01:01:01.1' from src tablesample (1 rows)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@timestamp_2
@@ -316,12 +316,12 @@ POSTHOOK: Lineage: timestamp_2.t EXPRESS
 POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
 2011-01-01 01:01:01.1
 PREHOOK: query: insert overwrite table timestamp_2
-  select '2011-01-01 01:01:01.0001' from src limit 1
+  select '2011-01-01 01:01:01.0001' from src tablesample (1 rows)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@timestamp_2
 POSTHOOK: query: insert overwrite table timestamp_2
-  select '2011-01-01 01:01:01.0001' from src limit 1
+  select '2011-01-01 01:01:01.0001' from src tablesample (1 rows)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@timestamp_2
@@ -434,12 +434,12 @@ POSTHOOK: Lineage: timestamp_2.t EXPRESS
 POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
 2011-01-01 01:01:01.0001
 PREHOOK: query: insert overwrite table timestamp_2
-  select '2011-01-01 01:01:01.000100000' from src limit 1
+  select '2011-01-01 01:01:01.000100000' from src tablesample (1 rows)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@timestamp_2
 POSTHOOK: query: insert overwrite table timestamp_2
-  select '2011-01-01 01:01:01.000100000' from src limit 1
+  select '2011-01-01 01:01:01.000100000' from src tablesample (1 rows)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@timestamp_2
@@ -561,12 +561,12 @@ POSTHOOK: Lineage: timestamp_2.t EXPRESS
 POSTHOOK: Lineage: timestamp_2.t EXPRESSION []
 2011-01-01 01:01:01.0001
 PREHOOK: query: insert overwrite table timestamp_2
-  select '2011-01-01 01:01:01.001000011' from src limit 1
+  select '2011-01-01 01:01:01.001000011' from src tablesample (1 rows)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@timestamp_2
 POSTHOOK: query: insert overwrite table timestamp_2
-  select '2011-01-01 01:01:01.001000011' from src limit 1
+  select '2011-01-01 01:01:01.001000011' from src tablesample (1 rows)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@timestamp_2

Modified: hive/trunk/ql/src/test/results/clientpositive/timestamp_3.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/timestamp_3.q.out?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/timestamp_3.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/timestamp_3.q.out Thu Oct 31 16:00:36 2013
@@ -15,13 +15,13 @@ POSTHOOK: query: alter table timestamp_3
 POSTHOOK: type: ALTERTABLE_SERIALIZER
 POSTHOOK: Input: default@timestamp_3
 POSTHOOK: Output: default@timestamp_3
-PREHOOK: query: insert overwrite table timestamp_3 
-  select cast(cast('1.3041352164485E9' as double) as timestamp) from src limit 1
+PREHOOK: query: insert overwrite table timestamp_3
+  select cast(cast('1.3041352164485E9' as double) as timestamp) from src tablesample (1 rows)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@timestamp_3
-POSTHOOK: query: insert overwrite table timestamp_3 
-  select cast(cast('1.3041352164485E9' as double) as timestamp) from src limit 1
+POSTHOOK: query: insert overwrite table timestamp_3
+  select cast(cast('1.3041352164485E9' as double) as timestamp) from src tablesample (1 rows)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@timestamp_3

Modified: hive/trunk/ql/src/test/results/clientpositive/timestamp_comparison.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/timestamp_comparison.q.out?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/timestamp_comparison.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/timestamp_comparison.q.out Thu Oct 31 16:00:36 2013
@@ -1,9 +1,9 @@
-PREHOOK: query: select cast('2011-05-06 07:08:09' as timestamp) > 
+PREHOOK: query: select cast('2011-05-06 07:08:09' as timestamp) >
   cast('2011-05-06 07:08:09' as timestamp) from src limit 1
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 #### A masked pattern was here ####
-POSTHOOK: query: select cast('2011-05-06 07:08:09' as timestamp) > 
+POSTHOOK: query: select cast('2011-05-06 07:08:09' as timestamp) >
   cast('2011-05-06 07:08:09' as timestamp) from src limit 1
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src

Modified: hive/trunk/ql/src/test/results/clientpositive/timestamp_lazy.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/timestamp_lazy.q.out?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/timestamp_lazy.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/timestamp_lazy.q.out Thu Oct 31 16:00:36 2013
@@ -7,11 +7,11 @@ PREHOOK: type: CREATETABLE
 POSTHOOK: query: create table timestamp_lazy (t timestamp, key string, value string)
 POSTHOOK: type: CREATETABLE
 POSTHOOK: Output: default@timestamp_lazy
-PREHOOK: query: insert overwrite table timestamp_lazy select cast('2011-01-01 01:01:01' as timestamp), key, value from src limit 5
+PREHOOK: query: insert overwrite table timestamp_lazy select cast('2011-01-01 01:01:01' as timestamp), key, value from src tablesample (5 rows)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@timestamp_lazy
-POSTHOOK: query: insert overwrite table timestamp_lazy select cast('2011-01-01 01:01:01' as timestamp), key, value from src limit 5
+POSTHOOK: query: insert overwrite table timestamp_lazy select cast('2011-01-01 01:01:01' as timestamp), key, value from src tablesample (5 rows)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@timestamp_lazy

Modified: hive/trunk/ql/src/test/results/clientpositive/timestamp_udf.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/timestamp_udf.q.out?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/timestamp_udf.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/timestamp_udf.q.out Thu Oct 31 16:00:36 2013
@@ -16,20 +16,20 @@ PREHOOK: type: CREATETABLE
 POSTHOOK: query: create table timestamp_udf_string (t string)
 POSTHOOK: type: CREATETABLE
 POSTHOOK: Output: default@timestamp_udf_string
-PREHOOK: query: from src
+PREHOOK: query: from (select * from src tablesample (1 rows)) s
   insert overwrite table timestamp_udf 
-    select '2011-05-06 07:08:09.1234567' limit 1
+    select '2011-05-06 07:08:09.1234567'
   insert overwrite table timestamp_udf_string
-    select '2011-05-06 07:08:09.1234567' limit 1
+    select '2011-05-06 07:08:09.1234567'
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@timestamp_udf
 PREHOOK: Output: default@timestamp_udf_string
-POSTHOOK: query: from src
+POSTHOOK: query: from (select * from src tablesample (1 rows)) s
   insert overwrite table timestamp_udf 
-    select '2011-05-06 07:08:09.1234567' limit 1
+    select '2011-05-06 07:08:09.1234567'
   insert overwrite table timestamp_udf_string
-    select '2011-05-06 07:08:09.1234567' limit 1
+    select '2011-05-06 07:08:09.1234567'
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@timestamp_udf

Modified: hive/trunk/ql/src/test/results/clientpositive/transform1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/transform1.q.out?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/transform1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/transform1.q.out Thu Oct 31 16:00:36 2013
@@ -63,12 +63,12 @@ POSTHOOK: query: create table transform1
 POSTHOOK: type: CREATETABLE
 POSTHOOK: Output: default@transform1_t2
 PREHOOK: query: insert overwrite table transform1_t2
-select array(1,2,3) from src limit 1
+select array(1,2,3) from src tablesample (1 rows)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@transform1_t2
 POSTHOOK: query: insert overwrite table transform1_t2
-select array(1,2,3) from src limit 1
+select array(1,2,3) from src tablesample (1 rows)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@transform1_t2

Modified: hive/trunk/ql/src/test/results/clientpositive/truncate_column.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/truncate_column.q.out?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/truncate_column.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/truncate_column.q.out Thu Oct 31 16:00:36 2013
@@ -9,11 +9,11 @@ CREATE TABLE test_tab (key STRING, value
 ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe' STORED AS RCFILE
 POSTHOOK: type: CREATETABLE
 POSTHOOK: Output: default@test_tab
-PREHOOK: query: INSERT OVERWRITE TABLE test_tab SELECT * FROM src LIMIT 10
+PREHOOK: query: INSERT OVERWRITE TABLE test_tab SELECT * FROM src tablesample (10 rows)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@test_tab
-POSTHOOK: query: INSERT OVERWRITE TABLE test_tab SELECT * FROM src LIMIT 10
+POSTHOOK: query: INSERT OVERWRITE TABLE test_tab SELECT * FROM src tablesample (10 rows)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@test_tab
@@ -146,12 +146,12 @@ NULL	val_484
 NULL	val_86
 NULL	val_98
 PREHOOK: query: -- Truncate multiple columns
-INSERT OVERWRITE TABLE test_tab SELECT * FROM src LIMIT 10
+INSERT OVERWRITE TABLE test_tab SELECT * FROM src tablesample (10 rows)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@test_tab
 POSTHOOK: query: -- Truncate multiple columns
-INSERT OVERWRITE TABLE test_tab SELECT * FROM src LIMIT 10
+INSERT OVERWRITE TABLE test_tab SELECT * FROM src tablesample (10 rows)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@test_tab
@@ -323,11 +323,11 @@ POSTHOOK: Lineage: test_tab.key SIMPLE [
 POSTHOOK: Lineage: test_tab.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: test_tab.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 POSTHOOK: Lineage: test_tab.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: INSERT OVERWRITE TABLE test_tab SELECT * FROM src LIMIT 10
+PREHOOK: query: INSERT OVERWRITE TABLE test_tab SELECT * FROM src tablesample (10 rows)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@test_tab
-POSTHOOK: query: INSERT OVERWRITE TABLE test_tab SELECT * FROM src LIMIT 10
+POSTHOOK: query: INSERT OVERWRITE TABLE test_tab SELECT * FROM src tablesample (10 rows)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@test_tab
@@ -581,11 +581,11 @@ POSTHOOK: Lineage: test_tab.key SIMPLE [
 POSTHOOK: Lineage: test_tab.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 POSTHOOK: Lineage: test_tab.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 POSTHOOK: Lineage: test_tab.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: INSERT OVERWRITE TABLE test_tab_part PARTITION (part = '1') SELECT * FROM src LIMIT 10
+PREHOOK: query: INSERT OVERWRITE TABLE test_tab_part PARTITION (part = '1') SELECT * FROM src tablesample (10 rows)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@test_tab_part@part=1
-POSTHOOK: query: INSERT OVERWRITE TABLE test_tab_part PARTITION (part = '1') SELECT * FROM src LIMIT 10
+POSTHOOK: query: INSERT OVERWRITE TABLE test_tab_part PARTITION (part = '1') SELECT * FROM src tablesample (10 rows)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@test_tab_part@part=1

Modified: hive/trunk/ql/src/test/results/clientpositive/truncate_column_merge.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/truncate_column_merge.q.out?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/truncate_column_merge.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/truncate_column_merge.q.out Thu Oct 31 16:00:36 2013
@@ -7,21 +7,21 @@ POSTHOOK: query: -- Tests truncating a c
 CREATE TABLE test_tab (key STRING, value STRING) STORED AS RCFILE
 POSTHOOK: type: CREATETABLE
 POSTHOOK: Output: default@test_tab
-PREHOOK: query: INSERT OVERWRITE TABLE test_tab SELECT * FROM src LIMIT 5
+PREHOOK: query: INSERT OVERWRITE TABLE test_tab SELECT * FROM src tablesample (5 rows)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@test_tab
-POSTHOOK: query: INSERT OVERWRITE TABLE test_tab SELECT * FROM src LIMIT 5
+POSTHOOK: query: INSERT OVERWRITE TABLE test_tab SELECT * FROM src tablesample (5 rows)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@test_tab
 POSTHOOK: Lineage: test_tab.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: test_tab.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: INSERT INTO TABLE test_tab SELECT * FROM src LIMIT 5
+PREHOOK: query: INSERT INTO TABLE test_tab SELECT * FROM src tablesample (5 rows)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@test_tab
-POSTHOOK: query: INSERT INTO TABLE test_tab SELECT * FROM src LIMIT 5
+POSTHOOK: query: INSERT INTO TABLE test_tab SELECT * FROM src tablesample (5 rows)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@test_tab

Modified: hive/trunk/ql/src/test/results/clientpositive/type_cast_1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/type_cast_1.q.out?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/type_cast_1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/type_cast_1.q.out Thu Oct 31 16:00:36 2013
@@ -8,33 +8,22 @@ ABSTRACT SYNTAX TREE:
   (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (+ (TOK_FUNCTION IF false 1 (TOK_FUNCTION TOK_SMALLINT 2)) 3))) (TOK_LIMIT 1)))
 
 STAGE DEPENDENCIES:
-  Stage-1 is a root stage
   Stage-0 is a root stage
 
 STAGE PLANS:
-  Stage: Stage-1
-    Map Reduce
-      Alias -> Map Operator Tree:
-        src 
-          TableScan
-            alias: src
-            Select Operator
-              expressions:
-                    expr: (if(false, 1, UDFToShort(2)) + 3)
-                    type: int
-              outputColumnNames: _col0
-              Limit
-                File Output Operator
-                  compressed: false
-                  GlobalTableId: 0
-                  table:
-                      input format: org.apache.hadoop.mapred.TextInputFormat
-                      output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                      serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
   Stage: Stage-0
     Fetch Operator
       limit: 1
+      Processor Tree:
+        TableScan
+          alias: src
+          Select Operator
+            expressions:
+                  expr: (if(false, 1, UDFToShort(2)) + 3)
+                  type: int
+            outputColumnNames: _col0
+            Limit
+              ListSink
 
 
 PREHOOK: query: SELECT IF(false, 1, cast(2 as smallint)) + 3 FROM src LIMIT 1

Modified: hive/trunk/ql/src/test/results/clientpositive/type_widening.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/type_widening.q.out?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/type_widening.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/type_widening.q.out Thu Oct 31 16:00:36 2013
@@ -8,33 +8,22 @@ ABSTRACT SYNTAX TREE:
   (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION COALESCE 0 9223372036854775807))) (TOK_LIMIT 1)))
 
 STAGE DEPENDENCIES:
-  Stage-1 is a root stage
   Stage-0 is a root stage
 
 STAGE PLANS:
-  Stage: Stage-1
-    Map Reduce
-      Alias -> Map Operator Tree:
-        src 
-          TableScan
-            alias: src
-            Select Operator
-              expressions:
-                    expr: COALESCE(0,9223372036854775807)
-                    type: bigint
-              outputColumnNames: _col0
-              Limit
-                File Output Operator
-                  compressed: false
-                  GlobalTableId: 0
-                  table:
-                      input format: org.apache.hadoop.mapred.TextInputFormat
-                      output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                      serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
   Stage: Stage-0
     Fetch Operator
       limit: 1
+      Processor Tree:
+        TableScan
+          alias: src
+          Select Operator
+            expressions:
+                  expr: COALESCE(0,9223372036854775807)
+                  type: bigint
+            outputColumnNames: _col0
+            Limit
+              ListSink
 
 
 PREHOOK: query: SELECT COALESCE(0, 9223372036854775807) FROM src LIMIT 1

Modified: hive/trunk/ql/src/test/results/clientpositive/udf_E.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf_E.q.out?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udf_E.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udf_E.q.out Thu Oct 31 16:00:36 2013
@@ -1,47 +1,36 @@
-PREHOOK: query: explain 
-select E() FROM src LIMIT 1
+PREHOOK: query: explain
+select E() FROM src tablesample (1 rows)
 PREHOOK: type: QUERY
-POSTHOOK: query: explain 
-select E() FROM src LIMIT 1
+POSTHOOK: query: explain
+select E() FROM src tablesample (1 rows)
 POSTHOOK: type: QUERY
 ABSTRACT SYNTAX TREE:
-  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION E))) (TOK_LIMIT 1)))
+  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src) (TOK_TABLESPLITSAMPLE TOK_ROWCOUNT 1))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION E)))))
 
 STAGE DEPENDENCIES:
-  Stage-1 is a root stage
   Stage-0 is a root stage
 
 STAGE PLANS:
-  Stage: Stage-1
-    Map Reduce
-      Alias -> Map Operator Tree:
-        src 
-          TableScan
-            alias: src
-            Select Operator
-              expressions:
-                    expr: e()
-                    type: double
-              outputColumnNames: _col0
-              Limit
-                File Output Operator
-                  compressed: false
-                  GlobalTableId: 0
-                  table:
-                      input format: org.apache.hadoop.mapred.TextInputFormat
-                      output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                      serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
   Stage: Stage-0
     Fetch Operator
-      limit: 1
+      limit: -1
+      Processor Tree:
+        TableScan
+          alias: src
+          Row Limit Per Split: 1
+          Select Operator
+            expressions:
+                  expr: e()
+                  type: double
+            outputColumnNames: _col0
+            ListSink
 
 
-PREHOOK: query: select E() FROM src LIMIT 1
+PREHOOK: query: select E() FROM src tablesample (1 rows)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 #### A masked pattern was here ####
-POSTHOOK: query: select E() FROM src LIMIT 1
+POSTHOOK: query: select E() FROM src tablesample (1 rows)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 #### A masked pattern was here ####
@@ -61,49 +50,38 @@ Example:
  > SELECT E() FROM src LIMIT 1;
  2.718281828459045
 PREHOOK: query: explain 
-select E() FROM src LIMIT 1
+select E() FROM src tablesample (1 rows)
 PREHOOK: type: QUERY
 POSTHOOK: query: explain 
-select E() FROM src LIMIT 1
+select E() FROM src tablesample (1 rows)
 POSTHOOK: type: QUERY
 ABSTRACT SYNTAX TREE:
-  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION E))) (TOK_LIMIT 1)))
+  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src) (TOK_TABLESPLITSAMPLE TOK_ROWCOUNT 1))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION E)))))
 
 STAGE DEPENDENCIES:
-  Stage-1 is a root stage
   Stage-0 is a root stage
 
 STAGE PLANS:
-  Stage: Stage-1
-    Map Reduce
-      Alias -> Map Operator Tree:
-        src 
-          TableScan
-            alias: src
-            Select Operator
-              expressions:
-                    expr: e()
-                    type: double
-              outputColumnNames: _col0
-              Limit
-                File Output Operator
-                  compressed: false
-                  GlobalTableId: 0
-                  table:
-                      input format: org.apache.hadoop.mapred.TextInputFormat
-                      output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                      serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
   Stage: Stage-0
     Fetch Operator
-      limit: 1
+      limit: -1
+      Processor Tree:
+        TableScan
+          alias: src
+          Row Limit Per Split: 1
+          Select Operator
+            expressions:
+                  expr: e()
+                  type: double
+            outputColumnNames: _col0
+            ListSink
 
 
-PREHOOK: query: select E() FROM src LIMIT 1
+PREHOOK: query: select E() FROM src tablesample (1 rows)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 #### A masked pattern was here ####
-POSTHOOK: query: select E() FROM src LIMIT 1
+POSTHOOK: query: select E() FROM src tablesample (1 rows)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 #### A masked pattern was here ####

Modified: hive/trunk/ql/src/test/results/clientpositive/udf_PI.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf_PI.q.out?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udf_PI.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udf_PI.q.out Thu Oct 31 16:00:36 2013
@@ -1,47 +1,36 @@
-PREHOOK: query: explain 
-select PI() FROM src LIMIT 1
+PREHOOK: query: explain
+select PI() FROM src tablesample (1 rows)
 PREHOOK: type: QUERY
-POSTHOOK: query: explain 
-select PI() FROM src LIMIT 1
+POSTHOOK: query: explain
+select PI() FROM src tablesample (1 rows)
 POSTHOOK: type: QUERY
 ABSTRACT SYNTAX TREE:
-  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION PI))) (TOK_LIMIT 1)))
+  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src) (TOK_TABLESPLITSAMPLE TOK_ROWCOUNT 1))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION PI)))))
 
 STAGE DEPENDENCIES:
-  Stage-1 is a root stage
   Stage-0 is a root stage
 
 STAGE PLANS:
-  Stage: Stage-1
-    Map Reduce
-      Alias -> Map Operator Tree:
-        src 
-          TableScan
-            alias: src
-            Select Operator
-              expressions:
-                    expr: pi()
-                    type: double
-              outputColumnNames: _col0
-              Limit
-                File Output Operator
-                  compressed: false
-                  GlobalTableId: 0
-                  table:
-                      input format: org.apache.hadoop.mapred.TextInputFormat
-                      output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                      serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
   Stage: Stage-0
     Fetch Operator
-      limit: 1
+      limit: -1
+      Processor Tree:
+        TableScan
+          alias: src
+          Row Limit Per Split: 1
+          Select Operator
+            expressions:
+                  expr: pi()
+                  type: double
+            outputColumnNames: _col0
+            ListSink
 
 
-PREHOOK: query: select PI() FROM src LIMIT 1
+PREHOOK: query: select PI() FROM src tablesample (1 rows)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 #### A masked pattern was here ####
-POSTHOOK: query: select PI() FROM src LIMIT 1
+POSTHOOK: query: select PI() FROM src tablesample (1 rows)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 #### A masked pattern was here ####
@@ -61,49 +50,38 @@ Example:
  > SELECT PI() FROM src LIMIT 1;
  3.14159...
 PREHOOK: query: explain 
-select PI() FROM src LIMIT 1
+select PI() FROM src tablesample (1 rows)
 PREHOOK: type: QUERY
 POSTHOOK: query: explain 
-select PI() FROM src LIMIT 1
+select PI() FROM src tablesample (1 rows)
 POSTHOOK: type: QUERY
 ABSTRACT SYNTAX TREE:
-  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION PI))) (TOK_LIMIT 1)))
+  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src) (TOK_TABLESPLITSAMPLE TOK_ROWCOUNT 1))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION PI)))))
 
 STAGE DEPENDENCIES:
-  Stage-1 is a root stage
   Stage-0 is a root stage
 
 STAGE PLANS:
-  Stage: Stage-1
-    Map Reduce
-      Alias -> Map Operator Tree:
-        src 
-          TableScan
-            alias: src
-            Select Operator
-              expressions:
-                    expr: pi()
-                    type: double
-              outputColumnNames: _col0
-              Limit
-                File Output Operator
-                  compressed: false
-                  GlobalTableId: 0
-                  table:
-                      input format: org.apache.hadoop.mapred.TextInputFormat
-                      output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                      serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
   Stage: Stage-0
     Fetch Operator
-      limit: 1
+      limit: -1
+      Processor Tree:
+        TableScan
+          alias: src
+          Row Limit Per Split: 1
+          Select Operator
+            expressions:
+                  expr: pi()
+                  type: double
+            outputColumnNames: _col0
+            ListSink
 
 
-PREHOOK: query: select PI() FROM src LIMIT 1
+PREHOOK: query: select PI() FROM src tablesample (1 rows)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 #### A masked pattern was here ####
-POSTHOOK: query: select PI() FROM src LIMIT 1
+POSTHOOK: query: select PI() FROM src tablesample (1 rows)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 #### A masked pattern was here ####

Modified: hive/trunk/ql/src/test/results/clientpositive/udf_abs.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf_abs.q.out?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udf_abs.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udf_abs.q.out Thu Oct 31 16:00:36 2013
@@ -19,7 +19,7 @@ PREHOOK: query: EXPLAIN SELECT
   abs(123),
   abs(-9223372036854775807),
   abs(9223372036854775807)
-FROM src LIMIT 1
+FROM src tablesample (1 rows)
 PREHOOK: type: QUERY
 POSTHOOK: query: EXPLAIN SELECT
   abs(0),
@@ -27,47 +27,36 @@ POSTHOOK: query: EXPLAIN SELECT
   abs(123),
   abs(-9223372036854775807),
   abs(9223372036854775807)
-FROM src LIMIT 1
+FROM src tablesample (1 rows)
 POSTHOOK: type: QUERY
 ABSTRACT SYNTAX TREE:
-  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION abs 0)) (TOK_SELEXPR (TOK_FUNCTION abs (- 1))) (TOK_SELEXPR (TOK_FUNCTION abs 123)) (TOK_SELEXPR (TOK_FUNCTION abs (- 9223372036854775807))) (TOK_SELEXPR (TOK_FUNCTION abs 9223372036854775807))) (TOK_LIMIT 1)))
+  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src) (TOK_TABLESPLITSAMPLE TOK_ROWCOUNT 1))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION abs 0)) (TOK_SELEXPR (TOK_FUNCTION abs (- 1))) (TOK_SELEXPR (TOK_FUNCTION abs 123)) (TOK_SELEXPR (TOK_FUNCTION abs (- 9223372036854775807))) (TOK_SELEXPR (TOK_FUNCTION abs 9223372036854775807)))))
 
 STAGE DEPENDENCIES:
-  Stage-1 is a root stage
   Stage-0 is a root stage
 
 STAGE PLANS:
-  Stage: Stage-1
-    Map Reduce
-      Alias -> Map Operator Tree:
-        src 
-          TableScan
-            alias: src
-            Select Operator
-              expressions:
-                    expr: abs(0)
-                    type: int
-                    expr: abs((- 1))
-                    type: int
-                    expr: abs(123)
-                    type: int
-                    expr: abs((- 9223372036854775807))
-                    type: bigint
-                    expr: abs(9223372036854775807)
-                    type: bigint
-              outputColumnNames: _col0, _col1, _col2, _col3, _col4
-              Limit
-                File Output Operator
-                  compressed: false
-                  GlobalTableId: 0
-                  table:
-                      input format: org.apache.hadoop.mapred.TextInputFormat
-                      output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                      serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
   Stage: Stage-0
     Fetch Operator
-      limit: 1
+      limit: -1
+      Processor Tree:
+        TableScan
+          alias: src
+          Row Limit Per Split: 1
+          Select Operator
+            expressions:
+                  expr: abs(0)
+                  type: int
+                  expr: abs((- 1))
+                  type: int
+                  expr: abs(123)
+                  type: int
+                  expr: abs((- 9223372036854775807))
+                  type: bigint
+                  expr: abs(9223372036854775807)
+                  type: bigint
+            outputColumnNames: _col0, _col1, _col2, _col3, _col4
+            ListSink
 
 
 PREHOOK: query: SELECT
@@ -76,7 +65,7 @@ PREHOOK: query: SELECT
   abs(123),
   abs(-9223372036854775807),
   abs(9223372036854775807)
-FROM src LIMIT 1
+FROM src tablesample (1 rows)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 #### A masked pattern was here ####
@@ -86,7 +75,7 @@ POSTHOOK: query: SELECT
   abs(123),
   abs(-9223372036854775807),
   abs(9223372036854775807)
-FROM src LIMIT 1
+FROM src tablesample (1 rows)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 #### A masked pattern was here ####
@@ -95,56 +84,45 @@ PREHOOK: query: EXPLAIN SELECT
   abs(0.0),
   abs(-3.14159265),
   abs(3.14159265)
-FROM src LIMIT 1
+FROM src tablesample (1 rows)
 PREHOOK: type: QUERY
 POSTHOOK: query: EXPLAIN SELECT
   abs(0.0),
   abs(-3.14159265),
   abs(3.14159265)
-FROM src LIMIT 1
+FROM src tablesample (1 rows)
 POSTHOOK: type: QUERY
 ABSTRACT SYNTAX TREE:
-  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION abs 0.0)) (TOK_SELEXPR (TOK_FUNCTION abs (- 3.14159265))) (TOK_SELEXPR (TOK_FUNCTION abs 3.14159265))) (TOK_LIMIT 1)))
+  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src) (TOK_TABLESPLITSAMPLE TOK_ROWCOUNT 1))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION abs 0.0)) (TOK_SELEXPR (TOK_FUNCTION abs (- 3.14159265))) (TOK_SELEXPR (TOK_FUNCTION abs 3.14159265)))))
 
 STAGE DEPENDENCIES:
-  Stage-1 is a root stage
   Stage-0 is a root stage
 
 STAGE PLANS:
-  Stage: Stage-1
-    Map Reduce
-      Alias -> Map Operator Tree:
-        src 
-          TableScan
-            alias: src
-            Select Operator
-              expressions:
-                    expr: abs(0.0)
-                    type: double
-                    expr: abs((- 3.14159265))
-                    type: double
-                    expr: abs(3.14159265)
-                    type: double
-              outputColumnNames: _col0, _col1, _col2
-              Limit
-                File Output Operator
-                  compressed: false
-                  GlobalTableId: 0
-                  table:
-                      input format: org.apache.hadoop.mapred.TextInputFormat
-                      output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                      serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
   Stage: Stage-0
     Fetch Operator
-      limit: 1
+      limit: -1
+      Processor Tree:
+        TableScan
+          alias: src
+          Row Limit Per Split: 1
+          Select Operator
+            expressions:
+                  expr: abs(0.0)
+                  type: double
+                  expr: abs((- 3.14159265))
+                  type: double
+                  expr: abs(3.14159265)
+                  type: double
+            outputColumnNames: _col0, _col1, _col2
+            ListSink
 
 
 PREHOOK: query: SELECT
   abs(0.0),
   abs(-3.14159265),
   abs(3.14159265)
-FROM src LIMIT 1
+FROM src tablesample (1 rows)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 #### A masked pattern was here ####
@@ -152,7 +130,7 @@ POSTHOOK: query: SELECT
   abs(0.0),
   abs(-3.14159265),
   abs(3.14159265)
-FROM src LIMIT 1
+FROM src tablesample (1 rows)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 #### A masked pattern was here ####

Modified: hive/trunk/ql/src/test/results/clientpositive/udf_acos.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf_acos.q.out?rev=1537540&r1=1537539&r2=1537540&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udf_acos.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udf_acos.q.out Thu Oct 31 16:00:36 2013
@@ -14,45 +14,45 @@ Example:
   > SELECT acos(2) FROM src LIMIT 1;
   NULL
 PREHOOK: query: SELECT acos(null)
-FROM src LIMIT 1
+FROM src tablesample (1 rows)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 #### A masked pattern was here ####
 POSTHOOK: query: SELECT acos(null)
-FROM src LIMIT 1
+FROM src tablesample (1 rows)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 #### A masked pattern was here ####
 NULL
 PREHOOK: query: SELECT acos(0)
-FROM src LIMIT 1
+FROM src tablesample (1 rows)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 #### A masked pattern was here ####
 POSTHOOK: query: SELECT acos(0)
-FROM src LIMIT 1
+FROM src tablesample (1 rows)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 #### A masked pattern was here ####
 1.5707963267948966
 PREHOOK: query: SELECT acos(-0.5), asin(0.66)
-FROM src LIMIT 1
+FROM src tablesample (1 rows)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 #### A masked pattern was here ####
 POSTHOOK: query: SELECT acos(-0.5), asin(0.66)
-FROM src LIMIT 1
+FROM src tablesample (1 rows)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 #### A masked pattern was here ####
 2.0943951023931957	0.7208187608700897
 PREHOOK: query: SELECT acos(2)
-FROM src LIMIT 1
+FROM src tablesample (1 rows)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 #### A masked pattern was here ####
 POSTHOOK: query: SELECT acos(2)
-FROM src LIMIT 1
+FROM src tablesample (1 rows)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 #### A masked pattern was here ####



Mime
View raw message