[ https://issues.apache.org/jira/browse/IMPALA-7613?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16627964#comment-16627964 ]
Tim Armstrong commented on IMPALA-7613: --------------------------------------- This is consistent with the principle of IMPALA-6230 of using the input type. > 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, 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-unsubscr...@impala.apache.org For additional commands, e-mail: issues-all-h...@impala.apache.org