This topic describes how to create a data view in Realtime Compute for Apache Flink to simplify the development process.
If your business logic is complex and you need to write nested statements in DML statements, it can be difficult to locate problems. To simplify the development process, you can define a data view and write nested statements to the data view.
Note A data view displays a logical table that describes the computing logic without storing physical data.
CREATE TEMPORARY VIEW viewName AS [ (columnName[ , columnName]* ) ] queryStatement;
- viewName: the name of the view.
- columnName: the name of the field.
- queryStatement: the alias of the nested statement.
CREATE TEMPORARY VIEW tmp_view AS SELECT * FROM datagen_source; INSERT INTO rds_output SELECT r, t, c, u FROM tmp_view;