http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/timestamp_ints_casts.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/timestamp_ints_casts.q.out 
b/ql/src/test/results/clientpositive/timestamp_ints_casts.q.out
index bc5ceb3..1966078 100644
--- a/ql/src/test/results/clientpositive/timestamp_ints_casts.q.out
+++ b/ql/src/test/results/clientpositive/timestamp_ints_casts.q.out
@@ -49,7 +49,7 @@ STAGE PLANS:
               predicate: ((cbigint % 250) = 0) (type: boolean)
               Statistics: Num rows: 6144 Data size: 1320982 Basic stats: 
COMPLETE Column stats: NONE
               Select Operator
-                expressions: CAST( ctinyint AS TIMESTAMP) (type: timestamp), 
CAST( csmallint AS TIMESTAMP) (type: timestamp), CAST( cint AS TIMESTAMP) 
(type: timestamp), CAST( cbigint AS TIMESTAMP) (type: timestamp), CAST( cfloat 
AS TIMESTAMP) (type: timestamp), CAST( cdouble AS TIMESTAMP) (type: timestamp), 
CAST( cboolean1 AS TIMESTAMP) (type: timestamp), CAST( (cbigint * 0) AS 
TIMESTAMP) (type: timestamp), ctimestamp1 (type: timestamp), CAST( cstring1 AS 
TIMESTAMP) (type: timestamp), CAST( substr(cstring1, 1, 1) AS TIMESTAMP) (type: 
timestamp)
+                expressions: CAST( ctinyint AS TIMESTAMP) (type: timestamp), 
CAST( csmallint AS TIMESTAMP) (type: timestamp), CAST( cint AS TIMESTAMP) 
(type: timestamp), CAST( cbigint AS TIMESTAMP) (type: timestamp), CAST( cfloat 
AS TIMESTAMP) (type: timestamp), CAST( cdouble AS TIMESTAMP) (type: timestamp), 
CAST( cboolean1 AS TIMESTAMP) (type: timestamp), CAST( (cbigint * 0L) AS 
TIMESTAMP) (type: timestamp), ctimestamp1 (type: timestamp), CAST( cstring1 AS 
TIMESTAMP) (type: timestamp), CAST( substr(cstring1, 1, 1) AS TIMESTAMP) (type: 
timestamp)
                 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, 
_col6, _col7, _col8, _col9, _col10
                 Statistics: Num rows: 6144 Data size: 1320982 Basic stats: 
COMPLETE Column stats: NONE
                 File Output Operator
@@ -181,7 +181,7 @@ STAGE PLANS:
               predicate: ((cbigint % 250) = 0) (type: boolean)
               Statistics: Num rows: 6144 Data size: 1320982 Basic stats: 
COMPLETE Column stats: NONE
               Select Operator
-                expressions: CAST( ctinyint AS TIMESTAMP) (type: timestamp), 
CAST( csmallint AS TIMESTAMP) (type: timestamp), CAST( cint AS TIMESTAMP) 
(type: timestamp), CAST( cbigint AS TIMESTAMP) (type: timestamp), CAST( cfloat 
AS TIMESTAMP) (type: timestamp), CAST( cdouble AS TIMESTAMP) (type: timestamp), 
CAST( cboolean1 AS TIMESTAMP) (type: timestamp), CAST( (cbigint * 0) AS 
TIMESTAMP) (type: timestamp), ctimestamp1 (type: timestamp), CAST( cstring1 AS 
TIMESTAMP) (type: timestamp), CAST( substr(cstring1, 1, 1) AS TIMESTAMP) (type: 
timestamp)
+                expressions: CAST( ctinyint AS TIMESTAMP) (type: timestamp), 
CAST( csmallint AS TIMESTAMP) (type: timestamp), CAST( cint AS TIMESTAMP) 
(type: timestamp), CAST( cbigint AS TIMESTAMP) (type: timestamp), CAST( cfloat 
AS TIMESTAMP) (type: timestamp), CAST( cdouble AS TIMESTAMP) (type: timestamp), 
CAST( cboolean1 AS TIMESTAMP) (type: timestamp), CAST( (cbigint * 0L) AS 
TIMESTAMP) (type: timestamp), ctimestamp1 (type: timestamp), CAST( cstring1 AS 
TIMESTAMP) (type: timestamp), CAST( substr(cstring1, 1, 1) AS TIMESTAMP) (type: 
timestamp)
                 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, 
_col6, _col7, _col8, _col9, _col10
                 Statistics: Num rows: 6144 Data size: 1320982 Basic stats: 
COMPLETE Column stats: NONE
                 File Output Operator

http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/timestamp_literal.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/timestamp_literal.q.out 
b/ql/src/test/results/clientpositive/timestamp_literal.q.out
index 4e06969..67750bb 100644
--- a/ql/src/test/results/clientpositive/timestamp_literal.q.out
+++ b/ql/src/test/results/clientpositive/timestamp_literal.q.out
@@ -17,7 +17,7 @@ STAGE PLANS:
           Row Limit Per Split: 1
           Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column 
stats: COMPLETE
           Select Operator
-            expressions: 2011-01-01 01:01:01.0 (type: timestamp)
+            expressions: TIMESTAMP'2011-01-01 01:01:01.0' (type: timestamp)
             outputColumnNames: _col0
             Statistics: Num rows: 1 Data size: 40 Basic stats: COMPLETE Column 
stats: COMPLETE
             ListSink

http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/timestamptz.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/timestamptz.q.out 
b/ql/src/test/results/clientpositive/timestamptz.q.out
index 7cff9a5..0b5c05c 100644
--- a/ql/src/test/results/clientpositive/timestamptz.q.out
+++ b/ql/src/test/results/clientpositive/timestamptz.q.out
@@ -15,7 +15,7 @@ STAGE PLANS:
           Row Limit Per Split: 1
           Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column 
stats: COMPLETE
           Select Operator
-            expressions: 2005-01-02 18:01:00.0 US/Pacific (type: timestamp 
with local time zone)
+            expressions: TIMESTAMPLOCALTZ'2005-01-02 18:01:00.0 US/Pacific' 
(type: timestamp with local time zone)
             outputColumnNames: _col0
             Statistics: Num rows: 1 Data size: 40 Basic stats: COMPLETE Column 
stats: COMPLETE
             ListSink
@@ -46,7 +46,7 @@ STAGE PLANS:
           Row Limit Per Split: 1
           Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column 
stats: COMPLETE
           Select Operator
-            expressions: 2016-01-03 12:26:34.0123 US/Pacific (type: timestamp 
with local time zone)
+            expressions: TIMESTAMPLOCALTZ'2016-01-03 12:26:34.0123 US/Pacific' 
(type: timestamp with local time zone)
             outputColumnNames: _col0
             Statistics: Num rows: 1 Data size: 40 Basic stats: COMPLETE Column 
stats: COMPLETE
             ListSink
@@ -77,7 +77,7 @@ STAGE PLANS:
           Row Limit Per Split: 1
           Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column 
stats: COMPLETE
           Select Operator
-            expressions: 2016-01-02 16:00:00.0 US/Pacific (type: timestamp 
with local time zone)
+            expressions: TIMESTAMPLOCALTZ'2016-01-02 16:00:00.0 US/Pacific' 
(type: timestamp with local time zone)
             outputColumnNames: _col0
             Statistics: Num rows: 1 Data size: 40 Basic stats: COMPLETE Column 
stats: COMPLETE
             ListSink
@@ -108,7 +108,7 @@ STAGE PLANS:
           Row Limit Per Split: 1
           Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column 
stats: COMPLETE
           Select Operator
-            expressions: 2016-01-03 04:34:56.38 US/Pacific (type: timestamp 
with local time zone)
+            expressions: TIMESTAMPLOCALTZ'2016-01-03 04:34:56.38 US/Pacific' 
(type: timestamp with local time zone)
             outputColumnNames: _col0
             Statistics: Num rows: 1 Data size: 40 Basic stats: COMPLETE Column 
stats: COMPLETE
             ListSink

http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/type_widening.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/type_widening.q.out 
b/ql/src/test/results/clientpositive/type_widening.q.out
index 30e5564..3c0feb8 100644
--- a/ql/src/test/results/clientpositive/type_widening.q.out
+++ b/ql/src/test/results/clientpositive/type_widening.q.out
@@ -14,7 +14,7 @@ STAGE PLANS:
           alias: src
           Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: COMPLETE
           Select Operator
-            expressions: 0 (type: bigint)
+            expressions: 0L (type: bigint)
             outputColumnNames: _col0
             Statistics: Num rows: 500 Data size: 4000 Basic stats: COMPLETE 
Column stats: COMPLETE
             Limit
@@ -47,7 +47,7 @@ STAGE PLANS:
             alias: src
             Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: COMPLETE
             Select Operator
-              expressions: 0 (type: bigint)
+              expressions: 0L (type: bigint)
               outputColumnNames: _col0
               Statistics: Num rows: 500 Data size: 4000 Basic stats: COMPLETE 
Column stats: COMPLETE
               Union
@@ -60,7 +60,7 @@ STAGE PLANS:
             alias: src
             Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: COMPLETE
             Select Operator
-              expressions: 9223372036854775807 (type: bigint)
+              expressions: 9223372036854775807L (type: bigint)
               outputColumnNames: _col0
               Statistics: Num rows: 500 Data size: 4000 Basic stats: COMPLETE 
Column stats: COMPLETE
               Union
@@ -1120,7 +1120,7 @@ STAGE PLANS:
           alias: t1
           Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
           Filter Operator
