drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Shivam Saxena (Jira)" <j...@apache.org>
Subject [jira] [Created] (DRILL-7786) Apache drill fails to execute when excel file has datetime column
Date Thu, 03 Sep 2020 07:38:00 GMT
Shivam Saxena created DRILL-7786:
------------------------------------

             Summary: 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
         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)

Mime
View raw message