drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Charles Givre <cgi...@gmail.com>
Subject Re: [jira] [Commented] (DRILL-7786) Apache drill fails to execute when excel file has datetime column
Date Thu, 03 Sep 2020 13:00:18 GMT
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) <jira@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)

Mime
View raw message