Re: [jira] [Commented] (DRILL-7786) Apache drill fails to execute when excel file has datetime column

[Charles Givre <cg...@gmail.com>]

1.18 will be released in a few days as an official release. Then it will be on the website.  

Sent from my iPhone

> On Sep 3, 2020, at 08:58, Shivam Saxena (Jira) <ji...@apache.org> wrote:
> 
> 
>    [ https://issues.apache.org/jira/browse/DRILL-7786?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17190118#comment-17190118 ] 
> 
> Shivam Saxena commented on DRILL-7786:
> --------------------------------------
> 
> Thanks. m able to query date fields now in 1.18.
> 
>  
> 
> Is it a final release version? I can't see it on official webpage
> 
>> 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)