[
https://issues.apache.org/jira/browse/IMPALA-7613?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Work on IMPALA-7613 started by Abhishek Rawat.
----------------------------------------------
> Support round(DECIMAL) with non-constant second argument
> --------------------------------------------------------
>
> Key: IMPALA-7613
> URL: https://issues.apache.org/jira/browse/IMPALA-7613
> Project: IMPALA
> Issue Type: Bug
> Components: Frontend
> Affects Versions: Impala 3.0, Impala 2.12.0
> Reporter: Tim Armstrong
> Assignee: Abhishek Rawat
> Priority: Major
> Labels: decimal, ramp-up
>
> Sometimes users want to round to a precision that is data-driven (e.g. using
> a lookup table). They can't currently do this with decimal. I think we could
> support this by just using the input decimal type as the output type when the
> second argument is non-constant.
> {noformat}
> select round(l_tax, l_linenumber) from tpch.lineitem limit 5;
> Query: select round(l_tax, l_linenumber) from tpch.lineitem limit 5
> Query submitted at: 2018-09-24 11:03:10 (Coordinator:
> http://tarmstrong-box:25000)
> ERROR: AnalysisException: round() must be called with a constant second
> argument.
> {noformat}
> Motivated by a user trying to do something like this;
> http://community.cloudera.com/t5/Interactive-Short-cycle-SQL/Impala-round-function-does-not-return-expected-result/m-p/80200#M4906
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
