[
https://issues.apache.org/jira/browse/DRILL-7786?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Charles Givre closed DRILL-7786.
--------------------------------
Fix Version/s: 1.18.0
Resolution: Fixed
Fixed in Drill 1.18.
> 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
> Fix For: 1.18.0
>
> 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)
