[
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
> 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)