-            predicate: (a > 2) (type: boolean)
+            predicate: (a > 2Y) (type: boolean)
             Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
             Select Operator
               expressions: a (type: tinyint), b (type: smallint)
@@ -1144,7 +1144,7 @@ STAGE PLANS:
           alias: t1
           Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
           Filter Operator
-            predicate: (b < 2) (type: boolean)
+            predicate: (b < 2S) (type: boolean)
             Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
             Select Operator
               expressions: a (type: tinyint), b (type: smallint)

http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/udaf_percentile_approx_23.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udaf_percentile_approx_23.q.out 
b/ql/src/test/results/clientpositive/udaf_percentile_approx_23.q.out
index bf78003..54cb131 100644
--- a/ql/src/test/results/clientpositive/udaf_percentile_approx_23.q.out
+++ b/ql/src/test/results/clientpositive/udaf_percentile_approx_23.q.out
@@ -512,7 +512,7 @@ STAGE PLANS:
             alias: bucket
             Statistics: Num rows: 1 Data size: 58120 Basic stats: COMPLETE 
Column stats: NONE
             Select Operator
-              expressions: CASE WHEN ((key < 100.0)) THEN (NaN) ELSE (key) END 
(type: double)
+              expressions: CASE WHEN ((key < 100.0D)) THEN (NaND) ELSE (key) 
END (type: double)
               outputColumnNames: _col0
               Statistics: Num rows: 1 Data size: 58120 Basic stats: COMPLETE 
Column stats: NONE
               Group By Operator

http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/udf1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf1.q.out 
b/ql/src/test/results/clientpositive/udf1.q.out
index 27dbfa4..885de90 100644
--- a/ql/src/test/results/clientpositive/udf1.q.out
+++ b/ql/src/test/results/clientpositive/udf1.q.out
@@ -50,7 +50,7 @@ STAGE PLANS:
             alias: src
             Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
-              predicate: (UDFToDouble(key) = 86.0) (type: boolean)
+              predicate: (UDFToDouble(key) = 86.0D) (type: boolean)
               Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
                 expressions: 'TRUE' (type: string), 'FALSE' (type: string), 
'TRUE' (type: string), 'TRUE' (type: string), 'TRUE' (type: string), 'FALSE' 
(type: string), 'FALSE' (type: string), 'FALSE' (type: string), 'TRUE' (type: 
string), 'TRUE' (type: string), 'FALSE' (type: string), 'TRUE' (type: string), 
'TRUE' (type: string), 'acc' (type: string), 'abc' (type: string), 'abb' (type: 
string), 'hive' (type: string), 'hadoop' (type: string), 'AaAbAcA' (type: 
string), 'FALSE' (type: string)

http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/udf4.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf4.q.out 
b/ql/src/test/results/clientpositive/udf4.q.out
index 5d263eb..1ffc265 100644
--- a/ql/src/test/results/clientpositive/udf4.q.out
+++ b/ql/src/test/results/clientpositive/udf4.q.out
@@ -77,7 +77,7 @@ STAGE PLANS:
             alias: dest1
             Statistics: Num rows: 1 Data size: 7 Basic stats: COMPLETE Column 
stats: COMPLETE
             Select Operator
-              expressions: 1 (type: decimal(1,0)), 2 (type: decimal(2,0)), -2 
(type: decimal(2,0)), 1 (type: decimal(2,0)), 1 (type: decimal(2,0)), -2 (type: 
decimal(2,0)), 1.0 (type: double), null (type: double), 0.0 (type: double), 1 
(type: decimal(2,0)), 2 (type: decimal(2,0)), -1 (type: decimal(2,0)), 1 (type: 
decimal(2,0)), rand(3) (type: double), 3 (type: int), -3 (type: int), 3 (type: 
int), -1 (type: int), -2 (type: int), -2 (type: tinyint), -2 (type: smallint), 
-2 (type: bigint), 0 (type: tinyint), 0 (type: smallint), 0 (type: int), 0 
(type: bigint), 3 (type: tinyint), 3 (type: smallint), 3 (type: int), 3 (type: 
bigint), 2 (type: tinyint), 2 (type: smallint), 2 (type: int), 2 (type: bigint)
+              expressions: 1 (type: decimal(1,0)), 2 (type: decimal(2,0)), -2 
(type: decimal(2,0)), 1 (type: decimal(2,0)), 1 (type: decimal(2,0)), -2 (type: 
decimal(2,0)), 1.0D (type: double), null (type: double), 0.0D (type: double), 1 
(type: decimal(2,0)), 2 (type: decimal(2,0)), -1 (type: decimal(2,0)), 1 (type: 
decimal(2,0)), rand(3) (type: double), 3 (type: int), -3 (type: int), 3 (type: 
int), -1 (type: int), -2 (type: int), -2Y (type: tinyint), -2S (type: 
smallint), -2L (type: bigint), 0Y (type: tinyint), 0S (type: smallint), 0 
(type: int), 0L (type: bigint), 3Y (type: tinyint), 3S (type: smallint), 3 
(type: int), 3L (type: bigint), 2Y (type: tinyint), 2S (type: smallint), 2 
(type: int), 2L (type: bigint)
               outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, 
_col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, 
_col16, _col17, _col18, _col19, _col20, _col21, _col22, _col23, _col24, _col25, 
_col26, _col27, _col28, _col29, _col30, _col31, _col32, _col33
               Statistics: Num rows: 1 Data size: 1248 Basic stats: COMPLETE 
Column stats: COMPLETE
               File Output Operator

http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/udf5.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf5.q.out 
b/ql/src/test/results/clientpositive/udf5.q.out
index 3fa801a..d96620a 100644
--- a/ql/src/test/results/clientpositive/udf5.q.out
+++ b/ql/src/test/results/clientpositive/udf5.q.out
@@ -33,7 +33,7 @@ STAGE PLANS:
           alias: dest1
           Statistics: Num rows: 1 Data size: 7 Basic stats: COMPLETE Column 
stats: COMPLETE
           Select Operator
-            expressions: '2008-11-11 15:32:20' (type: string), 2008-11-11 
(type: date), 1 (type: int), 11 (type: int), 2008 (type: int), 1 (type: int), 
11 (type: int), 2008 (type: int)
+            expressions: '2008-11-11 15:32:20' (type: string), 
DATE'2008-11-11' (type: date), 1 (type: int), 11 (type: int), 2008 (type: int), 
1 (type: int), 11 (type: int), 2008 (type: int)
             outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, 
_col6, _col7
             Statistics: Num rows: 1 Data size: 183 Basic stats: COMPLETE 
Column stats: COMPLETE
             ListSink

http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/udf6.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf6.q.out 
b/ql/src/test/results/clientpositive/udf6.q.out
index 4193d34..69e0130 100644
--- a/ql/src/test/results/clientpositive/udf6.q.out
+++ b/ql/src/test/results/clientpositive/udf6.q.out
@@ -75,7 +75,7 @@ STAGE PLANS:
           alias: dest1
           Statistics: Num rows: 1 Data size: 7 Basic stats: COMPLETE Column 
stats: COMPLETE
           Select Operator
-            expressions: 1 (type: int), 2 (type: int), 2 (type: int), 'a' 
(type: string), 0.1 (type: decimal(1,1)), 2 (type: bigint), 126 (type: 
tinyint), 128 (type: smallint), 128 (type: int), 1.0 (type: double), '128' 
(type: string)
+            expressions: 1 (type: int), 2 (type: int), 2 (type: int), 'a' 
(type: string), 0.1 (type: decimal(1,1)), 2L (type: bigint), 126Y (type: 
tinyint), 128S (type: smallint), 128 (type: int), 1.0D (type: double), '128' 
(type: string)
             outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, 
_col6, _col7, _col8, _col9, _col10
             Statistics: Num rows: 1 Data size: 324 Basic stats: COMPLETE 
Column stats: COMPLETE
             ListSink

http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/udf7.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf7.q.out 
b/ql/src/test/results/clientpositive/udf7.q.out
index 12ebb2d..9095569 100644
--- a/ql/src/test/results/clientpositive/udf7.q.out
+++ b/ql/src/test/results/clientpositive/udf7.q.out
@@ -47,7 +47,7 @@ STAGE PLANS:
           alias: dest1
           Statistics: Num rows: 1 Data size: 7 Basic stats: COMPLETE Column 
stats: COMPLETE
           Select Operator
-            expressions: 1.098612288668 (type: double), null (type: double), 
null (type: double), 1.098612288668 (type: double), null (type: double), null 
(type: double), 1.584962500721 (type: double), null (type: double), null (type: 
double), 0.47712125472 (type: double), null (type: double), null (type: 
double), 1.584962500721 (type: double), null (type: double), null (type: 
double), null (type: double), -1.0 (type: double), 7.389056098931 (type: 
double), 8.0 (type: double), 8.0 (type: double), 0.125 (type: double), 8.0 
(type: double), 2.0 (type: double), NaN (type: double), 1.0 (type: double), 1.0 
(type: double), 8.0 (type: double), 8.0 (type: double)
+            expressions: 1.098612288668D (type: double), null (type: double), 
null (type: double), 1.098612288668D (type: double), null (type: double), null 
(type: double), 1.584962500721D (type: double), null (type: double), null 
(type: double), 0.47712125472D (type: double), null (type: double), null (type: 
double), 1.584962500721D (type: double), null (type: double), null (type: 
double), null (type: double), -1.0D (type: double), 7.389056098931D (type: 
double), 8.0D (type: double), 8.0D (type: double), 0.125D (type: double), 8.0D 
(type: double), 2.0D (type: double), NaND (type: double), 1.0D (type: double), 
1.0D (type: double), 8.0D (type: double), 8.0D (type: double)
             outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, 
