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]


Reply via email to