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]
