[
https://issues.apache.org/jira/browse/DRILL-7495?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17006946#comment-17006946
]
ASF GitHub Bot commented on DRILL-7495:
---------------------------------------
KazydubB commented on issue #1941: DRILL-7495: Excel Reader Not Parsing Dates
Correctly in First Column
URL: https://github.com/apache/drill/pull/1941#issuecomment-570269960
@cgivre, while running tests I've encountered the next test failure:
```
[ERROR] Failures:
[ERROR] TestExcelFormat.testFileWithDoubleDates:401 1:0
expected:<1412308800000> but was:<1412294400000>
[INFO]
[ERROR] Tests run: 17, Failures: 1, Errors: 0, Skipped: 0
```
Probably, you need to use another `DateUtil.getJavaDate(...)` with
`TimeZone` notion, rather then with system one.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
> Excel Reader Not Parsing Dates Correctly in First Column
> --------------------------------------------------------
>
> Key: DRILL-7495
> URL: https://issues.apache.org/jira/browse/DRILL-7495
> Project: Apache Drill
> Issue Type: Bug
> Affects Versions: 1.17.0
> Reporter: Charles Givre
> Assignee: Charles Givre
> Priority: Minor
> Labels: ready-to-commit
> Fix For: 1.18.0
>
>
> The Excel format plugin is throwing an error if there is a date/time in the
> first column.
> *Workaround*
> Set {{allTextMode}} to true and it will query the data w/o issues.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
