ql/src/test/queries/clientpositive/parquet_vectorization_14.q

--! qt:dataset:alltypesparquet
set hive.mapred.mode=nonstrict;
set hive.explain.user=false;
SET hive.vectorized.execution.enabled=true;
set hive.fetch.task.conversion=none;

-- SORT_QUERY_RESULTS

EXPLAIN VECTORIZATION EXPRESSION
SELECT   ctimestamp1,
         cfloat,
         cstring1,
         cboolean1,
         cdouble,
         (-26.28 + cdouble),
         (-((-26.28 + cdouble))),
         STDDEV_SAMP((-((-26.28 + cdouble)))),
         (cfloat * -26.28),
         MAX(cfloat),
         (-(cfloat)),
         (-(MAX(cfloat))),
         ((-((-26.28 + cdouble))) / 10.175),
         STDDEV_POP(cfloat),
         COUNT(cfloat),
         (-(((-((-26.28 + cdouble))) / 10.175))),
         (-1.389 % STDDEV_SAMP((-((-26.28 + cdouble))))),
         (cfloat - cdouble),
         VAR_POP(cfloat),
         (VAR_POP(cfloat) % 10.175),
         VAR_SAMP(cfloat),
         (-((cfloat - cdouble)))
FROM     alltypesparquet
WHERE    (((ctinyint <= cbigint)
           AND ((cint <= cdouble)
                OR (ctimestamp2 < ctimestamp1)))
          AND ((cdouble < ctinyint)
              AND ((cbigint > -257)
                  OR (cfloat < cint))))
GROUP BY ctimestamp1, cfloat, cstring1, cboolean1, cdouble
ORDER BY cstring1, cfloat, cdouble, ctimestamp1;

SELECT   ctimestamp1,
         cfloat,
         cstring1,
         cboolean1,
         cdouble,
         (-26.28 + cdouble),
         (-((-26.28 + cdouble))),
         STDDEV_SAMP((-((-26.28 + cdouble)))),
         (cfloat * -26.28),
         MAX(cfloat),
         (-(cfloat)),
         (-(MAX(cfloat))),
         ((-((-26.28 + cdouble))) / 10.175),
         STDDEV_POP(cfloat),
         COUNT(cfloat),
         (-(((-((-26.28 + cdouble))) / 10.175))),
         (-1.389 % STDDEV_SAMP((-((-26.28 + cdouble))))),
         (cfloat - cdouble),
         VAR_POP(cfloat),
         (VAR_POP(cfloat) % 10.175),
         VAR_SAMP(cfloat),
         (-((cfloat - cdouble)))
FROM     alltypesparquet
WHERE    (((ctinyint <= cbigint)
           AND ((cint <= cdouble)
                OR (ctimestamp2 < ctimestamp1)))
          AND ((cdouble < ctinyint)
              AND ((cbigint > -257)
                  OR (cfloat < cint))))
GROUP BY ctimestamp1, cfloat, cstring1, cboolean1, cdouble
ORDER BY cstring1, cfloat, cdouble, ctimestamp1;