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

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

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

Shang Yuanchun (Jira)
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)