[jira] [Resolved] (HIVE-5918) int / int division does not vectorize due to type checks

["Sergey Shelukhin (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-5918?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Sergey Shelukhin resolved HIVE-5918.
------------------------------------

    Resolution: Duplicate

This is by design right now. Exact type division has to produce exact type according to SQL standard. Double as it previously did would break that... making it int is probably not what users expect (given that it was previously double). Optionally we could do a hack that converts to-from double, but that is ugly and would change query results from vectorization when conversion is lossy.

For proper fix, decimal support would need to be added. That is tracked in HIVE-5937

> int / int division does not vectorize due to type checks
> --------------------------------------------------------
>
>                 Key: HIVE-5918
>                 URL: https://issues.apache.org/jira/browse/HIVE-5918
>             Project: Hive
>          Issue Type: Bug
>          Components: Vectorization
>            Reporter: Sergey Shelukhin
>            Assignee: Sergey Shelukhin
>
> When I try to vectorize e.g. select cbigint / 0 from alltypesorc, (with some logging added), I get my logging
> physical.Vectorizer (Vectorizer.java:validateExprNodeDescRecursive(642)) - failed to validate type: decimal(25,6); (cbigint / 0)



--
This message was sent by Atlassian JIRA
(v6.1#6144)