You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@drill.apache.org by br...@apache.org on 2015/12/04 01:12:25 UTC
drill-site git commit: doc update
Repository: drill-site
Updated Branches:
refs/heads/asf-site 3a32c126e -> 89710fb39
doc update
Project: http://git-wip-us.apache.org/repos/asf/drill-site/repo
Commit: http://git-wip-us.apache.org/repos/asf/drill-site/commit/89710fb3
Tree: http://git-wip-us.apache.org/repos/asf/drill-site/tree/89710fb3
Diff: http://git-wip-us.apache.org/repos/asf/drill-site/diff/89710fb3
Branch: refs/heads/asf-site
Commit: 89710fb39f2ee9155fed658201990cea891abee9
Parents: 3a32c12
Author: Bridget Bevens <bb...@maprtech.com>
Authored: Thu Dec 3 16:12:03 2015 -0800
Committer: Bridget Bevens <bb...@maprtech.com>
Committed: Thu Dec 3 16:12:03 2015 -0800
----------------------------------------------------------------------
docs/plugin-configuration-basics/index.html | 17 ++++++++++++++++-
feed.xml | 4 ++--
2 files changed, 18 insertions(+), 3 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/drill-site/blob/89710fb3/docs/plugin-configuration-basics/index.html
----------------------------------------------------------------------
diff --git a/docs/plugin-configuration-basics/index.html b/docs/plugin-configuration-basics/index.html
index 6b7dd18..5753742 100644
--- a/docs/plugin-configuration-basics/index.html
+++ b/docs/plugin-configuration-basics/index.html
@@ -1181,7 +1181,22 @@ Using a copy of an existing configuration reduces the risk of JSON coding errors
<h2 id="using-the-formats-attributes">Using the Formats Attributes</h2>
-<p>You set the formats attributes, such as skipFirstLine, in the <code>formats</code> area of the storage plugin configuration. When setting attributes for text files, such as CSV, you also need to set the <code>sys.options</code> property <code>exec.storage.enable_new_text_reader</code> to true (the default). For more information and examples of using formats for text files, see <a href="/docs/text-files-csv-tsv-psv/">"Text Files: CSV, TSV, PSV"</a>.</p>
+<p>You set the formats attributes, such as skipFirstLine, in the <code>formats</code> area of the storage plugin configuration. When setting attributes for text files, such as CSV, you also need to set the <code>sys.options</code> property <code>exec.storage.enable_new_text_reader</code> to true (the default). For more information and examples of using formats for text files, see <a href="/docs/text-files-csv-tsv-psv/">"Text Files: CSV, TSV, PSV"</a>. </p>
+
+<h2 id="using-the-formats-attributes-as-table-function-parameters">Using the Formats Attributes as Table Function Parameters</h2>
+
+<p>You can also set the formats attributes defined above on a per query basis.
+To pass parameters to the format plugin you can use the table function syntax: </p>
+
+<p><code>select a, b from table({table function name}(parameters))</code></p>
+
+<p>The table function name is your table name, the type parameter is the format name and the other parameters are the fields that the configuration of the format plugin accepts as defined in the table above (except for <code>extensions</code> that does not apply in this context).</p>
+
+<p>For example to read a CSV file and parse its header:<br>
+<code>select a, b from table(dfs.</code><code>path/to/data.csv</code><code>(type => 'text',
+fieldDelimiter => ',', extractHeader => true))</code></p>
+
+<p>For more information about format plugin configuration see <a href="/docs/text-files-csv-tsv-psv/">"Text Files: CSV, TSV, PSV"</a>. </p>
<h2 id="using-other-attributes">Using Other Attributes</h2>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/89710fb3/feed.xml
----------------------------------------------------------------------
diff --git a/feed.xml b/feed.xml
index 3d7505c..1f08696 100644
--- a/feed.xml
+++ b/feed.xml
@@ -6,8 +6,8 @@
</description>
<link>/</link>
<atom:link href="/feed.xml" rel="self" type="application/rss+xml"/>
- <pubDate>Thu, 03 Dec 2015 13:56:49 -0800</pubDate>
- <lastBuildDate>Thu, 03 Dec 2015 13:56:49 -0800</lastBuildDate>
+ <pubDate>Thu, 03 Dec 2015 16:09:21 -0800</pubDate>
+ <lastBuildDate>Thu, 03 Dec 2015 16:09:21 -0800</lastBuildDate>
<generator>Jekyll v2.5.2</generator>
<item>