In Flink, the table of Iceberg has the same functions as other data sources. You can complete complex tasks through multiple data sources and multiple table queries. For example, for an order table, group statistics are performed on a type or label that needs to be acquired indirectly:
SELECT
COUNT(*) AS c,
`external_static`.`catalog`.type AS type
FROM `ecs`.`default`.`order`
LEFT JOIN `external_static`.`catalog`
ON `ecs`.`default`.`order`.catalog = `external_static`.`catalog`.id
GROUP BY `external_static`.`catalog`.type
This means that you can easily use Iceberg tables stored on ECS, and on other sources of data such as statistics, analysis, and forecasting of data.