_col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, 
_col16, _col17, _col18, _col19, _col20, _col21, _col22, _col23, _col24, _col25, 
_col26, _col27
             Statistics: Num rows: 1 Data size: 224 Basic stats: COMPLETE 
Column stats: COMPLETE
             ListSink

http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/udf9.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf9.q.out 
b/ql/src/test/results/clientpositive/udf9.q.out
index a9bd954..a247a8e 100644
--- a/ql/src/test/results/clientpositive/udf9.q.out
+++ b/ql/src/test/results/clientpositive/udf9.q.out
@@ -32,10 +32,10 @@ STAGE PLANS:
             alias: src
             Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
-              predicate: (UDFToDouble(key) = 86.0) (type: boolean)
+              predicate: (UDFToDouble(key) = 86.0D) (type: boolean)
               Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
-                expressions: -1 (type: int), 2 (type: int), 32 (type: int), -1 
(type: int), 2009-01-01 (type: date), 2009-12-31 (type: date), 2008-03-01 
(type: date), 2009-03-02 (type: date), 2008-02-28 (type: date), 2009-02-27 
(type: date), 2008-12-31 (type: date), 2008-01-02 (type: date), 2008-02-26 
(type: date), 2009-02-26 (type: date), 2006-02-28 (type: date), 2005-02-28 
(type: date)
+                expressions: -1 (type: int), 2 (type: int), 32 (type: int), -1 
(type: int), DATE'2009-01-01' (type: date), DATE'2009-12-31' (type: date), 
DATE'2008-03-01' (type: date), DATE'2009-03-02' (type: date), DATE'2008-02-28' 
(type: date), DATE'2009-02-27' (type: date), DATE'2008-12-31' (type: date), 
DATE'2008-01-02' (type: date), DATE'2008-02-26' (type: date), DATE'2009-02-26' 
(type: date), DATE'2006-02-28' (type: date), DATE'2005-02-28' (type: date)
                 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, 
_col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15
                 Statistics: Num rows: 250 Data size: 2656 Basic stats: 
COMPLETE Column stats: NONE
                 File Output Operator

http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/udf_10_trims.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_10_trims.q.out 
b/ql/src/test/results/clientpositive/udf_10_trims.q.out
index 4f08014..5a53eb1 100644
--- a/ql/src/test/results/clientpositive/udf_10_trims.q.out
+++ b/ql/src/test/results/clientpositive/udf_10_trims.q.out
@@ -36,7 +36,7 @@ STAGE PLANS:
             alias: src
             Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
-              predicate: (UDFToDouble(key) = 86.0) (type: boolean)
+              predicate: (UDFToDouble(key) = 86.0D) (type: boolean)
               Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
                 expressions: 'abc' (type: string)

http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/udf_E.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_E.q.out 
b/ql/src/test/results/clientpositive/udf_E.q.out
index 4ba0e1f..fe6cd9d 100644
--- a/ql/src/test/results/clientpositive/udf_E.q.out
+++ b/ql/src/test/results/clientpositive/udf_E.q.out
@@ -17,7 +17,7 @@ STAGE PLANS:
           Row Limit Per Split: 1
           Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: COMPLETE
           Select Operator
-            expressions: 2.718281828459045 (type: double)
+            expressions: 2.718281828459045D (type: double)
             outputColumnNames: _col0
             Statistics: Num rows: 500 Data size: 4000 Basic stats: COMPLETE 
Column stats: COMPLETE
             ListSink
@@ -66,7 +66,7 @@ STAGE PLANS:
           Row Limit Per Split: 1
           Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: COMPLETE
           Select Operator
-            expressions: 2.718281828459045 (type: double)
+            expressions: 2.718281828459045D (type: double)
             outputColumnNames: _col0
             Statistics: Num rows: 500 Data size: 4000 Basic stats: COMPLETE 
Column stats: COMPLETE
             ListSink

http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/udf_PI.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_PI.q.out 
b/ql/src/test/results/clientpositive/udf_PI.q.out
index 0479eef..df911df 100644
--- a/ql/src/test/results/clientpositive/udf_PI.q.out
+++ b/ql/src/test/results/clientpositive/udf_PI.q.out
@@ -17,7 +17,7 @@ STAGE PLANS:
           Row Limit Per Split: 1
           Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: COMPLETE
           Select Operator
-            expressions: 3.141592653589793 (type: double)
+            expressions: 3.141592653589793D (type: double)
             outputColumnNames: _col0
             Statistics: Num rows: 500 Data size: 4000 Basic stats: COMPLETE 
Column stats: COMPLETE
             ListSink
@@ -66,7 +66,7 @@ STAGE PLANS:
           Row Limit Per Split: 1
           Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: COMPLETE
           Select Operator
-            expressions: 3.141592653589793 (type: double)
+            expressions: 3.141592653589793D (type: double)
             outputColumnNames: _col0
             Statistics: Num rows: 500 Data size: 4000 Basic stats: COMPLETE 
Column stats: COMPLETE
             ListSink

http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/udf_abs.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_abs.q.out 
b/ql/src/test/results/clientpositive/udf_abs.q.out
index 5a8c4d7..dcd4b36 100644
--- a/ql/src/test/results/clientpositive/udf_abs.q.out
+++ b/ql/src/test/results/clientpositive/udf_abs.q.out
@@ -44,7 +44,7 @@ STAGE PLANS:
           Row Limit Per Split: 1
           Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: COMPLETE
           Select Operator
-            expressions: 0 (type: int), 1 (type: int), 123 (type: int), 
9223372036854775807 (type: bigint), 9223372036854775807 (type: bigint)
+            expressions: 0 (type: int), 1 (type: int), 123 (type: int), 
9223372036854775807L (type: bigint), 9223372036854775807L (type: bigint)
             outputColumnNames: _col0, _col1, _col2, _col3, _col4
             Statistics: Num rows: 500 Data size: 14000 Basic stats: COMPLETE 
Column stats: COMPLETE
             ListSink

http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/udf_between.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_between.q.out 
b/ql/src/test/results/clientpositive/udf_between.q.out
index 8070735..9262d42 100644
--- a/ql/src/test/results/clientpositive/udf_between.q.out
+++ b/ql/src/test/results/clientpositive/udf_between.q.out
@@ -26,7 +26,7 @@ STAGE PLANS:
           alias: src
           Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: NONE
           Filter Operator
-            predicate: (UDFToDouble(key) + 100.0) BETWEEN 100.0 AND 200.0 
(type: boolean)
+            predicate: (UDFToDouble(key) + 100.0D) BETWEEN 100.0D AND 200.0D 
(type: boolean)
             Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE 
Column stats: NONE
             Select Operator
               expressions: key (type: string), value (type: string)
@@ -81,7 +81,7 @@ STAGE PLANS:
           alias: src
           Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: NONE
           Filter Operator
-            predicate: (not (UDFToDouble(key) + 100.0) BETWEEN 100.0 AND 
200.0) (type: boolean)
+            predicate: (not (UDFToDouble(key) + 100.0D) BETWEEN 100.0D AND 
200.0D) (type: boolean)
             Statistics: Num rows: 445 Data size: 4727 Basic stats: COMPLETE 
Column stats: NONE
             Select Operator
               expressions: key (type: string), value (type: string)

http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/udf_cbrt.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_cbrt.q.out 
b/ql/src/test/results/clientpositive/udf_cbrt.q.out
index 4c30ad4..f5a19e6 100644
--- a/ql/src/test/results/clientpositive/udf_cbrt.q.out
+++ b/ql/src/test/results/clientpositive/udf_cbrt.q.out
@@ -30,7 +30,7 @@ STAGE PLANS:
           Row Limit Per Split: 1
           Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column 
stats: COMPLETE
           Select Operator
-            expressions: 3.0 (type: double)
+            expressions: 3.0D (type: double)
             outputColumnNames: _col0
             Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column 
stats: COMPLETE
             ListSink

http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/udf_crc32.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_crc32.q.out 
b/ql/src/test/results/clientpositive/udf_crc32.q.out
index 5d2888a..43be194 100644
--- a/ql/src/test/results/clientpositive/udf_crc32.q.out
+++ b/ql/src/test/results/clientpositive/udf_crc32.q.out
@@ -32,7 +32,7 @@ STAGE PLANS:
           Row Limit Per Split: 1
           Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column 
stats: COMPLETE
           Select Operator
-            expressions: 2743272264 (type: bigint)
+            expressions: 2743272264L (type: bigint)
             outputColumnNames: _col0
             Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column 
stats: COMPLETE
             ListSink

http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/udf_degrees.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_degrees.q.out 
b/ql/src/test/results/clientpositive/udf_degrees.q.out
index 867663b..8490c44 100644
--- a/ql/src/test/results/clientpositive/udf_degrees.q.out
+++ b/ql/src/test/results/clientpositive/udf_degrees.q.out
@@ -17,7 +17,7 @@ STAGE PLANS:
           Row Limit Per Split: 1
           Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: COMPLETE
           Select Operator
-            expressions: 180.0 (type: double)
+            expressions: 180.0D (type: double)
             outputColumnNames: _col0
             Statistics: Num rows: 500 Data size: 4000 Basic stats: COMPLETE 
Column stats: COMPLETE
             ListSink
@@ -66,7 +66,7 @@ STAGE PLANS:
           Row Limit Per Split: 1
           Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: COMPLETE
           Select Operator
-            expressions: 180.0 (type: double)
+            expressions: 180.0D (type: double)
             outputColumnNames: _col0
             Statistics: Num rows: 500 Data size: 4000 Basic stats: COMPLETE 
