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 12:22:00 UTC
[jira] [Commented] (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: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)