[DRILL-7786] Apache drill fails to execute when excel file has datetime column

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 1.17.0
• Fix Version/s: 1.18.0
• Component/s: Storage - Other
• Assignee: Unassigned
• Reporter: Shivam Saxena
• Created: 03/Sep/20 07:37
• Updated: 04/Sep/20 12:32
• Resolved: 03/Sep/20 14:20

Description

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.

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]

Attaching the sample excel sheet and converted csv file for reference.