[
https://issues.apache.org/jira/browse/IMPALA-7613?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Tim Armstrong updated IMPALA-7613:
----------------------------------
Affects Version/s: Impala 3.0
Impala 2.12.0
> 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
> Priority: Major
> Labels: decimal
>
> 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}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
