[
https://issues.apache.org/jira/browse/DRILL-7912?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17337949#comment-17337949
]
ASF GitHub Bot commented on DRILL-7912:
---------------------------------------
cgivre opened a new pull request #2211:
URL: https://github.com/apache/drill/pull/2211
# [DRILL-7912](https://issues.apache.org/jira/browse/DRILL-7912): Add Sheet
Names to Excel Reader
## Description
Currently, there was no way to determine what sheets are available in a
given Excel file. This minor PR adds a new implicit metadata field called
`_sheets` which a user can use to determine what sheets are available. By
definition, Excel files must have at least one sheet.
Additionally, I updated the streaming reader to the latest version.
## Documentation
Updated `README` to reflect the additional field, but to determine the
available sheets, a user could execute the query below:
```sql
SELECT FLATTEN(_sheets) AS sheetNames
FROM <Excel File>
```
## Testing
Added additional unit test.
--
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.
For queries about this service, please contact Infrastructure at:
[email protected]
> Add Sheet Names to Excel Reader
> -------------------------------
>
> Key: DRILL-7912
> URL: https://issues.apache.org/jira/browse/DRILL-7912
> Project: Apache Drill
> Issue Type: Improvement
> Components: Storage - Other
> Affects Versions: 1.18.0
> Reporter: Charles Givre
> Assignee: Charles Givre
> Priority: Major
> Fix For: 1.19.0
>
>
> Currently, there is no way to determine what sheets are available in an Excel
> file. This PR adds a metadata field called `_sheets` which a user can query
> to determine available sheets in a given file.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
