[
https://issues.apache.org/jira/browse/FLINK-16568?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17324116#comment-17324116
]
Flink Jira Bot commented on FLINK-16568:
----------------------------------------
This issue is assigned but has not received an update in 7 days so it has been
labeled "stale-assigned". If you are still working on the issue, please give an
update and remove the label. If you are no longer working on the issue, please
unassign so someone else may work on it. In 7 days the issue will be
automatically unassigned.
> Cannot call Hive UDAF that requires constant arguments
> ------------------------------------------------------
>
> Key: FLINK-16568
> URL: https://issues.apache.org/jira/browse/FLINK-16568
> Project: Flink
> Issue Type: Bug
> Components: Connectors / Hive, Documentation
> Reporter: Rui Li
> Assignee: Rui Li
> Priority: Major
> Labels: stale-assigned
>
> Calling Hive's {{percentile_approx}} would fail:
> {code}
> hiveShell.execute("create table src (key double,val string)");
> tableEnv.loadModule("hive", new HiveModule());
> tableEnv.sqlQuery("select percentile_approx(key,0.5) from src");
> TableUtils.collectToList(tableEnv.sqlQuery("select
> percentile_approx(key,0.5) from src"));
> {code}
> With error:
> {noformat}
> Caused by: org.apache.hadoop.hive.ql.exec.UDFArgumentTypeException: The
> second argument must be a constant, but decimal(2,1) was passed instead.
> at
> org.apache.hadoop.hive.ql.udf.generic.GenericUDAFPercentileApprox.getEvaluator(GenericUDAFPercentileApprox.java:145)
> at
> org.apache.flink.table.functions.hive.HiveGenericUDAF.createEvaluator(HiveGenericUDAF.java:120)
> at
> org.apache.flink.table.functions.hive.HiveGenericUDAF.init(HiveGenericUDAF.java:92)
> at
> org.apache.flink.table.functions.hive.HiveGenericUDAF.getHiveResultType(HiveGenericUDAF.java:196)
> ... 58 more
> {noformat}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
