drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From GitBox <...@apache.org>
Subject [GitHub] [drill] cgivre opened a new pull request #2211: DRILL-7912: Add Sheet Names to Excel Reader
Date Sun, 02 May 2021 04:13:05 GMT

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:
users@infra.apache.org



Mime
View raw message