[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[jira] [Created] (FLINK-9688) ATAN2 Sql Function support

Sergey Nuyanzin created FLINK-9688:

             Summary: ATAN2 Sql Function support
                 Key: FLINK-9688
             Project: Flink
          Issue Type: Bug
          Components: Table API & SQL
            Reporter: Sergey Nuyanzin
            Assignee: Sergey Nuyanzin

simple query fails {code}
ExecutionEnvironment env = ExecutionEnvironment.getExecutionEnvironment();
		BatchTableEnvironment tableEnv = TableEnvironment.getTableEnvironment(env, config());

		DataSet<Tuple3<Integer, Long, String>> ds = CollectionDataSets.get3TupleDataSet(env);
		tableEnv.registerDataSet("t1", ds, "x, y, z");

		String sqlQuery = "SELECT atan2(1,2)";
		Table result = tableEnv.sqlQuery(sqlQuery);
while at the same time Calcite supports it and in Calcite's sqlline it works like {noformat}
0: jdbc:calcite:model=target/test-classes/mod> select atan2(1,2);
|     EXPR$0      |
| 0.4636476090008061 |
1 row selected (0.173 seconds)

This message was sent by Atlassian JIRA