[
https://issues.apache.org/jira/browse/FLINK-10731?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16669871#comment-16669871
]
Flavio Pompermaier commented on FLINK-10731:
--------------------------------------------
{code:java}
ExecutionEnvironment env = ExecutionEnvironment.getExecutionEnvironment();
BatchTableEnvironment btEnv = TableEnvironment.getTableEnvironment(env);
btEnv.registerDataSet("TEST_TABLE", env.fromCollection(Arrays.asList(new
Date())), "somedate");
Table table = btEnv.sqlQuery("SELECT AVG(somedate) FROM TEST_TABLE");
btEnv.toDataSet(table, new RowTypeInfo(BasicTypeInfo.DATE_TYPE_INFO)).print();
{code}
> Support AVG on Date fields
> --------------------------
>
> Key: FLINK-10731
> URL: https://issues.apache.org/jira/browse/FLINK-10731
> Project: Flink
> Issue Type: Improvement
> Components: Table API & SQL
> Affects Versions: 1.6.2
> Reporter: Flavio Pompermaier
> Priority: Minor
>
> AVG function does not work on date fields right now
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
