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 <k...@apache.org> 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