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 <[email protected]>
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>
