http://git-wip-us.apache.org/repos/asf/hive/blob/63deec40/ql/src/test/results/clientpositive/vectorization_13.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/vectorization_13.q.out
b/ql/src/test/results/clientpositive/vectorization_13.q.out
index 7d14581..bfc8ad2 100644
--- a/ql/src/test/results/clientpositive/vectorization_13.q.out
+++ b/ql/src/test/results/clientpositive/vectorization_13.q.out
@@ -1,25 +1,27 @@
-PREHOOK: query: EXPLAIN
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+EXPLAIN
SELECT cboolean1,
ctinyint,
ctimestamp1,
cfloat,
cstring1,
- (-(ctinyint)),
- MAX(ctinyint),
- ((-(ctinyint)) + MAX(ctinyint)),
- SUM(cfloat),
- (SUM(cfloat) * ((-(ctinyint)) + MAX(ctinyint))),
- (-(SUM(cfloat))),
- (79.553 * cfloat),
- STDDEV_POP(cfloat),
- (-(SUM(cfloat))),
- STDDEV_POP(ctinyint),
- (((-(ctinyint)) + MAX(ctinyint)) - 10.175),
- (-((-(SUM(cfloat))))),
- (-26.28 / (-((-(SUM(cfloat)))))),
- MAX(cfloat),
- ((SUM(cfloat) * ((-(ctinyint)) + MAX(ctinyint))) / ctinyint),
- MIN(ctinyint)
+ (-(ctinyint)) as c1,
+ MAX(ctinyint) as c2,
+ ((-(ctinyint)) + MAX(ctinyint)) as c3,
+ SUM(cfloat) as c4,
+ (SUM(cfloat) * ((-(ctinyint)) + MAX(ctinyint))) as c5,
+ (-(SUM(cfloat))) as c6,
+ (79.553 * cfloat) as c7,
+ STDDEV_POP(cfloat) as c8,
+ (-(SUM(cfloat))) as c9,
+ STDDEV_POP(ctinyint) as c10,
+ (((-(ctinyint)) + MAX(ctinyint)) - 10.175) as c11,
+ (-((-(SUM(cfloat))))) as c12,
+ (-26.28 / (-((-(SUM(cfloat)))))) as c13,
+ MAX(cfloat) as c14,
+ ((SUM(cfloat) * ((-(ctinyint)) + MAX(ctinyint))) / ctinyint) as c15,
+ MIN(ctinyint) as c16
FROM alltypesorc
WHERE (((cfloat < 3569)
AND ((10.175 >= cdouble)
@@ -28,31 +30,33 @@ WHERE (((cfloat < 3569)
AND ((ctimestamp2 != 12)
AND (ctinyint < 9763215.5639))))
GROUP BY cboolean1, ctinyint, ctimestamp1, cfloat, cstring1
-ORDER BY cboolean1, ctinyint, ctimestamp1, cfloat, cstring1
+ORDER BY cboolean1, ctinyint, ctimestamp1, cfloat, cstring1, c1, c2, c3, c4,
c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16
LIMIT 40
PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+EXPLAIN
SELECT cboolean1,
ctinyint,
ctimestamp1,
cfloat,
cstring1,
- (-(ctinyint)),
- MAX(ctinyint),
- ((-(ctinyint)) + MAX(ctinyint)),
- SUM(cfloat),
- (SUM(cfloat) * ((-(ctinyint)) + MAX(ctinyint))),
- (-(SUM(cfloat))),
- (79.553 * cfloat),
- STDDEV_POP(cfloat),
- (-(SUM(cfloat))),
- STDDEV_POP(ctinyint),
- (((-(ctinyint)) + MAX(ctinyint)) - 10.175),
- (-((-(SUM(cfloat))))),
- (-26.28 / (-((-(SUM(cfloat)))))),
- MAX(cfloat),
- ((SUM(cfloat) * ((-(ctinyint)) + MAX(ctinyint))) / ctinyint),
- MIN(ctinyint)
+ (-(ctinyint)) as c1,
+ MAX(ctinyint) as c2,
+ ((-(ctinyint)) + MAX(ctinyint)) as c3,
+ SUM(cfloat) as c4,
+ (SUM(cfloat) * ((-(ctinyint)) + MAX(ctinyint))) as c5,
+ (-(SUM(cfloat))) as c6,
+ (79.553 * cfloat) as c7,
+ STDDEV_POP(cfloat) as c8,
+ (-(SUM(cfloat))) as c9,
+ STDDEV_POP(ctinyint) as c10,
+ (((-(ctinyint)) + MAX(ctinyint)) - 10.175) as c11,
+ (-((-(SUM(cfloat))))) as c12,
+ (-26.28 / (-((-(SUM(cfloat)))))) as c13,
+ MAX(cfloat) as c14,
+ ((SUM(cfloat) * ((-(ctinyint)) + MAX(ctinyint))) / ctinyint) as c15,
+ MIN(ctinyint) as c16
FROM alltypesorc
WHERE (((cfloat < 3569)
AND ((10.175 >= cdouble)
@@ -61,7 +65,7 @@ WHERE (((cfloat < 3569)
AND ((ctimestamp2 != 12)
AND (ctinyint < 9763215.5639))))
GROUP BY cboolean1, ctinyint, ctimestamp1, cfloat, cstring1
-ORDER BY cboolean1, ctinyint, ctimestamp1, cfloat, cstring1
+ORDER BY cboolean1, ctinyint, ctimestamp1, cfloat, cstring1, c1, c2, c3, c4,
c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16
LIMIT 40
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
@@ -104,8 +108,8 @@ STAGE PLANS:
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6,
_col7, _col8, _col9, _col10
Statistics: Num rows: 1365 Data size: 293479 Basic stats: COMPLETE
Column stats: NONE
Select Operator
- expressions: _col0 (type: boolean), _col1 (type: tinyint), (-
_col6) (type: double), (79.553 * UDFToDouble(_col3)) (type: double), _col7
(type: double), _col8 (type: double), (UDFToDouble(((- _col1) + _col5)) -
10.175) (type: double), (- (- _col6)) (type: double), (-26.28 / (- (- _col6)))
(type: double), _col9 (type: float), ((_col6 * UDFToDouble(((- _col1) +
_col5))) / UDFToDouble(_col1)) (type: double), _col2 (type: timestamp), _col10
(type: tinyint), _col3 (type: float), _col4 (type: string), (- _col1) (type:
tinyint), _col5 (type: tinyint), ((- _col1) + _col5) (type: tinyint), _col6
(type: double), (_col6 * UDFToDouble(((- _col1) + _col5))) (type: double)
- outputColumnNames: _col0, _col1, _col10, _col11, _col12, _col14,
_col15, _col16, _col17, _col18, _col19, _col2, _col20, _col3, _col4, _col5,
_col6, _col7, _col8, _col9
+ expressions: _col0 (type: boolean), _col1 (type: tinyint), _col2
(type: timestamp), _col3 (type: float), _col4 (type: string), (- _col1) (type:
tinyint), _col5 (type: tinyint), ((- _col1) + _col5) (type: tinyint), _col6
(type: double), (_col6 * UDFToDouble(((- _col1) + _col5))) (type: double), (-
_col6) (type: double), (79.553 * UDFToDouble(_col3)) (type: double), _col7
(type: double), (- _col6) (type: double), _col8 (type: double),
(UDFToDouble(((- _col1) + _col5)) - 10.175) (type: double), (- (- _col6))
(type: double), (-26.28 / (- (- _col6))) (type: double), _col9 (type: float),
((_col6 * UDFToDouble(((- _col1) + _col5))) / UDFToDouble(_col1)) (type:
double), _col10 (type: tinyint)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5,
_col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15,
_col16, _col17, _col18, _col19, _col20
Statistics: Num rows: 1365 Data size: 293479 Basic stats: COMPLETE
Column stats: NONE
File Output Operator
compressed: false
@@ -119,13 +123,12 @@ STAGE PLANS:
Map Operator Tree:
TableScan
Reduce Output Operator
- key expressions: _col0 (type: boolean), _col1 (type: tinyint),
_col2 (type: timestamp), _col3 (type: float), _col4 (type: string)
- sort order: +++++
+ key expressions: _col0 (type: boolean), _col1 (type: tinyint),
_col2 (type: timestamp), _col3 (type: float), _col4 (type: string), _col5
(type: tinyint), _col6 (type: tinyint), _col7 (type: tinyint), _col8 (type:
double), _col9 (type: double), _col10 (type: double), _col11 (type: double),
_col12 (type: double), _col13 (type: double), _col14 (type: double), _col15
(type: double), _col16 (type: double), _col17 (type: double), _col18 (type:
float), _col19 (type: double), _col20 (type: tinyint)
+ sort order: +++++++++++++++++++++
Statistics: Num rows: 1365 Data size: 293479 Basic stats:
COMPLETE Column stats: NONE
- value expressions: _col5 (type: tinyint), _col6 (type: tinyint),
_col7 (type: tinyint), _col8 (type: double), _col9 (type: double), _col10
(type: double), _col11 (type: double), _col12 (type: double), _col14 (type:
double), _col15 (type: double), _col16 (type: double), _col17 (type: double),
_col18 (type: float), _col19 (type: double), _col20 (type: tinyint)
Reduce Operator Tree:
Select Operator
- expressions: KEY.reducesinkkey0 (type: boolean), KEY.reducesinkkey1
(type: tinyint), KEY.reducesinkkey2 (type: timestamp), KEY.reducesinkkey3
(type: float), KEY.reducesinkkey4 (type: string), VALUE._col0 (type: tinyint),
VALUE._col1 (type: tinyint), VALUE._col2 (type: tinyint), VALUE._col3 (type:
double), VALUE._col4 (type: double), VALUE._col5 (type: double), VALUE._col6
(type: double), VALUE._col7 (type: double), VALUE._col5 (type: double),
VALUE._col8 (type: double), VALUE._col9 (type: double), VALUE._col10 (type:
double), VALUE._col11 (type: double), VALUE._col12 (type: float), VALUE._col13
(type: double), VALUE._col14 (type: tinyint)
+ expressions: KEY.reducesinkkey0 (type: boolean), KEY.reducesinkkey1
(type: tinyint), KEY.reducesinkkey2 (type: timestamp), KEY.reducesinkkey3
(type: float), KEY.reducesinkkey4 (type: string), KEY.reducesinkkey5 (type:
tinyint), KEY.reducesinkkey6 (type: tinyint), KEY.reducesinkkey7 (type:
tinyint), KEY.reducesinkkey8 (type: double), KEY.reducesinkkey9 (type: double),
KEY.reducesinkkey10 (type: double), KEY.reducesinkkey11 (type: double),
KEY.reducesinkkey12 (type: double), KEY.reducesinkkey10 (type: double),
KEY.reducesinkkey14 (type: double), KEY.reducesinkkey15 (type: double),
KEY.reducesinkkey16 (type: double), KEY.reducesinkkey17 (type: double),
KEY.reducesinkkey18 (type: float), KEY.reducesinkkey19 (type: double),
KEY.reducesinkkey20 (type: tinyint)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6,
_col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16,
_col17, _col18, _col19, _col20
Statistics: Num rows: 1365 Data size: 293479 Basic stats: COMPLETE
Column stats: NONE
Limit
@@ -150,22 +153,22 @@ PREHOOK: query: SELECT cboolean1,
ctimestamp1,
cfloat,
cstring1,
- (-(ctinyint)),
- MAX(ctinyint),
- ((-(ctinyint)) + MAX(ctinyint)),
- SUM(cfloat),
- (SUM(cfloat) * ((-(ctinyint)) + MAX(ctinyint))),
- (-(SUM(cfloat))),
- (79.553 * cfloat),
- STDDEV_POP(cfloat),
- (-(SUM(cfloat))),
- STDDEV_POP(ctinyint),
- (((-(ctinyint)) + MAX(ctinyint)) - 10.175),
- (-((-(SUM(cfloat))))),
- (-26.28 / (-((-(SUM(cfloat)))))),
- MAX(cfloat),
- ((SUM(cfloat) * ((-(ctinyint)) + MAX(ctinyint))) / ctinyint),
- MIN(ctinyint)
+ (-(ctinyint)) as c1,
+ MAX(ctinyint) as c2,
+ ((-(ctinyint)) + MAX(ctinyint)) as c3,
+ SUM(cfloat) as c4,
+ (SUM(cfloat) * ((-(ctinyint)) + MAX(ctinyint))) as c5,
+ (-(SUM(cfloat))) as c6,
+ (79.553 * cfloat) as c7,
+ STDDEV_POP(cfloat) as c8,
+ (-(SUM(cfloat))) as c9,
+ STDDEV_POP(ctinyint) as c10,
+ (((-(ctinyint)) + MAX(ctinyint)) - 10.175) as c11,
+ (-((-(SUM(cfloat))))) as c12,
+ (-26.28 / (-((-(SUM(cfloat)))))) as c13,
+ MAX(cfloat) as c14,
+ ((SUM(cfloat) * ((-(ctinyint)) + MAX(ctinyint))) / ctinyint) as c15,
+ MIN(ctinyint) as c16
FROM alltypesorc
WHERE (((cfloat < 3569)
AND ((10.175 >= cdouble)
@@ -174,7 +177,7 @@ WHERE (((cfloat < 3569)
AND ((ctimestamp2 != 12)
AND (ctinyint < 9763215.5639))))
GROUP BY cboolean1, ctinyint, ctimestamp1, cfloat, cstring1
-ORDER BY cboolean1, ctinyint, ctimestamp1, cfloat, cstring1
+ORDER BY cboolean1, ctinyint, ctimestamp1, cfloat, cstring1, c1, c2, c3, c4,
c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16
LIMIT 40
PREHOOK: type: QUERY
PREHOOK: Input: default@alltypesorc
@@ -184,22 +187,22 @@ POSTHOOK: query: SELECT cboolean1,
ctimestamp1,
cfloat,
cstring1,
- (-(ctinyint)),
- MAX(ctinyint),
- ((-(ctinyint)) + MAX(ctinyint)),
- SUM(cfloat),
- (SUM(cfloat) * ((-(ctinyint)) + MAX(ctinyint))),
- (-(SUM(cfloat))),
- (79.553 * cfloat),
- STDDEV_POP(cfloat),
- (-(SUM(cfloat))),
- STDDEV_POP(ctinyint),
- (((-(ctinyint)) + MAX(ctinyint)) - 10.175),
- (-((-(SUM(cfloat))))),
- (-26.28 / (-((-(SUM(cfloat)))))),
- MAX(cfloat),
- ((SUM(cfloat) * ((-(ctinyint)) + MAX(ctinyint))) / ctinyint),
- MIN(ctinyint)
+ (-(ctinyint)) as c1,
+ MAX(ctinyint) as c2,
+ ((-(ctinyint)) + MAX(ctinyint)) as c3,
+ SUM(cfloat) as c4,
+ (SUM(cfloat) * ((-(ctinyint)) + MAX(ctinyint))) as c5,
+ (-(SUM(cfloat))) as c6,
+ (79.553 * cfloat) as c7,
+ STDDEV_POP(cfloat) as c8,
+ (-(SUM(cfloat))) as c9,
+ STDDEV_POP(ctinyint) as c10,
+ (((-(ctinyint)) + MAX(ctinyint)) - 10.175) as c11,
+ (-((-(SUM(cfloat))))) as c12,
+ (-26.28 / (-((-(SUM(cfloat)))))) as c13,
+ MAX(cfloat) as c14,
+ ((SUM(cfloat) * ((-(ctinyint)) + MAX(ctinyint))) / ctinyint) as c15,
+ MIN(ctinyint) as c16
FROM alltypesorc
WHERE (((cfloat < 3569)
AND ((10.175 >= cdouble)
@@ -208,51 +211,51 @@ WHERE (((cfloat < 3569)
AND ((ctimestamp2 != 12)
AND (ctinyint < 9763215.5639))))
GROUP BY cboolean1, ctinyint, ctimestamp1, cfloat, cstring1
-ORDER BY cboolean1, ctinyint, ctimestamp1, cfloat, cstring1
+ORDER BY cboolean1, ctinyint, ctimestamp1, cfloat, cstring1, c1, c2, c3, c4,
c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16
LIMIT 40
POSTHOOK: type: QUERY
POSTHOOK: Input: default@alltypesorc
#### A masked pattern was here ####
-NULL -64 1969-12-31 16:00:11.912 -64.0 NULL 64 -64 0
-64.0 -0.0 64.0 -5091.392 0.0 64.0 0.0 -10.175 -64.0
0.410625 -64.0 0.0 -64
-NULL -64 1969-12-31 16:00:12.339 -64.0 NULL 64 -64 0
-64.0 -0.0 64.0 -5091.392 0.0 64.0 0.0 -10.175 -64.0
0.410625 -64.0 0.0 -64
-NULL -64 1969-12-31 16:00:13.274 -64.0 NULL 64 -64 0
-64.0 -0.0 64.0 -5091.392 0.0 64.0 0.0 -10.175 -64.0
0.410625 -64.0 0.0 -64
-NULL -63 1969-12-31 16:00:11.946 -63.0 NULL 63 -63 0
-63.0 -0.0 63.0 -5011.839 0.0 63.0 0.0 -10.175 -63.0
0.41714285714285715 -63.0 0.0 -63
-NULL -63 1969-12-31 16:00:12.188 -63.0 NULL 63 -63 0
-63.0 -0.0 63.0 -5011.839 0.0 63.0 0.0 -10.175 -63.0
0.41714285714285715 -63.0 0.0 -63
-NULL -63 1969-12-31 16:00:15.436 -63.0 NULL 63 -63 0
-63.0 -0.0 63.0 -5011.839 0.0 63.0 0.0 -10.175 -63.0
0.41714285714285715 -63.0 0.0 -63
+NULL -55 1969-12-31 16:00:11.38 -55.0 NULL 55 -55 0
-55.0 -0.0 55.0 -4375.415 0.0 55.0 0.0 -10.175 -55.0
0.47781818181818186 -55.0 0.0 -55
+NULL -55 1969-12-31 16:00:11.751 -55.0 NULL 55 -55 0
-55.0 -0.0 55.0 -4375.415 0.0 55.0 0.0 -10.175 -55.0
0.47781818181818186 -55.0 0.0 -55
+NULL -56 1969-12-31 16:00:13.602 -56.0 NULL 56 -56 0
-56.0 -0.0 56.0 -4454.968 0.0 56.0 0.0 -10.175 -56.0
0.4692857142857143 -56.0 0.0 -56
+NULL -56 1969-12-31 16:00:13.958 -56.0 NULL 56 -56 0
-56.0 -0.0 56.0 -4454.968 0.0 56.0 0.0 -10.175 -56.0
0.4692857142857143 -56.0 0.0 -56
+NULL -56 1969-12-31 16:00:15.038 -56.0 NULL 56 -56 0
-56.0 -0.0 56.0 -4454.968 0.0 56.0 0.0 -10.175 -56.0
0.4692857142857143 -56.0 0.0 -56
+NULL -57 1969-12-31 16:00:11.451 -57.0 NULL 57 -57 0
-57.0 -0.0 57.0 -4534.521 0.0 57.0 0.0 -10.175 -57.0
0.4610526315789474 -57.0 0.0 -57
+NULL -57 1969-12-31 16:00:11.883 -57.0 NULL 57 -57 0
-57.0 -0.0 57.0 -4534.521 0.0 57.0 0.0 -10.175 -57.0
0.4610526315789474 -57.0 0.0 -57
+NULL -57 1969-12-31 16:00:12.626 -57.0 NULL 57 -57 0
-57.0 -0.0 57.0 -4534.521 0.0 57.0 0.0 -10.175 -57.0
0.4610526315789474 -57.0 0.0 -57
+NULL -57 1969-12-31 16:00:13.578 -57.0 NULL 57 -57 0
-57.0 -0.0 57.0 -4534.521 0.0 57.0 0.0 -10.175 -57.0
0.4610526315789474 -57.0 0.0 -57
+NULL -57 1969-12-31 16:00:15.39 -57.0 NULL 57 -57 0
-57.0 -0.0 57.0 -4534.521 0.0 57.0 0.0 -10.175 -57.0
0.4610526315789474 -57.0 0.0 -57
+NULL -58 1969-12-31 16:00:12.065 -58.0 NULL 58 -58 0
-58.0 -0.0 58.0 -4614.074 0.0 58.0 0.0 -10.175 -58.0
0.4531034482758621 -58.0 0.0 -58
+NULL -58 1969-12-31 16:00:12.683 -58.0 NULL 58 -58 0
-58.0 -0.0 58.0 -4614.074 0.0 58.0 0.0 -10.175 -58.0
0.4531034482758621 -58.0 0.0 -58
+NULL -58 1969-12-31 16:00:12.948 -58.0 NULL 58 -58 0
-58.0 -0.0 58.0 -4614.074 0.0 58.0 0.0 -10.175 -58.0
0.4531034482758621 -58.0 0.0 -58
+NULL -58 1969-12-31 16:00:14.066 -58.0 NULL 58 -58 0
-58.0 -0.0 58.0 -4614.074 0.0 58.0 0.0 -10.175 -58.0
0.4531034482758621 -58.0 0.0 -58
+NULL -58 1969-12-31 16:00:15.658 -58.0 NULL 58 -58 0
-58.0 -0.0 58.0 -4614.074 0.0 58.0 0.0 -10.175 -58.0
0.4531034482758621 -58.0 0.0 -58
+NULL -59 1969-12-31 16:00:12.008 -59.0 NULL 59 -59 0
-59.0 -0.0 59.0 -4693.6269999999995 0.0 59.0 0.0 -10.175
-59.0 0.44542372881355935 -59.0 0.0 -59
+NULL -59 1969-12-31 16:00:13.15 -59.0 NULL 59 -59 0
-59.0 -0.0 59.0 -4693.6269999999995 0.0 59.0 0.0 -10.175
-59.0 0.44542372881355935 -59.0 0.0 -59
+NULL -59 1969-12-31 16:00:13.625 -59.0 NULL 59 -59 0
-59.0 -0.0 59.0 -4693.6269999999995 0.0 59.0 0.0 -10.175
-59.0 0.44542372881355935 -59.0 0.0 -59
+NULL -59 1969-12-31 16:00:15.296 -59.0 NULL 59 -59 0
-59.0 -0.0 59.0 -4693.6269999999995 0.0 59.0 0.0 -10.175
-59.0 0.44542372881355935 -59.0 0.0 -59
+NULL -59 1969-12-31 16:00:15.861 -59.0 NULL 59 -59 0
-59.0 -0.0 59.0 -4693.6269999999995 0.0 59.0 0.0 -10.175
-59.0 0.44542372881355935 -59.0 0.0 -59
+NULL -60 1969-12-31 16:00:11.504 -60.0 NULL 60 -60 0
-60.0 -0.0 60.0 -4773.18 0.0 60.0 0.0 -10.175 -60.0
0.438 -60.0 0.0 -60
+NULL -60 1969-12-31 16:00:11.641 -60.0 NULL 60 -60 0
-60.0 -0.0 60.0 -4773.18 0.0 60.0 0.0 -10.175 -60.0
0.438 -60.0 0.0 -60
+NULL -60 1969-12-31 16:00:11.996 -60.0 NULL 60 -60 0
-60.0 -0.0 60.0 -4773.18 0.0 60.0 0.0 -10.175 -60.0
0.438 -60.0 0.0 -60
+NULL -60 1969-12-31 16:00:12.779 -60.0 NULL 60 -60 0
-60.0 -0.0 60.0 -4773.18 0.0 60.0 0.0 -10.175 -60.0
0.438 -60.0 0.0 -60
+NULL -61 1969-12-31 16:00:11.842 -61.0 NULL 61 -61 0
-61.0 -0.0 61.0 -4852.733 0.0 61.0 0.0 -10.175 -61.0
0.4308196721311476 -61.0 0.0 -61
+NULL -61 1969-12-31 16:00:12.454 -61.0 NULL 61 -61 0
-61.0 -0.0 61.0 -4852.733 0.0 61.0 0.0 -10.175 -61.0
0.4308196721311476 -61.0 0.0 -61
+NULL -61 1969-12-31 16:00:14.192 -61.0 NULL 61 -61 0
-61.0 -0.0 61.0 -4852.733 0.0 61.0 0.0 -10.175 -61.0
0.4308196721311476 -61.0 0.0 -61
+NULL -61 1969-12-31 16:00:16.558 -61.0 NULL 61 -61 0
-61.0 -0.0 61.0 -4852.733 0.0 61.0 0.0 -10.175 -61.0
0.4308196721311476 -61.0 0.0 -61
NULL -62 1969-12-31 16:00:12.388 -62.0 NULL 62 -62 0
-62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0
0.4238709677419355 -62.0 0.0 -62
NULL -62 1969-12-31 16:00:12.591 -62.0 NULL 62 -62 0
-62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0
0.4238709677419355 -62.0 0.0 -62
NULL -62 1969-12-31 16:00:14.154 -62.0 NULL 62 -62 0
-62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0
0.4238709677419355 -62.0 0.0 -62
NULL -62 1969-12-31 16:00:14.247 -62.0 NULL 62 -62 0
-62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0
0.4238709677419355 -62.0 0.0 -62
NULL -62 1969-12-31 16:00:14.517 -62.0 NULL 62 -62 0
-62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0
0.4238709677419355 -62.0 0.0 -62
NULL -62 1969-12-31 16:00:14.965 -62.0 NULL 62 -62 0
-62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0
0.4238709677419355 -62.0 0.0 -62
-NULL -61 1969-12-31 16:00:11.842 -61.0 NULL 61 -61 0
-61.0 -0.0 61.0 -4852.733 0.0 61.0 0.0 -10.175 -61.0
0.4308196721311476 -61.0 0.0 -61
-NULL -61 1969-12-31 16:00:12.454 -61.0 NULL 61 -61 0
-61.0 -0.0 61.0 -4852.733 0.0 61.0 0.0 -10.175 -61.0
0.4308196721311476 -61.0 0.0 -61
-NULL -61 1969-12-31 16:00:14.192 -61.0 NULL 61 -61 0
-61.0 -0.0 61.0 -4852.733 0.0 61.0 0.0 -10.175 -61.0
0.4308196721311476 -61.0 0.0 -61
-NULL -61 1969-12-31 16:00:16.558 -61.0 NULL 61 -61 0
-61.0 -0.0 61.0 -4852.733 0.0 61.0 0.0 -10.175 -61.0
0.4308196721311476 -61.0 0.0 -61
-NULL -60 1969-12-31 16:00:11.504 -60.0 NULL 60 -60 0
-60.0 -0.0 60.0 -4773.18 0.0 60.0 0.0 -10.175 -60.0
0.438 -60.0 0.0 -60
-NULL -60 1969-12-31 16:00:11.641 -60.0 NULL 60 -60 0
-60.0 -0.0 60.0 -4773.18 0.0 60.0 0.0 -10.175 -60.0
0.438 -60.0 0.0 -60
-NULL -60 1969-12-31 16:00:11.996 -60.0 NULL 60 -60 0
-60.0 -0.0 60.0 -4773.18 0.0 60.0 0.0 -10.175 -60.0
0.438 -60.0 0.0 -60
-NULL -60 1969-12-31 16:00:12.779 -60.0 NULL 60 -60 0
-60.0 -0.0 60.0 -4773.18 0.0 60.0 0.0 -10.175 -60.0
0.438 -60.0 0.0 -60
-NULL -59 1969-12-31 16:00:12.008 -59.0 NULL 59 -59 0
-59.0 -0.0 59.0 -4693.6269999999995 0.0 59.0 0.0 -10.175
-59.0 0.44542372881355935 -59.0 0.0 -59
-NULL -59 1969-12-31 16:00:13.15 -59.0 NULL 59 -59 0
-59.0 -0.0 59.0 -4693.6269999999995 0.0 59.0 0.0 -10.175
-59.0 0.44542372881355935 -59.0 0.0 -59
-NULL -59 1969-12-31 16:00:13.625 -59.0 NULL 59 -59 0
-59.0 -0.0 59.0 -4693.6269999999995 0.0 59.0 0.0 -10.175
-59.0 0.44542372881355935 -59.0 0.0 -59
-NULL -59 1969-12-31 16:00:15.296 -59.0 NULL 59 -59 0
-59.0 -0.0 59.0 -4693.6269999999995 0.0 59.0 0.0 -10.175
-59.0 0.44542372881355935 -59.0 0.0 -59
-NULL -59 1969-12-31 16:00:15.861 -59.0 NULL 59 -59 0
-59.0 -0.0 59.0 -4693.6269999999995 0.0 59.0 0.0 -10.175
-59.0 0.44542372881355935 -59.0 0.0 -59
-NULL -58 1969-12-31 16:00:12.065 -58.0 NULL 58 -58 0
-58.0 -0.0 58.0 -4614.074 0.0 58.0 0.0 -10.175 -58.0
0.4531034482758621 -58.0 0.0 -58
-NULL -58 1969-12-31 16:00:12.683 -58.0 NULL 58 -58 0
-58.0 -0.0 58.0 -4614.074 0.0 58.0 0.0 -10.175 -58.0
0.4531034482758621 -58.0 0.0 -58
-NULL -58 1969-12-31 16:00:12.948 -58.0 NULL 58 -58 0
-58.0 -0.0 58.0 -4614.074 0.0 58.0 0.0 -10.175 -58.0
0.4531034482758621 -58.0 0.0 -58
-NULL -58 1969-12-31 16:00:14.066 -58.0 NULL 58 -58 0
-58.0 -0.0 58.0 -4614.074 0.0 58.0 0.0 -10.175 -58.0
0.4531034482758621 -58.0 0.0 -58
-NULL -58 1969-12-31 16:00:15.658 -58.0 NULL 58 -58 0
-58.0 -0.0 58.0 -4614.074 0.0 58.0 0.0 -10.175 -58.0
0.4531034482758621 -58.0 0.0 -58
-NULL -57 1969-12-31 16:00:11.451 -57.0 NULL 57 -57 0
-57.0 -0.0 57.0 -4534.521 0.0 57.0 0.0 -10.175 -57.0
0.4610526315789474 -57.0 0.0 -57
-NULL -57 1969-12-31 16:00:11.883 -57.0 NULL 57 -57 0
-57.0 -0.0 57.0 -4534.521 0.0 57.0 0.0 -10.175 -57.0
0.4610526315789474 -57.0 0.0 -57
-NULL -57 1969-12-31 16:00:12.626 -57.0 NULL 57 -57 0
-57.0 -0.0 57.0 -4534.521 0.0 57.0 0.0 -10.175 -57.0
0.4610526315789474 -57.0 0.0 -57
-NULL -57 1969-12-31 16:00:13.578 -57.0 NULL 57 -57 0
-57.0 -0.0 57.0 -4534.521 0.0 57.0 0.0 -10.175 -57.0
0.4610526315789474 -57.0 0.0 -57
-NULL -57 1969-12-31 16:00:15.39 -57.0 NULL 57 -57 0
-57.0 -0.0 57.0 -4534.521 0.0 57.0 0.0 -10.175 -57.0
0.4610526315789474 -57.0 0.0 -57
-NULL -56 1969-12-31 16:00:13.602 -56.0 NULL 56 -56 0
-56.0 -0.0 56.0 -4454.968 0.0 56.0 0.0 -10.175 -56.0
0.4692857142857143 -56.0 0.0 -56
-NULL -56 1969-12-31 16:00:13.958 -56.0 NULL 56 -56 0
-56.0 -0.0 56.0 -4454.968 0.0 56.0 0.0 -10.175 -56.0
0.4692857142857143 -56.0 0.0 -56
-NULL -56 1969-12-31 16:00:15.038 -56.0 NULL 56 -56 0
-56.0 -0.0 56.0 -4454.968 0.0 56.0 0.0 -10.175 -56.0
0.4692857142857143 -56.0 0.0 -56
-NULL -55 1969-12-31 16:00:11.38 -55.0 NULL 55 -55 0
-55.0 -0.0 55.0 -4375.415 0.0 55.0 0.0 -10.175 -55.0
0.47781818181818186 -55.0 0.0 -55
-NULL -55 1969-12-31 16:00:11.751 -55.0 NULL 55 -55 0
-55.0 -0.0 55.0 -4375.415 0.0 55.0 0.0 -10.175 -55.0
0.47781818181818186 -55.0 0.0 -55
+NULL -63 1969-12-31 16:00:11.946 -63.0 NULL 63 -63 0
-63.0 -0.0 63.0 -5011.839 0.0 63.0 0.0 -10.175 -63.0
0.41714285714285715 -63.0 0.0 -63
+NULL -63 1969-12-31 16:00:12.188 -63.0 NULL 63 -63 0
-63.0 -0.0 63.0 -5011.839 0.0 63.0 0.0 -10.175 -63.0
0.41714285714285715 -63.0 0.0 -63
+NULL -63 1969-12-31 16:00:15.436 -63.0 NULL 63 -63 0
-63.0 -0.0 63.0 -5011.839 0.0 63.0 0.0 -10.175 -63.0
0.41714285714285715 -63.0 0.0 -63
+NULL -64 1969-12-31 16:00:11.912 -64.0 NULL 64 -64 0
-64.0 -0.0 64.0 -5091.392 0.0 64.0 0.0 -10.175 -64.0
0.410625 -64.0 0.0 -64
+NULL -64 1969-12-31 16:00:12.339 -64.0 NULL 64 -64 0
-64.0 -0.0 64.0 -5091.392 0.0 64.0 0.0 -10.175 -64.0
0.410625 -64.0 0.0 -64
+NULL -64 1969-12-31 16:00:13.274 -64.0 NULL 64 -64 0
-64.0 -0.0 64.0 -5091.392 0.0 64.0 0.0 -10.175 -64.0
0.410625 -64.0 0.0 -64
PREHOOK: query: -- double compare timestamp
EXPLAIN
SELECT cboolean1,
@@ -260,22 +263,22 @@ SELECT cboolean1,
ctimestamp1,
cfloat,
cstring1,
- (-(ctinyint)),
- MAX(ctinyint),
- ((-(ctinyint)) + MAX(ctinyint)),
- SUM(cfloat),
- (SUM(cfloat) * ((-(ctinyint)) + MAX(ctinyint))),
- (-(SUM(cfloat))),
- (79.553 * cfloat),
- STDDEV_POP(cfloat),
- (-(SUM(cfloat))),
- STDDEV_POP(ctinyint),
- (((-(ctinyint)) + MAX(ctinyint)) - 10.175),
- (-((-(SUM(cfloat))))),
- (-26.28 / (-((-(SUM(cfloat)))))),
- MAX(cfloat),
- ((SUM(cfloat) * ((-(ctinyint)) + MAX(ctinyint))) / ctinyint),
- MIN(ctinyint)
+ (-(ctinyint)) as c1,
+ MAX(ctinyint) as c2,
+ ((-(ctinyint)) + MAX(ctinyint)) as c3,
+ SUM(cfloat) as c4,
+ (SUM(cfloat) * ((-(ctinyint)) + MAX(ctinyint))) as c5,
+ (-(SUM(cfloat))) as c6,
+ (79.553 * cfloat) as c7,
+ STDDEV_POP(cfloat) as c8,
+ (-(SUM(cfloat))) as c9,
+ STDDEV_POP(ctinyint) as c10,
+ (((-(ctinyint)) + MAX(ctinyint)) - 10.175) as c11,
+ (-((-(SUM(cfloat))))) as c12,
+ (-26.28 / (-((-(SUM(cfloat)))))) as c13,
+ MAX(cfloat) as c14,
+ ((SUM(cfloat) * ((-(ctinyint)) + MAX(ctinyint))) / ctinyint) as c15,
+ MIN(ctinyint) as c16
FROM alltypesorc
WHERE (((cfloat < 3569)
AND ((10.175 >= cdouble)
@@ -284,7 +287,7 @@ WHERE (((cfloat < 3569)
AND ((ctimestamp2 != -1.3359999999999999)
AND (ctinyint < 9763215.5639))))
GROUP BY cboolean1, ctinyint, ctimestamp1, cfloat, cstring1
-ORDER BY cboolean1, ctinyint, ctimestamp1, cfloat, cstring1
+ORDER BY cboolean1, ctinyint, ctimestamp1, cfloat, cstring1, c1, c2, c3, c4,
c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16
LIMIT 40
PREHOOK: type: QUERY
POSTHOOK: query: -- double compare timestamp
@@ -294,22 +297,22 @@ SELECT cboolean1,
ctimestamp1,
cfloat,
cstring1,
- (-(ctinyint)),
- MAX(ctinyint),
- ((-(ctinyint)) + MAX(ctinyint)),
- SUM(cfloat),
- (SUM(cfloat) * ((-(ctinyint)) + MAX(ctinyint))),
- (-(SUM(cfloat))),
- (79.553 * cfloat),
- STDDEV_POP(cfloat),
- (-(SUM(cfloat))),
- STDDEV_POP(ctinyint),
- (((-(ctinyint)) + MAX(ctinyint)) - 10.175),
- (-((-(SUM(cfloat))))),
- (-26.28 / (-((-(SUM(cfloat)))))),
- MAX(cfloat),
- ((SUM(cfloat) * ((-(ctinyint)) + MAX(ctinyint))) / ctinyint),
- MIN(ctinyint)
+ (-(ctinyint)) as c1,
+ MAX(ctinyint) as c2,
+ ((-(ctinyint)) + MAX(ctinyint)) as c3,
+ SUM(cfloat) as c4,
+ (SUM(cfloat) * ((-(ctinyint)) + MAX(ctinyint))) as c5,
+ (-(SUM(cfloat))) as c6,
+ (79.553 * cfloat) as c7,
+ STDDEV_POP(cfloat) as c8,
+ (-(SUM(cfloat))) as c9,
+ STDDEV_POP(ctinyint) as c10,
+ (((-(ctinyint)) + MAX(ctinyint)) - 10.175) as c11,
+ (-((-(SUM(cfloat))))) as c12,
+ (-26.28 / (-((-(SUM(cfloat)))))) as c13,
+ MAX(cfloat) as c14,
+ ((SUM(cfloat) * ((-(ctinyint)) + MAX(ctinyint))) / ctinyint) as c15,
+ MIN(ctinyint) as c16
FROM alltypesorc
WHERE (((cfloat < 3569)
AND ((10.175 >= cdouble)
@@ -318,7 +321,7 @@ WHERE (((cfloat < 3569)
AND ((ctimestamp2 != -1.3359999999999999)
AND (ctinyint < 9763215.5639))))
GROUP BY cboolean1, ctinyint, ctimestamp1, cfloat, cstring1
-ORDER BY cboolean1, ctinyint, ctimestamp1, cfloat, cstring1
+ORDER BY cboolean1, ctinyint, ctimestamp1, cfloat, cstring1, c1, c2, c3, c4,
c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16
LIMIT 40
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
@@ -361,8 +364,8 @@ STAGE PLANS:
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6,
_col7, _col8, _col9, _col10
Statistics: Num rows: 1365 Data size: 293479 Basic stats: COMPLETE
Column stats: NONE
Select Operator
- expressions: _col0 (type: boolean), _col1 (type: tinyint), (-
_col6) (type: double), (79.553 * UDFToDouble(_col3)) (type: double), _col7
(type: double), _col8 (type: double), (UDFToDouble(((- _col1) + _col5)) -
10.175) (type: double), (- (- _col6)) (type: double), (-26.28 / (- (- _col6)))
(type: double), _col9 (type: float), ((_col6 * UDFToDouble(((- _col1) +
_col5))) / UDFToDouble(_col1)) (type: double), _col2 (type: timestamp), _col10
(type: tinyint), _col3 (type: float), _col4 (type: string), (- _col1) (type:
tinyint), _col5 (type: tinyint), ((- _col1) + _col5) (type: tinyint), _col6
(type: double), (_col6 * UDFToDouble(((- _col1) + _col5))) (type: double)
- outputColumnNames: _col0, _col1, _col10, _col11, _col12, _col14,
_col15, _col16, _col17, _col18, _col19, _col2, _col20, _col3, _col4, _col5,
_col6, _col7, _col8, _col9
+ expressions: _col0 (type: boolean), _col1 (type: tinyint), _col2
(type: timestamp), _col3 (type: float), _col4 (type: string), (- _col1) (type:
tinyint), _col5 (type: tinyint), ((- _col1) + _col5) (type: tinyint), _col6
(type: double), (_col6 * UDFToDouble(((- _col1) + _col5))) (type: double), (-
_col6) (type: double), (79.553 * UDFToDouble(_col3)) (type: double), _col7
(type: double), (- _col6) (type: double), _col8 (type: double),
(UDFToDouble(((- _col1) + _col5)) - 10.175) (type: double), (- (- _col6))
(type: double), (-26.28 / (- (- _col6))) (type: double), _col9 (type: float),
((_col6 * UDFToDouble(((- _col1) + _col5))) / UDFToDouble(_col1)) (type:
double), _col10 (type: tinyint)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5,
_col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15,
_col16, _col17, _col18, _col19, _col20
Statistics: Num rows: 1365 Data size: 293479 Basic stats: COMPLETE
Column stats: NONE
File Output Operator
compressed: false
@@ -376,13 +379,12 @@ STAGE PLANS:
Map Operator Tree:
TableScan
Reduce Output Operator
- key expressions: _col0 (type: boolean), _col1 (type: tinyint),
_col2 (type: timestamp), _col3 (type: float), _col4 (type: string)
- sort order: +++++
+ key expressions: _col0 (type: boolean), _col1 (type: tinyint),
_col2 (type: timestamp), _col3 (type: float), _col4 (type: string), _col5
(type: tinyint), _col6 (type: tinyint), _col7 (type: tinyint), _col8 (type:
double), _col9 (type: double), _col10 (type: double), _col11 (type: double),
_col12 (type: double), _col13 (type: double), _col14 (type: double), _col15
(type: double), _col16 (type: double), _col17 (type: double), _col18 (type:
float), _col19 (type: double), _col20 (type: tinyint)
+ sort order: +++++++++++++++++++++
Statistics: Num rows: 1365 Data size: 293479 Basic stats:
COMPLETE Column stats: NONE
- value expressions: _col5 (type: tinyint), _col6 (type: tinyint),
_col7 (type: tinyint), _col8 (type: double), _col9 (type: double), _col10
(type: double), _col11 (type: double), _col12 (type: double), _col14 (type:
double), _col15 (type: double), _col16 (type: double), _col17 (type: double),
_col18 (type: float), _col19 (type: double), _col20 (type: tinyint)
Reduce Operator Tree:
Select Operator
- expressions: KEY.reducesinkkey0 (type: boolean), KEY.reducesinkkey1
(type: tinyint), KEY.reducesinkkey2 (type: timestamp), KEY.reducesinkkey3
(type: float), KEY.reducesinkkey4 (type: string), VALUE._col0 (type: tinyint),
VALUE._col1 (type: tinyint), VALUE._col2 (type: tinyint), VALUE._col3 (type:
double), VALUE._col4 (type: double), VALUE._col5 (type: double), VALUE._col6
(type: double), VALUE._col7 (type: double), VALUE._col5 (type: double),
VALUE._col8 (type: double), VALUE._col9 (type: double), VALUE._col10 (type:
double), VALUE._col11 (type: double), VALUE._col12 (type: float), VALUE._col13
(type: double), VALUE._col14 (type: tinyint)
+ expressions: KEY.reducesinkkey0 (type: boolean), KEY.reducesinkkey1
(type: tinyint), KEY.reducesinkkey2 (type: timestamp), KEY.reducesinkkey3
(type: float), KEY.reducesinkkey4 (type: string), KEY.reducesinkkey5 (type:
tinyint), KEY.reducesinkkey6 (type: tinyint), KEY.reducesinkkey7 (type:
tinyint), KEY.reducesinkkey8 (type: double), KEY.reducesinkkey9 (type: double),
KEY.reducesinkkey10 (type: double), KEY.reducesinkkey11 (type: double),
KEY.reducesinkkey12 (type: double), KEY.reducesinkkey10 (type: double),
KEY.reducesinkkey14 (type: double), KEY.reducesinkkey15 (type: double),
KEY.reducesinkkey16 (type: double), KEY.reducesinkkey17 (type: double),
KEY.reducesinkkey18 (type: float), KEY.reducesinkkey19 (type: double),
KEY.reducesinkkey20 (type: tinyint)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6,
_col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16,
_col17, _col18, _col19, _col20
Statistics: Num rows: 1365 Data size: 293479 Basic stats: COMPLETE
Column stats: NONE
Limit
@@ -407,22 +409,22 @@ PREHOOK: query: SELECT cboolean1,
ctimestamp1,
cfloat,
cstring1,
- (-(ctinyint)),
- MAX(ctinyint),
- ((-(ctinyint)) + MAX(ctinyint)),
- SUM(cfloat),
- (SUM(cfloat) * ((-(ctinyint)) + MAX(ctinyint))),
- (-(SUM(cfloat))),
- (79.553 * cfloat),
- STDDEV_POP(cfloat),
- (-(SUM(cfloat))),
- STDDEV_POP(ctinyint),
- (((-(ctinyint)) + MAX(ctinyint)) - 10.175),
- (-((-(SUM(cfloat))))),
- (-26.28 / (-((-(SUM(cfloat)))))),
- MAX(cfloat),
- ((SUM(cfloat) * ((-(ctinyint)) + MAX(ctinyint))) / ctinyint),
- MIN(ctinyint)
+ (-(ctinyint)) as c1,
+ MAX(ctinyint) as c2,
+ ((-(ctinyint)) + MAX(ctinyint)) as c3,
+ SUM(cfloat) as c4,
+ (SUM(cfloat) * ((-(ctinyint)) + MAX(ctinyint))) as c5,
+ (-(SUM(cfloat))) as c6,
+ (79.553 * cfloat) as c7,
+ STDDEV_POP(cfloat) as c8,
+ (-(SUM(cfloat))) as c9,
+ STDDEV_POP(ctinyint) as c10,
+ (((-(ctinyint)) + MAX(ctinyint)) - 10.175) as c11,
+ (-((-(SUM(cfloat))))) as c12,
+ (-26.28 / (-((-(SUM(cfloat)))))) as c13,
+ MAX(cfloat) as c14,
+ ((SUM(cfloat) * ((-(ctinyint)) + MAX(ctinyint))) / ctinyint) as c15,
+ MIN(ctinyint) as c16
FROM alltypesorc
WHERE (((cfloat < 3569)
AND ((10.175 >= cdouble)
@@ -431,7 +433,7 @@ WHERE (((cfloat < 3569)
AND ((ctimestamp2 != -1.3359999999999999)
AND (ctinyint < 9763215.5639))))
GROUP BY cboolean1, ctinyint, ctimestamp1, cfloat, cstring1
-ORDER BY cboolean1, ctinyint, ctimestamp1, cfloat, cstring1
+ORDER BY cboolean1, ctinyint, ctimestamp1, cfloat, cstring1, c1, c2, c3, c4,
c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16
LIMIT 40
PREHOOK: type: QUERY
PREHOOK: Input: default@alltypesorc
@@ -441,22 +443,22 @@ POSTHOOK: query: SELECT cboolean1,
ctimestamp1,
cfloat,
cstring1,
- (-(ctinyint)),
- MAX(ctinyint),
- ((-(ctinyint)) + MAX(ctinyint)),
- SUM(cfloat),
- (SUM(cfloat) * ((-(ctinyint)) + MAX(ctinyint))),
- (-(SUM(cfloat))),
- (79.553 * cfloat),
- STDDEV_POP(cfloat),
- (-(SUM(cfloat))),
- STDDEV_POP(ctinyint),
- (((-(ctinyint)) + MAX(ctinyint)) - 10.175),
- (-((-(SUM(cfloat))))),
- (-26.28 / (-((-(SUM(cfloat)))))),
- MAX(cfloat),
- ((SUM(cfloat) * ((-(ctinyint)) + MAX(ctinyint))) / ctinyint),
- MIN(ctinyint)
+ (-(ctinyint)) as c1,
+ MAX(ctinyint) as c2,
+ ((-(ctinyint)) + MAX(ctinyint)) as c3,
+ SUM(cfloat) as c4,
+ (SUM(cfloat) * ((-(ctinyint)) + MAX(ctinyint))) as c5,
+ (-(SUM(cfloat))) as c6,
+ (79.553 * cfloat) as c7,
+ STDDEV_POP(cfloat) as c8,
+ (-(SUM(cfloat))) as c9,
+ STDDEV_POP(ctinyint) as c10,
+ (((-(ctinyint)) + MAX(ctinyint)) - 10.175) as c11,
+ (-((-(SUM(cfloat))))) as c12,
+ (-26.28 / (-((-(SUM(cfloat)))))) as c13,
+ MAX(cfloat) as c14,
+ ((SUM(cfloat) * ((-(ctinyint)) + MAX(ctinyint))) / ctinyint) as c15,
+ MIN(ctinyint) as c16
FROM alltypesorc
WHERE (((cfloat < 3569)
AND ((10.175 >= cdouble)
@@ -465,28 +467,16 @@ WHERE (((cfloat < 3569)
AND ((ctimestamp2 != -1.3359999999999999)
AND (ctinyint < 9763215.5639))))
GROUP BY cboolean1, ctinyint, ctimestamp1, cfloat, cstring1
-ORDER BY cboolean1, ctinyint, ctimestamp1, cfloat, cstring1
+ORDER BY cboolean1, ctinyint, ctimestamp1, cfloat, cstring1, c1, c2, c3, c4,
c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16
LIMIT 40
POSTHOOK: type: QUERY
POSTHOOK: Input: default@alltypesorc
#### A masked pattern was here ####
-NULL -64 1969-12-31 16:00:00.199 -64.0 NULL 64 -64 0
-64.0 -0.0 64.0 -5091.392 0.0 64.0 0.0 -10.175 -64.0
0.410625 -64.0 0.0 -64
-NULL -64 1969-12-31 16:00:00.29 -64.0 NULL 64 -64 0
-64.0 -0.0 64.0 -5091.392 0.0 64.0 0.0 -10.175 -64.0
0.410625 -64.0 0.0 -64
-NULL -64 1969-12-31 16:00:01.785 -64.0 NULL 64 -64 0
-64.0 -0.0 64.0 -5091.392 0.0 64.0 0.0 -10.175 -64.0
0.410625 -64.0 0.0 -64
-NULL -64 1969-12-31 16:00:03.944 -64.0 NULL 64 -64 0
-64.0 -0.0 64.0 -5091.392 0.0 64.0 0.0 -10.175 -64.0
0.410625 -64.0 0.0 -64
-NULL -64 1969-12-31 16:00:05.997 -64.0 NULL 64 -64 0
-64.0 -0.0 64.0 -5091.392 0.0 64.0 0.0 -10.175 -64.0
0.410625 -64.0 0.0 -64
-NULL -64 1969-12-31 16:00:10.858 -64.0 NULL 64 -64 0
-64.0 -0.0 64.0 -5091.392 0.0 64.0 0.0 -10.175 -64.0
0.410625 -64.0 0.0 -64
-NULL -64 1969-12-31 16:00:11.912 -64.0 NULL 64 -64 0
-64.0 -0.0 64.0 -5091.392 0.0 64.0 0.0 -10.175 -64.0
0.410625 -64.0 0.0 -64
-NULL -64 1969-12-31 16:00:12.339 -64.0 NULL 64 -64 0
-64.0 -0.0 64.0 -5091.392 0.0 64.0 0.0 -10.175 -64.0
0.410625 -64.0 0.0 -64
-NULL -64 1969-12-31 16:00:13.274 -64.0 NULL 64 -64 0
-64.0 -0.0 64.0 -5091.392 0.0 64.0 0.0 -10.175 -64.0
0.410625 -64.0 0.0 -64
-NULL -63 1969-12-31 16:00:01.843 -63.0 NULL 63 -63 0
-63.0 -0.0 63.0 -5011.839 0.0 63.0 0.0 -10.175 -63.0
0.41714285714285715 -63.0 0.0 -63
-NULL -63 1969-12-31 16:00:03.552 -63.0 NULL 63 -63 0
-63.0 -0.0 63.0 -5011.839 0.0 63.0 0.0 -10.175 -63.0
0.41714285714285715 -63.0 0.0 -63
-NULL -63 1969-12-31 16:00:06.852 -63.0 NULL 63 -63 0
-63.0 -0.0 63.0 -5011.839 0.0 63.0 0.0 -10.175 -63.0
0.41714285714285715 -63.0 0.0 -63
-NULL -63 1969-12-31 16:00:07.375 -63.0 NULL 63 -63 0
-63.0 -0.0 63.0 -5011.839 0.0 63.0 0.0 -10.175 -63.0
0.41714285714285715 -63.0 0.0 -63
-NULL -63 1969-12-31 16:00:10.205 -63.0 NULL 63 -63 0
-63.0 -0.0 63.0 -5011.839 0.0 63.0 0.0 -10.175 -63.0
0.41714285714285715 -63.0 0.0 -63
-NULL -63 1969-12-31 16:00:11.946 -63.0 NULL 63 -63 0
-63.0 -0.0 63.0 -5011.839 0.0 63.0 0.0 -10.175 -63.0
0.41714285714285715 -63.0 0.0 -63
-NULL -63 1969-12-31 16:00:12.188 -63.0 NULL 63 -63 0
-63.0 -0.0 63.0 -5011.839 0.0 63.0 0.0 -10.175 -63.0
0.41714285714285715 -63.0 0.0 -63
-NULL -63 1969-12-31 16:00:15.436 -63.0 NULL 63 -63 0
-63.0 -0.0 63.0 -5011.839 0.0 63.0 0.0 -10.175 -63.0
0.41714285714285715 -63.0 0.0 -63
+NULL -61 1969-12-31 16:00:00.142 -61.0 NULL 61 -61 0
-61.0 -0.0 61.0 -4852.733 0.0 61.0 0.0 -10.175 -61.0
0.4308196721311476 -61.0 0.0 -61
+NULL -61 1969-12-31 16:00:02.698 -61.0 NULL 61 -61 0
-61.0 -0.0 61.0 -4852.733 0.0 61.0 0.0 -10.175 -61.0
0.4308196721311476 -61.0 0.0 -61
+NULL -61 1969-12-31 16:00:03.049 -61.0 NULL 61 -61 0
-61.0 -0.0 61.0 -4852.733 0.0 61.0 0.0 -10.175 -61.0
0.4308196721311476 -61.0 0.0 -61
+NULL -61 1969-12-31 16:00:04.165 -61.0 NULL 61 -61 0
-61.0 -0.0 61.0 -4852.733 0.0 61.0 0.0 -10.175 -61.0
0.4308196721311476 -61.0 0.0 -61
+NULL -61 1969-12-31 16:00:04.977 -61.0 NULL 61 -61 0
-61.0 -0.0 61.0 -4852.733 0.0 61.0 0.0 -10.175 -61.0
0.4308196721311476 -61.0 0.0 -61
NULL -62 1969-12-31 16:00:00.037 -62.0 NULL 62 -62 0
-62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0
0.4238709677419355 -62.0 0.0 -62
NULL -62 1969-12-31 16:00:01.22 -62.0 NULL 62 -62 0
-62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0
0.4238709677419355 -62.0 0.0 -62
NULL -62 1969-12-31 16:00:01.515 -62.0 NULL 62 -62 0
-62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0
0.4238709677419355 -62.0 0.0 -62
@@ -505,8 +495,20 @@ NULL -62 1969-12-31 16:00:14.154 -62.0 NULL
62 -62 0 -62.0 -0.0 62.0 -4932.286 0
NULL -62 1969-12-31 16:00:14.247 -62.0 NULL 62 -62 0
-62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0
0.4238709677419355 -62.0 0.0 -62
NULL -62 1969-12-31 16:00:14.517 -62.0 NULL 62 -62 0
-62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0
0.4238709677419355 -62.0 0.0 -62
NULL -62 1969-12-31 16:00:14.965 -62.0 NULL 62 -62 0
-62.0 -0.0 62.0 -4932.286 0.0 62.0 0.0 -10.175 -62.0
0.4238709677419355 -62.0 0.0 -62
-NULL -61 1969-12-31 16:00:00.142 -61.0 NULL 61 -61 0
-61.0 -0.0 61.0 -4852.733 0.0 61.0 0.0 -10.175 -61.0
0.4308196721311476 -61.0 0.0 -61
-NULL -61 1969-12-31 16:00:02.698 -61.0 NULL 61 -61 0
-61.0 -0.0 61.0 -4852.733 0.0 61.0 0.0 -10.175 -61.0
0.4308196721311476 -61.0 0.0 -61
-NULL -61 1969-12-31 16:00:03.049 -61.0 NULL 61 -61 0
-61.0 -0.0 61.0 -4852.733 0.0 61.0 0.0 -10.175 -61.0
0.4308196721311476 -61.0 0.0 -61
-NULL -61 1969-12-31 16:00:04.165 -61.0 NULL 61 -61 0
-61.0 -0.0 61.0 -4852.733 0.0 61.0 0.0 -10.175 -61.0
0.4308196721311476 -61.0 0.0 -61
-NULL -61 1969-12-31 16:00:04.977 -61.0 NULL 61 -61 0
-61.0 -0.0 61.0 -4852.733 0.0 61.0 0.0 -10.175 -61.0
0.4308196721311476 -61.0 0.0 -61
+NULL -63 1969-12-31 16:00:01.843 -63.0 NULL 63 -63 0
-63.0 -0.0 63.0 -5011.839 0.0 63.0 0.0 -10.175 -63.0
0.41714285714285715 -63.0 0.0 -63
+NULL -63 1969-12-31 16:00:03.552 -63.0 NULL 63 -63 0
-63.0 -0.0 63.0 -5011.839 0.0 63.0 0.0 -10.175 -63.0
0.41714285714285715 -63.0 0.0 -63
+NULL -63 1969-12-31 16:00:06.852 -63.0 NULL 63 -63 0
-63.0 -0.0 63.0 -5011.839 0.0 63.0 0.0 -10.175 -63.0
0.41714285714285715 -63.0 0.0 -63
+NULL -63 1969-12-31 16:00:07.375 -63.0 NULL 63 -63 0
-63.0 -0.0 63.0 -5011.839 0.0 63.0 0.0 -10.175 -63.0
0.41714285714285715 -63.0 0.0 -63
+NULL -63 1969-12-31 16:00:10.205 -63.0 NULL 63 -63 0
-63.0 -0.0 63.0 -5011.839 0.0 63.0 0.0 -10.175 -63.0
0.41714285714285715 -63.0 0.0 -63
+NULL -63 1969-12-31 16:00:11.946 -63.0 NULL 63 -63 0
-63.0 -0.0 63.0 -5011.839 0.0 63.0 0.0 -10.175 -63.0
0.41714285714285715 -63.0 0.0 -63
+NULL -63 1969-12-31 16:00:12.188 -63.0 NULL 63 -63 0
-63.0 -0.0 63.0 -5011.839 0.0 63.0 0.0 -10.175 -63.0
0.41714285714285715 -63.0 0.0 -63
+NULL -63 1969-12-31 16:00:15.436 -63.0 NULL 63 -63 0
-63.0 -0.0 63.0 -5011.839 0.0 63.0 0.0 -10.175 -63.0
0.41714285714285715 -63.0 0.0 -63
+NULL -64 1969-12-31 16:00:00.199 -64.0 NULL 64 -64 0
-64.0 -0.0 64.0 -5091.392 0.0 64.0 0.0 -10.175 -64.0
0.410625 -64.0 0.0 -64
+NULL -64 1969-12-31 16:00:00.29 -64.0 NULL 64 -64 0
-64.0 -0.0 64.0 -5091.392 0.0 64.0 0.0 -10.175 -64.0
0.410625 -64.0 0.0 -64
+NULL -64 1969-12-31 16:00:01.785 -64.0 NULL 64 -64 0
-64.0 -0.0 64.0 -5091.392 0.0 64.0 0.0 -10.175 -64.0
0.410625 -64.0 0.0 -64
+NULL -64 1969-12-31 16:00:03.944 -64.0 NULL 64 -64 0
-64.0 -0.0 64.0 -5091.392 0.0 64.0 0.0 -10.175 -64.0
0.410625 -64.0 0.0 -64
+NULL -64 1969-12-31 16:00:05.997 -64.0 NULL 64 -64 0
-64.0 -0.0 64.0 -5091.392 0.0 64.0 0.0 -10.175 -64.0
0.410625 -64.0 0.0 -64
+NULL -64 1969-12-31 16:00:10.858 -64.0 NULL 64 -64 0
-64.0 -0.0 64.0 -5091.392 0.0 64.0 0.0 -10.175 -64.0
0.410625 -64.0 0.0 -64
+NULL -64 1969-12-31 16:00:11.912 -64.0 NULL 64 -64 0
-64.0 -0.0 64.0 -5091.392 0.0 64.0 0.0 -10.175 -64.0
0.410625 -64.0 0.0 -64
+NULL -64 1969-12-31 16:00:12.339 -64.0 NULL 64 -64 0
-64.0 -0.0 64.0 -5091.392 0.0 64.0 0.0 -10.175 -64.0
0.410625 -64.0 0.0 -64
+NULL -64 1969-12-31 16:00:13.274 -64.0 NULL 64 -64 0
-64.0 -0.0 64.0 -5091.392 0.0 64.0 0.0 -10.175 -64.0
0.410625 -64.0 0.0 -64
