Reason columnOPER_TIME values is null while columns is not nullable src line doris错误怎么解决

To solve the Doris error where the column OPER_TIME has null values even though the column is defined as not nullable, you can follow these steps:

1. Identify the root cause: Check the data source or the process that inserts or updates the data in the table. It is possible that there is a bug or an issue in the data loading process that is causing the null values to be inserted.

2. Validate the data: Review the data that is being inserted or updated in the table. Check if there are any null values being provided explicitly or if there are any transformations or calculations that might be causing the null values.

3. Fix the source of the data: If the issue is identified in the data loading process, you will need to fix the source code or configuration that is responsible for inserting or updating the data. Ensure that the data being provided is valid and does not contain any null values for the non-nullable column.

4. Update the data: If there are already null values present in the OPER_TIME column, you will need to update the data to replace the null values with valid values. You can use an UPDATE statement to modify the existing records and set a default or valid value for the null entries.

5. Modify the table schema: After ensuring that the data is correct, you can modify the table schema to allow null values for the OPER_TIME column. This step should only be considered if it is acceptable for the column to have null values. However, if the column should always have a value and the null values are incorrect, this step should be avoided.

6. Test and validate: After implementing the necessary changes, thoroughly test the data loading process and verify that the null values issue is resolved. Ensure that the column behaves as expected and does not allow null values if it is not supposed to.

By following these steps, you should be able to identify and resolve the Doris error related to null values in the OPER_TIME column