You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Charles Givre (Jira)" <ji...@apache.org> on 2020/09/03 14:21:00 UTC
[jira] [Closed] (DRILL-7786) Apache drill fails to execute when
excel file has datetime column
[ 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)