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:29 UTC
[drill-site] branch master updated (7e7f5a5 -> f4e472d)
This is an automated email from the ASF dual-hosted git repository.
dzamo pushed a change to branch master
in repository https://gitbox.apache.org/repos/asf/drill-site.git.
from 7e7f5a5 Add a ClickHouse example to RDBMS storage plugin page.
new ad02a9d Clean up section headings in RDBMS plugin page.
new f4e472d Document SAS format plugin.
The 2 revisions listed above as "new" are entirely new to this
repository and will be described in separate emails. The revisions
listed as "add" were already present in the repository and have only
been added to this reference.
Summary of changes:
.../plugins/080-rdbms-storage-plugin.md | 10 +++---
.../130-sas-format.plugin.md | 40 ++++++++++++++++++++++
2 files changed, 45 insertions(+), 5 deletions(-)
create mode 100644 _docs/en/data-sources-and-file-formats/130-sas-format.plugin.md
[drill-site] 02/02: Document SAS format plugin.
Posted by dz...@apache.org.
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`
+
[drill-site] 01/02: Clean up section headings in RDBMS plugin page.
Posted by dz...@apache.org.
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 ad02a9d15ad826c2e20b4ac7c62abbe8b56d4e87
Author: James Turton <ja...@somecomputer.xyz>
AuthorDate: Wed Nov 24 13:23:46 2021 +0200
Clean up section headings in RDBMS plugin page.
---
.../connect-a-data-source/plugins/080-rdbms-storage-plugin.md | 10 +++++-----
1 file changed, 5 insertions(+), 5 deletions(-)
diff --git a/_docs/en/connect-a-data-source/plugins/080-rdbms-storage-plugin.md b/_docs/en/connect-a-data-source/plugins/080-rdbms-storage-plugin.md
index 6dffacc..43000b2 100644
--- a/_docs/en/connect-a-data-source/plugins/080-rdbms-storage-plugin.md
+++ b/_docs/en/connect-a-data-source/plugins/080-rdbms-storage-plugin.md
@@ -67,7 +67,7 @@ You can use the performance_schema database, which is installed with MySQL to qu
## Example Configurations
-### Example ClickHouse configuration
+### ClickHouse
Download and install the [official ClickHouse JDBC driver](https://github.com/ClickHouse/clickhouse-jdbc) on all of the nodes in your cluster.
```json
@@ -81,7 +81,7 @@ Download and install the [official ClickHouse JDBC driver](https://github.com/Cl
}
```
-### Example MySQL Configuration
+### MySQL
For MySQL, Drill has been tested with MySQL's [mysql-connector-java-5.1.37-bin.jar](http://dev.mysql.com/downloads/connector/j/) driver. Copy this to all nodes.
```json
@@ -95,7 +95,7 @@ For MySQL, Drill has been tested with MySQL's [mysql-connector-java-5.1.37-bin.j
}
```
-### Example Oracle configuration
+### Oracle Database
Download and install Oracle's Thin [ojdbc7.12.1.0.2.jar](http://www.oracle.com/technetwork/database/features/jdbc/default-2280470.html) driver and copy it to all nodes in your cluster.
@@ -108,7 +108,7 @@ Download and install Oracle's Thin [ojdbc7.12.1.0.2.jar](http://www.oracle.com/t
}
```
-### Example PostgreSQL configuration
+### PostgreSQL
Drill is tested with the PostgreSQL driver version [42.2.11](https://mvnrepository.com/artifact/org.postgresql/postgresql) (any recent driver should work).
Download and copy this driver jar to the `jars/3rdparty` folder on all nodes.
@@ -171,7 +171,7 @@ You may need to qualify a table name with a schema name for Drill to return data
}
```
-### Example SQL Server configuration
+### MS SQL Server
For SQL Server, Drill has been tested with Microsoft's [sqljdbc41.4.2.6420.100.jar](https://www.microsoft.com/en-US/download/details.aspx?id=11774) driver. Copy this jar file to all Drillbits.