Table API: Joining on Tables of Complex Types

2020-01-03 Thread Hailu, Andreas
Hi folks, I'm trying to join two Tables which are composed of complex types, Avro's GenericRecord to be exact. I have to use a custom UDF to extract fields out of the record and I'm having some trouble on how to do joins on them as I need to call this UDF to read what I need. Example below: ba

Re: Table API: Joining on Tables of Complex Types

2020-01-06 Thread Dawid Wysakowicz
Hi Andreas, First of all I would highly recommend converting a non-structured types to structured types as soon as possible as it opens more possibilities to optimize the plan. Have you tried: Table users = batchTableEnvironment.fromDataSet(usersDataset).select("getField(f0, userName) as userNam

RE: Table API: Joining on Tables of Complex Types

2020-01-06 Thread Hailu, Andreas
gt;complex object with accessors into a Table of structured types. Or by >structured types, did you mean Row? // ah From: Dawid Wysakowicz Sent: Monday, January 6, 2020 9:32 AM To: Hailu, Andreas [Engineering] ; user@flink.apache.org Cc: Richards, Adam S [Engineering] Subject: Re: Table API: Joi

Re: Table API: Joining on Tables of Complex Types

2020-01-08 Thread Dawid Wysakowicz
Hailu, Andreas [Engineering] ; > user@flink.apache.org > *Cc:* Richards, Adam S [Engineering] > *Subject:* Re: Table API: Joining on Tables of Complex Types > >   > > Hi Andreas, > > First of all I would highly recommend converting a non-structured > types to structured

RE: Table API: Joining on Tables of Complex Types

2020-01-08 Thread Hailu, Andreas
Very well - I'll give this a try. Thanks, Dawid. // ah From: Dawid Wysakowicz Sent: Wednesday, January 8, 2020 7:21 AM To: Hailu, Andreas [Engineering] ; user@flink.apache.org Cc: Richards, Adam S [Engineering] Subject: Re: Table API: Joining on Tables of Complex Types Hi An

RE: Table API: Joining on Tables of Complex Types

2020-01-15 Thread Hailu, Andreas
g Cc: Richards, Adam S [Engineering] Subject: RE: Table API: Joining on Tables of Complex Types Very well - I'll give this a try. Thanks, Dawid. // ah From: Dawid Wysakowicz mailto:dwysakow...@apache.org>> Sent: Wednesday, January 8, 2020 7:21 AM To: Hailu, Andreas [Engineering] ma

Re: Table API: Joining on Tables of Complex Types

2020-01-17 Thread Timo Walther
.gs.com>>; user@flink.apache.org <mailto:user@flink.apache.org> *Cc:* Richards, Adam S [Engineering] <mailto:adam.richa...@ny.email.gs.com>> *Subject:* Re: Table API: Joining on Tables of Complex Types Hi Andreas, Converting your GenericRecords to Rows would

RE: Table API: Joining on Tables of Complex Types

2020-02-14 Thread Hailu, Andreas
eed. // ah -Original Message- From: Timo Walther Sent: Friday, January 17, 2020 11:29 AM To: user@flink.apache.org Subject: Re: Table API: Joining on Tables of Complex Types Hi Andreas, if dataset.getType() returns a RowTypeInfo you can ignore this log message. The type extractor runs b

Re: Table API: Joining on Tables of Complex Types

2020-02-19 Thread Timo Walther
Wysakowicz' <mailto:dwysakow...@apache.org>; mailto:user@flink.apache.org *Cc:* Richards, Adam S [Engineering] <mailto:adam.richa...@ny.email.gs.com> *Subject:* RE: Table API: Joining on Tables of Complex Types Very well - I'll give this a try. Thanks, Dawid. *// *ah** *