Column stats: COMPLETE
             ListSink

http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/udf_example_add.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_example_add.q.out 
b/ql/src/test/results/clientpositive/udf_example_add.q.out
index 7916679..b092383 100644
--- a/ql/src/test/results/clientpositive/udf_example_add.q.out
+++ b/ql/src/test/results/clientpositive/udf_example_add.q.out
@@ -36,7 +36,7 @@ STAGE PLANS:
           alias: src
           Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: COMPLETE
           Select Operator
-            expressions: 3 (type: int), 6 (type: int), 10 (type: int), 
3.3000000000000003 (type: double), 6.6 (type: double), 11.0 (type: double), 
10.4 (type: double)
+            expressions: 3 (type: int), 6 (type: int), 10 (type: int), 
3.3000000000000003D (type: double), 6.6D (type: double), 11.0D (type: double), 
10.4D (type: double)
             outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
             Statistics: Num rows: 500 Data size: 22000 Basic stats: COMPLETE 
Column stats: COMPLETE
             Limit

http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/udf_factorial.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_factorial.q.out 
b/ql/src/test/results/clientpositive/udf_factorial.q.out
index d6757aa..4700c69 100644
--- a/ql/src/test/results/clientpositive/udf_factorial.q.out
+++ b/ql/src/test/results/clientpositive/udf_factorial.q.out
@@ -31,7 +31,7 @@ STAGE PLANS:
           Row Limit Per Split: 1
           Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column 
stats: COMPLETE
           Select Operator
-            expressions: 120 (type: bigint)
+            expressions: 120L (type: bigint)
             outputColumnNames: _col0
             Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column 
stats: COMPLETE
             ListSink

http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/udf_folder_constants.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_folder_constants.q.out 
b/ql/src/test/results/clientpositive/udf_folder_constants.q.out
index 70a8c01..33070c7 100644
--- a/ql/src/test/results/clientpositive/udf_folder_constants.q.out
+++ b/ql/src/test/results/clientpositive/udf_folder_constants.q.out
@@ -94,7 +94,7 @@ STAGE PLANS:
             1 _col0 (type: int)
           Statistics: Num rows: 1 Data size: 7 Basic stats: COMPLETE Column 
stats: NONE
           Select Operator
-            expressions: 978336000 (type: bigint)
+            expressions: 978336000L (type: bigint)
             outputColumnNames: _col0
             Statistics: Num rows: 1 Data size: 7 Basic stats: COMPLETE Column 
stats: NONE
             File Output Operator

http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/udf_from_utc_timestamp.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_from_utc_timestamp.q.out 
b/ql/src/test/results/clientpositive/udf_from_utc_timestamp.q.out
index f00e3a1..d650e39 100644
--- a/ql/src/test/results/clientpositive/udf_from_utc_timestamp.q.out
+++ b/ql/src/test/results/clientpositive/udf_from_utc_timestamp.q.out
@@ -27,7 +27,7 @@ STAGE PLANS:
           Row Limit Per Split: 1
           Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column 
stats: COMPLETE
           Select Operator
-            expressions: 2012-02-11 02:30:00.0 (type: timestamp)
+            expressions: TIMESTAMP'2012-02-11 02:30:00.0' (type: timestamp)
             outputColumnNames: _col0
             Statistics: Num rows: 1 Data size: 40 Basic stats: COMPLETE Column 
stats: COMPLETE
             ListSink

http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/udf_hour.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_hour.q.out 
b/ql/src/test/results/clientpositive/udf_hour.q.out
index d37c079..d26d71f 100644
--- a/ql/src/test/results/clientpositive/udf_hour.q.out
+++ b/ql/src/test/results/clientpositive/udf_hour.q.out
@@ -38,7 +38,7 @@ STAGE PLANS:
           alias: src
           Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: NONE
           Filter Operator
-            predicate: (UDFToDouble(key) = 86.0) (type: boolean)
+            predicate: (UDFToDouble(key) = 86.0D) (type: boolean)
             Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE 
Column stats: NONE
             Select Operator
               expressions: 13 (type: int), 13 (type: int), null (type: int)

http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/udf_if.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_if.q.out 
b/ql/src/test/results/clientpositive/udf_if.q.out
index eac4fe3..c46a730 100644
--- a/ql/src/test/results/clientpositive/udf_if.q.out
+++ b/ql/src/test/results/clientpositive/udf_if.q.out
@@ -94,7 +94,7 @@ STAGE PLANS:
           Row Limit Per Split: 1
           Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: COMPLETE
           Select Operator
-            expressions: 128 (type: smallint), 1.1 (type: decimal(11,1)), 
'ABC' (type: string), '12.3' (type: string)
+            expressions: 128S (type: smallint), 1.1 (type: decimal(11,1)), 
'ABC' (type: string), '12.3' (type: string)
             outputColumnNames: _col0, _col1, _col2, _col3
             Statistics: Num rows: 500 Data size: 145500 Basic stats: COMPLETE 
Column stats: COMPLETE
             ListSink

http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/udf_java_method.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_java_method.q.out 
b/ql/src/test/results/clientpositive/udf_java_method.q.out
index f2f146d..6a62111 100644
--- a/ql/src/test/results/clientpositive/udf_java_method.q.out
+++ b/ql/src/test/results/clientpositive/udf_java_method.q.out
@@ -47,7 +47,7 @@ STAGE PLANS:
           Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: COMPLETE
           GatherStats: false
           Select Operator
-            expressions: reflect('java.lang.String','valueOf',1) (type: 
string), reflect('java.lang.String','isEmpty') (type: string), 
reflect('java.lang.Math','max',2,3) (type: string), 
reflect('java.lang.Math','min',2,3) (type: string), 
reflect('java.lang.Math','round',2.5) (type: string), 
round(reflect('java.lang.Math','exp',1.0), 6) (type: double), 
reflect('java.lang.Math','floor',1.9) (type: string)
+            expressions: reflect('java.lang.String','valueOf',1) (type: 
string), reflect('java.lang.String','isEmpty') (type: string), 
reflect('java.lang.Math','max',2,3) (type: string), 
reflect('java.lang.Math','min',2,3) (type: string), 
reflect('java.lang.Math','round',2.5D) (type: string), 
round(reflect('java.lang.Math','exp',1.0D), 6) (type: double), 
reflect('java.lang.Math','floor',1.9D) (type: string)
             outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
             Statistics: Num rows: 500 Data size: 556000 Basic stats: COMPLETE 
Column stats: COMPLETE
             ListSink

http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/udf_like.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_like.q.out 
b/ql/src/test/results/clientpositive/udf_like.q.out
index 64c17bd..c248e54 100644
--- a/ql/src/test/results/clientpositive/udf_like.q.out
+++ b/ql/src/test/results/clientpositive/udf_like.q.out
@@ -37,7 +37,7 @@ STAGE PLANS:
           alias: src
           Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: NONE
           Filter Operator
-            predicate: (UDFToDouble(key) = 86.0) (type: boolean)
+            predicate: (UDFToDouble(key) = 86.0D) (type: boolean)
             Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE 
Column stats: NONE
             Select Operator
               expressions: true (type: boolean), false (type: boolean), true 
(type: boolean), true (type: boolean), false (type: boolean), false (type: 
boolean), false (type: boolean), false (type: boolean), true (type: boolean), 
false (type: boolean), false (type: boolean), false (type: boolean), false 
(type: boolean), true (type: boolean)

http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/udf_lower.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_lower.q.out 
b/ql/src/test/results/clientpositive/udf_lower.q.out
index e816594..3d995d1 100644
--- a/ql/src/test/results/clientpositive/udf_lower.q.out
+++ b/ql/src/test/results/clientpositive/udf_lower.q.out
@@ -32,7 +32,7 @@ STAGE PLANS:
             alias: src
             Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
-              predicate: (UDFToDouble(key) = 86.0) (type: boolean)
+              predicate: (UDFToDouble(key) = 86.0D) (type: boolean)
               Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
                 expressions: 'abc 123' (type: string), 'ABC 123' (type: string)

http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/udf_minute.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_minute.q.out 
b/ql/src/test/results/clientpositive/udf_minute.q.out
index f7141d2..13f2125 100644
--- a/ql/src/test/results/clientpositive/udf_minute.q.out
+++ b/ql/src/test/results/clientpositive/udf_minute.q.out
@@ -38,7 +38,7 @@ STAGE PLANS:
             alias: src
             Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
-              predicate: (UDFToDouble(key) = 86.0) (type: boolean)
+              predicate: (UDFToDouble(key) = 86.0D) (type: boolean)
               Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
                 expressions: 14 (type: int), 14 (type: int), null (type: int)

http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/udf_months_between.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_months_between.q.out 
b/ql/src/test/results/clientpositive/udf_months_between.q.out
index 2335f0b..d78d9b3 100644
--- a/ql/src/test/results/clientpositive/udf_months_between.q.out
+++ b/ql/src/test/results/clientpositive/udf_months_between.q.out
@@ -32,7 +32,7 @@ STAGE PLANS:
           Row Limit Per Split: 1
           Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column 
stats: COMPLETE
           Select Operator
-            expressions: 1.03225806 (type: double)
+            expressions: 1.03225806D (type: double)
             outputColumnNames: _col0
             Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column 
stats: COMPLETE
             ListSink

http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/udf_parse_url.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_parse_url.q.out 
b/ql/src/test/results/clientpositive/udf_parse_url.q.out
index 0ea8584..dc4341c 100644
--- a/ql/src/test/results/clientpositive/udf_parse_url.q.out
+++ b/ql/src/test/results/clientpositive/udf_parse_url.q.out
@@ -59,7 +59,7 @@ STAGE PLANS:
             alias: src
             Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
