from pyflink.table import EnvironmentSettings, StreamTableEnvironment
env_settings =
EnvironmentSettings.new_instance().in_streaming_mode().use_blink_planner().build()
table_env = StreamTableEnvironment.create(environment_settings=env_settings)
table = table_env.from_elements([(1, 'Hi'), (2, 'Hello')], ['id', 'data'])
table_env.create_temporary_view("simple_source", table)
table_env.execute_sql("""
CREATE TABLE first_sink_table (
id BIGINT,
data VARCHAR
) WITH (
'connector' = 'print'
)
""")
table_env.execute_sql("""
CREATE TABLE second_sink_table (
id BIGINT,
data VARCHAR
) WITH (
'connector' = 'print'
)
""")
# ????????statement????
statement_set = table_env.create_statement_set()
# ????TABLE API ??table??????first_sink_table??????
statement_set.add_insert("first_sink_table", table)
# ????SQL??table??????second_sink_table??????
statement_set.add_insert_sql("INSERT INTO second_sink_table SELECT * FROM
simple_source")
# ????????
statement_set.execute().wait()????????????????????????????????????????????????????????????1??2??1??2????????1??1??2??2??4>
+I(1,Hi)
4> +I(1,Hi)
4> +I(2,Hello)
4> +I(2,Hello)
