This is an automated email from the ASF dual-hosted git repository. dzamo pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/drill-site.git
commit f4e472da5e406d880be38b377cde888cf01b42fd Author: James Turton <[email protected]> AuthorDate: Wed Nov 24 14:10:14 2021 +0200 Document SAS format plugin. --- .../130-sas-format.plugin.md | 40 ++++++++++++++++++++++ 1 file changed, 40 insertions(+) diff --git a/_docs/en/data-sources-and-file-formats/130-sas-format.plugin.md b/_docs/en/data-sources-and-file-formats/130-sas-format.plugin.md new file mode 100644 index 0000000..1746e6a --- /dev/null +++ b/_docs/en/data-sources-and-file-formats/130-sas-format.plugin.md @@ -0,0 +1,40 @@ +--- +title: "SAS Format Plugin" +slug: "SAS Format Plugin" +parent: "Data Sources and File Formats" +--- + +**Introduced in release:** 1.20 + +This format plugin enables Drill to read SAS files (sas7bdat). The schema of the queried data is inferred from the metadata in the SAS file format. + +## Configuration Options +This function has no configuration options other than the file extension. + +```json + "sas": { + "type": "sas", + "extensions": [ + "sas7bdat" + ] +} +``` + +This plugin is enabled by default. + +## Data Types +The SAS format supports the `VARCHAR`, `LONG`, `DOUBLE` and `DATE` types. + +## Implicit Fields (Metadata) +The SAS reader provides the following file metadata fields: +* `_compression_method` +* `_encoding` +* `_file_label` +* `_file_type` +* `_os_name` +* `_os_type` +* `_sas_release` +* `_session_encoding` +* `_date_created` +* `_date_modified` +
