I am struggling for an hour now with a very simple thing. I need to add 3 new fields to a record and set them to NULL but it does not work.
I tried null instead - same thing. I checked Calcite docs and I do not see anything special about NULL. And I know you can do it in SQL. This works: SELECT * ,'' as unit_cerner_alias ,'' as room_cerner_alias ,'' as bed_cerner_alias FROM FLOWFILE But this does not: SELECT * ,NULL as unit_cerner_alias ,NULL as room_cerner_alias ,NULL as bed_cerner_alias FROM FLOWFILE Then I use LookupRecord processor to populate them or leave with NULL
