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`
+