Hi Porritt,

Flink does not support streaming and batch join, currently, streaming and
batch job are both independent.

I guess your use case is streaming and dimension table join?
Unfortunately, it's not possible for the Flink SQL API to join a stream
with a common dataset now.

1)
As a workaround, if the table is just a tiny one, you can achieve a
inner/left outer join with the user defined table functions :

https://ci.apache.org/projects/flink/flink-docs-release-1.4/dev/table/sql.html#joins

2)
I did not see any plan about this.

Thanks, vino.


2018-07-20 17:29 GMT+08:00 Porritt, James <james.porr...@uk.mlp.com>:

> I was hoping to join a StreamTableSource to a BatchTableSource, but I find
> it’s not simple. A couple of questions:
>
>
>
> 1)      Other than just pushing the DataSet to a Kafka topic (either
> internally or externally to the application) and reading it into a
> DataStream are there any means of doing the conversion?
>
> 2)      Are there any plans to get OrcTableSource to be both
> StreamTableSource and BatchTableSource instead of just a BatchTableSource?
>
>
>
> Thanks,
>
> James.
> ######################################################################
> The information contained in this communication is confidential and
> intended only for the individual(s) named above. If you are not a named
> addressee, please notify the sender immediately and delete this email
> from your system and do not disclose the email or any part of it to any
> person. The views expressed in this email are the views of the author
> and do not necessarily represent the views of Millennium Capital Partners
> LLP (MCP LLP) or any of its affiliates. Outgoing and incoming electronic
> communications of MCP LLP and its affiliates, including telephone
> communications, may be electronically archived and subject to review
> and/or disclosure to someone other than the recipient. MCP LLP is
> authorized and regulated by the Financial Conduct Authority. Millennium
> Capital Partners LLP is a limited liability partnership registered in
> England & Wales with number OC312897 and with its registered office at
> 50 Berkeley Street, London, W1J 8HD
> <https://maps.google.com/?q=50+Berkeley+Street,+London,+W1J+8HD&entry=gmail&source=g>
> .
> ######################################################################
>
>

Reply via email to