?????? flink lookup join ????????????????????????

Sat, 09 May 2020 05:22:08 -0700 

??????????????????note_id??????????????????????????????????binlog??????note_id??????????????????????????????
??????????????????????note_id????????????????????





------------------ ???????? ------------------
??????:&nbsp;"Benchao Li"<libenc...@gmail.com&gt;;
????????:&nbsp;2020??5??9??(??????) ????7:36
??????:&nbsp;"user-zh"<user-zh@flink.apache.org&gt;;

????:&nbsp;Re: flink lookup join ????????????????????????



Hi??????????????????????????????????????????????????????????join??0????????????????????????????????

????????????????note_id??????????????????????????????group 
by??count??????????????

867127831 <867127...@qq.com&gt; ??2020??5??9?????? ????7:10??????

&gt; Hi,&amp;nbsp;
&gt;
&gt;
&gt; ??????flink??lookup 
join??????????????????????????????????????????????????????????????? 
??????????????????
&gt;
&gt;
&gt; ????(??????)??note(note_id varchar)
&gt; ????(??????)??picture(pic_id varchar, note_id varchar)
&gt;
&gt;
&gt; 
??????????????????????????????note??????????????picture????????????????????????????note????????picture,
 ????sql??????????
&gt;
&gt;
&gt; select
&gt; &amp;nbsp; N.note_id as note_id,
&gt; &amp;nbsp; COUNT(P.pic_id) AS img_count&amp;nbsp;
&gt; from note N
&gt; LEFT JOIN picture FOR SYSTEM_TIME AS OF N.proc_time AS P ON N.note_id =
&gt; P.note_id
&gt; group by N.note_id
&gt;
&gt;
&gt;
&gt; ??????????group by????????????????????????????????????



-- 

Benchao Li
School of Electronics Engineering and Computer Science, Peking University
Tel:+86-15650713730
Email: libenc...@gmail.com; libenc...@pku.edu.cn

回复