Hi Community users,
I am writing the below data into MongoDB database using MongoDB writer node. I want MongoDB to recognize the column ‘event_date’ as a date column and ‘event_datetime’ as a timestamp column (or at least as a datetime column). But what’s happening is everything is getting inserted as a string. This has serious issues in the visualization layer as data types are not getting recognized correctly. I tried converting the dates into unix timestamp formats and inserted as strings (as mentioned in MongoDB Extended JSON (v2) syntax) but that also doesn’t work. Until we specify the datatype during insertion into MongoDB, it seems like MongoDB will not recognize the data being inserted.
How to deal with this situation ?