[ 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-unsubscr...@drill.apache.org For queries about this service, please contact Infrastructure at: us...@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)