# Dremio can't read datetime values in parquet files created with Drill 1.11

**URL:** https://community.dremio.com/t/dremio-cant-read-datetime-values-in-parquet-files-created-with-drill-1-11/294
**Category:** Uncategorized
**Created:** [September 18, 2017, 7:23pm UTC](https://community.dremio.com/t/dremio-cant-read-datetime-values-in-parquet-files-created-with-drill-1-11/294 "2017-09-18T19:23:12Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![david.lee](https://avatars.discourse-cdn.com/v4/letter/d/ed655f/32.png) [@david.lee](https://community.dremio.com/u/david.lee)
#### Post date: [September 18, 2017, 7:23pm UTC](https://community.dremio.com/t/dremio-cant-read-datetime-values-in-parquet-files-created-with-drill-1-11/294/1 "2017-09-18T19:23:13Z")

</div>

After upgrading from Apache Drill 1.09 to Apache Drill 1.11, the Parquet files I’m creating with a datetime field are no longer being read correctly by Dremio…

July 31st, 2017 is somehow being read as -11347-05-17 00:00:00.000. I tried using Apache Spark to read the same files and it correctly returns back July 31st, 2107.

Here’s the Drill SQL Snippet which takes a CSV files and creates a Parquet file.

create table dfs.tmp.`as_of=20170331` as  
select  
cast(invariant\_id as char(9)) as invariant\_id,  
to\_date(‘20170731’,‘yyyyMMdd’) as as\_of\_dt,  
cast(‘DALYRATIO’ as varchar) as analytic\_type,  
cast(dalyratio as float) as analytic\_value\_float  
from table(dfs.`/proj/r20170731.csv.gz`(type =\> ‘text’, fieldDelimiter =\> ‘,’, extractHeader =\> true))  
where dalyratio not in (’’,’#DIV/0’)

This is what I see in Dremio when opening up the parquet files.

ESG000004  
-11347-05-17 00:00:00.000  
ANTICOMP\_SCORE  
5

ESG000004  
-11347-05-17 00:00:00.000  
BUSETH\_FD\_MGMT\_SCORE  
2.5

ESG000004  
-11347-05-17 00:00:00.000  
CLIM\_CHG\_THM\_SCORE  
6.3

ESG000004  
-11347-05-17 00:00:00.000  
COMP\_ENV\_SCORE  
6.3

ESG000004  
-11347-05-17 00:00:00.000  
COMP\_ESG\_ADJ\_SCORE  
4.2

---

<div class="post-metadata">

### Author: ![venki](https://avatars.discourse-cdn.com/v4/letter/v/f0a364/32.png) [@venki](https://community.dremio.com/u/venki)
#### Post date: [September 19, 2017, 6:21pm UTC](https://community.dremio.com/t/dremio-cant-read-datetime-values-in-parquet-files-created-with-drill-1-11/294/2 "2017-09-19T18:21:57Z")

</div>

This issue is fixed in current development branch. It will be available in next release.