Using NULLIF can be a workaround. I was able to populate new columns with null.
SELECT * ,NULLIF(5, 5) as unit_cerner_alias ,NULLIF(5, 5) as room_cerner_alias ,NULLIF(5, 5) as bed_cerner_alias FROM FLOWFILE On Fri, Mar 8, 2019 at 7:57 AM Boris Tyukin <[email protected]> wrote: > > 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
