This is an automated email from the ASF dual-hosted git repository. git-site-role pushed a commit to branch asf-site in repository https://gitbox.apache.org/repos/asf/beam.git
The following commit(s) were added to refs/heads/asf-site by this push: new 203926c Publishing website 2019/02/01 02:41:19 at commit af6b869 203926c is described below commit 203926c237af0e940607a5fee3b98a4957e20f9f Author: jenkins <bui...@apache.org> AuthorDate: Fri Feb 1 02:41:19 2019 +0000 Publishing website 2019/02/01 02:41:19 at commit af6b869 --- .../dsls/sql/create-external-table/index.html | 60 +++++++++++++++++++++- 1 file changed, 58 insertions(+), 2 deletions(-) diff --git a/website/generated-content/documentation/dsls/sql/create-external-table/index.html b/website/generated-content/documentation/dsls/sql/create-external-table/index.html index 13571e9..bc4bd8b 100644 --- a/website/generated-content/documentation/dsls/sql/create-external-table/index.html +++ b/website/generated-content/documentation/dsls/sql/create-external-table/index.html @@ -643,12 +643,68 @@ TBLPROPERTIES '{"format: "Excel"}' <li><code class="highlighter-rouge">LOCATION</code>: The path to the file for Read Mode. The prefix for Write Mode.</li> <li><code class="highlighter-rouge">TBLPROPERTIES</code>: <ul> - <li><code class="highlighter-rouge">format</code>: Optional. Allows you to specify the -<a href="https://commons.apache.org/proper/commons-csv/archives/1.5/apidocs/org/apache/commons/csv/CSVFormat.Predefined.html">CSVFormat</a>.</li> + <li><code class="highlighter-rouge">format</code>: Optional. Allows you to specify the CSV Format, which controls +the field delimeter, quote character, record separator, and other properties. +See the following table:</li> </ul> </li> </ul> +<table class="table-bordered"> + <thead> + <tr> + <th>Value for <code class="highlighter-rouge">format</code></th> + <th>Field delimiter</th> + <th>Quote</th> + <th>Record separator</th> + <th>Ignore empty lines?</th> + <th>Allow missing column names?</th> + </tr> + </thead> + <tbody> + <tr> + <td><code class="highlighter-rouge">default</code></td> + <td><code class="highlighter-rouge">,</code></td> + <td><code class="highlighter-rouge">"</code></td> + <td><code class="highlighter-rouge">\r\n</code></td> + <td>Yes</td> + <td>No</td> + </tr> + <tr> + <td><code class="highlighter-rouge">rfc4180</code></td> + <td><code class="highlighter-rouge">,</code></td> + <td><code class="highlighter-rouge">"</code></td> + <td><code class="highlighter-rouge">\r\n</code></td> + <td>No</td> + <td>No</td> + </tr> + <tr> + <td><code class="highlighter-rouge">excel</code></td> + <td><code class="highlighter-rouge">,</code></td> + <td><code class="highlighter-rouge">"</code></td> + <td><code class="highlighter-rouge">\r\n</code></td> + <td>No</td> + <td>Yes</td> + </tr> + <tr> + <td><code class="highlighter-rouge">tdf</code></td> + <td><code class="highlighter-rouge">\t</code></td> + <td><code class="highlighter-rouge">"</code></td> + <td><code class="highlighter-rouge">\r\n</code></td> + <td>Yes</td> + <td>No</td> + </tr> + <tr> + <td><code class="highlighter-rouge">mysql</code></td> + <td><code class="highlighter-rouge">\t</code></td> + <td>none</td> + <td><code class="highlighter-rouge">\n</code></td> + <td>No</td> + <td>No</td> + </tr> + </tbody> +</table> + <h3 id="read-mode-3">Read Mode</h3> <p>Read Mode supports reading from a file.</p>