flink Table SQL Api

Question

I want to know can we write query using two tables ( join) in flink Table and SQL api.

I am new to flik, I want to create two table from two different data set and query them and produce other dataset.

my query would be like select... from table1, table 2... so can we write like this query which querying two tables or more?

Thanks

Till Rohrmann · Accepted Answer · 2017-06-02 16:37:44Z

2

Flink's Table API supports join operations (full, left, right, inner joins) on batch tables (e.g. those created from a DataSet).

SELECT c, g FROM Table3, Table5 WHERE b = e

For streaming tables (e.g. those created from a DataStream), Flink does not yet support join operations. But the Flink community is actively working to add them in the near future.

answered Jun 2, 2017 at 16:37

Till Rohrmann

13.4k2 gold badges27 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

flink Table SQL Api

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related