-              predicate: (UDFToDouble(key) = 86.0) (type: boolean)
+              predicate: (UDFToDouble(key) = 86.0D) (type: boolean)
               Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
                 expressions: 'facebook.com' (type: string), '/path1/p.php' 
(type: string), 'k1=v1&k2=v2' (type: string), 'Ref1' (type: string), 'v2' 
(type: string), 'v1' (type: string), null (type: string), 
'/path1/p.php?k1=v1&k2=v2' (type: string), 'http' (type: string), null (type: 
string), 'facebook.com' (type: string)

http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/udf_radians.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_radians.q.out 
b/ql/src/test/results/clientpositive/udf_radians.q.out
index 14bd78c..0ce8281 100644
--- a/ql/src/test/results/clientpositive/udf_radians.q.out
+++ b/ql/src/test/results/clientpositive/udf_radians.q.out
@@ -17,7 +17,7 @@ STAGE PLANS:
           Row Limit Per Split: 1
           Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: COMPLETE
           Select Operator
-            expressions: 1.000000357564167 (type: double)
+            expressions: 1.000000357564167D (type: double)
             outputColumnNames: _col0
             Statistics: Num rows: 500 Data size: 4000 Basic stats: COMPLETE 
Column stats: COMPLETE
             ListSink
@@ -75,7 +75,7 @@ STAGE PLANS:
           Row Limit Per Split: 1
           Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: COMPLETE
           Select Operator
-            expressions: 1.000000357564167 (type: double)
+            expressions: 1.000000357564167D (type: double)
             outputColumnNames: _col0
             Statistics: Num rows: 500 Data size: 4000 Basic stats: COMPLETE 
Column stats: COMPLETE
             ListSink

http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/udf_reflect.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_reflect.q.out 
b/ql/src/test/results/clientpositive/udf_reflect.q.out
index a9863f7..97e40d1 100644
--- a/ql/src/test/results/clientpositive/udf_reflect.q.out
+++ b/ql/src/test/results/clientpositive/udf_reflect.q.out
@@ -49,7 +49,7 @@ STAGE PLANS:
           Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: NONE
           GatherStats: false
           Select Operator
-            expressions: reflect('java.lang.String','valueOf',1) (type: 
string), reflect('java.lang.String','isEmpty') (type: string), 
reflect('java.lang.Math','max',2,3) (type: string), 
reflect('java.lang.Math','min',2,3) (type: string), 
reflect('java.lang.Math','round',2.5) (type: string), 
round(reflect('java.lang.Math','exp',1.0), 6) (type: double), 
reflect('java.lang.Math','floor',1.9) (type: string), 
reflect('java.lang.Integer','valueOf',key,16) (type: string)
+            expressions: reflect('java.lang.String','valueOf',1) (type: 
string), reflect('java.lang.String','isEmpty') (type: string), 
reflect('java.lang.Math','max',2,3) (type: string), 
reflect('java.lang.Math','min',2,3) (type: string), 
reflect('java.lang.Math','round',2.5D) (type: string), 
round(reflect('java.lang.Math','exp',1.0D), 6) (type: double), 
reflect('java.lang.Math','floor',1.9D) (type: string), 
reflect('java.lang.Integer','valueOf',key,16) (type: string)
             outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, 
_col6, _col7
             Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: NONE
             ListSink

http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/udf_reflect2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_reflect2.q.out 
b/ql/src/test/results/clientpositive/udf_reflect2.q.out
index a1074f8..4834cd6 100644
--- a/ql/src/test/results/clientpositive/udf_reflect2.q.out
+++ b/ql/src/test/results/clientpositive/udf_reflect2.q.out
@@ -93,7 +93,7 @@ STAGE PLANS:
           Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: NONE
           GatherStats: false
           Select Operator
-            expressions: UDFToInteger(key) (type: int), 
reflect2(UDFToInteger(key),'byteValue') (type: tinyint), 
reflect2(UDFToInteger(key),'shortValue') (type: smallint), 
reflect2(UDFToInteger(key),'intValue') (type: int), 
reflect2(UDFToInteger(key),'longValue') (type: bigint), 
reflect2(UDFToInteger(key),'floatValue') (type: float), 
reflect2(UDFToInteger(key),'doubleValue') (type: double), 
reflect2(UDFToInteger(key),'toString') (type: string), value (type: string), 
reflect2(value,'concat','_concat') (type: string), 
reflect2(value,'contains','86') (type: boolean), 
reflect2(value,'startsWith','v') (type: boolean), 
reflect2(value,'endsWith','6') (type: boolean), 
reflect2(value,'equals','val_86') (type: boolean), 
reflect2(value,'equalsIgnoreCase','VAL_86') (type: boolean), 
reflect2(value,'getBytes') (type: binary), reflect2(value,'indexOf','1') (type: 
int), reflect2(value,'lastIndexOf','1') (type: int), 
reflect2(value,'replace','val','VALUE') (type: string), 
reflect2(value,'substring',
 1) (type: string), reflect2(value,'substring',1,5) (type: string), 
reflect2(value,'toUpperCase') (type: string), reflect2(value,'trim') (type: 
string), 2013-02-15 19:41:20.0 (type: timestamp), 113 (type: int), 1 (type: 
int), 5 (type: int), 19 (type: int), 41 (type: int), 20 (type: int), 
1360986080000 (type: bigint)
+            expressions: UDFToInteger(key) (type: int), 
reflect2(UDFToInteger(key),'byteValue') (type: tinyint), 
reflect2(UDFToInteger(key),'shortValue') (type: smallint), 
reflect2(UDFToInteger(key),'intValue') (type: int), 
reflect2(UDFToInteger(key),'longValue') (type: bigint), 
reflect2(UDFToInteger(key),'floatValue') (type: float), 
reflect2(UDFToInteger(key),'doubleValue') (type: double), 
reflect2(UDFToInteger(key),'toString') (type: string), value (type: string), 
reflect2(value,'concat','_concat') (type: string), 
reflect2(value,'contains','86') (type: boolean), 
reflect2(value,'startsWith','v') (type: boolean), 
reflect2(value,'endsWith','6') (type: boolean), 
reflect2(value,'equals','val_86') (type: boolean), 
reflect2(value,'equalsIgnoreCase','VAL_86') (type: boolean), 
reflect2(value,'getBytes') (type: binary), reflect2(value,'indexOf','1') (type: 
int), reflect2(value,'lastIndexOf','1') (type: int), 
reflect2(value,'replace','val','VALUE') (type: string), 
reflect2(value,'substring',
 1) (type: string), reflect2(value,'substring',1,5) (type: string), 
reflect2(value,'toUpperCase') (type: string), reflect2(value,'trim') (type: 
string), TIMESTAMP'2013-02-15 19:41:20.0' (type: timestamp), 113 (type: int), 1 
(type: int), 5 (type: int), 19 (type: int), 41 (type: int), 20 (type: int), 
1360986080000L (type: bigint)
             outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, 
_col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, 
_col16, _col17, _col18, _col19, _col20, _col21, _col22, _col23, _col24, _col25, 
_col26, _col27, _col28, _col29, _col30
             Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: NONE
             Limit

http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/udf_second.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_second.q.out 
b/ql/src/test/results/clientpositive/udf_second.q.out
index c1f3504..8042a30 100644
--- a/ql/src/test/results/clientpositive/udf_second.q.out
+++ b/ql/src/test/results/clientpositive/udf_second.q.out
@@ -38,7 +38,7 @@ STAGE PLANS:
           alias: src
           Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: NONE
           Filter Operator
-            predicate: (UDFToDouble(key) = 86.0) (type: boolean)
+            predicate: (UDFToDouble(key) = 86.0D) (type: boolean)
             Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE 
Column stats: NONE
             Select Operator
               expressions: 15 (type: int), 15 (type: int), null (type: int)

http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/udf_sign.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_sign.q.out 
b/ql/src/test/results/clientpositive/udf_sign.q.out
index fe84402..35e482f 100644
--- a/ql/src/test/results/clientpositive/udf_sign.q.out
+++ b/ql/src/test/results/clientpositive/udf_sign.q.out
@@ -17,7 +17,7 @@ STAGE PLANS:
           Row Limit Per Split: 1
           Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: COMPLETE
           Select Operator
-            expressions: 0.0 (type: double)
+            expressions: 0.0D (type: double)
             outputColumnNames: _col0
             Statistics: Num rows: 500 Data size: 4000 Basic stats: COMPLETE 
Column stats: COMPLETE
             ListSink
@@ -83,7 +83,7 @@ STAGE PLANS:
           Row Limit Per Split: 1
           Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: COMPLETE
           Select Operator
-            expressions: 0.0 (type: double)
+            expressions: 0.0D (type: double)
             outputColumnNames: _col0
             Statistics: Num rows: 500 Data size: 4000 Basic stats: COMPLETE 
Column stats: COMPLETE
             ListSink

http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/udf_to_utc_timestamp.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_to_utc_timestamp.q.out 
b/ql/src/test/results/clientpositive/udf_to_utc_timestamp.q.out
index 7bd9aaf..4abf0ed 100644
--- a/ql/src/test/results/clientpositive/udf_to_utc_timestamp.q.out
+++ b/ql/src/test/results/clientpositive/udf_to_utc_timestamp.q.out
@@ -27,7 +27,7 @@ STAGE PLANS:
           Row Limit Per Split: 1
           Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column 
stats: COMPLETE
           Select Operator
