Denodo 5.0 release 20141023 - Windows Server 2008R2.
I have three views that I am trying to union together. view1 and view2 have 10 fields in it, view3 only has 8 fields. view3 is missing 2 date fields so I created 2 new date fields in view3. The date fields were created like this to_date('MM/dd/yyyy', ''). I do not get an error when I create this but when the union happens, I get the following in the error logs: com.denodo.vdb.catalog.view.function.ExecuteFunctionException: Error executing function to_date: Unparseable date: "". The only way I can get rid of this error is to actually put a date in the field which is not a valid option for me. If I put an empty string, it turns it to a text field and breaks my view.
So how do I get around this error and still have a date field that is null?