[
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)
