So I’m using jdbc connector to transfer data from MySQL to the mapd, and problem I keep having is that mapd adds timezone info to the date fields when none is specified. I set my MySQL server time to UTC+0 and global variable and I can confirm that NOW() returns UTC+0 however mapd insist on adding +2 GMT to date fields.
I even tried setting the session time_zone variable within MySQL query used to pull the data however no luck (box that is running mapd is also set to use UTC). Most weird thing is that it sometimes does CET and sometimes CEST as shown in image.
Any suggestion how set timezone to UTC or disable it whatsoever? Thanks