You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Tim Armstrong (JIRA)" <ji...@apache.org> on 2018/09/24 18:10:00 UTC
[jira] [Updated] (IMPALA-7613) Support round(DECIMAL) with
non-constant second argument
[ 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: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org