Hello BB,
1. For the datastream approach, you can use broadcast pattern to build state
to enrich your data instead of join.
* You can define something like this,
Class CodebookData{
private Currency currency;
private OrganizationUnit organizationUnit;
...
}
* you can leverage Broadcast stream[1] as you mentioned your code book
streams doesn’t have much data. This is a good use case for broadcast pattern.
Connect the wrapper class datastream with the main stream and simply enrich it
with the state you built. Not sure if this fits into your use case…. Please
check.
1. I am not sure, lateral table join (temporal join) is designed to handle
some data enrich work load. You have a main table, and probe side table… I
suppose there is some kind of optimization, maybe I am wrong... In theory, it
is still based on join, maybe you forget about this part. Anyway, Flink SQL
will make join easier.
Reference:
[1]
https://ci.apache.org/projects/flink/flink-docs-stable/dev/stream/state/broadcast_state.html
Best,
Fuyao
From: B.B.
Date: Monday, April 5, 2021 at 06:27
To: Fuyao Li
Subject: Re: [External] : Union of more then two streams
Hi Fuyao,
thanks for you input.
I have follow up questions regarding your advices.
In your DataStream suggested solution in a) case could you elaborate a little
bit more. When you create that kind of generalized type how would you join it
with main stream? Which key would you use.
I was thinking of creating wrapper class that inside will have all the data
from code books. For example
Class CodebookData{
private Currency currency;
private OrganizationUnit organizationUnit
...
}
But then I have problem which key to use to join with main stream because
currency has its own key currencyId and organization unit has also its key
organizationId and so on.
Regarding your 2. suggested solution with Flink SQL what do you mean by
“ For such join, there should be some internal optimization and might get rid
of some memory consumption issues”.
Thx in advance
BB
On Mon, 5 Apr 2021 at 07:29, Fuyao Li
mailto:fuyao...@oracle.com>> wrote:
Hello BB,
Just want to share you some of my immature ideas. Maybe some experts can give
you better solutions and advice.
1. DataStream based solution:
* To do a union, as you already know, you must have the datastream to be
of the same format. Otherwise, you can’t do it. There is a work around way to
solve you problem. You can ingest the datastream with deserializationSchema and
map different code book streams to the same Java type, there is a field of
foreign key value (codebook_fk1, cookbook_fk2 values will all stored here),
another field just contains the name of the foreign value (e.g. cookbook_fk1.)
All other fields should also be generalized into such Java Type. After that,
you can do a union for these different code book streams and join with
mainstream.
* For cascade connect streams, I guess it is not a suggested approach,
in additional to memory, I think it will also make the watermark hard to
coordinate.
1. Flink SQL approach:
You can try to use Flink temporal table join to do the join work here. [1][2].
For such approach, you are cascade the join to enrich the mainstream. This
seems to be fitting into your use case since your enrich stream doesn’t change
so often and contains something like currency. For such join, there should be
some internal optimization and might get rid of some memory consumption issues,
I guess? Maybe I am wrong. But it worth to take a look.
Reference:
[1]
https://ci.apache.org/projects/flink/flink-docs-release-1.12/dev/table/streaming/joins.html<https://urldefense.com/v3/__https:/ci.apache.org/projects/flink/flink-docs-release-1.12/dev/table/streaming/joins.html__;!!GqivPVa7Brio!K_hRpSQQU6PTuqsuTgr5EWEukirSN1zRc53RlMQYK-tCJjuzvXikshp8M__T3j8$>
[2]
https://ci.apache.org/projects/flink/flink-docs-release-1.12/dev/table/streaming/joins.html#event-time-temporal-join<https://urldefense.com/v3/__https:/ci.apache.org/projects/flink/flink-docs-release-1.12/dev/table/streaming/joins.html*event-time-temporal-join__;Iw!!GqivPVa7Brio!K_hRpSQQU6PTuqsuTgr5EWEukirSN1zRc53RlMQYK-tCJjuzvXikshp8fpTJ5MA$>
Best,
Fuyao
From: B.B. mailto:bijela.vr...@gmail.com>>
Date: Friday, April 2, 2021 at 01:41
To: user@flink.apache.org<mailto:user@flink.apache.org>
mailto:user@flink.apache.org>>
Subject: [External] : Union of more then two streams
Hi,
I have an architecture question regarding the union of more than two streams in
Apache Flink.
We are having three and sometime more streams that are some kind of code book
with whom we have to enrich main stream.
Code book streams are compacted Kafka topics. Code books are something that
doesn't change so often, eg currency. Main stream is a fast event stream.
Idea is to make a union of all code books and then join it with main stream and
store the enrichment data as man