You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@drill.apache.org by dz...@apache.org on 2021/11/24 12:10:31 UTC
[drill-site] 02/02: Document SAS format plugin.
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 <ja...@somecomputer.xyz>
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`
+