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)
