Try setting set enable_insert_strict = false; in the session before the INSERT, to see if that changes NULL handling.
set enable_insert_strict = false;
You can refer: https://doris.apache.org/docs/2.1/data-operate/import/handling-messy-data#strict-mode