-            expressions: 2012-02-11 18:30:00.0 (type: timestamp)
+            expressions: TIMESTAMP'2012-02-11 18:30:00.0' (type: timestamp)
             outputColumnNames: _col0
             Statistics: Num rows: 1 Data size: 40 Basic stats: COMPLETE Column 
stats: COMPLETE
             ListSink

http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/union.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/union.q.out 
b/ql/src/test/results/clientpositive/union.q.out
index 67c9ba4..dc9baf2 100644
--- a/ql/src/test/results/clientpositive/union.q.out
+++ b/ql/src/test/results/clientpositive/union.q.out
@@ -31,7 +31,7 @@ STAGE PLANS:
             alias: src
             Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
-              predicate: (UDFToDouble(key) < 100.0) (type: boolean)
+              predicate: (UDFToDouble(key) < 100.0D) (type: boolean)
               Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
                 expressions: key (type: string), value (type: string)
@@ -50,7 +50,7 @@ STAGE PLANS:
             alias: src
             Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
-              predicate: (UDFToDouble(key) > 100.0) (type: boolean)
+              predicate: (UDFToDouble(key) > 100.0D) (type: boolean)
               Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
                 expressions: key (type: string), value (type: string)

http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/union20.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/union20.q.out 
b/ql/src/test/results/clientpositive/union20.q.out
index d911b90..860179a 100644
--- a/ql/src/test/results/clientpositive/union20.q.out
+++ b/ql/src/test/results/clientpositive/union20.q.out
@@ -77,7 +77,7 @@ STAGE PLANS:
             alias: s2
             Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
-              predicate: (UDFToDouble(key) < 10.0) (type: boolean)
+              predicate: (UDFToDouble(key) < 10.0D) (type: boolean)
               Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
                 expressions: key (type: string), value (type: string)
@@ -104,7 +104,7 @@ STAGE PLANS:
             alias: s4
             Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
-              predicate: (UDFToDouble(key) < 10.0) (type: boolean)
+              predicate: (UDFToDouble(key) < 10.0D) (type: boolean)
               Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
                 expressions: key (type: string), value (type: string)

http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/union22.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/union22.q.out 
b/ql/src/test/results/clientpositive/union22.q.out
index ce4fa62..50d06c0 100644
--- a/ql/src/test/results/clientpositive/union22.q.out
+++ b/ql/src/test/results/clientpositive/union22.q.out
@@ -144,7 +144,7 @@ STAGE PLANS:
             GatherStats: false
             Filter Operator
               isSamplingPred: false
-              predicate: ((UDFToDouble(k0) > 50.0) and (UDFToDouble(k1) > 
20.0)) (type: boolean)
+              predicate: ((UDFToDouble(k0) > 50.0D) and (UDFToDouble(k1) > 
20.0D)) (type: boolean)
               Statistics: Num rows: 55 Data size: 1862 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
                 expressions: k1 (type: string), k3 (type: string), k4 (type: 
string)
@@ -170,7 +170,7 @@ STAGE PLANS:
             GatherStats: false
             Filter Operator
               isSamplingPred: false
-              predicate: (UDFToDouble(k1) > 20.0) (type: boolean)
+              predicate: (UDFToDouble(k1) > 20.0D) (type: boolean)
               Statistics: Num rows: 166 Data size: 3693 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
                 expressions: k1 (type: string), k2 (type: string), ds (type: 
string)
@@ -323,7 +323,7 @@ STAGE PLANS:
             GatherStats: false
             Filter Operator
               isSamplingPred: false
-              predicate: (UDFToDouble(k0) <= 50.0) (type: boolean)
+              predicate: (UDFToDouble(k0) <= 50.0D) (type: boolean)
               Statistics: Num rows: 166 Data size: 5622 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
                 expressions: k1 (type: string), k2 (type: string), k3 (type: 
string), k4 (type: string)
@@ -589,7 +589,7 @@ STAGE PLANS:
             GatherStats: false
             Filter Operator
               isSamplingPred: false
-              predicate: (UDFToDouble(k1) > 20.0) (type: boolean)
+              predicate: (UDFToDouble(k1) > 20.0D) (type: boolean)
               Statistics: Num rows: 166 Data size: 3693 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
                 expressions: k1 (type: string), k2 (type: string), ds (type: 
string)
@@ -610,7 +610,7 @@ STAGE PLANS:
             GatherStats: false
             Filter Operator
               isSamplingPred: false
-              predicate: ((UDFToDouble(k0) > 50.0) and (UDFToDouble(k1) > 
20.0)) (type: boolean)
+              predicate: ((UDFToDouble(k0) > 50.0D) and (UDFToDouble(k1) > 
20.0D)) (type: boolean)
               Statistics: Num rows: 55 Data size: 1862 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
                 expressions: k1 (type: string), k3 (type: string), k4 (type: 
string)

http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/union24.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/union24.q.out 
b/ql/src/test/results/clientpositive/union24.q.out
index 8f8c170..dfa614e 100644
--- a/ql/src/test/results/clientpositive/union24.q.out
+++ b/ql/src/test/results/clientpositive/union24.q.out
@@ -83,7 +83,7 @@ STAGE PLANS:
             GatherStats: false
             Filter Operator
               isSamplingPred: false
-              predicate: (UDFToDouble(key) < 10.0) (type: boolean)
+              predicate: (UDFToDouble(key) < 10.0D) (type: boolean)
               Statistics: Num rows: 103 Data size: 494 Basic stats: COMPLETE 
Column stats: NONE
               Group By Operator
                 aggregations: count()
@@ -187,7 +187,7 @@ STAGE PLANS:
             GatherStats: false
             Filter Operator
               isSamplingPred: false
-              predicate: (UDFToDouble(key) < 10.0) (type: boolean)
+              predicate: (UDFToDouble(key) < 10.0D) (type: boolean)
               Statistics: Num rows: 103 Data size: 494 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
                 expressions: key (type: string), count (type: bigint)
@@ -223,7 +223,7 @@ STAGE PLANS:
             GatherStats: false
             Filter Operator
               isSamplingPred: false
-              predicate: (UDFToDouble(key) < 10.0) (type: boolean)
+              predicate: (UDFToDouble(key) < 10.0D) (type: boolean)
               Statistics: Num rows: 103 Data size: 494 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
                 expressions: key (type: string), count (type: bigint)
@@ -259,7 +259,7 @@ STAGE PLANS:
             GatherStats: false
             Filter Operator
               isSamplingPred: false
-              predicate: (UDFToDouble(key) < 10.0) (type: boolean)
+              predicate: (UDFToDouble(key) < 10.0D) (type: boolean)
               Statistics: Num rows: 103 Data size: 494 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
                 expressions: key (type: string), count (type: bigint)
@@ -577,7 +577,7 @@ STAGE PLANS:
             GatherStats: false
             Filter Operator
               isSamplingPred: false
-              predicate: (UDFToDouble(key) < 10.0) (type: boolean)
+              predicate: (UDFToDouble(key) < 10.0D) (type: boolean)
               Statistics: Num rows: 103 Data size: 494 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
                 expressions: key (type: string)
@@ -597,7 +597,7 @@ STAGE PLANS:
             GatherStats: false
             Filter Operator
               isSamplingPred: false
-              predicate: (UDFToDouble(key) < 10.0) (type: boolean)
+              predicate: (UDFToDouble(key) < 10.0D) (type: boolean)
               Statistics: Num rows: 103 Data size: 494 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
                 expressions: key (type: string), count (type: bigint)
@@ -752,7 +752,7 @@ STAGE PLANS:
             GatherStats: false
             Filter Operator
               isSamplingPred: false
-              predicate: (UDFToDouble(key) < 10.0) (type: boolean)
+              predicate: (UDFToDouble(key) < 10.0D) (type: boolean)
               Statistics: Num rows: 103 Data size: 494 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
                 expressions: key (type: string), count (type: bigint)
@@ -788,7 +788,7 @@ STAGE PLANS:
             GatherStats: false
             Filter Operator
               isSamplingPred: false
-              predicate: (UDFToDouble(key) < 10.0) (type: boolean)
+              predicate: (UDFToDouble(key) < 10.0D) (type: boolean)
               Statistics: Num rows: 103 Data size: 494 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
                 expressions: key (type: string), count (type: bigint)
@@ -1050,7 +1050,7 @@ STAGE PLANS:
             GatherStats: false
             Filter Operator
               isSamplingPred: false
-              predicate: (UDFToDouble(key) < 10.0) (type: boolean)
+              predicate: (UDFToDouble(key) < 10.0D) (type: boolean)
               Statistics: Num rows: 103 Data size: 494 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
                 expressions: key (type: string)
@@ -1070,7 +1070,7 @@ STAGE PLANS:
             GatherStats: false
             Filter Operator
               isSamplingPred: false
-              predicate: (UDFToDouble(key) < 10.0) (type: boolean)
+              predicate: (UDFToDouble(key) < 10.0D) (type: boolean)
               Statistics: Num rows: 103 Data size: 494 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
                 expressions: key (type: string)
@@ -1294,7 +1294,7 @@ STAGE PLANS:
             GatherStats: false
             Filter Operator
               isSamplingPred: false
-              predicate: (UDFToDouble(key) < 10.0) (type: boolean)
+              predicate: (UDFToDouble(key) < 10.0D) (type: boolean)
               Statistics: Num rows: 103 Data size: 494 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
                 expressions: key (type: string), count (type: bigint)
@@ -1330,7 +1330,7 @@ STAGE PLANS:
             GatherStats: false
             Filter Operator
               isSamplingPred: false
-              predicate: (UDFToDouble(key) < 10.0) (type: boolean)
+              predicate: (UDFToDouble(key) < 10.0D) (type: boolean)
               Statistics: Num rows: 103 Data size: 494 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
                 expressions: key (type: string), count (type: bigint)

