A Parquet file has data which represent DATE values.
When a query projects data using the Dremio JDBC driver, the data is being shifted.
It appears that Dremio is effectively treating the value as a time stamp and then shifting the value based on the session time zone. By doing so, values are changing which day they represent.
select rnum, cdt, cast ( cdt as varchar(10)) from dbcert.tdt
As shown, type casting at the server shows the value in the original data versus the value returned by the driver.
Meanwhile same test using the web console shows the expected values.