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

["Tim Armstrong (JIRA)" <ji...@apache.org>]

Tim Armstrong created IMPALA-7613:
-------------------------------------

             Summary: 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
            Reporter: Tim Armstrong


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