http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/union27.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/union27.q.out 
b/ql/src/test/results/clientpositive/union27.q.out
index 34b46f1..8e3dae9 100644
--- a/ql/src/test/results/clientpositive/union27.q.out
+++ b/ql/src/test/results/clientpositive/union27.q.out
@@ -50,7 +50,7 @@ STAGE PLANS:
             alias: a
             Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
-              predicate: (UDFToDouble(key) = 97.0) (type: boolean)
+              predicate: (UDFToDouble(key) = 97.0D) (type: boolean)
               Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
                 expressions: key (type: string)
@@ -65,7 +65,7 @@ STAGE PLANS:
             alias: dim_pho
             Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
-              predicate: (UDFToDouble(key) = 97.0) (type: boolean)
+              predicate: (UDFToDouble(key) = 97.0D) (type: boolean)
               Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
                 expressions: key (type: string), value (type: string)
@@ -83,7 +83,7 @@ STAGE PLANS:
             alias: jackson_sev_add
             Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
-              predicate: (UDFToDouble(key) = 97.0) (type: boolean)
+              predicate: (UDFToDouble(key) = 97.0D) (type: boolean)
               Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
                 expressions: key (type: string), value (type: string)

http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/union33.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/union33.q.out 
b/ql/src/test/results/clientpositive/union33.q.out
index d12db79..bd1c9a9 100644
--- a/ql/src/test/results/clientpositive/union33.q.out
+++ b/ql/src/test/results/clientpositive/union33.q.out
@@ -108,7 +108,7 @@ STAGE PLANS:
             alias: src
             Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
-              predicate: (UDFToDouble(key) = 0.0) (type: boolean)
+              predicate: (UDFToDouble(key) = 0.0D) (type: boolean)
               Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
                 expressions: key (type: string), value (type: string)
@@ -391,7 +391,7 @@ STAGE PLANS:
             alias: src
             Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
-              predicate: (UDFToDouble(key) = 0.0) (type: boolean)
+              predicate: (UDFToDouble(key) = 0.0D) (type: boolean)
               Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
                 expressions: key (type: string), value (type: string)

http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/union_pos_alias.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/union_pos_alias.q.out 
b/ql/src/test/results/clientpositive/union_pos_alias.q.out
index 65e736f..493316b 100644
--- a/ql/src/test/results/clientpositive/union_pos_alias.q.out
+++ b/ql/src/test/results/clientpositive/union_pos_alias.q.out
@@ -535,7 +535,7 @@ STAGE PLANS:
           outputColumnNames: _col0, _col1, _col2, _col3
           Statistics: Num rows: 13 Data size: 137 Basic stats: COMPLETE Column 
stats: NONE
           Filter Operator
-            predicate: (_col3 = 2) (type: boolean)
+            predicate: (_col3 = 2L) (type: boolean)
             Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column 
stats: NONE
             Select Operator
               expressions: _col2 (type: bigint), _col0 (type: int), _col1 
(type: string)

http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/union_remove_10.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/union_remove_10.q.out 
b/ql/src/test/results/clientpositive/union_remove_10.q.out
index f1f2dd6..500c123 100644
--- a/ql/src/test/results/clientpositive/union_remove_10.q.out
+++ b/ql/src/test/results/clientpositive/union_remove_10.q.out
@@ -67,7 +67,7 @@ STAGE PLANS:
             alias: inputtbl1
             Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE 
Column stats: NONE
             Select Operator
-              expressions: key (type: string), 1 (type: bigint)
+              expressions: key (type: string), 1L (type: bigint)
               outputColumnNames: _col0, _col1
               Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE 
Column stats: NONE
               File Output Operator
@@ -163,7 +163,7 @@ STAGE PLANS:
             alias: inputtbl1
             Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE 
Column stats: NONE
             Select Operator
-              expressions: key (type: string), 2 (type: bigint)
+              expressions: key (type: string), 2L (type: bigint)
               outputColumnNames: _col0, _col1
               Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE 
Column stats: NONE
               File Output Operator

http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/union_remove_12.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/union_remove_12.q.out 
b/ql/src/test/results/clientpositive/union_remove_12.q.out
index 702aef8..29141e1 100644
--- a/ql/src/test/results/clientpositive/union_remove_12.q.out
+++ b/ql/src/test/results/clientpositive/union_remove_12.q.out
@@ -61,7 +61,7 @@ STAGE PLANS:
             alias: inputtbl1
             Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE 
Column stats: NONE
             Select Operator
-              expressions: key (type: string), 1 (type: bigint)
+              expressions: key (type: string), 1L (type: bigint)
               outputColumnNames: _col0, _col1
               Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE 
Column stats: NONE
               File Output Operator

http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/union_remove_14.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/union_remove_14.q.out 
b/ql/src/test/results/clientpositive/union_remove_14.q.out
index 702aef8..29141e1 100644
--- a/ql/src/test/results/clientpositive/union_remove_14.q.out
+++ b/ql/src/test/results/clientpositive/union_remove_14.q.out
@@ -61,7 +61,7 @@ STAGE PLANS:
             alias: inputtbl1
             Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE 
Column stats: NONE
             Select Operator
-              expressions: key (type: string), 1 (type: bigint)
+              expressions: key (type: string), 1L (type: bigint)
               outputColumnNames: _col0, _col1
               Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE 
Column stats: NONE
               File Output Operator

http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/union_remove_19.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/union_remove_19.q.out 
b/ql/src/test/results/clientpositive/union_remove_19.q.out
index 8a71f96..8f9be65 100644
--- a/ql/src/test/results/clientpositive/union_remove_19.q.out
+++ b/ql/src/test/results/clientpositive/union_remove_19.q.out
@@ -234,7 +234,7 @@ STAGE PLANS:
             alias: inputtbl1
             Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
-              predicate: (UDFToDouble(key) = 7.0) (type: boolean)
+              predicate: (UDFToDouble(key) = 7.0D) (type: boolean)
               Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE 
Column stats: NONE
               Group By Operator
                 aggregations: count()
@@ -281,7 +281,7 @@ STAGE PLANS:
             alias: inputtbl1
             Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
-              predicate: (UDFToDouble(key) = 7.0) (type: boolean)
+              predicate: (UDFToDouble(key) = 7.0D) (type: boolean)
               Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE 
Column stats: NONE
               Group By Operator
                 aggregations: count()
@@ -380,7 +380,7 @@ STAGE PLANS:
             alias: inputtbl1
             Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
-              predicate: ((UDFToDouble(key) + UDFToDouble(key)) >= 7.0) (type: 
boolean)
+              predicate: ((UDFToDouble(key) + UDFToDouble(key)) >= 7.0D) 
(type: boolean)
               Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE 
Column stats: NONE
               Group By Operator
                 aggregations: count()
@@ -431,7 +431,7 @@ STAGE PLANS:
             alias: inputtbl1
             Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
-              predicate: ((UDFToDouble(key) + UDFToDouble(key)) >= 7.0) (type: 
boolean)
+              predicate: ((UDFToDouble(key) + UDFToDouble(key)) >= 7.0D) 
(type: boolean)
               Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE 
Column stats: NONE
               Group By Operator
                 aggregations: count()

http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/union_remove_2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/union_remove_2.q.out 
b/ql/src/test/results/clientpositive/union_remove_2.q.out
index 0b84fb0..cd1f243 100644
--- a/ql/src/test/results/clientpositive/union_remove_2.q.out
+++ b/ql/src/test/results/clientpositive/union_remove_2.q.out
@@ -106,7 +106,7 @@ STAGE PLANS:
             alias: inputtbl1
             Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE 
Column stats: NONE
             Select Operator
-              expressions: key (type: string), 1 (type: bigint)
+              expressions: key (type: string), 1L (type: bigint)
               outputColumnNames: _col0, _col1
               Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE 
Column stats: NONE
               File Output Operator
@@ -125,7 +125,7 @@ STAGE PLANS:
             alias: inputtbl1
             Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE 
Column stats: NONE
             Select Operator
-              expressions: key (type: string), 2 (type: bigint)
+              expressions: key (type: string), 2L (type: bigint)
               outputColumnNames: _col0, _col1
               Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE 
Column stats: NONE
               File Output Operator

http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/union_remove_5.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/union_remove_5.q.out 
b/ql/src/test/results/clientpositive/union_remove_5.q.out
index efe59a1..f60b88b 100644
--- a/ql/src/test/results/clientpositive/union_remove_5.q.out
+++ b/ql/src/test/results/clientpositive/union_remove_5.q.out
@@ -150,7 +150,7 @@ STAGE PLANS:
             alias: inputtbl1
             Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE 
Column stats: NONE
             Select Operator
-              expressions: key (type: string), 1 (type: bigint)
+              expressions: key (type: string), 1L (type: bigint)
               outputColumnNames: _col0, _col1
               Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE 
Column stats: NONE
               File Output Operator
@@ -169,7 +169,7 @@ STAGE PLANS:
             alias: inputtbl1
             Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE 
Column stats: NONE
             Select Operator
-              expressions: key (type: string), 2 (type: bigint)
+              expressions: key (type: string), 2L (type: bigint)
               outputColumnNames: _col0, _col1
               Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE 
Column stats: NONE
               File Output Operator

http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/union_remove_6_subq.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/union_remove_6_subq.q.out 
b/ql/src/test/results/clientpositive/union_remove_6_subq.q.out
index 742e5b1..096d98d 100644
--- a/ql/src/test/results/clientpositive/union_remove_6_subq.q.out
+++ b/ql/src/test/results/clientpositive/union_remove_6_subq.q.out
@@ -305,7 +305,7 @@ STAGE PLANS:
           outputColumnNames: _col0
           Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column 
