This is an automated email from the ASF dual-hosted git repository.
anton pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/beam.git
The following commit(s) were added to refs/heads/master by this push:
new b4d1846 [BEAM-6574] Inline description of CSV formats
new af6b869 Merge pull request #7697 from kennknowles/CSVFormat
b4d1846 is described below
commit b4d1846ad134484be0e50e2851e100303690ce60
Author: Kenneth Knowles <[email protected]>
AuthorDate: Thu Jan 31 16:49:19 2019 -0800
[BEAM-6574] Inline description of CSV formats
---
.../src/documentation/dsls/sql/create-external-table.md | 15 +++++++++++++--
1 file changed, 13 insertions(+), 2 deletions(-)
diff --git a/website/src/documentation/dsls/sql/create-external-table.md
b/website/src/documentation/dsls/sql/create-external-table.md
index a6f6e32..f332880 100644
--- a/website/src/documentation/dsls/sql/create-external-table.md
+++ b/website/src/documentation/dsls/sql/create-external-table.md
@@ -323,8 +323,19 @@ TBLPROPERTIES '{"format: "Excel"}'
* `LOCATION`: The path to the file for Read Mode. The prefix for Write Mode.
* `TBLPROPERTIES`:
- * `format`: Optional. Allows you to specify the
-
[CSVFormat](https://commons.apache.org/proper/commons-csv/archives/1.5/apidocs/org/apache/commons/csv/CSVFormat.Predefined.html).
+ * `format`: Optional. Allows you to specify the CSV Format, which
controls
+ the field delimeter, quote character, record separator, and other
properties.
+ See the following table:
+
+
+| Value for `format` | Field delimiter | Quote | Record separator | Ignore
empty lines? | Allow missing column names? |
+|--------------------|-----------------|-------|------------------|---------------------|-----------------------------|
+| `default` | `,` | `"` | `\r\n` | Yes
| No |
+| `rfc4180` | `,` | `"` | `\r\n` | No
| No |
+| `excel` | `,` | `"` | `\r\n` | No
| Yes |
+| `tdf` | `\t` | `"` | `\r\n` | Yes
| No |
+| `mysql` | `\t` | none | `\n` | No
| No |
+{:.table-bordered}
### Read Mode
