You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by xu...@apache.org on 2015/11/12 04:59:28 UTC
[04/55] [abbrv] hive git commit: HIVE-12063: Pad Decimal numbers with
trailing zeros to the scale of the column (reviewed by Szehon)
http://git-wip-us.apache.org/repos/asf/hive/blob/13f8cfec/ql/src/test/results/clientpositive/parquet_ppd_decimal.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/parquet_ppd_decimal.q.out b/ql/src/test/results/clientpositive/parquet_ppd_decimal.q.out
index 7c17733..a30820e 100644
--- a/ql/src/test/results/clientpositive/parquet_ppd_decimal.q.out
+++ b/ql/src/test/results/clientpositive/parquet_ppd_decimal.q.out
@@ -28,11 +28,11 @@ select * from newtypestbl where d=0.22
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
PREHOOK: query: select * from newtypestbl where d=0.22
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -41,11 +41,11 @@ POSTHOOK: query: select * from newtypestbl where d=0.22
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
PREHOOK: query: select * from newtypestbl where d='0.22'
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -54,11 +54,11 @@ POSTHOOK: query: select * from newtypestbl where d='0.22'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
PREHOOK: query: select * from newtypestbl where d='0.22'
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -67,11 +67,11 @@ POSTHOOK: query: select * from newtypestbl where d='0.22'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
PREHOOK: query: select * from newtypestbl where d=cast('0.22' as float)
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -80,11 +80,11 @@ POSTHOOK: query: select * from newtypestbl where d=cast('0.22' as float)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
PREHOOK: query: select * from newtypestbl where d=cast('0.22' as float)
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -93,11 +93,11 @@ POSTHOOK: query: select * from newtypestbl where d=cast('0.22' as float)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
PREHOOK: query: select * from newtypestbl where d!=0.22
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -106,11 +106,11 @@ POSTHOOK: query: select * from newtypestbl where d!=0.22
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
PREHOOK: query: select * from newtypestbl where d!=0.22
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -119,11 +119,11 @@ POSTHOOK: query: select * from newtypestbl where d!=0.22
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
PREHOOK: query: select * from newtypestbl where d!='0.22'
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -132,11 +132,11 @@ POSTHOOK: query: select * from newtypestbl where d!='0.22'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
PREHOOK: query: select * from newtypestbl where d!='0.22'
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -145,11 +145,11 @@ POSTHOOK: query: select * from newtypestbl where d!='0.22'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
PREHOOK: query: select * from newtypestbl where d!=cast('0.22' as float)
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -158,11 +158,11 @@ POSTHOOK: query: select * from newtypestbl where d!=cast('0.22' as float)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
PREHOOK: query: select * from newtypestbl where d!=cast('0.22' as float)
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -171,11 +171,11 @@ POSTHOOK: query: select * from newtypestbl where d!=cast('0.22' as float)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
PREHOOK: query: select * from newtypestbl where d<11.22
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -184,11 +184,11 @@ POSTHOOK: query: select * from newtypestbl where d<11.22
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
PREHOOK: query: select * from newtypestbl where d<11.22
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -197,11 +197,11 @@ POSTHOOK: query: select * from newtypestbl where d<11.22
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
PREHOOK: query: select * from newtypestbl where d<'11.22'
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -210,11 +210,11 @@ POSTHOOK: query: select * from newtypestbl where d<'11.22'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
PREHOOK: query: select * from newtypestbl where d<'11.22'
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -223,11 +223,11 @@ POSTHOOK: query: select * from newtypestbl where d<'11.22'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
PREHOOK: query: select * from newtypestbl where d<cast('11.22' as float)
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -236,11 +236,11 @@ POSTHOOK: query: select * from newtypestbl where d<cast('11.22' as float)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
PREHOOK: query: select * from newtypestbl where d<cast('11.22' as float)
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -249,11 +249,11 @@ POSTHOOK: query: select * from newtypestbl where d<cast('11.22' as float)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
PREHOOK: query: select * from newtypestbl where d<1
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -262,11 +262,11 @@ POSTHOOK: query: select * from newtypestbl where d<1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
PREHOOK: query: select * from newtypestbl where d<1
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -275,11 +275,11 @@ POSTHOOK: query: select * from newtypestbl where d<1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
PREHOOK: query: select * from newtypestbl where d<=11.22 sort by c
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -288,16 +288,16 @@ POSTHOOK: query: select * from newtypestbl where d<=11.22 sort by c
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
PREHOOK: query: select * from newtypestbl where d<=11.22 sort by c
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -306,16 +306,16 @@ POSTHOOK: query: select * from newtypestbl where d<=11.22 sort by c
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
PREHOOK: query: select * from newtypestbl where d<='11.22' sort by c
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -324,16 +324,16 @@ POSTHOOK: query: select * from newtypestbl where d<='11.22' sort by c
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
PREHOOK: query: select * from newtypestbl where d<='11.22' sort by c
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -342,16 +342,16 @@ POSTHOOK: query: select * from newtypestbl where d<='11.22' sort by c
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
PREHOOK: query: select * from newtypestbl where d<=cast('11.22' as float) sort by c
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -360,16 +360,16 @@ POSTHOOK: query: select * from newtypestbl where d<=cast('11.22' as float) sort
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
PREHOOK: query: select * from newtypestbl where d<=cast('11.22' as float) sort by c
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -378,16 +378,16 @@ POSTHOOK: query: select * from newtypestbl where d<=cast('11.22' as float) sort
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
PREHOOK: query: select * from newtypestbl where d<=cast('11.22' as decimal)
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -396,11 +396,11 @@ POSTHOOK: query: select * from newtypestbl where d<=cast('11.22' as decimal)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
PREHOOK: query: select * from newtypestbl where d<=cast('11.22' as decimal)
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -409,11 +409,11 @@ POSTHOOK: query: select * from newtypestbl where d<=cast('11.22' as decimal)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
PREHOOK: query: select * from newtypestbl where d<=11.22BD sort by c
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -422,16 +422,16 @@ POSTHOOK: query: select * from newtypestbl where d<=11.22BD sort by c
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
PREHOOK: query: select * from newtypestbl where d<=11.22BD sort by c
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -440,16 +440,16 @@ POSTHOOK: query: select * from newtypestbl where d<=11.22BD sort by c
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
PREHOOK: query: select * from newtypestbl where d<=12 sort by c
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -458,16 +458,16 @@ POSTHOOK: query: select * from newtypestbl where d<=12 sort by c
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
PREHOOK: query: select * from newtypestbl where d<=12 sort by c
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -476,16 +476,16 @@ POSTHOOK: query: select * from newtypestbl where d<=12 sort by c
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
PREHOOK: query: select * from newtypestbl where d in ('0.22', '1.0')
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -494,11 +494,11 @@ POSTHOOK: query: select * from newtypestbl where d in ('0.22', '1.0')
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
PREHOOK: query: select * from newtypestbl where d in ('0.22', '1.0')
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -507,11 +507,11 @@ POSTHOOK: query: select * from newtypestbl where d in ('0.22', '1.0')
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
PREHOOK: query: select * from newtypestbl where d in ('0.22', '11.22') sort by c
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -520,16 +520,16 @@ POSTHOOK: query: select * from newtypestbl where d in ('0.22', '11.22') sort by
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
PREHOOK: query: select * from newtypestbl where d in ('0.22', '11.22') sort by c
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -538,16 +538,16 @@ POSTHOOK: query: select * from newtypestbl where d in ('0.22', '11.22') sort by
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
PREHOOK: query: select * from newtypestbl where d in ('0.9', '1.0')
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -572,11 +572,11 @@ POSTHOOK: query: select * from newtypestbl where d in ('0.9', 0.22)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
PREHOOK: query: select * from newtypestbl where d in ('0.9', 0.22)
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -585,11 +585,11 @@ POSTHOOK: query: select * from newtypestbl where d in ('0.9', 0.22)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
PREHOOK: query: select * from newtypestbl where d in ('0.9', 0.22, cast('11.22' as float)) sort by c
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -598,16 +598,16 @@ POSTHOOK: query: select * from newtypestbl where d in ('0.9', 0.22, cast('11.22'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
PREHOOK: query: select * from newtypestbl where d in ('0.9', 0.22, cast('11.22' as float)) sort by c
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -616,16 +616,16 @@ POSTHOOK: query: select * from newtypestbl where d in ('0.9', 0.22, cast('11.22'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
PREHOOK: query: select * from newtypestbl where d between 0 and 1
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -634,11 +634,11 @@ POSTHOOK: query: select * from newtypestbl where d between 0 and 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
PREHOOK: query: select * from newtypestbl where d between 0 and 1
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -647,11 +647,11 @@ POSTHOOK: query: select * from newtypestbl where d between 0 and 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
PREHOOK: query: select * from newtypestbl where d between 0 and 1000 sort by c
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -660,16 +660,16 @@ POSTHOOK: query: select * from newtypestbl where d between 0 and 1000 sort by c
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
PREHOOK: query: select * from newtypestbl where d between 0 and 1000 sort by c
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -678,16 +678,16 @@ POSTHOOK: query: select * from newtypestbl where d between 0 and 1000 sort by c
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
PREHOOK: query: select * from newtypestbl where d between 0 and '2.0'
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -696,11 +696,11 @@ POSTHOOK: query: select * from newtypestbl where d between 0 and '2.0'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
PREHOOK: query: select * from newtypestbl where d between 0 and '2.0'
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -709,11 +709,11 @@ POSTHOOK: query: select * from newtypestbl where d between 0 and '2.0'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
PREHOOK: query: select * from newtypestbl where d between 0 and cast(3 as float)
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -722,11 +722,11 @@ POSTHOOK: query: select * from newtypestbl where d between 0 and cast(3 as float
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
PREHOOK: query: select * from newtypestbl where d between 0 and cast(3 as float)
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -735,11 +735,11 @@ POSTHOOK: query: select * from newtypestbl where d between 0 and cast(3 as float
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
PREHOOK: query: select * from newtypestbl where d between 1 and cast(30 as char(10))
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -748,11 +748,11 @@ POSTHOOK: query: select * from newtypestbl where d between 1 and cast(30 as char
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
PREHOOK: query: select * from newtypestbl where d between 1 and cast(30 as char(10))
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -761,8 +761,8 @@ POSTHOOK: query: select * from newtypestbl where d between 1 and cast(30 as char
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
http://git-wip-us.apache.org/repos/asf/hive/blob/13f8cfec/ql/src/test/results/clientpositive/parquet_ppd_timestamp.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/parquet_ppd_timestamp.q.out b/ql/src/test/results/clientpositive/parquet_ppd_timestamp.q.out
index e314c10..3b3e5b7 100644
--- a/ql/src/test/results/clientpositive/parquet_ppd_timestamp.q.out
+++ b/ql/src/test/results/clientpositive/parquet_ppd_timestamp.q.out
@@ -28,11 +28,11 @@ select * from newtypestbl where cast(ts as string)='2011-01-01 01:01:01'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
PREHOOK: query: select * from newtypestbl where cast(ts as string)='2011-01-01 01:01:01'
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -41,11 +41,11 @@ POSTHOOK: query: select * from newtypestbl where cast(ts as string)='2011-01-01
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
PREHOOK: query: select * from newtypestbl where ts=cast('2011-01-01 01:01:01' as timestamp)
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -54,11 +54,11 @@ POSTHOOK: query: select * from newtypestbl where ts=cast('2011-01-01 01:01:01' a
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
PREHOOK: query: select * from newtypestbl where ts=cast('2011-01-01 01:01:01' as timestamp)
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -67,11 +67,11 @@ POSTHOOK: query: select * from newtypestbl where ts=cast('2011-01-01 01:01:01' a
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
PREHOOK: query: select * from newtypestbl where ts=cast('2011-01-01 01:01:01' as varchar(20))
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -80,11 +80,11 @@ POSTHOOK: query: select * from newtypestbl where ts=cast('2011-01-01 01:01:01' a
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
PREHOOK: query: select * from newtypestbl where ts=cast('2011-01-01 01:01:01' as varchar(20))
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -93,11 +93,11 @@ POSTHOOK: query: select * from newtypestbl where ts=cast('2011-01-01 01:01:01' a
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
PREHOOK: query: select * from newtypestbl where ts!=cast('2011-01-01 01:01:01' as timestamp)
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -106,11 +106,11 @@ POSTHOOK: query: select * from newtypestbl where ts!=cast('2011-01-01 01:01:01'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-hello world 11.22 2011-01-20 01:01:01
-hello world 11.22 2011-01-20 01:01:01
-hello world 11.22 2011-01-20 01:01:01
-hello world 11.22 2011-01-20 01:01:01
-hello world 11.22 2011-01-20 01:01:01
+hello world 11.220 2011-01-20 01:01:01
+hello world 11.220 2011-01-20 01:01:01
+hello world 11.220 2011-01-20 01:01:01
+hello world 11.220 2011-01-20 01:01:01
+hello world 11.220 2011-01-20 01:01:01
PREHOOK: query: select * from newtypestbl where ts!=cast('2011-01-01 01:01:01' as timestamp)
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -119,11 +119,11 @@ POSTHOOK: query: select * from newtypestbl where ts!=cast('2011-01-01 01:01:01'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-hello world 11.22 2011-01-20 01:01:01
-hello world 11.22 2011-01-20 01:01:01
-hello world 11.22 2011-01-20 01:01:01
-hello world 11.22 2011-01-20 01:01:01
-hello world 11.22 2011-01-20 01:01:01
+hello world 11.220 2011-01-20 01:01:01
+hello world 11.220 2011-01-20 01:01:01
+hello world 11.220 2011-01-20 01:01:01
+hello world 11.220 2011-01-20 01:01:01
+hello world 11.220 2011-01-20 01:01:01
PREHOOK: query: select * from newtypestbl where ts<cast('2011-01-20 01:01:01' as timestamp)
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -132,11 +132,11 @@ POSTHOOK: query: select * from newtypestbl where ts<cast('2011-01-20 01:01:01' a
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
PREHOOK: query: select * from newtypestbl where ts<cast('2011-01-20 01:01:01' as timestamp)
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -145,11 +145,11 @@ POSTHOOK: query: select * from newtypestbl where ts<cast('2011-01-20 01:01:01' a
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
PREHOOK: query: select * from newtypestbl where ts<cast('2011-01-22 01:01:01' as timestamp) sort by c
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -158,16 +158,16 @@ POSTHOOK: query: select * from newtypestbl where ts<cast('2011-01-22 01:01:01' a
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-hello world 11.22 2011-01-20 01:01:01
-hello world 11.22 2011-01-20 01:01:01
-hello world 11.22 2011-01-20 01:01:01
-hello world 11.22 2011-01-20 01:01:01
-hello world 11.22 2011-01-20 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+hello world 11.220 2011-01-20 01:01:01
+hello world 11.220 2011-01-20 01:01:01
+hello world 11.220 2011-01-20 01:01:01
+hello world 11.220 2011-01-20 01:01:01
+hello world 11.220 2011-01-20 01:01:01
PREHOOK: query: select * from newtypestbl where ts<cast('2011-01-22 01:01:01' as timestamp) sort by c
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -176,16 +176,16 @@ POSTHOOK: query: select * from newtypestbl where ts<cast('2011-01-22 01:01:01' a
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-hello world 11.22 2011-01-20 01:01:01
-hello world 11.22 2011-01-20 01:01:01
-hello world 11.22 2011-01-20 01:01:01
-hello world 11.22 2011-01-20 01:01:01
-hello world 11.22 2011-01-20 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+hello world 11.220 2011-01-20 01:01:01
+hello world 11.220 2011-01-20 01:01:01
+hello world 11.220 2011-01-20 01:01:01
+hello world 11.220 2011-01-20 01:01:01
+hello world 11.220 2011-01-20 01:01:01
PREHOOK: query: select * from newtypestbl where ts<cast('2010-10-01 01:01:01' as timestamp)
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -210,11 +210,11 @@ POSTHOOK: query: select * from newtypestbl where ts<=cast('2011-01-01 01:01:01'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
PREHOOK: query: select * from newtypestbl where ts<=cast('2011-01-01 01:01:01' as timestamp)
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -223,11 +223,11 @@ POSTHOOK: query: select * from newtypestbl where ts<=cast('2011-01-01 01:01:01'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
PREHOOK: query: select * from newtypestbl where ts<=cast('2011-01-20 01:01:01' as timestamp) sort by c
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -236,16 +236,16 @@ POSTHOOK: query: select * from newtypestbl where ts<=cast('2011-01-20 01:01:01'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-hello world 11.22 2011-01-20 01:01:01
-hello world 11.22 2011-01-20 01:01:01
-hello world 11.22 2011-01-20 01:01:01
-hello world 11.22 2011-01-20 01:01:01
-hello world 11.22 2011-01-20 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+hello world 11.220 2011-01-20 01:01:01
+hello world 11.220 2011-01-20 01:01:01
+hello world 11.220 2011-01-20 01:01:01
+hello world 11.220 2011-01-20 01:01:01
+hello world 11.220 2011-01-20 01:01:01
PREHOOK: query: select * from newtypestbl where ts<=cast('2011-01-20 01:01:01' as timestamp) sort by c
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -254,16 +254,16 @@ POSTHOOK: query: select * from newtypestbl where ts<=cast('2011-01-20 01:01:01'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-hello world 11.22 2011-01-20 01:01:01
-hello world 11.22 2011-01-20 01:01:01
-hello world 11.22 2011-01-20 01:01:01
-hello world 11.22 2011-01-20 01:01:01
-hello world 11.22 2011-01-20 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+hello world 11.220 2011-01-20 01:01:01
+hello world 11.220 2011-01-20 01:01:01
+hello world 11.220 2011-01-20 01:01:01
+hello world 11.220 2011-01-20 01:01:01
+hello world 11.220 2011-01-20 01:01:01
PREHOOK: query: select * from newtypestbl where ts in (cast('2011-01-02 01:01:01' as timestamp), cast('2011-01-20 01:01:01' as timestamp))
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -272,11 +272,11 @@ POSTHOOK: query: select * from newtypestbl where ts in (cast('2011-01-02 01:01:0
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-hello world 11.22 2011-01-20 01:01:01
-hello world 11.22 2011-01-20 01:01:01
-hello world 11.22 2011-01-20 01:01:01
-hello world 11.22 2011-01-20 01:01:01
-hello world 11.22 2011-01-20 01:01:01
+hello world 11.220 2011-01-20 01:01:01
+hello world 11.220 2011-01-20 01:01:01
+hello world 11.220 2011-01-20 01:01:01
+hello world 11.220 2011-01-20 01:01:01
+hello world 11.220 2011-01-20 01:01:01
PREHOOK: query: select * from newtypestbl where ts in (cast('2011-01-02 01:01:01' as timestamp), cast('2011-01-20 01:01:01' as timestamp))
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -285,11 +285,11 @@ POSTHOOK: query: select * from newtypestbl where ts in (cast('2011-01-02 01:01:0
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-hello world 11.22 2011-01-20 01:01:01
-hello world 11.22 2011-01-20 01:01:01
-hello world 11.22 2011-01-20 01:01:01
-hello world 11.22 2011-01-20 01:01:01
-hello world 11.22 2011-01-20 01:01:01
+hello world 11.220 2011-01-20 01:01:01
+hello world 11.220 2011-01-20 01:01:01
+hello world 11.220 2011-01-20 01:01:01
+hello world 11.220 2011-01-20 01:01:01
+hello world 11.220 2011-01-20 01:01:01
PREHOOK: query: select * from newtypestbl where ts in (cast('2011-01-01 01:01:01' as timestamp), cast('2011-01-20 01:01:01' as timestamp)) sort by c
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -298,16 +298,16 @@ POSTHOOK: query: select * from newtypestbl where ts in (cast('2011-01-01 01:01:0
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-hello world 11.22 2011-01-20 01:01:01
-hello world 11.22 2011-01-20 01:01:01
-hello world 11.22 2011-01-20 01:01:01
-hello world 11.22 2011-01-20 01:01:01
-hello world 11.22 2011-01-20 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+hello world 11.220 2011-01-20 01:01:01
+hello world 11.220 2011-01-20 01:01:01
+hello world 11.220 2011-01-20 01:01:01
+hello world 11.220 2011-01-20 01:01:01
+hello world 11.220 2011-01-20 01:01:01
PREHOOK: query: select * from newtypestbl where ts in (cast('2011-01-01 01:01:01' as timestamp), cast('2011-01-20 01:01:01' as timestamp)) sort by c
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -316,16 +316,16 @@ POSTHOOK: query: select * from newtypestbl where ts in (cast('2011-01-01 01:01:0
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-hello world 11.22 2011-01-20 01:01:01
-hello world 11.22 2011-01-20 01:01:01
-hello world 11.22 2011-01-20 01:01:01
-hello world 11.22 2011-01-20 01:01:01
-hello world 11.22 2011-01-20 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+hello world 11.220 2011-01-20 01:01:01
+hello world 11.220 2011-01-20 01:01:01
+hello world 11.220 2011-01-20 01:01:01
+hello world 11.220 2011-01-20 01:01:01
+hello world 11.220 2011-01-20 01:01:01
PREHOOK: query: select * from newtypestbl where ts in (cast('2011-01-02 01:01:01' as timestamp), cast('2011-01-08 01:01:01' as timestamp))
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -350,11 +350,11 @@ POSTHOOK: query: select * from newtypestbl where ts between cast('2010-10-01 01:
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
PREHOOK: query: select * from newtypestbl where ts between cast('2010-10-01 01:01:01' as timestamp) and cast('2011-01-08 01:01:01' as timestamp)
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -363,11 +363,11 @@ POSTHOOK: query: select * from newtypestbl where ts between cast('2010-10-01 01:
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
PREHOOK: query: select * from newtypestbl where ts between cast('2010-10-01 01:01:01' as timestamp) and cast('2011-01-25 01:01:01' as timestamp) sort by c
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -376,16 +376,16 @@ POSTHOOK: query: select * from newtypestbl where ts between cast('2010-10-01 01:
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-hello world 11.22 2011-01-20 01:01:01
-hello world 11.22 2011-01-20 01:01:01
-hello world 11.22 2011-01-20 01:01:01
-hello world 11.22 2011-01-20 01:01:01
-hello world 11.22 2011-01-20 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+hello world 11.220 2011-01-20 01:01:01
+hello world 11.220 2011-01-20 01:01:01
+hello world 11.220 2011-01-20 01:01:01
+hello world 11.220 2011-01-20 01:01:01
+hello world 11.220 2011-01-20 01:01:01
PREHOOK: query: select * from newtypestbl where ts between cast('2010-10-01 01:01:01' as timestamp) and cast('2011-01-25 01:01:01' as timestamp) sort by c
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -394,16 +394,16 @@ POSTHOOK: query: select * from newtypestbl where ts between cast('2010-10-01 01:
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-apple bee 0.22 2011-01-01 01:01:01
-hello world 11.22 2011-01-20 01:01:01
-hello world 11.22 2011-01-20 01:01:01
-hello world 11.22 2011-01-20 01:01:01
-hello world 11.22 2011-01-20 01:01:01
-hello world 11.22 2011-01-20 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+apple bee 0.220 2011-01-01 01:01:01
+hello world 11.220 2011-01-20 01:01:01
+hello world 11.220 2011-01-20 01:01:01
+hello world 11.220 2011-01-20 01:01:01
+hello world 11.220 2011-01-20 01:01:01
+hello world 11.220 2011-01-20 01:01:01
PREHOOK: query: select * from newtypestbl where ts between cast('2010-10-01 01:01:01' as timestamp) and cast('2010-11-01 01:01:01' as timestamp)
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
http://git-wip-us.apache.org/repos/asf/hive/blob/13f8cfec/ql/src/test/results/clientpositive/parquet_ppd_varchar.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/parquet_ppd_varchar.q.out b/ql/src/test/results/clientpositive/parquet_ppd_varchar.q.out
index 2e9f72f..5a62e80 100644
--- a/ql/src/test/results/clientpositive/parquet_ppd_varchar.q.out
+++ b/ql/src/test/results/clientpositive/parquet_ppd_varchar.q.out
@@ -28,11 +28,11 @@ select * from newtypestbl where v="bee"
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
PREHOOK: query: select * from newtypestbl where v="bee"
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -41,11 +41,11 @@ POSTHOOK: query: select * from newtypestbl where v="bee"
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
PREHOOK: query: select * from newtypestbl where v!="bee"
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -54,11 +54,11 @@ POSTHOOK: query: select * from newtypestbl where v!="bee"
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
PREHOOK: query: select * from newtypestbl where v!="bee"
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -67,11 +67,11 @@ POSTHOOK: query: select * from newtypestbl where v!="bee"
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
PREHOOK: query: select * from newtypestbl where v<"world"
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -80,11 +80,11 @@ POSTHOOK: query: select * from newtypestbl where v<"world"
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
PREHOOK: query: select * from newtypestbl where v<"world"
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -93,11 +93,11 @@ POSTHOOK: query: select * from newtypestbl where v<"world"
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
PREHOOK: query: select * from newtypestbl where v<="world" sort by c
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -106,16 +106,16 @@ POSTHOOK: query: select * from newtypestbl where v<="world" sort by c
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
PREHOOK: query: select * from newtypestbl where v<="world" sort by c
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -124,16 +124,16 @@ POSTHOOK: query: select * from newtypestbl where v<="world" sort by c
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
PREHOOK: query: select * from newtypestbl where v="bee "
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -158,11 +158,11 @@ POSTHOOK: query: select * from newtypestbl where v in ("bee", "orange")
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
PREHOOK: query: select * from newtypestbl where v in ("bee", "orange")
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -171,11 +171,11 @@ POSTHOOK: query: select * from newtypestbl where v in ("bee", "orange")
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
PREHOOK: query: select * from newtypestbl where v in ("bee", "world") sort by c
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -184,16 +184,16 @@ POSTHOOK: query: select * from newtypestbl where v in ("bee", "world") sort by c
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
PREHOOK: query: select * from newtypestbl where v in ("bee", "world") sort by c
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -202,16 +202,16 @@ POSTHOOK: query: select * from newtypestbl where v in ("bee", "world") sort by c
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
PREHOOK: query: select * from newtypestbl where v in ("orange")
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -236,11 +236,11 @@ POSTHOOK: query: select * from newtypestbl where v between "bee" and "orange"
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
PREHOOK: query: select * from newtypestbl where v between "bee" and "orange"
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -249,11 +249,11 @@ POSTHOOK: query: select * from newtypestbl where v between "bee" and "orange"
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
PREHOOK: query: select * from newtypestbl where v between "bee" and "zombie" sort by c
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -262,16 +262,16 @@ POSTHOOK: query: select * from newtypestbl where v between "bee" and "zombie" so
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
PREHOOK: query: select * from newtypestbl where v between "bee" and "zombie" sort by c
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
@@ -280,16 +280,16 @@ POSTHOOK: query: select * from newtypestbl where v between "bee" and "zombie" so
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl
#### A masked pattern was here ####
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-apple bee 0.22 1970-02-20
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
-hello world 11.22 1970-02-27
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+apple bee 0.220 1970-02-20
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
+hello world 11.220 1970-02-27
PREHOOK: query: select * from newtypestbl where v between "orange" and "pine"
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl
http://git-wip-us.apache.org/repos/asf/hive/blob/13f8cfec/ql/src/test/results/clientpositive/parquet_predicate_pushdown.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/parquet_predicate_pushdown.q.out b/ql/src/test/results/clientpositive/parquet_predicate_pushdown.q.out
index aa3b272..980b65b 100644
--- a/ql/src/test/results/clientpositive/parquet_predicate_pushdown.q.out
+++ b/ql/src/test/results/clientpositive/parquet_predicate_pushdown.q.out
@@ -241,7 +241,7 @@ POSTHOOK: query: SELECT * FROM tbl_pred WHERE t>2 limit 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tbl_pred
#### A masked pattern was here ####
-124 336 65664 4294967435 74.72 42.47 true bob davidson 2013-03-01 09:11:58.703302 45.4 yard duty
+124 336 65664 4294967435 74.72 42.47 true bob davidson 2013-03-01 09:11:58.703302 45.40 yard duty
PREHOOK: query: SELECT * FROM tbl_pred WHERE t>2 limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@tbl_pred
@@ -250,7 +250,7 @@ POSTHOOK: query: SELECT * FROM tbl_pred WHERE t>2 limit 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tbl_pred
#### A masked pattern was here ####
-124 336 65664 4294967435 74.72 42.47 true bob davidson 2013-03-01 09:11:58.703302 45.4 yard duty
+124 336 65664 4294967435 74.72 42.47 true bob davidson 2013-03-01 09:11:58.703302 45.40 yard duty
PREHOOK: query: SELECT * FROM tbl_pred
WHERE t IS NOT NULL
AND t < 0
http://git-wip-us.apache.org/repos/asf/hive/blob/13f8cfec/ql/src/test/results/clientpositive/serde_regex.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/serde_regex.q.out b/ql/src/test/results/clientpositive/serde_regex.q.out
index ad3af57..7bebb0c 100644
--- a/ql/src/test/results/clientpositive/serde_regex.q.out
+++ b/ql/src/test/results/clientpositive/serde_regex.q.out
@@ -201,43 +201,43 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@serde_regex1
#### A masked pattern was here ####
NULL 0
--1234567890.123456789 -1234567890
--4400 4400
--1255.49 -1255
--1.122 -11
--1.12 -1
--1.12 -1
--0.333 0
--0.33 0
--0.3 0
-0 0
-0 0
-0 0
-0.01 0
-0.02 0
-0.1 0
-0.2 0
-0.3 0
-0.33 0
-0.333 0
-1 1
-1 1
-1 1
-1.12 1
-1.122 1
-2 2
-2 2
-3.14 3
-3.14 3
-3.14 3
-3.14 4
-10 10
-20 20
-100 100
-124 124
-125.2 125
-200 200
-1234567890.12345678 1234567890
+-1234567890.123456789000000000 -1234567890
+-4400.000000000000000000 4400
+-1255.490000000000000000 -1255
+-1.122000000000000000 -11
+-1.120000000000000000 -1
+-1.120000000000000000 -1
+-0.333000000000000000 0
+-0.330000000000000000 0
+-0.300000000000000000 0
+0.000000000000000000 0
+0.000000000000000000 0
+0.000000000000000000 0
+0.010000000000000000 0
+0.020000000000000000 0
+0.100000000000000000 0
+0.200000000000000000 0
+0.300000000000000000 0
+0.330000000000000000 0
+0.333000000000000000 0
+1.000000000000000000 1
+1.000000000000000000 1
+1.000000000000000000 1
+1.120000000000000000 1
+1.122000000000000000 1
+2.000000000000000000 2
+2.000000000000000000 2
+3.140000000000000000 3
+3.140000000000000000 3
+3.140000000000000000 3
+3.140000000000000000 4
+10.000000000000000000 10
+20.000000000000000000 20
+100.000000000000000000 100
+124.000000000000000000 124
+125.200000000000000000 125
+200.000000000000000000 200
+1234567890.123456780000000000 1234567890
PREHOOK: query: DROP TABLE serde_regex1
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@serde_regex1
http://git-wip-us.apache.org/repos/asf/hive/blob/13f8cfec/ql/src/test/results/clientpositive/spark/avro_decimal_native.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/avro_decimal_native.q.out b/ql/src/test/results/clientpositive/spark/avro_decimal_native.q.out
index 318be3d..cebc342 100644
--- a/ql/src/test/results/clientpositive/spark/avro_decimal_native.q.out
+++ b/ql/src/test/results/clientpositive/spark/avro_decimal_native.q.out
@@ -92,9 +92,9 @@ Mary 4.33
Cluck 5.96
Tom -12.25
Mary 33.33
-Tom 19
-Beck 0
-Beck 79.9
+Tom 19.00
+Beck 0.00
+Beck 79.90
PREHOOK: query: DROP TABLE IF EXISTS avro_dec1
PREHOOK: type: DROPTABLE
POSTHOOK: query: DROP TABLE IF EXISTS avro_dec1
@@ -143,10 +143,10 @@ POSTHOOK: Input: default@avro_dec1
77.3
55.7
4.3
-6
+6.0
12.3
33.3
-19
+19.0
3.2
79.9
PREHOOK: query: DROP TABLE dec
http://git-wip-us.apache.org/repos/asf/hive/blob/13f8cfec/ql/src/test/results/clientpositive/spark/decimal_1_1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/decimal_1_1.q.out b/ql/src/test/results/clientpositive/spark/decimal_1_1.q.out
index b2704c6..46fbeb7 100644
--- a/ql/src/test/results/clientpositive/spark/decimal_1_1.q.out
+++ b/ql/src/test/results/clientpositive/spark/decimal_1_1.q.out
@@ -26,9 +26,9 @@ POSTHOOK: query: select * from decimal_1_1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_1_1
#### A masked pattern was here ####
-0
-0
-0
+0.0
+0.0
+0.0
0.1
0.2
0.9
@@ -37,13 +37,13 @@ NULL
0.3
NULL
NULL
-0
-0
+0.0
+0.0
NULL
-0
-0
-0
-0
+0.0
+0.0
+0.0
+0.0
-0.1
-0.2
-0.9
@@ -52,10 +52,10 @@ NULL
-0.3
NULL
NULL
-0
-0
+0.0
+0.0
NULL
-0
+0.0
PREHOOK: query: select d from decimal_1_1 order by d desc
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_1_1
@@ -69,18 +69,18 @@ POSTHOOK: Input: default@decimal_1_1
0.3
0.2
0.1
-0
-0
-0
-0
-0
-0
-0
-0
-0
-0
-0
-0
+0.0
+0.0
+0.0
+0.0
+0.0
+0.0
+0.0
+0.0
+0.0
+0.0
+0.0
+0.0
-0.1
-0.2
-0.3
http://git-wip-us.apache.org/repos/asf/hive/blob/13f8cfec/ql/src/test/results/clientpositive/spark/mapjoin_decimal.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/mapjoin_decimal.q.out b/ql/src/test/results/clientpositive/spark/mapjoin_decimal.q.out
index 20b188b..bc785f9 100644
--- a/ql/src/test/results/clientpositive/spark/mapjoin_decimal.q.out
+++ b/ql/src/test/results/clientpositive/spark/mapjoin_decimal.q.out
@@ -172,112 +172,112 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
#### A masked pattern was here ####
-14 14
-14 14
-14 14
-14 14
-14 14
-14 14
-14 14
-14 14
-14 14
-17 17
-17 17
-17 17
-17 17
-17 17
-17 17
-17 17
-17 17
-17 17
-17 17
-45 45
-45 45
-45 45
-45 45
-45 45
-6 6
-6 6
-6 6
-6 6
-6 6
-6 6
-62 62
-62 62
-62 62
-62 62
-62 62
-62 62
-62 62
-62 62
-62 62
-62 62
-62 62
-62 62
-64 64
-64 64
-64 64
-64 64
-64 64
-64 64
-64 64
-64 64
-64 64
-64 64
-64 64
-64 64
-64 64
-64 64
-64 64
-64 64
-64 64
-64 64
-70 70
-70 70
-70 70
-70 70
-70 70
-70 70
-70 70
-79 79
-79 79
-79 79
-79 79
-79 79
-79 79
-89 89
-89 89
-89 89
-89 89
-89 89
-89 89
-89 89
-89 89
-89 89
-89 89
-89 89
-89 89
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
+14.00 14
+14.00 14
+14.00 14
+14.00 14
+14.00 14
+14.00 14
+14.00 14
+14.00 14
+14.00 14
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+45.00 45
+45.00 45
+45.00 45
+45.00 45
+45.00 45
+6.00 6
+6.00 6
+6.00 6
+6.00 6
+6.00 6
+6.00 6
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+70.00 70
+70.00 70
+70.00 70
+70.00 70
+70.00 70
+70.00 70
+70.00 70
+79.00 79
+79.00 79
+79.00 79
+79.00 79
+79.00 79
+79.00 79
+89.00 89
+89.00 89
+89.00 89
+89.00 89
+89.00 89
+89.00 89
+89.00 89
+89.00 89
+89.00 89
+89.00 89
+89.00 89
+89.00 89
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
PREHOOK: query: select t1.dec, t2.dec from t1 join t2 on (t1.dec=t2.dec) order by t1.dec
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
@@ -288,109 +288,109 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
#### A masked pattern was here ####
-14 14
-14 14
-14 14
-14 14
-14 14
-14 14
-14 14
-14 14
-14 14
-17 17
-17 17
-17 17
-17 17
-17 17
-17 17
-17 17
-17 17
-17 17
-17 17
-45 45
-45 45
-45 45
-45 45
-45 45
-6 6
-6 6
-6 6
-6 6
-6 6
-6 6
-62 62
-62 62
-62 62
-62 62
-62 62
-62 62
-62 62
-62 62
-62 62
-62 62
-62 62
-62 62
-64 64
-64 64
-64 64
-64 64
-64 64
-64 64
-64 64
-64 64
-64 64
-64 64
-64 64
-64 64
-64 64
-64 64
-64 64
-64 64
-64 64
-64 64
-70 70
-70 70
-70 70
-70 70
-70 70
-70 70
-70 70
-79 79
-79 79
-79 79
-79 79
-79 79
-79 79
-89 89
-89 89
-89 89
-89 89
-89 89
-89 89
-89 89
-89 89
-89 89
-89 89
-89 89
-89 89
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
-9 9
+14.00 14
+14.00 14
+14.00 14
+14.00 14
+14.00 14
+14.00 14
+14.00 14
+14.00 14
+14.00 14
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+17.00 17
+45.00 45
+45.00 45
+45.00 45
+45.00 45
+45.00 45
+6.00 6
+6.00 6
+6.00 6
+6.00 6
+6.00 6
+6.00 6
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+62.00 62
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+64.00 64
+70.00 70
+70.00 70
+70.00 70
+70.00 70
+70.00 70
+70.00 70
+70.00 70
+79.00 79
+79.00 79
+79.00 79
+79.00 79
+79.00 79
+79.00 79
+89.00 89
+89.00 89
+89.00 89
+89.00 89
+89.00 89
+89.00 89
+89.00 89
+89.00 89
+89.00 89
+89.00 89
+89.00 89
+89.00 89
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
+9.00 9
http://git-wip-us.apache.org/repos/asf/hive/blob/13f8cfec/ql/src/test/results/clientpositive/spark/vector_between_in.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/vector_between_in.q.out b/ql/src/test/results/clientpositive/spark/vector_between_in.q.out
index 133769a..f1ff784 100644
--- a/ql/src/test/results/clientpositive/spark/vector_between_in.q.out
+++ b/ql/src/test/results/clientpositive/spark/vector_between_in.q.out
@@ -650,34 +650,34 @@ POSTHOOK: Input: default@decimal_date_test
-18.5162162162
-17.3216216216
-16.7243243243
--16.127027027
+-16.1270270270
-15.5297297297
-10.7513513514
-9.5567567568
-8.3621621622
--5.972972973
+-5.9729729730
-3.5837837838
4.1810810811
4.7783783784
4.7783783784
5.3756756757
-5.972972973
-5.972972973
+5.9729729730
+5.9729729730
11.3486486486
11.3486486486
11.9459459459
14.9324324324
19.1135135135
20.3081081081
-22.1
+22.1000000000
24.4891891892
33.4486486486
34.6432432432
40.0189189189
42.4081081081
43.0054054054
-44.2
-44.2
+44.2000000000
+44.2000000000
44.7972972973
45.9918918919
PREHOOK: query: SELECT COUNT(*) FROM decimal_date_test WHERE cdecimal1 NOT BETWEEN -2000 AND 4390.1351351351
http://git-wip-us.apache.org/repos/asf/hive/blob/13f8cfec/ql/src/test/results/clientpositive/spark/vector_cast_constant.q.java1.7.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/vector_cast_constant.q.java1.7.out b/ql/src/test/results/clientpositive/spark/vector_cast_constant.q.java1.7.out
index e1acab1..c3e7779 100644
--- a/ql/src/test/results/clientpositive/spark/vector_cast_constant.q.java1.7.out
+++ b/ql/src/test/results/clientpositive/spark/vector_cast_constant.q.java1.7.out
@@ -204,13 +204,13 @@ POSTHOOK: query: SELECT
POSTHOOK: type: QUERY
POSTHOOK: Input: default@over1korc
#### A masked pattern was here ####
-65536 50.0 50.0 50
-65537 50.0 50.0 50
-65538 50.0 50.0 50
-65539 50.0 50.0 50
-65540 50.0 50.0 50
-65541 50.0 50.0 50
-65542 50.0 50.0 50
-65543 50.0 50.0 50
-65544 50.0 50.0 50
-65545 50.0 50.0 50
+65536 50.0 50.0 50.0000
+65537 50.0 50.0 50.0000
+65538 50.0 50.0 50.0000
+65539 50.0 50.0 50.0000
+65540 50.0 50.0 50.0000
+65541 50.0 50.0 50.0000
+65542 50.0 50.0 50.0000
+65543 50.0 50.0 50.0000
+65544 50.0 50.0 50.0000
+65545 50.0 50.0 50.0000
http://git-wip-us.apache.org/repos/asf/hive/blob/13f8cfec/ql/src/test/results/clientpositive/spark/vector_data_types.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/vector_data_types.q.out b/ql/src/test/results/clientpositive/spark/vector_data_types.q.out
index f6b2920..bcabc98 100644
--- a/ql/src/test/results/clientpositive/spark/vector_data_types.q.out
+++ b/ql/src/test/results/clientpositive/spark/vector_data_types.q.out
@@ -159,7 +159,7 @@ POSTHOOK: Input: default@over1korc
#### A masked pattern was here ####
NULL 374 65560 4294967516 65.43 22.48 true oscar quirinius 2013-03-01 09:11:58.703316 16.86 mathematics
NULL 409 65536 4294967490 46.97 25.92 false fred miller 2013-03-01 09:11:58.703116 33.45 history
-NULL 473 65720 4294967324 80.74 40.6 false holly falkner 2013-03-01 09:11:58.703111 18.8 mathematics
+NULL 473 65720 4294967324 80.74 40.6 false holly falkner 2013-03-01 09:11:58.703111 18.80 mathematics
-3 275 65622 4294967302 71.78 8.49 false wendy robinson 2013-03-01 09:11:58.703294 95.39 undecided
-3 344 65733 4294967363 0.56 11.96 true rachel thompson 2013-03-01 09:11:58.703276 88.46 wind surfing
-3 376 65548 4294967431 96.78 43.23 false fred ellison 2013-03-01 09:11:58.703233 75.39 education
@@ -252,7 +252,7 @@ POSTHOOK: Input: default@over1korc
#### A masked pattern was here ####
NULL 374 65560 4294967516 65.43 22.48 true oscar quirinius 2013-03-01 09:11:58.703316 16.86 mathematics
NULL 409 65536 4294967490 46.97 25.92 false fred miller 2013-03-01 09:11:58.703116 33.45 history
-NULL 473 65720 4294967324 80.74 40.6 false holly falkner 2013-03-01 09:11:58.703111 18.8 mathematics
+NULL 473 65720 4294967324 80.74 40.6 false holly falkner 2013-03-01 09:11:58.703111 18.80 mathematics
-3 275 65622 4294967302 71.78 8.49 false wendy robinson 2013-03-01 09:11:58.703294 95.39 undecided
-3 344 65733 4294967363 0.56 11.96 true rachel thompson 2013-03-01 09:11:58.703276 88.46 wind surfing
-3 376 65548 4294967431 96.78 43.23 false fred ellison 2013-03-01 09:11:58.703233 75.39 education