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