How to write null values into a decimal field in Flink SQL?
In Flink SQL, you can use the NULL keyword to write a null value in a DECIMAL field. Here’s an example:
INSERT INTO my_table (dec_column) VALUES (NULL);
In this example, “my_table” is the table name and “dec_column” is the column name for the DECIMAL field. By placing the NULL keyword in the VALUES clause of the INSERT INTO statement, you can write a null value into the DECIMAL field.