You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by na...@apache.org on 2013/04/09 08:33:23 UTC
svn commit: r1465903 [11/13] - in /hive/trunk/ql/src/test:
queries/clientpositive/ results/clientpositive/
Modified: hive/trunk/ql/src/test/results/clientpositive/stats19.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/stats19.q.out?rev=1465903&r1=1465902&r2=1465903&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/stats19.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/stats19.q.out Tue Apr 9 06:33:16 2013
@@ -1,41 +1,27 @@
-PREHOOK: query: -- Note, its important that the partitions created below have a name greater than 16 characters in
--- length since KeyVerifyingStatsAggregator depends on checking that a keyPrefix is hashed by the
--- length of the keyPrefix, having a partition name greather than 16 characters guarantees no false
--- positives.
-
-create table stats_part like srcpart
+PREHOOK: query: create table stats_part like srcpart
PREHOOK: type: CREATETABLE
-POSTHOOK: query: -- Note, its important that the partitions created below have a name greater than 16 characters in
--- length since KeyVerifyingStatsAggregator depends on checking that a keyPrefix is hashed by the
--- length of the keyPrefix, having a partition name greather than 16 characters guarantees no false
--- positives.
-
-create table stats_part like srcpart
+POSTHOOK: query: create table stats_part like srcpart
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@stats_part
-PREHOOK: query: -- The stats key should be hashed since the max length is too small
-insert overwrite table stats_part partition (ds='2010-04-08', hr = '13') select key, value from src
+PREHOOK: query: insert overwrite table stats_part partition (ds='2010-04-08', hr = '13') select key, value from src
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@stats_part@ds=2010-04-08/hr=13
Stats prefix is hashed: true
Stats prefix is hashed: true
-POSTHOOK: query: -- The stats key should be hashed since the max length is too small
-insert overwrite table stats_part partition (ds='2010-04-08', hr = '13') select key, value from src
+POSTHOOK: query: insert overwrite table stats_part partition (ds='2010-04-08', hr = '13') select key, value from src
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@stats_part@ds=2010-04-08/hr=13
POSTHOOK: Lineage: stats_part PARTITION(ds=2010-04-08,hr=13).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: stats_part PARTITION(ds=2010-04-08,hr=13).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: -- The stats key should not be hashed since the max length is large enough
-insert overwrite table stats_part partition (ds='2010-04-08', hr = '13') select key, value from src
+PREHOOK: query: insert overwrite table stats_part partition (ds='2010-04-08', hr = '13') select key, value from src
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@stats_part@ds=2010-04-08/hr=13
Stats prefix is hashed: false
Stats prefix is hashed: false
-POSTHOOK: query: -- The stats key should not be hashed since the max length is large enough
-insert overwrite table stats_part partition (ds='2010-04-08', hr = '13') select key, value from src
+POSTHOOK: query: insert overwrite table stats_part partition (ds='2010-04-08', hr = '13') select key, value from src
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@stats_part@ds=2010-04-08/hr=13
@@ -43,15 +29,13 @@ POSTHOOK: Lineage: stats_part PARTITION(
POSTHOOK: Lineage: stats_part PARTITION(ds=2010-04-08,hr=13).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: stats_part PARTITION(ds=2010-04-08,hr=13).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: stats_part PARTITION(ds=2010-04-08,hr=13).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: -- The stats key should not be hashed since negative values should imply hashing is turned off
-insert overwrite table stats_part partition (ds='2010-04-08', hr = '13') select key, value from src
+PREHOOK: query: insert overwrite table stats_part partition (ds='2010-04-08', hr = '13') select key, value from src
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@stats_part@ds=2010-04-08/hr=13
Stats prefix is hashed: false
Stats prefix is hashed: false
-POSTHOOK: query: -- The stats key should not be hashed since negative values should imply hashing is turned off
-insert overwrite table stats_part partition (ds='2010-04-08', hr = '13') select key, value from src
+POSTHOOK: query: insert overwrite table stats_part partition (ds='2010-04-08', hr = '13') select key, value from src
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@stats_part@ds=2010-04-08/hr=13
@@ -61,19 +45,11 @@ POSTHOOK: Lineage: stats_part PARTITION(
POSTHOOK: Lineage: stats_part PARTITION(ds=2010-04-08,hr=13).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: stats_part PARTITION(ds=2010-04-08,hr=13).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: stats_part PARTITION(ds=2010-04-08,hr=13).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: -- Run the tests again and verify the stats are correct, this should verify that the stats publisher
--- is hashing as well where appropriate
-
--- The stats key should be hashed since the max length is too small
-insert overwrite table stats_part partition (ds='2010-04-08', hr = '13') select key, value from src
+PREHOOK: query: insert overwrite table stats_part partition (ds='2010-04-08', hr = '13') select key, value from src
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@stats_part@ds=2010-04-08/hr=13
-POSTHOOK: query: -- Run the tests again and verify the stats are correct, this should verify that the stats publisher
--- is hashing as well where appropriate
-
--- The stats key should be hashed since the max length is too small
-insert overwrite table stats_part partition (ds='2010-04-08', hr = '13') select key, value from src
+POSTHOOK: query: insert overwrite table stats_part partition (ds='2010-04-08', hr = '13') select key, value from src
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@stats_part@ds=2010-04-08/hr=13
@@ -132,13 +108,11 @@ Bucket Columns: []
Sort Columns: []
Storage Desc Params:
serialization.format 1
-PREHOOK: query: -- The stats key should not be hashed since the max length is large enough
-insert overwrite table stats_part partition (ds='2010-04-08', hr = '13') select key, value from src
+PREHOOK: query: insert overwrite table stats_part partition (ds='2010-04-08', hr = '13') select key, value from src
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@stats_part@ds=2010-04-08/hr=13
-POSTHOOK: query: -- The stats key should not be hashed since the max length is large enough
-insert overwrite table stats_part partition (ds='2010-04-08', hr = '13') select key, value from src
+POSTHOOK: query: insert overwrite table stats_part partition (ds='2010-04-08', hr = '13') select key, value from src
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@stats_part@ds=2010-04-08/hr=13
@@ -201,13 +175,11 @@ Bucket Columns: []
Sort Columns: []
Storage Desc Params:
serialization.format 1
-PREHOOK: query: -- The stats key should not be hashed since negative values should imply hashing is turned off
-insert overwrite table stats_part partition (ds='2010-04-08', hr = '13') select key, value from src
+PREHOOK: query: insert overwrite table stats_part partition (ds='2010-04-08', hr = '13') select key, value from src
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@stats_part@ds=2010-04-08/hr=13
-POSTHOOK: query: -- The stats key should not be hashed since negative values should imply hashing is turned off
-insert overwrite table stats_part partition (ds='2010-04-08', hr = '13') select key, value from src
+POSTHOOK: query: insert overwrite table stats_part partition (ds='2010-04-08', hr = '13') select key, value from src
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@stats_part@ds=2010-04-08/hr=13
@@ -274,19 +246,13 @@ Bucket Columns: []
Sort Columns: []
Storage Desc Params:
serialization.format 1
-PREHOOK: query: -- Do the same for dynamic partitions
-
--- The stats key should be hashed since the max length is too small
-insert overwrite table stats_part partition (ds='2010-04-08', hr) select key, value, '13' from src
+PREHOOK: query: insert overwrite table stats_part partition (ds='2010-04-08', hr) select key, value, '13' from src
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@stats_part@ds=2010-04-08
Stats prefix is hashed: true
Stats prefix is hashed: true
-POSTHOOK: query: -- Do the same for dynamic partitions
-
--- The stats key should be hashed since the max length is too small
-insert overwrite table stats_part partition (ds='2010-04-08', hr) select key, value, '13' from src
+POSTHOOK: query: insert overwrite table stats_part partition (ds='2010-04-08', hr) select key, value, '13' from src
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@stats_part@ds=2010-04-08/hr=13
@@ -304,15 +270,13 @@ POSTHOOK: Lineage: stats_part PARTITION(
POSTHOOK: Lineage: stats_part PARTITION(ds=2010-04-08,hr=13).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: stats_part PARTITION(ds=2010-04-08,hr=13).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: stats_part PARTITION(ds=2010-04-08,hr=13).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: -- The stats key should not be hashed since the max length is large enough
-insert overwrite table stats_part partition (ds='2010-04-08', hr) select key, value, '13' from src
+PREHOOK: query: insert overwrite table stats_part partition (ds='2010-04-08', hr) select key, value, '13' from src
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@stats_part@ds=2010-04-08
Stats prefix is hashed: false
Stats prefix is hashed: false
-POSTHOOK: query: -- The stats key should not be hashed since the max length is large enough
-insert overwrite table stats_part partition (ds='2010-04-08', hr) select key, value, '13' from src
+POSTHOOK: query: insert overwrite table stats_part partition (ds='2010-04-08', hr) select key, value, '13' from src
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@stats_part@ds=2010-04-08/hr=13
@@ -332,15 +296,13 @@ POSTHOOK: Lineage: stats_part PARTITION(
POSTHOOK: Lineage: stats_part PARTITION(ds=2010-04-08,hr=13).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: stats_part PARTITION(ds=2010-04-08,hr=13).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: stats_part PARTITION(ds=2010-04-08,hr=13).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: -- The stats key should not be hashed since negative values should imply hashing is turned off
-insert overwrite table stats_part partition (ds='2010-04-08', hr) select key, value, '13' from src
+PREHOOK: query: insert overwrite table stats_part partition (ds='2010-04-08', hr) select key, value, '13' from src
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@stats_part@ds=2010-04-08
Stats prefix is hashed: false
Stats prefix is hashed: false
-POSTHOOK: query: -- The stats key should not be hashed since negative values should imply hashing is turned off
-insert overwrite table stats_part partition (ds='2010-04-08', hr) select key, value, '13' from src
+POSTHOOK: query: insert overwrite table stats_part partition (ds='2010-04-08', hr) select key, value, '13' from src
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@stats_part@ds=2010-04-08/hr=13
@@ -362,19 +324,11 @@ POSTHOOK: Lineage: stats_part PARTITION(
POSTHOOK: Lineage: stats_part PARTITION(ds=2010-04-08,hr=13).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: stats_part PARTITION(ds=2010-04-08,hr=13).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: stats_part PARTITION(ds=2010-04-08,hr=13).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: -- Run the tests again and verify the stats are correct, this should verify that the stats publisher
--- is hashing as well where appropriate
-
--- The stats key should be hashed since the max length is too small
-insert overwrite table stats_part partition (ds='2010-04-08', hr) select key, value, '13' from src
+PREHOOK: query: insert overwrite table stats_part partition (ds='2010-04-08', hr) select key, value, '13' from src
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@stats_part@ds=2010-04-08
-POSTHOOK: query: -- Run the tests again and verify the stats are correct, this should verify that the stats publisher
--- is hashing as well where appropriate
-
--- The stats key should be hashed since the max length is too small
-insert overwrite table stats_part partition (ds='2010-04-08', hr) select key, value, '13' from src
+POSTHOOK: query: insert overwrite table stats_part partition (ds='2010-04-08', hr) select key, value, '13' from src
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@stats_part@ds=2010-04-08/hr=13
@@ -457,13 +411,11 @@ Bucket Columns: []
Sort Columns: []
Storage Desc Params:
serialization.format 1
-PREHOOK: query: -- The stats key should not be hashed since the max length is large enough
-insert overwrite table stats_part partition (ds='2010-04-08', hr) select key, value, '13' from src
+PREHOOK: query: insert overwrite table stats_part partition (ds='2010-04-08', hr) select key, value, '13' from src
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@stats_part@ds=2010-04-08
-POSTHOOK: query: -- The stats key should not be hashed since the max length is large enough
-insert overwrite table stats_part partition (ds='2010-04-08', hr) select key, value, '13' from src
+POSTHOOK: query: insert overwrite table stats_part partition (ds='2010-04-08', hr) select key, value, '13' from src
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@stats_part@ds=2010-04-08/hr=13
@@ -550,13 +502,11 @@ Bucket Columns: []
Sort Columns: []
Storage Desc Params:
serialization.format 1
-PREHOOK: query: -- The stats key should not be hashed since negative values should imply hashing is turned off
-insert overwrite table stats_part partition (ds='2010-04-08', hr) select key, value, '13' from src
+PREHOOK: query: insert overwrite table stats_part partition (ds='2010-04-08', hr) select key, value, '13' from src
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@stats_part@ds=2010-04-08
-POSTHOOK: query: -- The stats key should not be hashed since negative values should imply hashing is turned off
-insert overwrite table stats_part partition (ds='2010-04-08', hr) select key, value, '13' from src
+POSTHOOK: query: insert overwrite table stats_part partition (ds='2010-04-08', hr) select key, value, '13' from src
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@stats_part@ds=2010-04-08/hr=13
Modified: hive/trunk/ql/src/test/results/clientpositive/stats20.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/stats20.q.out?rev=1465903&r1=1465902&r2=1465903&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/stats20.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/stats20.q.out Tue Apr 9 06:33:16 2013
@@ -15,11 +15,9 @@ POSTHOOK: Input: default@src
POSTHOOK: Output: default@stats_partitioned@ds=1
POSTHOOK: Lineage: stats_partitioned PARTITION(ds=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: stats_partitioned PARTITION(ds=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: -- rawDataSize is 5312 after config is turned on
-describe formatted stats_partitioned
+PREHOOK: query: describe formatted stats_partitioned
PREHOOK: type: DESCTABLE
-POSTHOOK: query: -- rawDataSize is 5312 after config is turned on
-describe formatted stats_partitioned
+POSTHOOK: query: describe formatted stats_partitioned
POSTHOOK: type: DESCTABLE
POSTHOOK: Lineage: stats_partitioned PARTITION(ds=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: stats_partitioned PARTITION(ds=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
@@ -72,11 +70,9 @@ POSTHOOK: Lineage: stats_partitioned PAR
POSTHOOK: Lineage: stats_partitioned PARTITION(ds=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: stats_partitioned PARTITION(ds=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: stats_partitioned PARTITION(ds=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: -- rawDataSize is 0 after config is turned off
-describe formatted stats_partitioned
+PREHOOK: query: describe formatted stats_partitioned
PREHOOK: type: DESCTABLE
-POSTHOOK: query: -- rawDataSize is 0 after config is turned off
-describe formatted stats_partitioned
+POSTHOOK: query: describe formatted stats_partitioned
POSTHOOK: type: DESCTABLE
POSTHOOK: Lineage: stats_partitioned PARTITION(ds=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: stats_partitioned PARTITION(ds=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
Modified: hive/trunk/ql/src/test/results/clientpositive/stats_aggregator_error_1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/stats_aggregator_error_1.q.out?rev=1465903&r1=1465902&r2=1465903&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/stats_aggregator_error_1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/stats_aggregator_error_1.q.out Tue Apr 9 06:33:16 2013
@@ -1,18 +1,6 @@
-PREHOOK: query: -- In this test, there is a dummy stats aggregator which throws an error when various
--- methods are called (as indicated by the parameter hive.test.dummystats.agregator)
--- Since stats need not be reliable (by setting hive.stats.reliable to false), the
--- insert statements succeed. The insert statement succeeds even if the stats aggregator
--- is set to null, since stats need not be reliable.
-
-create table tmptable(key string, value string)
+PREHOOK: query: create table tmptable(key string, value string)
PREHOOK: type: CREATETABLE
-POSTHOOK: query: -- In this test, there is a dummy stats aggregator which throws an error when various
--- methods are called (as indicated by the parameter hive.test.dummystats.agregator)
--- Since stats need not be reliable (by setting hive.stats.reliable to false), the
--- insert statements succeed. The insert statement succeeds even if the stats aggregator
--- is set to null, since stats need not be reliable.
-
-create table tmptable(key string, value string)
+POSTHOOK: query: create table tmptable(key string, value string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@tmptable
PREHOOK: query: INSERT OVERWRITE TABLE tmptable select * from src
Modified: hive/trunk/ql/src/test/results/clientpositive/stats_empty_dyn_part.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/stats_empty_dyn_part.q.out?rev=1465903&r1=1465902&r2=1465903&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/stats_empty_dyn_part.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/stats_empty_dyn_part.q.out Tue Apr 9 06:33:16 2013
@@ -1,14 +1,6 @@
-PREHOOK: query: -- This test verifies writing a query using dynamic partitions
--- which results in no partitions actually being created with
--- hive.stats.reliable set to true
-
-create table tmptable(key string) partitioned by (part string)
+PREHOOK: query: create table tmptable(key string) partitioned by (part string)
PREHOOK: type: CREATETABLE
-POSTHOOK: query: -- This test verifies writing a query using dynamic partitions
--- which results in no partitions actually being created with
--- hive.stats.reliable set to true
-
-create table tmptable(key string) partitioned by (part string)
+POSTHOOK: query: create table tmptable(key string) partitioned by (part string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@tmptable
PREHOOK: query: explain insert overwrite table tmptable partition (part) select key, value from src where key = 'no_such_value'
Modified: hive/trunk/ql/src/test/results/clientpositive/stats_empty_partition.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/stats_empty_partition.q.out?rev=1465903&r1=1465902&r2=1465903&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/stats_empty_partition.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/stats_empty_partition.q.out Tue Apr 9 06:33:16 2013
@@ -1,12 +1,6 @@
-PREHOOK: query: -- This test verifies that writing an empty partition succeeds when
--- hive.stats.reliable is set to true.
-
-create table tmptable(key string, value string) partitioned by (part string)
+PREHOOK: query: create table tmptable(key string, value string) partitioned by (part string)
PREHOOK: type: CREATETABLE
-POSTHOOK: query: -- This test verifies that writing an empty partition succeeds when
--- hive.stats.reliable is set to true.
-
-create table tmptable(key string, value string) partitioned by (part string)
+POSTHOOK: query: create table tmptable(key string, value string) partitioned by (part string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@tmptable
PREHOOK: query: insert overwrite table tmptable partition (part = '1') select * from src where key = 'no_such_value'
Modified: hive/trunk/ql/src/test/results/clientpositive/stats_noscan_1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/stats_noscan_1.q.out?rev=1465903&r1=1465902&r2=1465903&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/stats_noscan_1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/stats_noscan_1.q.out Tue Apr 9 06:33:16 2013
@@ -1,12 +1,6 @@
-PREHOOK: query: -- test analyze table ... compute statistics noscan
-
--- 1. test full spec
-create table analyze_srcpart like srcpart
+PREHOOK: query: create table analyze_srcpart like srcpart
PREHOOK: type: CREATETABLE
-POSTHOOK: query: -- test analyze table ... compute statistics noscan
-
--- 1. test full spec
-create table analyze_srcpart like srcpart
+POSTHOOK: query: create table analyze_srcpart like srcpart
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@analyze_srcpart
PREHOOK: query: insert overwrite table analyze_srcpart partition (ds, hr) select * from srcpart where ds is not null
@@ -101,11 +95,9 @@ POSTHOOK: Lineage: analyze_srcpart PARTI
POSTHOOK: Lineage: analyze_srcpart PARTITION(ds=2008-04-09,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: analyze_srcpart PARTITION(ds=2008-04-09,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: analyze_srcpart PARTITION(ds=2008-04-09,hr=12).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: -- confirm result
-describe formatted analyze_srcpart PARTITION(ds='2008-04-08',hr=11)
+PREHOOK: query: describe formatted analyze_srcpart PARTITION(ds='2008-04-08',hr=11)
PREHOOK: type: DESCTABLE
-POSTHOOK: query: -- confirm result
-describe formatted analyze_srcpart PARTITION(ds='2008-04-08',hr=11)
+POSTHOOK: query: describe formatted analyze_srcpart PARTITION(ds='2008-04-08',hr=11)
POSTHOOK: type: DESCTABLE
POSTHOOK: Lineage: analyze_srcpart PARTITION(ds=2008-04-08,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: analyze_srcpart PARTITION(ds=2008-04-08,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
@@ -347,11 +339,9 @@ POSTHOOK: Lineage: analyze_srcpart PARTI
POSTHOOK: Lineage: analyze_srcpart PARTITION(ds=2008-04-09,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: analyze_srcpart PARTITION(ds=2008-04-09,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: analyze_srcpart PARTITION(ds=2008-04-09,hr=12).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: -- 2. test partial spec
-create table analyze_srcpart_partial like srcpart
+PREHOOK: query: create table analyze_srcpart_partial like srcpart
PREHOOK: type: CREATETABLE
-POSTHOOK: query: -- 2. test partial spec
-create table analyze_srcpart_partial like srcpart
+POSTHOOK: query: create table analyze_srcpart_partial like srcpart
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@analyze_srcpart_partial
POSTHOOK: Lineage: analyze_srcpart PARTITION(ds=2008-04-08,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
@@ -462,11 +452,9 @@ POSTHOOK: Lineage: analyze_srcpart_parti
POSTHOOK: Lineage: analyze_srcpart_partial PARTITION(ds=2008-04-09,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: analyze_srcpart_partial PARTITION(ds=2008-04-09,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: analyze_srcpart_partial PARTITION(ds=2008-04-09,hr=12).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: -- confirm result
-describe formatted analyze_srcpart_partial PARTITION(ds='2008-04-08',hr=11)
+PREHOOK: query: describe formatted analyze_srcpart_partial PARTITION(ds='2008-04-08',hr=11)
PREHOOK: type: DESCTABLE
-POSTHOOK: query: -- confirm result
-describe formatted analyze_srcpart_partial PARTITION(ds='2008-04-08',hr=11)
+POSTHOOK: query: describe formatted analyze_srcpart_partial PARTITION(ds='2008-04-08',hr=11)
POSTHOOK: type: DESCTABLE
POSTHOOK: Lineage: analyze_srcpart PARTITION(ds=2008-04-08,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: analyze_srcpart PARTITION(ds=2008-04-08,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
Modified: hive/trunk/ql/src/test/results/clientpositive/stats_noscan_2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/stats_noscan_2.q.out?rev=1465903&r1=1465902&r2=1465903&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/stats_noscan_2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/stats_noscan_2.q.out Tue Apr 9 06:33:16 2013
@@ -1,9 +1,5 @@
-PREHOOK: query: -- test analyze table compute statistiscs [noscan] on external table
--- 1 test table
#### A masked pattern was here ####
PREHOOK: type: CREATETABLE
-POSTHOOK: query: -- test analyze table compute statistiscs [noscan] on external table
--- 1 test table
#### A masked pattern was here ####
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@anaylyze_external
@@ -113,13 +109,9 @@ POSTHOOK: query: drop table anaylyze_ext
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@anaylyze_external
POSTHOOK: Output: default@anaylyze_external
-PREHOOK: query: -- 2 test partition
--- prepare data
-create table texternal(key string, val string) partitioned by (insertdate string)
+PREHOOK: query: create table texternal(key string, val string) partitioned by (insertdate string)
PREHOOK: type: CREATETABLE
-POSTHOOK: query: -- 2 test partition
--- prepare data
-create table texternal(key string, val string) partitioned by (insertdate string)
+POSTHOOK: query: create table texternal(key string, val string) partitioned by (insertdate string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@texternal
#### A masked pattern was here ####
@@ -152,10 +144,8 @@ POSTHOOK: Input: default@texternal@inser
POSTHOOK: Lineage: texternal PARTITION(insertdate=2008-01-01).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: texternal PARTITION(insertdate=2008-01-01).val SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
500
-PREHOOK: query: -- create external table
#### A masked pattern was here ####
PREHOOK: type: CREATETABLE
-POSTHOOK: query: -- create external table
#### A masked pattern was here ####
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@anaylyze_external
@@ -183,15 +173,13 @@ POSTHOOK: Input: default@anaylyze_extern
POSTHOOK: Lineage: texternal PARTITION(insertdate=2008-01-01).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: texternal PARTITION(insertdate=2008-01-01).val SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
500
-PREHOOK: query: -- analyze
-analyze table anaylyze_external PARTITION (insertdate='2008-01-01') compute statistics
+PREHOOK: query: analyze table anaylyze_external PARTITION (insertdate='2008-01-01') compute statistics
PREHOOK: type: QUERY
PREHOOK: Input: default@anaylyze_external
PREHOOK: Input: default@anaylyze_external@insertdate=2008-01-01
PREHOOK: Output: default@anaylyze_external
PREHOOK: Output: default@anaylyze_external@insertdate=2008-01-01
-POSTHOOK: query: -- analyze
-analyze table anaylyze_external PARTITION (insertdate='2008-01-01') compute statistics
+POSTHOOK: query: analyze table anaylyze_external PARTITION (insertdate='2008-01-01') compute statistics
POSTHOOK: type: QUERY
POSTHOOK: Input: default@anaylyze_external
POSTHOOK: Input: default@anaylyze_external@insertdate=2008-01-01
Modified: hive/trunk/ql/src/test/results/clientpositive/stats_partscan_1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/stats_partscan_1.q.out?rev=1465903&r1=1465902&r2=1465903&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/stats_partscan_1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/stats_partscan_1.q.out Tue Apr 9 06:33:16 2013
@@ -1,14 +1,8 @@
-PREHOOK: query: -- test analyze table ... compute statistics partialscan
-
--- 1. prepare data
-CREATE table analyze_srcpart_partial_scan (key STRING, value STRING)
+PREHOOK: query: CREATE table analyze_srcpart_partial_scan (key STRING, value STRING)
partitioned by (ds string, hr string)
stored as rcfile
PREHOOK: type: CREATETABLE
-POSTHOOK: query: -- test analyze table ... compute statistics partialscan
-
--- 1. prepare data
-CREATE table analyze_srcpart_partial_scan (key STRING, value STRING)
+POSTHOOK: query: CREATE table analyze_srcpart_partial_scan (key STRING, value STRING)
partitioned by (ds string, hr string)
stored as rcfile
POSTHOOK: type: CREATETABLE
@@ -83,12 +77,10 @@ Bucket Columns: []
Sort Columns: []
Storage Desc Params:
serialization.format 1
-PREHOOK: query: -- 2. partialscan
-explain
+PREHOOK: query: explain
analyze table analyze_srcpart_partial_scan PARTITION(ds='2008-04-08',hr=11) compute statistics partialscan
PREHOOK: type: QUERY
-POSTHOOK: query: -- 2. partialscan
-explain
+POSTHOOK: query: explain
analyze table analyze_srcpart_partial_scan PARTITION(ds='2008-04-08',hr=11) compute statistics partialscan
POSTHOOK: type: QUERY
POSTHOOK: Lineage: analyze_srcpart_partial_scan PARTITION(ds=2008-04-08,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
@@ -134,11 +126,9 @@ POSTHOOK: Lineage: analyze_srcpart_parti
POSTHOOK: Lineage: analyze_srcpart_partial_scan PARTITION(ds=2008-04-09,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: analyze_srcpart_partial_scan PARTITION(ds=2008-04-09,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: analyze_srcpart_partial_scan PARTITION(ds=2008-04-09,hr=12).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: -- 3. confirm result
-describe formatted analyze_srcpart_partial_scan PARTITION(ds='2008-04-08',hr=11)
+PREHOOK: query: describe formatted analyze_srcpart_partial_scan PARTITION(ds='2008-04-08',hr=11)
PREHOOK: type: DESCTABLE
-POSTHOOK: query: -- 3. confirm result
-describe formatted analyze_srcpart_partial_scan PARTITION(ds='2008-04-08',hr=11)
+POSTHOOK: query: describe formatted analyze_srcpart_partial_scan PARTITION(ds='2008-04-08',hr=11)
POSTHOOK: type: DESCTABLE
POSTHOOK: Lineage: analyze_srcpart_partial_scan PARTITION(ds=2008-04-08,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: analyze_srcpart_partial_scan PARTITION(ds=2008-04-08,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
Modified: hive/trunk/ql/src/test/results/clientpositive/stats_publisher_error_1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/stats_publisher_error_1.q.out?rev=1465903&r1=1465902&r2=1465903&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/stats_publisher_error_1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/stats_publisher_error_1.q.out Tue Apr 9 06:33:16 2013
@@ -1,18 +1,6 @@
-PREHOOK: query: -- In this test, there is a dummy stats publisher which throws an error when various
--- methods are called (as indicated by the parameter hive.test.dummystats.publisher)
--- Since stats need not be reliable (by setting hive.stats.reliable to false), the
--- insert statements succeed. The insert statement succeeds even if the stats publisher
--- is set to null, since stats need not be reliable.
-
-create table tmptable(key string, value string)
+PREHOOK: query: create table tmptable(key string, value string)
PREHOOK: type: CREATETABLE
-POSTHOOK: query: -- In this test, there is a dummy stats publisher which throws an error when various
--- methods are called (as indicated by the parameter hive.test.dummystats.publisher)
--- Since stats need not be reliable (by setting hive.stats.reliable to false), the
--- insert statements succeed. The insert statement succeeds even if the stats publisher
--- is set to null, since stats need not be reliable.
-
-create table tmptable(key string, value string)
+POSTHOOK: query: create table tmptable(key string, value string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@tmptable
PREHOOK: query: INSERT OVERWRITE TABLE tmptable select * from src
Modified: hive/trunk/ql/src/test/results/clientpositive/table_access_keys_stats.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/table_access_keys_stats.q.out?rev=1465903&r1=1465902&r2=1465903&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/table_access_keys_stats.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/table_access_keys_stats.q.out Tue Apr 9 06:33:16 2013
@@ -1,6 +1,4 @@
-PREHOOK: query: -- This test is used for testing the TableAccessAnalyzer
-
-CREATE TABLE T1(key STRING, val STRING) STORED AS TEXTFILE
+PREHOOK: query: CREATE TABLE T1(key STRING, val STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/T1.txt' INTO TABLE T1
PREHOOK: type: LOAD
@@ -9,8 +7,7 @@ PREHOOK: query: CREATE TABLE T2(key STRI
PREHOOK: type: CREATETABLE
PREHOOK: query: CREATE TABLE T3(key STRING, val STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
-PREHOOK: query: -- Simple group-by queries
-SELECT key, count(1) FROM T1 GROUP BY key
+PREHOOK: query: SELECT key, count(1) FROM T1 GROUP BY key
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
#### A masked pattern was here ####
@@ -37,8 +34,7 @@ Keys:key,val
7 17 1
8 18 1
8 28 1
-PREHOOK: query: -- With subqueries and column aliases
-SELECT key, count(1) FROM (SELECT key, val FROM T1) subq1 GROUP BY key
+PREHOOK: query: SELECT key, count(1) FROM (SELECT key, val FROM T1) subq1 GROUP BY key
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
#### A masked pattern was here ####
@@ -64,8 +60,7 @@ Keys:key
3 1
7 1
8 2
-PREHOOK: query: -- With constants
-SELECT 1, key, count(1) FROM T1 GROUP BY 1, key
+PREHOOK: query: SELECT 1, key, count(1) FROM T1 GROUP BY 1, key
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
#### A masked pattern was here ####
@@ -106,8 +101,7 @@ Keys:key,val
7 1 17 2 1
8 1 18 2 1
8 1 28 2 1
-PREHOOK: query: -- no mapping with functions
-SELECT key, key + 1, count(1) FROM T1 GROUP BY key, key + 1
+PREHOOK: query: SELECT key, key + 1, count(1) FROM T1 GROUP BY key, key + 1
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
#### A masked pattern was here ####
@@ -131,8 +125,7 @@ Keys:key
6.0 1
14.0 1
16.0 2
-PREHOOK: query: -- group by followed by union
-SELECT * FROM (
+PREHOOK: query: SELECT * FROM (
SELECT key, count(1) as c FROM T1 GROUP BY key
UNION ALL
SELECT key, count(1) as c FROM T1 GROUP BY key
@@ -158,8 +151,7 @@ Keys:key
3 1
7 1
8 2
-PREHOOK: query: -- group by followed by a join
-SELECT * FROM
+PREHOOK: query: SELECT * FROM
(SELECT key, count(1) as c FROM T1 GROUP BY key) subq1
JOIN
(SELECT key, count(1) as c FROM T1 GROUP BY key) subq2
@@ -203,8 +195,7 @@ Keys:key
7 1 7 17 1
8 2 8 18 1
8 2 8 28 1
-PREHOOK: query: -- constants from sub-queries should work fine
-SELECT key, constant, val, count(1) from
+PREHOOK: query: SELECT key, constant, val, count(1) from
(SELECT key, 1 as constant, val from T1) subq1
group by key, constant, val
PREHOOK: type: QUERY
@@ -220,8 +211,7 @@ Keys:key,val
7 1 17 1
8 1 18 1
8 1 28 1
-PREHOOK: query: -- multiple levels of constants from sub-queries should work fine
-SELECT key, constant3, val, count(1) FROM
+PREHOOK: query: SELECT key, constant3, val, count(1) FROM
(
SELECT key, constant AS constant2, val, 2 AS constant3
FROM
@@ -244,8 +234,7 @@ Keys:key,val
7 2 17 1
8 2 18 1
8 2 28 1
-PREHOOK: query: -- work with insert overwrite
-FROM T1
+PREHOOK: query: FROM T1
INSERT OVERWRITE TABLE T2 SELECT key, count(1) GROUP BY key, 1
INSERT OVERWRITE TABLE T3 SELECT key, sum(val) GROUP BY key
PREHOOK: type: QUERY
@@ -260,8 +249,7 @@ Operator:GBY_8
Table:default@t1
Keys:key
-PREHOOK: query: -- simple joins
-SELECT *
+PREHOOK: query: SELECT *
FROM T1 JOIN T2
ON T1.key = t2.key
ORDER BY T1.key ASC, T1.val ASC
@@ -294,8 +282,7 @@ Keys:key,val
Table:default@t1
Keys:key,val
-PREHOOK: query: -- map join
-SELECT /*+ MAPJOIN(a) */ *
+PREHOOK: query: SELECT /*+ MAPJOIN(a) */ *
FROM T1 a JOIN T2 b
ON a.key = b.key
PREHOOK: type: QUERY
@@ -314,8 +301,7 @@ Keys:key
7 17 7 1
8 18 8 2
8 28 8 2
-PREHOOK: query: -- with constant in join condition
-SELECT *
+PREHOOK: query: SELECT *
FROM T1 JOIN T2
ON T1.key = T2.key AND T1.val = 3 and T2.val = 3
PREHOOK: type: QUERY
@@ -328,8 +314,7 @@ Keys:key
Table:default@t1
Keys:key
-PREHOOK: query: -- subqueries
-SELECT *
+PREHOOK: query: SELECT *
FROM
(
SELECT val FROM T1 WHERE key = 5
@@ -367,8 +352,7 @@ Keys:val
Table:default@t1
Keys:val
-PREHOOK: query: -- with column aliases in subqueries
-SELECT *
+PREHOOK: query: SELECT *
FROM
(
SELECT val as v FROM T1 WHERE key = 5
@@ -388,8 +372,7 @@ Keys:val
Table:default@t1
Keys:val
-PREHOOK: query: -- with constants in subqueries
-SELECT *
+PREHOOK: query: SELECT *
FROM
(
SELECT key, val FROM T1
@@ -409,8 +392,7 @@ Keys:key
Table:default@t1
Keys:val,key
-PREHOOK: query: -- multiple levels of constants in subqueries
-SELECT *
+PREHOOK: query: SELECT *
FROM
(
SELECT key, val from
@@ -433,8 +415,7 @@ Keys:val,key
Table:default@t1
Keys:key
-PREHOOK: query: -- no mapping on functions
-SELECT *
+PREHOOK: query: SELECT *
FROM
(
SELECT key, val from T1
@@ -448,8 +429,7 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
#### A masked pattern was here ####
-PREHOOK: query: -- join followed by group by
-SELECT subq1.val, COUNT(*)
+PREHOOK: query: SELECT subq1.val, COUNT(*)
FROM
(
SELECT key, val FROM T1
@@ -470,8 +450,7 @@ Keys:key
Table:default@t1
Keys:val,key
-PREHOOK: query: -- join followed by union
-SELECT *
+PREHOOK: query: SELECT *
FROM
(
SELECT subq1.val, COUNT(*)
@@ -510,8 +489,7 @@ Keys:val,key
13.0 1
17.0 1
46.0 1
-PREHOOK: query: -- join followed by join
-SELECT *
+PREHOOK: query: SELECT *
FROM
(
SELECT subq1.val as val, COUNT(*)
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=1465903&r1=1465902&r2=1465903&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 Tue Apr 9 06:33:16 2013
@@ -36,15 +36,13 @@ POSTHOOK: Output: default@timestamp_udf
POSTHOOK: Output: default@timestamp_udf_string
POSTHOOK: Lineage: timestamp_udf.t EXPRESSION []
POSTHOOK: Lineage: timestamp_udf_string.t SIMPLE []
-PREHOOK: query: -- Test UDFs with Timestamp input
-select unix_timestamp(t), year(t), month(t), day(t), dayofmonth(t),
+PREHOOK: query: select unix_timestamp(t), year(t), month(t), day(t), dayofmonth(t),
weekofyear(t), hour(t), minute(t), second(t), to_date(t)
from timestamp_udf
PREHOOK: type: QUERY
PREHOOK: Input: default@timestamp_udf
#### A masked pattern was here ####
-POSTHOOK: query: -- Test UDFs with Timestamp input
-select unix_timestamp(t), year(t), month(t), day(t), dayofmonth(t),
+POSTHOOK: query: select unix_timestamp(t), year(t), month(t), day(t), dayofmonth(t),
weekofyear(t), hour(t), minute(t), second(t), to_date(t)
from timestamp_udf
POSTHOOK: type: QUERY
@@ -157,15 +155,13 @@ POSTHOOK: Input: default@timestamp_udf
POSTHOOK: Lineage: timestamp_udf.t EXPRESSION []
POSTHOOK: Lineage: timestamp_udf_string.t SIMPLE []
2011-05-06 07:08:09.1234567 2011-05-06 12:08:09.1234567 2011-05-06 07:08:09.1234567 2011-05-06 12:08:09.1234567
-PREHOOK: query: -- Test UDFs with string input
-select unix_timestamp(t), year(t), month(t), day(t), dayofmonth(t),
+PREHOOK: query: select unix_timestamp(t), year(t), month(t), day(t), dayofmonth(t),
weekofyear(t), hour(t), minute(t), second(t), to_date(t)
from timestamp_udf_string
PREHOOK: type: QUERY
PREHOOK: Input: default@timestamp_udf_string
#### A masked pattern was here ####
-POSTHOOK: query: -- Test UDFs with string input
-select unix_timestamp(t), year(t), month(t), day(t), dayofmonth(t),
+POSTHOOK: query: select unix_timestamp(t), year(t), month(t), day(t), dayofmonth(t),
weekofyear(t), hour(t), minute(t), second(t), to_date(t)
from timestamp_udf_string
POSTHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/transform2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/transform2.q.out?rev=1465903&r1=1465902&r2=1465903&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/transform2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/transform2.q.out Tue Apr 9 06:33:16 2013
@@ -1,10 +1,8 @@
-PREHOOK: query: -- Transform with a function that has many parameters
-SELECT TRANSFORM(substr(key, 1, 2)) USING 'cat' FROM src LIMIT 1
+PREHOOK: query: SELECT TRANSFORM(substr(key, 1, 2)) USING 'cat' FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: -- Transform with a function that has many parameters
-SELECT TRANSFORM(substr(key, 1, 2)) USING 'cat' FROM src LIMIT 1
+POSTHOOK: query: SELECT TRANSFORM(substr(key, 1, 2)) USING 'cat' FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
Modified: hive/trunk/ql/src/test/results/clientpositive/truncate_table.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/truncate_table.q.out?rev=1465903&r1=1465902&r2=1465903&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/truncate_table.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/truncate_table.q.out Tue Apr 9 06:33:16 2013
@@ -66,11 +66,9 @@ PREHOOK: Output: default@srcpart_truncat
POSTHOOK: query: load data local inpath '../data/files/kv1.txt' into table srcpart_truncate partition (ds='2008-04-09', hr='12')
POSTHOOK: type: LOAD
POSTHOOK: Output: default@srcpart_truncate@ds=2008-04-09/hr=12
-PREHOOK: query: -- truncate non-partitioned table
-explain TRUNCATE TABLE src_truncate
+PREHOOK: query: explain TRUNCATE TABLE src_truncate
PREHOOK: type: TRUNCATETABLE
-POSTHOOK: query: -- truncate non-partitioned table
-explain TRUNCATE TABLE src_truncate
+POSTHOOK: query: explain TRUNCATE TABLE src_truncate
POSTHOOK: type: TRUNCATETABLE
ABSTRACT SYNTAX TREE:
(TOK_TRUNCATETABLE (TOK_TABLE_PARTITION src_truncate))
@@ -99,11 +97,9 @@ POSTHOOK: query: select * from src_trunc
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_truncate
#### A masked pattern was here ####
-PREHOOK: query: -- truncate a partition
-explain TRUNCATE TABLE srcpart_truncate partition (ds='2008-04-08', hr='11')
+PREHOOK: query: explain TRUNCATE TABLE srcpart_truncate partition (ds='2008-04-08', hr='11')
PREHOOK: type: TRUNCATETABLE
-POSTHOOK: query: -- truncate a partition
-explain TRUNCATE TABLE srcpart_truncate partition (ds='2008-04-08', hr='11')
+POSTHOOK: query: explain TRUNCATE TABLE srcpart_truncate partition (ds='2008-04-08', hr='11')
POSTHOOK: type: TRUNCATETABLE
ABSTRACT SYNTAX TREE:
(TOK_TRUNCATETABLE (TOK_TABLE_PARTITION srcpart_truncate (TOK_PARTSPEC (TOK_PARTVAL ds '2008-04-08') (TOK_PARTVAL hr '11'))))
@@ -137,11 +133,9 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcpart_truncate
POSTHOOK: Input: default@srcpart_truncate@ds=2008-04-08/hr=11
#### A masked pattern was here ####
-PREHOOK: query: -- truncate partitions with partial spec
-explain TRUNCATE TABLE srcpart_truncate partition (ds, hr='12')
+PREHOOK: query: explain TRUNCATE TABLE srcpart_truncate partition (ds, hr='12')
PREHOOK: type: TRUNCATETABLE
-POSTHOOK: query: -- truncate partitions with partial spec
-explain TRUNCATE TABLE srcpart_truncate partition (ds, hr='12')
+POSTHOOK: query: explain TRUNCATE TABLE srcpart_truncate partition (ds, hr='12')
POSTHOOK: type: TRUNCATETABLE
ABSTRACT SYNTAX TREE:
(TOK_TRUNCATETABLE (TOK_TABLE_PARTITION srcpart_truncate (TOK_PARTSPEC (TOK_PARTVAL ds) (TOK_PARTVAL hr '12'))))
@@ -179,11 +173,9 @@ POSTHOOK: Input: default@srcpart_truncat
POSTHOOK: Input: default@srcpart_truncate@ds=2008-04-08/hr=12
POSTHOOK: Input: default@srcpart_truncate@ds=2008-04-09/hr=12
#### A masked pattern was here ####
-PREHOOK: query: -- truncate partitioned table
-explain TRUNCATE TABLE srcpart_truncate
+PREHOOK: query: explain TRUNCATE TABLE srcpart_truncate
PREHOOK: type: TRUNCATETABLE
-POSTHOOK: query: -- truncate partitioned table
-explain TRUNCATE TABLE srcpart_truncate
+POSTHOOK: query: explain TRUNCATE TABLE srcpart_truncate
POSTHOOK: type: TRUNCATETABLE
ABSTRACT SYNTAX TREE:
(TOK_TRUNCATETABLE (TOK_TABLE_PARTITION srcpart_truncate))
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=1465903&r1=1465902&r2=1465903&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 Tue Apr 9 06:33:16 2013
@@ -1,8 +1,6 @@
-PREHOOK: query: -- Check for int, bigint automatic type widening conversions in UDFs, UNIONS
-EXPLAIN SELECT COALESCE(0, 9223372036854775807) FROM src LIMIT 1
+PREHOOK: query: EXPLAIN SELECT COALESCE(0, 9223372036854775807) FROM src LIMIT 1
PREHOOK: type: QUERY
-POSTHOOK: query: -- Check for int, bigint automatic type widening conversions in UDFs, UNIONS
-EXPLAIN SELECT COALESCE(0, 9223372036854775807) FROM src LIMIT 1
+POSTHOOK: query: EXPLAIN SELECT COALESCE(0, 9223372036854775807) FROM src LIMIT 1
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 COALESCE 0 9223372036854775807))) (TOK_LIMIT 1)))
Modified: hive/trunk/ql/src/test/results/clientpositive/udaf_percentile_approx.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udaf_percentile_approx.q.out?rev=1465903&r1=1465902&r2=1465903&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udaf_percentile_approx.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udaf_percentile_approx.q.out Tue Apr 9 06:33:16 2013
@@ -1,10 +1,8 @@
-PREHOOK: query: -- disable map-side aggregation
-SELECT percentile_approx(cast(substr(src.value,5) AS double), 0.5) FROM src
+PREHOOK: query: SELECT percentile_approx(cast(substr(src.value,5) AS double), 0.5) FROM src
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: -- disable map-side aggregation
-SELECT percentile_approx(cast(substr(src.value,5) AS double), 0.5) FROM src
+POSTHOOK: query: SELECT percentile_approx(cast(substr(src.value,5) AS double), 0.5) FROM src
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
@@ -108,13 +106,11 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
[26.0,255.5,479.0,491.0]
-PREHOOK: query: -- enable map-side aggregation
-SELECT percentile_approx(cast(substr(src.value,5) AS double), 0.5) FROM src
+PREHOOK: query: SELECT percentile_approx(cast(substr(src.value,5) AS double), 0.5) FROM src
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: -- enable map-side aggregation
-SELECT percentile_approx(cast(substr(src.value,5) AS double), 0.5) FROM src
+POSTHOOK: query: SELECT percentile_approx(cast(substr(src.value,5) AS double), 0.5) FROM src
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
Modified: hive/trunk/ql/src/test/results/clientpositive/udf_array_contains.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf_array_contains.q.out?rev=1465903&r1=1465902&r2=1465903&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udf_array_contains.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udf_array_contains.q.out Tue Apr 9 06:33:16 2013
@@ -11,25 +11,21 @@ array_contains(array, value) - Returns T
Example:
> SELECT array_contains(array(1, 2, 3), 2) FROM src LIMIT 1;
true
-PREHOOK: query: -- evalutes function for array of primitives
-SELECT array_contains(array(1, 2, 3), 1) FROM src LIMIT 1
+PREHOOK: query: SELECT array_contains(array(1, 2, 3), 1) FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: -- evalutes function for array of primitives
-SELECT array_contains(array(1, 2, 3), 1) FROM src LIMIT 1
+POSTHOOK: query: SELECT array_contains(array(1, 2, 3), 1) FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
true
-PREHOOK: query: -- evaluates function for nested arrays
-SELECT array_contains(array(array(1,2), array(2,3), array(3,4)), array(1,2))
+PREHOOK: query: SELECT array_contains(array(array(1,2), array(2,3), array(3,4)), array(1,2))
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: -- evaluates function for nested arrays
-SELECT array_contains(array(array(1,2), array(2,3), array(3,4)), array(1,2))
+POSTHOOK: query: SELECT array_contains(array(array(1,2), array(2,3), array(3,4)), array(1,2))
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
Modified: hive/trunk/ql/src/test/results/clientpositive/udf_bin.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf_bin.q.out?rev=1465903&r1=1465902&r2=1465903&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udf_bin.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udf_bin.q.out Tue Apr 9 06:33:16 2013
@@ -29,13 +29,11 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
1 0 101111101011100001101100101
-PREHOOK: query: -- Negative numbers should be treated as two's complement (64 bit).
-SELECT bin(-5) FROM src LIMIT 1
+PREHOOK: query: SELECT bin(-5) FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: -- Negative numbers should be treated as two's complement (64 bit).
-SELECT bin(-5) FROM src LIMIT 1
+POSTHOOK: query: SELECT bin(-5) FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
Modified: hive/trunk/ql/src/test/results/clientpositive/udf_case.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf_case.q.out?rev=1465903&r1=1465902&r2=1465903&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udf_case.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udf_case.q.out Tue Apr 9 06:33:16 2013
@@ -165,17 +165,13 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
2 5 15 NULL 20 24
-PREHOOK: query: -- verify that short-circuiting is working correctly for CASE
--- we should never get to the ELSE branch, which would raise an exception
-SELECT CASE 1 WHEN 1 THEN 'yo'
+PREHOOK: query: SELECT CASE 1 WHEN 1 THEN 'yo'
ELSE reflect('java.lang.String', 'bogus', 1) END
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: -- verify that short-circuiting is working correctly for CASE
--- we should never get to the ELSE branch, which would raise an exception
-SELECT CASE 1 WHEN 1 THEN 'yo'
+POSTHOOK: query: SELECT CASE 1 WHEN 1 THEN 'yo'
ELSE reflect('java.lang.String', 'bogus', 1) END
FROM src LIMIT 1
POSTHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/udf_concat_ws.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf_concat_ws.q.out?rev=1465903&r1=1465902&r2=1465903&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udf_concat_ws.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udf_concat_ws.q.out Tue Apr 9 06:33:16 2013
@@ -97,8 +97,7 @@ POSTHOOK: Lineage: dest1.c1 SIMPLE []
POSTHOOK: Lineage: dest1.c2 SIMPLE []
POSTHOOK: Lineage: dest1.c3 SIMPLE []
xyzabc8675309 abc,xyz,8675309 NULL abc**8675309
-PREHOOK: query: -- evalutes function for array of strings
-EXPLAIN
+PREHOOK: query: EXPLAIN
SELECT concat_ws('.', array('www', 'face', 'book', 'com'), '1234'),
concat_ws('-', 'www', array('face', 'book', 'com'), '1234'),
concat_ws('F', 'www', array('face', 'book', 'com', '1234')),
@@ -107,8 +106,7 @@ SELECT concat_ws('.', array('www', 'face
concat_ws('[]', array('www'), 'face', array('book', 'com', '1234')),
concat_ws('AAA', array('www'), array('face', 'book', 'com'), '1234') FROM dest1 LIMIT 1
PREHOOK: type: QUERY
-POSTHOOK: query: -- evalutes function for array of strings
-EXPLAIN
+POSTHOOK: query: EXPLAIN
SELECT concat_ws('.', array('www', 'face', 'book', 'com'), '1234'),
concat_ws('-', 'www', array('face', 'book', 'com'), '1234'),
concat_ws('F', 'www', array('face', 'book', 'com', '1234')),
Modified: hive/trunk/ql/src/test/results/clientpositive/udf_conv.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf_conv.q.out?rev=1465903&r1=1465902&r2=1465903&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udf_conv.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udf_conv.q.out Tue Apr 9 06:33:16 2013
@@ -14,10 +14,7 @@ Example:
'4'
> SELECT conv(-10, 16, -10) FROM src LIMIT 1;
'16'
-PREHOOK: query: -- conv must work on both strings and integers up to 64-bit precision
-
--- Some simple conversions to test different bases
-SELECT
+PREHOOK: query: SELECT
conv('4521', 10, 36),
conv('22', 10, 10),
conv('110011', 2, 16),
@@ -26,10 +23,7 @@ FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: -- conv must work on both strings and integers up to 64-bit precision
-
--- Some simple conversions to test different bases
-SELECT
+POSTHOOK: query: SELECT
conv('4521', 10, 36),
conv('22', 10, 10),
conv('110011', 2, 16),
@@ -39,9 +33,7 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
3HL 22 33 116ED2B2FB4
-PREHOOK: query: -- Test negative numbers. If to_base is positive, the number should be handled
--- as a two's complement (64-bit)
-SELECT
+PREHOOK: query: SELECT
conv('-641', 10, -10),
conv('1011', 2, -16),
conv('-1', 10, 16),
@@ -50,9 +42,7 @@ FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: -- Test negative numbers. If to_base is positive, the number should be handled
--- as a two's complement (64-bit)
-SELECT
+POSTHOOK: query: SELECT
conv('-641', 10, -10),
conv('1011', 2, -16),
conv('-1', 10, 16),
@@ -62,9 +52,7 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
-641 B FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFF1
-PREHOOK: query: -- Test overflow. If a number is two large, the result should be -1 (if signed)
--- or MAX_LONG (if unsigned)
-SELECT
+PREHOOK: query: SELECT
conv('9223372036854775807', 36, 16),
conv('9223372036854775807', 36, -16),
conv('-9223372036854775807', 36, 16),
@@ -73,9 +61,7 @@ FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: -- Test overflow. If a number is two large, the result should be -1 (if signed)
--- or MAX_LONG (if unsigned)
-SELECT
+POSTHOOK: query: SELECT
conv('9223372036854775807', 36, 16),
conv('9223372036854775807', 36, -16),
conv('-9223372036854775807', 36, 16),
@@ -85,10 +71,7 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
FFFFFFFFFFFFFFFF -1 FFFFFFFFFFFFFFFF -1
-PREHOOK: query: -- Test with invalid input. If one of the bases is invalid, the result should
--- be NULL. If there is an invalid digit in the number, the longest valid
--- prefix should be converted.
-SELECT
+PREHOOK: query: SELECT
conv('123455', 3, 10),
conv('131', 1, 5),
conv('515', 5, 100),
@@ -97,10 +80,7 @@ FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: -- Test with invalid input. If one of the bases is invalid, the result should
--- be NULL. If there is an invalid digit in the number, the longest valid
--- prefix should be converted.
-SELECT
+POSTHOOK: query: SELECT
conv('123455', 3, 10),
conv('131', 1, 5),
conv('515', 5, 100),
@@ -110,9 +90,7 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
5 NULL NULL NULL
-PREHOOK: query: -- Perform the same tests with number arguments.
-
-SELECT
+PREHOOK: query: SELECT
conv(4521, 10, 36),
conv(22, 10, 10),
conv(110011, 2, 16)
@@ -120,9 +98,7 @@ FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: -- Perform the same tests with number arguments.
-
-SELECT
+POSTHOOK: query: SELECT
conv(4521, 10, 36),
conv(22, 10, 10),
conv(110011, 2, 16)
@@ -188,17 +164,13 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
5 NULL NULL NULL
-PREHOOK: query: -- Make sure that state is properly reset.
-
-SELECT conv(key, 10, 16),
+PREHOOK: query: SELECT conv(key, 10, 16),
conv(key, 16, 10)
FROM src LIMIT 3
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: -- Make sure that state is properly reset.
-
-SELECT conv(key, 10, 16),
+POSTHOOK: query: SELECT conv(key, 10, 16),
conv(key, 16, 10)
FROM src LIMIT 3
POSTHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/udf_format_number.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf_format_number.q.out?rev=1465903&r1=1465902&r2=1465903&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udf_format_number.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udf_format_number.q.out Tue Apr 9 06:33:16 2013
@@ -2,13 +2,9 @@ PREHOOK: query: use default
PREHOOK: type: SWITCHDATABASE
POSTHOOK: query: use default
POSTHOOK: type: SWITCHDATABASE
-PREHOOK: query: -- Test format_number() UDF
-
-DESCRIBE FUNCTION format_number
+PREHOOK: query: DESCRIBE FUNCTION format_number
PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: -- Test format_number() UDF
-
-DESCRIBE FUNCTION format_number
+POSTHOOK: query: DESCRIBE FUNCTION format_number
POSTHOOK: type: DESCFUNCTION
format_number(X, D) - Formats the number X to a format like '#,###,###.##', rounded to D decimal places, and returns the result as a string. If D is 0, the result has no decimal point or fractional part. This is supposed to function like MySQL's FORMAT
PREHOOK: query: DESCRIBE FUNCTION EXTENDED format_number
@@ -80,8 +76,7 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
12,332.1235 12,332.1000 12,332
-PREHOOK: query: -- positive numbers
-SELECT format_number(0.123456789, 12),
+PREHOOK: query: SELECT format_number(0.123456789, 12),
format_number(12345678.123456789, 5),
format_number(1234567.123456789, 7),
format_number(123456.123456789, 0)
@@ -89,8 +84,7 @@ FROM src limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: -- positive numbers
-SELECT format_number(0.123456789, 12),
+POSTHOOK: query: SELECT format_number(0.123456789, 12),
format_number(12345678.123456789, 5),
format_number(1234567.123456789, 7),
format_number(123456.123456789, 0)
@@ -99,8 +93,7 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
0.123456789000 12,345,678.12346 1,234,567.1234568 123,456
-PREHOOK: query: -- negative numbers
-SELECT format_number(-123456.123456789, 0),
+PREHOOK: query: SELECT format_number(-123456.123456789, 0),
format_number(-1234567.123456789, 2),
format_number(-0.123456789, 15),
format_number(-12345.123456789, 4)
@@ -108,8 +101,7 @@ FROM src limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: -- negative numbers
-SELECT format_number(-123456.123456789, 0),
+POSTHOOK: query: SELECT format_number(-123456.123456789, 0),
format_number(-1234567.123456789, 2),
format_number(-0.123456789, 15),
format_number(-12345.123456789, 4)
@@ -118,8 +110,7 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
-123,456 -1,234,567.12 -0.123456789000000 -12,345.1235
-PREHOOK: query: -- zeros
-SELECT format_number(0.0, 4),
+PREHOOK: query: SELECT format_number(0.0, 4),
format_number(0.000000, 1),
format_number(000.0000, 1),
format_number(00000.0000, 1),
@@ -128,8 +119,7 @@ FROM src limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: -- zeros
-SELECT format_number(0.0, 4),
+POSTHOOK: query: SELECT format_number(0.0, 4),
format_number(0.000000, 1),
format_number(000.0000, 1),
format_number(00000.0000, 1),
@@ -139,8 +129,7 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
0.0000 0.0 0.0 0.0 -0.0000
-PREHOOK: query: -- integers
-SELECT format_number(0, 0),
+PREHOOK: query: SELECT format_number(0, 0),
format_number(1, 4),
format_number(12, 2),
format_number(123, 5),
@@ -149,8 +138,7 @@ FROM src limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: -- integers
-SELECT format_number(0, 0),
+POSTHOOK: query: SELECT format_number(0, 0),
format_number(1, 4),
format_number(12, 2),
format_number(123, 5),
@@ -160,13 +148,7 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
0 1.0000 12.00 123.00000 1,234.0000000
-PREHOOK: query: -- long and double boundary
--- 9223372036854775807 is LONG_MAX
--- -9223372036854775807 is one more than LONG_MIN,
--- due to HIVE-2733, put it here to check LONG_MIN boundary
--- 4.9E-324 and 1.7976931348623157E308 are Double.MIN_VALUE and Double.MAX_VALUE
--- check them for Double boundary
-SELECT format_number(-9223372036854775807, 10),
+PREHOOK: query: SELECT format_number(-9223372036854775807, 10),
format_number(9223372036854775807, 20),
format_number(4.9E-324, 324),
format_number(1.7976931348623157E308, 308)
@@ -174,13 +156,7 @@ FROM src limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: -- long and double boundary
--- 9223372036854775807 is LONG_MAX
--- -9223372036854775807 is one more than LONG_MIN,
--- due to HIVE-2733, put it here to check LONG_MIN boundary
--- 4.9E-324 and 1.7976931348623157E308 are Double.MIN_VALUE and Double.MAX_VALUE
--- check them for Double boundary
-SELECT format_number(-9223372036854775807, 10),
+POSTHOOK: query: SELECT format_number(-9223372036854775807, 10),
format_number(9223372036854775807, 20),
format_number(4.9E-324, 324),
format_number(1.7976931348623157E308, 308)
Modified: hive/trunk/ql/src/test/results/clientpositive/udf_get_json_object.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf_get_json_object.q.out?rev=1465903&r1=1465902&r2=1465903&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udf_get_json_object.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udf_get_json_object.q.out Tue Apr 9 06:33:16 2013
@@ -173,13 +173,9 @@ POSTHOOK: Input: default@src_json
#### A masked pattern was here ####
POSTHOOK: Lineage: dest1.c1 SIMPLE []
1234
-PREHOOK: query: -- Verify that get_json_object can handle new lines in JSON values
-
-CREATE TABLE dest2(c1 STRING) STORED AS RCFILE
+PREHOOK: query: CREATE TABLE dest2(c1 STRING) STORED AS RCFILE
PREHOOK: type: CREATETABLE
-POSTHOOK: query: -- Verify that get_json_object can handle new lines in JSON values
-
-CREATE TABLE dest2(c1 STRING) STORED AS RCFILE
+POSTHOOK: query: CREATE TABLE dest2(c1 STRING) STORED AS RCFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@dest2
POSTHOOK: Lineage: dest1.c1 SIMPLE []
Modified: hive/trunk/ql/src/test/results/clientpositive/udf_hex.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf_hex.q.out?rev=1465903&r1=1465902&r2=1465903&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udf_hex.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udf_hex.q.out Tue Apr 9 06:33:16 2013
@@ -15,9 +15,7 @@ Example:
'H1'
> SELECT hex('Facebook') FROM src LIMIT 1;
'46616365626F6F6B'
-PREHOOK: query: -- If the argument is a string, hex should return a string containing two hex
--- digits for every character in the input.
-SELECT
+PREHOOK: query: SELECT
hex('Facebook'),
hex('\0'),
hex('qwertyuiopasdfghjkl')
@@ -25,9 +23,7 @@ FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: -- If the argument is a string, hex should return a string containing two hex
--- digits for every character in the input.
-SELECT
+POSTHOOK: query: SELECT
hex('Facebook'),
hex('\0'),
hex('qwertyuiopasdfghjkl')
@@ -36,8 +32,7 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
46616365626F6F6B 00 71776572747975696F706173646667686A6B6C
-PREHOOK: query: -- If the argument is a number, hex should convert it to hexadecimal.
-SELECT
+PREHOOK: query: SELECT
hex(1),
hex(0),
hex(4207849477)
@@ -45,8 +40,7 @@ FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: -- If the argument is a number, hex should convert it to hexadecimal.
-SELECT
+POSTHOOK: query: SELECT
hex(1),
hex(0),
hex(4207849477)
@@ -55,13 +49,11 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
1 0 FACEB005
-PREHOOK: query: -- Negative numbers should be treated as two's complement (64 bit).
-SELECT hex(-5) FROM src LIMIT 1
+PREHOOK: query: SELECT hex(-5) FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: -- Negative numbers should be treated as two's complement (64 bit).
-SELECT hex(-5) FROM src LIMIT 1
+POSTHOOK: query: SELECT hex(-5) FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
Modified: hive/trunk/ql/src/test/results/clientpositive/udf_if.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf_if.q.out?rev=1465903&r1=1465902&r2=1465903&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udf_if.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udf_if.q.out Tue Apr 9 06:33:16 2013
@@ -89,16 +89,14 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
1 1 1 1 NULL 2
-PREHOOK: query: -- Type conversions
-EXPLAIN
+PREHOOK: query: EXPLAIN
SELECT IF(TRUE, CAST(128 AS SMALLINT), CAST(1 AS TINYINT)) AS COL1,
IF(FALSE, 1, 1.1) AS COL2,
IF(FALSE, 1, 'ABC') AS COL3,
IF(FALSE, 'ABC', 12.3) AS COL4
FROM src LIMIT 1
PREHOOK: type: QUERY
-POSTHOOK: query: -- Type conversions
-EXPLAIN
+POSTHOOK: query: EXPLAIN
SELECT IF(TRUE, CAST(128 AS SMALLINT), CAST(1 AS TINYINT)) AS COL1,
IF(FALSE, 1, 1.1) AS COL2,
IF(FALSE, 1, 'ABC') AS COL3,
Modified: hive/trunk/ql/src/test/results/clientpositive/udf_java_method.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf_java_method.q.out?rev=1465903&r1=1465902&r2=1465903&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udf_java_method.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udf_java_method.q.out Tue Apr 9 06:33:16 2013
@@ -11,9 +11,7 @@ java_method(class,method[,arg1[,arg2..]]
Synonyms: reflect
Use this UDF to call Java methods by matching the argument signature
-PREHOOK: query: -- java_method() is a synonym for reflect()
-
-EXPLAIN EXTENDED
+PREHOOK: query: EXPLAIN EXTENDED
SELECT java_method("java.lang.String", "valueOf", 1),
java_method("java.lang.String", "isEmpty"),
java_method("java.lang.Math", "max", 2, 3),
@@ -23,9 +21,7 @@ SELECT java_method("java.lang.String", "
java_method("java.lang.Math", "floor", 1.9)
FROM src LIMIT 1
PREHOOK: type: QUERY
-POSTHOOK: query: -- java_method() is a synonym for reflect()
-
-EXPLAIN EXTENDED
+POSTHOOK: query: EXPLAIN EXTENDED
SELECT java_method("java.lang.String", "valueOf", 1),
java_method("java.lang.String", "isEmpty"),
java_method("java.lang.Math", "max", 2, 3),
Modified: hive/trunk/ql/src/test/results/clientpositive/udf_length.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf_length.q.out?rev=1465903&r1=1465902&r2=1465903&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udf_length.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udf_length.q.out Tue Apr 9 06:33:16 2013
@@ -161,11 +161,9 @@ POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@dest1
POSTHOOK: Output: default@dest1
POSTHOOK: Lineage: dest1.len EXPRESSION [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: -- Test with non-ascii characters.
-CREATE TABLE dest1(name STRING) STORED AS TEXTFILE
+PREHOOK: query: CREATE TABLE dest1(name STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
-POSTHOOK: query: -- Test with non-ascii characters.
-CREATE TABLE dest1(name STRING) STORED AS TEXTFILE
+POSTHOOK: query: CREATE TABLE dest1(name STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@dest1
POSTHOOK: Lineage: dest1.len EXPRESSION [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
Modified: hive/trunk/ql/src/test/results/clientpositive/udf_map_keys.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf_map_keys.q.out?rev=1465903&r1=1465902&r2=1465903&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udf_map_keys.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udf_map_keys.q.out Tue Apr 9 06:33:16 2013
@@ -2,13 +2,9 @@ PREHOOK: query: use default
PREHOOK: type: SWITCHDATABASE
POSTHOOK: query: use default
POSTHOOK: type: SWITCHDATABASE
-PREHOOK: query: -- Test map_keys() UDF
-
-DESCRIBE FUNCTION map_keys
+PREHOOK: query: DESCRIBE FUNCTION map_keys
PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: -- Test map_keys() UDF
-
-DESCRIBE FUNCTION map_keys
+POSTHOOK: query: DESCRIBE FUNCTION map_keys
POSTHOOK: type: DESCFUNCTION
map_keys(map) - Returns an unordered array containing the keys of the input map.
PREHOOK: query: DESCRIBE FUNCTION EXTENDED map_keys
@@ -16,24 +12,20 @@ PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED map_keys
POSTHOOK: type: DESCFUNCTION
map_keys(map) - Returns an unordered array containing the keys of the input map.
-PREHOOK: query: -- Evaluate function against INT valued keys
-SELECT map_keys(map(1, "a", 2, "b", 3, "c")) FROM src LIMIT 1
+PREHOOK: query: SELECT map_keys(map(1, "a", 2, "b", 3, "c")) FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: -- Evaluate function against INT valued keys
-SELECT map_keys(map(1, "a", 2, "b", 3, "c")) FROM src LIMIT 1
+POSTHOOK: query: SELECT map_keys(map(1, "a", 2, "b", 3, "c")) FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
[1,2,3]
-PREHOOK: query: -- Evaluate function against STRING valued keys
-SELECT map_keys(map("a", 1, "b", 2, "c", 3)) FROM src LIMIT 1
+PREHOOK: query: SELECT map_keys(map("a", 1, "b", 2, "c", 3)) FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: -- Evaluate function against STRING valued keys
-SELECT map_keys(map("a", 1, "b", 2, "c", 3)) FROM src LIMIT 1
+POSTHOOK: query: SELECT map_keys(map("a", 1, "b", 2, "c", 3)) FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
Modified: hive/trunk/ql/src/test/results/clientpositive/udf_map_values.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf_map_values.q.out?rev=1465903&r1=1465902&r2=1465903&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udf_map_values.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udf_map_values.q.out Tue Apr 9 06:33:16 2013
@@ -2,13 +2,9 @@ PREHOOK: query: use default
PREHOOK: type: SWITCHDATABASE
POSTHOOK: query: use default
POSTHOOK: type: SWITCHDATABASE
-PREHOOK: query: -- Test map_values() UDF
-
-DESCRIBE FUNCTION map_values
+PREHOOK: query: DESCRIBE FUNCTION map_values
PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: -- Test map_values() UDF
-
-DESCRIBE FUNCTION map_values
+POSTHOOK: query: DESCRIBE FUNCTION map_values
POSTHOOK: type: DESCFUNCTION
map_values(map) - Returns an unordered array containing the values of the input map.
PREHOOK: query: DESCRIBE FUNCTION EXTENDED map_values
@@ -16,24 +12,20 @@ PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED map_values
POSTHOOK: type: DESCFUNCTION
map_values(map) - Returns an unordered array containing the values of the input map.
-PREHOOK: query: -- Evaluate function against STRING valued values
-SELECT map_values(map(1, "a", 2, "b", 3, "c")) FROM src LIMIT 1
+PREHOOK: query: SELECT map_values(map(1, "a", 2, "b", 3, "c")) FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: -- Evaluate function against STRING valued values
-SELECT map_values(map(1, "a", 2, "b", 3, "c")) FROM src LIMIT 1
+POSTHOOK: query: SELECT map_values(map(1, "a", 2, "b", 3, "c")) FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
["a","b","c"]
-PREHOOK: query: -- Evaluate function against INT valued keys
-SELECT map_values(map("a", 1, "b", 2, "c", 3)) FROM src LIMIT 1
+PREHOOK: query: SELECT map_values(map("a", 1, "b", 2, "c", 3)) FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: -- Evaluate function against INT valued keys
-SELECT map_values(map("a", 1, "b", 2, "c", 3)) FROM src LIMIT 1
+POSTHOOK: query: SELECT map_values(map("a", 1, "b", 2, "c", 3)) FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
Modified: hive/trunk/ql/src/test/results/clientpositive/udf_negative.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf_negative.q.out?rev=1465903&r1=1465902&r2=1465903&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udf_negative.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udf_negative.q.out Tue Apr 9 06:33:16 2013
@@ -8,11 +8,9 @@ PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED negative
POSTHOOK: type: DESCFUNCTION
negative a - Returns -a
-PREHOOK: query: -- synonym
-DESCRIBE FUNCTION -
+PREHOOK: query: DESCRIBE FUNCTION -
PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: -- synonym
-DESCRIBE FUNCTION -
+POSTHOOK: query: DESCRIBE FUNCTION -
POSTHOOK: type: DESCFUNCTION
a - b - Returns the difference a-b
PREHOOK: query: DESCRIBE FUNCTION EXTENDED -
Modified: hive/trunk/ql/src/test/results/clientpositive/udf_not.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf_not.q.out?rev=1465903&r1=1465902&r2=1465903&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udf_not.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udf_not.q.out Tue Apr 9 06:33:16 2013
@@ -9,11 +9,9 @@ POSTHOOK: query: DESCRIBE FUNCTION EXTEN
POSTHOOK: type: DESCFUNCTION
not a - Logical not
Synonyms: !
-PREHOOK: query: -- synonym
-DESCRIBE FUNCTION !
+PREHOOK: query: DESCRIBE FUNCTION !
PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: -- synonym
-DESCRIBE FUNCTION !
+POSTHOOK: query: DESCRIBE FUNCTION !
POSTHOOK: type: DESCFUNCTION
! a - Logical not
PREHOOK: query: DESCRIBE FUNCTION EXTENDED !
Modified: hive/trunk/ql/src/test/results/clientpositive/udf_percentile.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf_percentile.q.out?rev=1465903&r1=1465902&r2=1465903&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udf_percentile.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udf_percentile.q.out Tue Apr 9 06:33:16 2013
@@ -288,8 +288,7 @@ POSTHOOK: Input: default@src
47 470.0 477.0 479.0 [470.0,477.0,478.94,479.0]
48 480.0 484.0 489.0 [480.0,484.0,489.0,489.0]
49 490.0 494.5 498.0 [490.0,494.5,498.0,498.0]
-PREHOOK: query: -- test null handling
-SELECT CAST(key AS INT) DIV 10,
+PREHOOK: query: SELECT CAST(key AS INT) DIV 10,
percentile(NULL, 0.0),
percentile(NULL, array(0.0, 0.5, 0.99, 1.0))
FROM src
@@ -297,8 +296,7 @@ GROUP BY CAST(key AS INT) DIV 10
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: -- test null handling
-SELECT CAST(key AS INT) DIV 10,
+POSTHOOK: query: SELECT CAST(key AS INT) DIV 10,
percentile(NULL, 0.0),
percentile(NULL, array(0.0, 0.5, 0.99, 1.0))
FROM src
@@ -356,8 +354,7 @@ POSTHOOK: Input: default@src
47 NULL NULL
48 NULL NULL
49 NULL NULL
-PREHOOK: query: -- test empty array handling
-SELECT CAST(key AS INT) DIV 10,
+PREHOOK: query: SELECT CAST(key AS INT) DIV 10,
percentile(IF(CAST(key AS INT) DIV 10 < 5, 1, NULL), 0.5),
percentile(IF(CAST(key AS INT) DIV 10 < 5, 1, NULL), array(0.0, 0.5, 0.99, 1.0))
FROM src
@@ -365,8 +362,7 @@ GROUP BY CAST(key AS INT) DIV 10
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: -- test empty array handling
-SELECT CAST(key AS INT) DIV 10,
+POSTHOOK: query: SELECT CAST(key AS INT) DIV 10,
percentile(IF(CAST(key AS INT) DIV 10 < 5, 1, NULL), 0.5),
percentile(IF(CAST(key AS INT) DIV 10 < 5, 1, NULL), array(0.0, 0.5, 0.99, 1.0))
FROM src
@@ -433,13 +429,11 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
NULL
-PREHOOK: query: -- test where percentile list is empty
-select percentile(cast(key as bigint), array()) from src where false
+PREHOOK: query: select percentile(cast(key as bigint), array()) from src where false
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: -- test where percentile list is empty
-select percentile(cast(key as bigint), array()) from src where false
+POSTHOOK: query: select percentile(cast(key as bigint), array()) from src where false
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
Modified: hive/trunk/ql/src/test/results/clientpositive/udf_positive.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf_positive.q.out?rev=1465903&r1=1465902&r2=1465903&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udf_positive.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udf_positive.q.out Tue Apr 9 06:33:16 2013
@@ -8,11 +8,9 @@ PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED positive
POSTHOOK: type: DESCFUNCTION
positive a - Returns a
-PREHOOK: query: -- synonym
-DESCRIBE FUNCTION +
+PREHOOK: query: DESCRIBE FUNCTION +
PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: -- synonym
-DESCRIBE FUNCTION +
+POSTHOOK: query: DESCRIBE FUNCTION +
POSTHOOK: type: DESCFUNCTION
a + b - Returns a+b
PREHOOK: query: DESCRIBE FUNCTION EXTENDED +