[
https://issues.apache.org/jira/browse/DRILL-7786?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17190097#comment-17190097
]
Charles Givre commented on DRILL-7786:
--------------------------------------
[~shivamsaxena]
This issue was fixed in the new version of Drill which is about to be released.
Specifically in DRILL-7495 [1]. Also in Drill 1.18, we switched to a
streaming reader [2] for Excel files which means that you can read files of any
size without issues.
[1]:[https://github.com/apache/drill/pull/1941|https://github.com/apache/drill/pull/1941)]
[2]:[https://github.com/apache/drill/pull/2024]
> Apache drill fails to execute when excel file has datetime column
> -----------------------------------------------------------------
>
> Key: DRILL-7786
> URL: https://issues.apache.org/jira/browse/DRILL-7786
> Project: Apache Drill
> Issue Type: Bug
> Components: Storage - Other
> Affects Versions: 1.17.0
> Reporter: Shivam Saxena
> Priority: Blocker
> Attachments: excel_date_testing.csv, excel_date_testing.xlsx
>
>
> I am getting below error when m trying to query an excel sheet having
> datetime column in it. While when we convert same excel sheet to csv, its
> working fine.
> {color:#FF0000}org.apache.drill.common.exceptions.UserRemoteException:
> EXECUTION_ERROR ERROR: No instant converter found for type: java.lang.Double
> Read failed for reader ExcelBatchReader Fragment 0:0 [Error Id:
> 0d8bf3b7-d6f3-4a12-8633-eb10a36cc6cb on 192.168.1.20:31010]{color}
> {color:#172b4d}Attaching the sample excel sheet and converted csv file for
> reference.{color}
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
