[jira] [Work stopped] (IMPALA-7613) Support round(DECIMAL) with non-constant second argument

["Abhishek Rawat (JIRA)" <ji...@apache.org>]

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

Work on IMPALA-7613 stopped 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: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org