You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Matt McCline (JIRA)" <ji...@apache.org> on 2017/06/20 06:56:01 UTC

[jira] [Created] (HIVE-16919) Vectorization: vectorization_short_regress.q has query result differences with non-vectorized run.

Matt McCline created HIVE-16919:
-----------------------------------

             Summary: Vectorization: vectorization_short_regress.q has query result differences with non-vectorized run.
                 Key: HIVE-16919
                 URL: https://issues.apache.org/jira/browse/HIVE-16919
             Project: Hive
          Issue Type: Bug
          Components: Hive
            Reporter: Matt McCline
            Assignee: Matt McCline
            Priority: Critical


Query result for vectorization_short_regress.q.out -- that is when vectorization is turned off and a base .q.out file created.

-----------------------------------------------

10th field of the query below: Non-Vectorized -6432.000015344526 vs. Vectorized -6432.0

Column expression is (-(cdouble)) as c4,

{noformat}
SELECT   ctimestamp1,
         cstring2,
         cdouble,
         cfloat,
         cbigint,
         csmallint,
         (cbigint / 3569) as c1,
         (-257 - csmallint) as c2,
         (-6432 * cfloat) as c3,
         (-(cdouble)) as c4,
         (cdouble * 10.175) as c5,
         ((-6432 * cfloat) / cfloat) as c6,
         (-(cfloat)) as c7,
         (cint % csmallint) as c8,
         (-(cdouble)) as c9,
         (cdouble * (-(cdouble))) as c10
FROM     alltypesorc
WHERE    (((-1.389 >= cint)
           AND ((csmallint < ctinyint)
                AND (-6432 > csmallint)))
          OR ((cdouble >= cfloat)
              AND (cstring2 <= 'a'))
             OR ((cstring1 LIKE 'ss%')
                 AND (10.175 > cbigint)))
{noformat}



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)