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

-- Until HIVE-16756: 'Vectorization: LongColModuloLongColumn throws "java.lang.ArithmeticException: / by zero"' is resolved, do not vectorize Reducers
set hive.vectorized.execution.reduce.enabled=false;

-- SORT_QUERY_RESULTS

EXPLAIN VECTORIZATION DETAIL
SELECT   cfloat,
         cboolean1,
         cdouble,
         cstring1,
         ctinyint,
         cint,
         ctimestamp1,
         STDDEV_SAMP(cfloat),
         (-26.28 - cint),
         MIN(cdouble),
         (cdouble * 79.553),
         (33 % cfloat),
         STDDEV_SAMP(ctinyint),
         VAR_POP(ctinyint),
         (-23 % cdouble),
         (-(ctinyint)),
         VAR_SAMP(cint),
         (cint - cfloat),
         (-23 % ctinyint),
         (-((-26.28 - cint))),
         STDDEV_POP(cint)
FROM     alltypesorc
WHERE    (((cstring2 LIKE '%ss%')
           OR (cstring1 LIKE '10%'))
          OR ((cint >= -75)
              AND ((ctinyint = csmallint)
                   AND (cdouble >= -3728))))
GROUP BY cfloat, cboolean1, cdouble, cstring1, ctinyint, cint, ctimestamp1
ORDER BY cfloat, cboolean1, cdouble, cstring1, ctinyint, cint, ctimestamp1;

SELECT   cfloat,
         cboolean1,
         cdouble,
         cstring1,
         ctinyint,
         cint,
         ctimestamp1,
         STDDEV_SAMP(cfloat),
         (-26.28 - cint),
         MIN(cdouble),
         (cdouble * 79.553),
         (33 % cfloat),
         STDDEV_SAMP(ctinyint),
         VAR_POP(ctinyint),
         (-23 % cdouble),
         (-(ctinyint)),
         VAR_SAMP(cint),
         (cint - cfloat),
         (-23 % ctinyint),
         (-((-26.28 - cint))),
         STDDEV_POP(cint)
FROM     alltypesorc
WHERE    (((cstring2 LIKE '%ss%')
           OR (cstring1 LIKE '10%'))
          OR ((cint >= -75)
              AND ((ctinyint = csmallint)
                   AND (cdouble >= -3728))))
GROUP BY cfloat, cboolean1, cdouble, cstring1, ctinyint, cint, ctimestamp1
ORDER BY cfloat, cboolean1, cdouble, cstring1, ctinyint, cint, ctimestamp1;