http://git-wip-us.apache.org/repos/asf/hive/blob/3228ba7c/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/3228ba7c/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/3228ba7c/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/3228ba7c/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/3228ba7c/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/3228ba7c/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/3228ba7c/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/3228ba7c/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/3228ba7c/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/3228ba7c/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/3228ba7c/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
