开发者社区 问答 正文

Time attribute will be lost after two(or more) tab

Hi Friends,However, we found that the time attribute will be lost after table joining, which means that we cannot do the joining and aggregation at one SQL query statement. There will be no output after the above SQL querying, for SQL queries on streaming tables, the time_attr argument of the group window function https://ci.apache.org/projects/flink/flink-docs-release-1.12/dev/table/sql/queries.html#group-windows must refer to a valid time attribute that specifies the processing time or event time of rows. In wide_table, the time_attr of field eventInfo_eventTime has been lost.*来自志愿者整理的flink邮件归档

展开
收起
moonlightdisco 2021-12-07 16:33:39 692 分享 版权
1 条回答
写回答
取消 提交回答
  • Hi!

    As this mail is written in English I'm also forwarding this to the user mailing list.

    Streaming joins do not retain row time attribute and this is the expected behavior. As you're windowing the results of joins I guess you're enriching the records from one stream with that join. Lookup joins [1] and event time temporal join [2] will retain row time and their results can be used by windowing operators later. Do they meet your needs?

    [1] https://nightlies.apache.org/flink/flink-docs-release-1.14/docs/dev/table/sql/queries/joins/#lookup-join [2] https://nightlies.apache.org/flink/flink-docs-release-1.14/docs/dev/table/sql/queries/joins/#event-time-temporal-join*来自志愿者整理的flink邮件归档

    2021-12-07 17:05:16
    赞同 展开评论
问答地址: