[ https://issues.apache.org/jira/browse/HIVE-6327?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13887220#comment-13887220 ]
Xuefu Zhang commented on HIVE-6327: ----------------------------------- Good thinking. I'm not sure what you have in mind, but my work is generic for those mathematical functions where decimal can be treated as double. In general though, this is not true: we cannot just treat decimal as double in every case. The other direction is not desirable either: we cannot implicitly convert double to decimal as hive type promotion hierarchy suggests. > A few mathematic functions don't take decimal input > --------------------------------------------------- > > Key: HIVE-6327 > URL: https://issues.apache.org/jira/browse/HIVE-6327 > Project: Hive > Issue Type: Improvement > Affects Versions: 0.11.0, 0.12.0 > Reporter: Xuefu Zhang > Assignee: Xuefu Zhang > > A few mathematical functions, such as sin() cos(), etc. don't take decimal as > argument. > {code} > hive> show tables; > OK > Time taken: 0.534 seconds > hive> create table test(d decimal(5,2)); > OK > Time taken: 0.351 seconds > hive> select sin(d) from test; > FAILED: SemanticException [Error 10014]: Line 1:7 Wrong arguments 'd': No > matching method for class org.apache.hadoop.hive.ql.udf.UDFSin with > (decimal(5,2)). Possible choices: _FUNC_(double) > {code} > HIVE-6246 covers only sign() function. The remaining ones, including sin, > cos, tan, asin, acos, atan, exp, ln, log, log10, log2, radians, and sqrt. > These are non-generic UDFs. -- This message was sent by Atlassian JIRA (v6.1.5#6160)