Impala does not support DATE data type, please refer to Cloudera doc:

https://www.cloudera.com/documentation/enterprise/latest/topics/impala_langref_unsupported.html

You mentioned you changed to timestamp, it also failed, can you please let me know how you made the change?