stats: COMPLETE
           Select Operator
-            expressions: (_col0 - 200) (type: bigint)
+            expressions: (_col0 - 200L) (type: bigint)
             outputColumnNames: _col0
             Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column 
stats: COMPLETE
             File Output Operator
@@ -462,7 +462,7 @@ STAGE PLANS:
           outputColumnNames: _col0, _col1
           Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE 
Column stats: NONE
           Select Operator
-            expressions: _col0 (type: string), (_col1 * 2) (type: bigint)
+            expressions: _col0 (type: string), (_col1 * 2L) (type: bigint)
             outputColumnNames: _col0, _col1
             Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE 
Column stats: NONE
             File Output Operator

http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/union_remove_8.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/union_remove_8.q.out 
b/ql/src/test/results/clientpositive/union_remove_8.q.out
index 2093fe6..f1ae75a 100644
--- a/ql/src/test/results/clientpositive/union_remove_8.q.out
+++ b/ql/src/test/results/clientpositive/union_remove_8.q.out
@@ -106,7 +106,7 @@ STAGE PLANS:
             alias: inputtbl1
             Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE 
Column stats: NONE
             Select Operator
-              expressions: key (type: string), 1 (type: bigint)
+              expressions: key (type: string), 1L (type: bigint)
               outputColumnNames: _col0, _col1
               Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE 
Column stats: NONE
               File Output Operator
@@ -125,7 +125,7 @@ STAGE PLANS:
             alias: inputtbl1
             Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE 
Column stats: NONE
             Select Operator
-              expressions: key (type: string), 2 (type: bigint)
+              expressions: key (type: string), 2L (type: bigint)
               outputColumnNames: _col0, _col1
               Statistics: Num rows: 1 Data size: 300 Basic stats: COMPLETE 
Column stats: NONE
               File Output Operator

http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/vector_cast_constant.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/vector_cast_constant.q.out 
b/ql/src/test/results/clientpositive/vector_cast_constant.q.out
index d16c7e0..4b06016 100644
--- a/ql/src/test/results/clientpositive/vector_cast_constant.q.out
+++ b/ql/src/test/results/clientpositive/vector_cast_constant.q.out
@@ -136,7 +136,7 @@ STAGE PLANS:
                   projectedOutputColumnNums: [2]
               Statistics: Num rows: 1049 Data size: 311170 Basic stats: 
COMPLETE Column stats: NONE
               Group By Operator
-                aggregations: avg(50), avg(50.0), avg(50)
+                aggregations: avg(50), avg(50.0D), avg(50)
                 Group By Vectorization:
                     aggregators: 
VectorUDAFAvgLong(ConstantVectorExpression(val 50) -> 12:int) -> 
struct<count:bigint,sum:double,input:int>, 
VectorUDAFAvgDouble(ConstantVectorExpression(val 50.0) -> 13:double) -> 
struct<count:bigint,sum:double,input:double>, 
VectorUDAFAvgDecimal(ConstantVectorExpression(val 50) -> 14:decimal(10,0)) -> 
struct<count:bigint,sum:decimal(20,0),input:decimal(10,0)>
                     className: VectorGroupByOperator

http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/vector_coalesce_2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/vector_coalesce_2.q.out 
b/ql/src/test/results/clientpositive/vector_coalesce_2.q.out
index ca06456..48d38c3 100644
--- a/ql/src/test/results/clientpositive/vector_coalesce_2.q.out
+++ b/ql/src/test/results/clientpositive/vector_coalesce_2.q.out
@@ -111,7 +111,7 @@ STAGE PLANS:
           outputColumnNames: _col0, _col1
           Statistics: Num rows: 2 Data size: 271 Basic stats: COMPLETE Column 
stats: NONE
           Select Operator
-            expressions: _col0 (type: string), round((UDFToDouble(_col1) / 
60.0), 2) (type: double)
+            expressions: _col0 (type: string), round((UDFToDouble(_col1) / 
60.0D), 2) (type: double)
             outputColumnNames: _col0, _col1
             Statistics: Num rows: 2 Data size: 271 Basic stats: COMPLETE 
Column stats: NONE
             File Output Operator
@@ -306,7 +306,7 @@ STAGE PLANS:
           outputColumnNames: _col0, _col1
           Statistics: Num rows: 2 Data size: 271 Basic stats: COMPLETE Column 
stats: NONE
           Select Operator
-            expressions: _col0 (type: string), round((UDFToDouble(_col1) / 
60.0), 2) (type: double)
+            expressions: _col0 (type: string), round((UDFToDouble(_col1) / 
60.0D), 2) (type: double)
             outputColumnNames: _col0, _col1
             Statistics: Num rows: 2 Data size: 271 Basic stats: COMPLETE 
Column stats: NONE
             File Output Operator

http://git-wip-us.apache.org/repos/asf/hive/blob/17441e48/ql/src/test/results/clientpositive/vector_date_1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/vector_date_1.q.out 
b/ql/src/test/results/clientpositive/vector_date_1.q.out
index 93f9a71..050f9c3 100644
--- a/ql/src/test/results/clientpositive/vector_date_1.q.out
+++ b/ql/src/test/results/clientpositive/vector_date_1.q.out
@@ -387,7 +387,7 @@ STAGE PLANS:
                 native: true
                 vectorizationSchemaColumns: [0:dt1:date, 1:dt2:date, 
2:ROW__ID:struct<transactionid:bigint,bucketid:int,rowid:bigint>]
             Select Operator
-              expressions: dt1 (type: date), (dt1 <> 1970-01-01) (type: 
boolean), (dt1 >= 1970-01-01) (type: boolean), (dt1 > 1970-01-01) (type: 
boolean), (dt1 <= 2100-01-01) (type: boolean), (dt1 < 2100-01-01) (type: 
boolean), (1970-01-01 <> dt1) (type: boolean), (1970-01-01 <= dt1) (type: 
boolean), (1970-01-01 < dt1) (type: boolean)
+              expressions: dt1 (type: date), (dt1 <> DATE'1970-01-01') (type: 
boolean), (dt1 >= DATE'1970-01-01') (type: boolean), (dt1 > DATE'1970-01-01') 
(type: boolean), (dt1 <= DATE'2100-01-01') (type: boolean), (dt1 < 
DATE'2100-01-01') (type: boolean), (DATE'1970-01-01' <> dt1) (type: boolean), 
(DATE'1970-01-01' <= dt1) (type: boolean), (DATE'1970-01-01' < dt1) (type: 
boolean)
               outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, 
_col6, _col7, _col8
               Select Vectorization:
                   className: VectorSelectOperator
@@ -526,7 +526,7 @@ STAGE PLANS:
                 native: true
                 vectorizationSchemaColumns: [0:dt1:date, 1:dt2:date, 
2:ROW__ID:struct<transactionid:bigint,bucketid:int,rowid:bigint>]
             Select Operator
-              expressions: dt1 (type: date), (dt1 = 1970-01-01) (type: 
boolean), (dt1 <= 1970-01-01) (type: boolean), (dt1 < 1970-01-01) (type: 
boolean), (dt1 >= 2100-01-01) (type: boolean), (dt1 > 2100-01-01) (type: 
boolean), (1970-01-01 = dt1) (type: boolean), (1970-01-01 >= dt1) (type: 
boolean), (1970-01-01 > dt1) (type: boolean)
+              expressions: dt1 (type: date), (dt1 = DATE'1970-01-01') (type: 
boolean), (dt1 <= DATE'1970-01-01') (type: boolean), (dt1 < DATE'1970-01-01') 
(type: boolean), (dt1 >= DATE'2100-01-01') (type: boolean), (dt1 > 
DATE'2100-01-01') (type: boolean), (DATE'1970-01-01' = dt1) (type: boolean), 
(DATE'1970-01-01' >= dt1) (type: boolean), (DATE'1970-01-01' > dt1) (type: 
boolean)
               outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, 
_col6, _col7, _col8
               Select Vectorization:
                   className: VectorSelectOperator
@@ -811,10 +811,10 @@ STAGE PLANS:
                   className: VectorFilterOperator
                   native: true
                   predicateExpression: FilterExprAndExpr(children: 
FilterDateScalarEqualDateColumn(val 11323, col 0:date), 
FilterDateColNotEqualDateScalar(col 0:date, val 0), 
FilterDateScalarNotEqualDateColumn(val 0, col 0:date))
-              predicate: ((1970-01-01 <> dt1) and (2001-01-01 = dt1) and (dt1 
<> 1970-01-01)) (type: boolean)
+              predicate: ((DATE'1970-01-01' <> dt1) and (DATE'2001-01-01' = 
dt1) and (dt1 <> DATE'1970-01-01')) (type: boolean)
               Statistics: Num rows: 1 Data size: 74 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
-                expressions: 2001-01-01 (type: date), dt2 (type: date)
+                expressions: DATE'2001-01-01' (type: date), dt2 (type: date)
                 outputColumnNames: _col0, _col1
                 Select Vectorization:
                     className: VectorSelectOperator
@@ -919,7 +919,7 @@ STAGE PLANS:
                   className: VectorFilterOperator
                   native: true
                   predicateExpression: FilterLongColumnInList(col 0:date, 
values [0, 11323])
-              predicate: (dt1) IN (1970-01-01, 2001-01-01) (type: boolean)
+              predicate: (dt1) IN (DATE'1970-01-01', DATE'2001-01-01') (type: 
boolean)
               Statistics: Num rows: 2 Data size: 149 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
                 expressions: dt1 (type: date)

Reply via email to