You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "Timo Walther (Jira)" <ji...@apache.org> on 2021/01/14 09:31:00 UTC

[jira] [Created] (FLINK-20971) Allow SQL expressions in Table API

Timo Walther created FLINK-20971:
------------------------------------

             Summary: Allow SQL expressions in Table API
                 Key: FLINK-20971
                 URL: https://issues.apache.org/jira/browse/FLINK-20971
             Project: Flink
          Issue Type: Sub-task
          Components: Table SQL / API
            Reporter: Timo Walther
            Assignee: Timo Walther


Both FLIP-136 and FLIP-129 assume that a table schema is able to store both a SQL expression and a Table API one. Therefore we should introduce an expression in Table API that allows to use SQL expressions. This is also useful for other use cases where people prefer SQL expressions in Table API.

An expression `callSql(String)` next to `call(udf)` can offer scalar operations such as:
{code}
table.select(callSql("1+1"), 12, call(Udf.class, $("f0")))
{code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)