[jira] [Commented] (DRILL-8022) Add Provided Schema Support for Excel Reader

["ASF GitHub Bot (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DRILL-8022?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17435413#comment-17435413 ] 

ASF GitHub Bot commented on DRILL-8022:
---------------------------------------

cgivre opened a new pull request #2354:
URL: https://github.com/apache/drill/pull/2354


   # [DRILL-8022](https://issues.apache.org/jira/browse/DRILL-8022): Add Provided Schema Support for Excel Reader
   
   ## Description
   This PR adds support for provided schema for the Excel format plugin. 
   
   ## Documentation
   The provided schema functionality is already documented in the Drill docs, but this PR applies it to the Excel reader.
   
   An example query:
   ```sql
   SELECT col1, col2, col3 
   FROM table(dfs.`excel/schema_provisioning.xlsx`  
   (schema => 'inline=(`col1` INTEGER, `col2` FLOAT, `col3` VARCHAR)'))
   ```
   
   Previously, the Excel reader only supported dates, and doubles as data types.  This PR adds support for INT data types but only via provided schema.  
   
   One limitation is that while Drill supports nested data, this PR does not allow a user to provision data types that Excel does not support.  So if a user attempts to create a schema with maps, or lists, this will fail. 
   
   ## Testing
   Added additional unit tests


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscribe@drill.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


> Add Provided Schema Support for Excel Reader
> --------------------------------------------
>
>                 Key: DRILL-8022
>                 URL: https://issues.apache.org/jira/browse/DRILL-8022
>             Project: Apache Drill
>          Issue Type: Improvement
>          Components: Storage - Text & CSV
>    Affects Versions: 1.19.0
>            Reporter: Charles Givre
>            Assignee: Charles Givre
>            Priority: Major
>             Fix For: 1.20.0
>
>
> Add support for provided schema for Excel files. 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)