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/07/17 23:47:25 UTC
drill-site git commit: drill updates/edits for 1.1
Repository: drill-site
Updated Branches:
refs/heads/asf-site d0ba86f3b -> c3ff31ca0
drill updates/edits for 1.1
Project: http://git-wip-us.apache.org/repos/asf/drill-site/repo
Commit: http://git-wip-us.apache.org/repos/asf/drill-site/commit/c3ff31ca
Tree: http://git-wip-us.apache.org/repos/asf/drill-site/tree/c3ff31ca
Diff: http://git-wip-us.apache.org/repos/asf/drill-site/diff/c3ff31ca
Branch: refs/heads/asf-site
Commit: c3ff31ca03921155b9911ecec2ba63cdab46568f
Parents: d0ba86f
Author: Bridget Bevens <bb...@maprtech.com>
Authored: Fri Jul 17 14:47:11 2015 -0700
Committer: Bridget Bevens <bb...@maprtech.com>
Committed: Fri Jul 17 14:47:11 2015 -0700
----------------------------------------------------------------------
.../index.html | 18 ++++++++++-----
docs/drill-in-10-minutes/index.html | 24 ++++++++++----------
.../index.html | 4 ++--
.../index.html | 6 ++---
docs/plugin-configuration-basics/index.html | 14 ++----------
docs/text-files-csv-tsv-psv/index.html | 2 +-
feed.xml | 4 ++--
7 files changed, 34 insertions(+), 38 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/drill-site/blob/c3ff31ca/docs/aggregate-and-aggregate-statistical/index.html
----------------------------------------------------------------------
diff --git a/docs/aggregate-and-aggregate-statistical/index.html b/docs/aggregate-and-aggregate-statistical/index.html
index 248f1c8..eb8bb72 100644
--- a/docs/aggregate-and-aggregate-statistical/index.html
+++ b/docs/aggregate-and-aggregate-statistical/index.html
@@ -1250,12 +1250,18 @@ SELECT SUM(salary) FROM cp.`employee.json` WHERE employee_id IN (1139, 1140, 114
<p>Drill provides following aggregate statistics functions:</p>
<ul>
-<li>stddev(expression) </li>
-<li>stddev_pop(expression)</li>
-<li>stddev_samp(expression)</li>
-<li>variance(expression)</li>
-<li>var_pop(expression)</li>
-<li>var_samp(expression)</li>
+<li>stddev(expression)<br>
+An alias for stddev_samp</li>
+<li>stddev_pop(expression)
+Population standard deviate of input values</li>
+<li>stddev_samp(expression)
+Sample standard deviate of input values</li>
+<li>variance(expression)
+An alias for var_samp</li>
+<li>var_pop(expression)
+Population variance of input values (the population standard deviated squared)</li>
+<li>var_samp(expression)
+Sample variance of input values (sample standard deviation squared)</li>
</ul>
<p>These functions take a SMALLINT, INTEGER, BIGINT, FLOAT, DOUBLE, or DECIMAL expression as the argument. If the expression is FLOAT, the function returns DOUBLE; otherwise, the function returns DECIMAL.</p>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/c3ff31ca/docs/drill-in-10-minutes/index.html
----------------------------------------------------------------------
diff --git a/docs/drill-in-10-minutes/index.html b/docs/drill-in-10-minutes/index.html
index 19d461e..7bbfde8 100644
--- a/docs/drill-in-10-minutes/index.html
+++ b/docs/drill-in-10-minutes/index.html
@@ -1046,22 +1046,22 @@ Java HotSpot(TM) 64-Bit Server VM (build 24.79-b02, mixed mode)
<ol>
<li><p>In a terminal windows, change to the directory where you want to install Drill.</p></li>
-<li><p>To download the latest version of Apache Drill, download Drill from the <a href="http://getdrill.org/drill/download/apache-drill-1.0.0.tar.gz">Drill web site</a> or run one of the following commands, depending on which you have installed on your system:</p></li>
+<li><p>To download the latest version of Apache Drill, download Drill from the <a href="http://getdrill.org/drill/download/apache-drill-1.1.0.tar.gz">Drill web site</a> or run one of the following commands, depending on which you have installed on your system:</p></li>
</ol>
<ul>
-<li><code>wget http://getdrill.org/drill/download/apache-drill-1.0.0.tar.gz</code><br></li>
-<li> <code>curl -o apache-drill-1.0.0.tar.gz http://getdrill.org/drill/download/apache-drill-1.0.0.tar.gz</code><br></li>
+<li><code>wget http://getdrill.org/drill/download/apache-drill-1.1.0.tar.gz</code><br></li>
+<li> <code>curl -o apache-drill-1.1.0.tar.gz http://getdrill.org/drill/download/apache-drill-1.1.0.tar.gz</code><br></li>
</ul>
<ol>
<li><p>Copy the downloaded file to the directory where you want to install Drill. </p></li>
<li><p>Extract the contents of the Drill tar.gz file. Use sudo only if necessary: </p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">tar -xvzf apache-drill-1.0.0.tar.gz
+<div class="highlight"><pre><code class="language-text" data-lang="text">tar -xvzf apache-drill-1.1.0.tar.gz
</code></pre></div></li>
</ol>
-<p>The extraction process creates the installation directory named apache-drill-1.0.0 containing the Drill software.</p>
+<p>The extraction process creates the installation directory named apache-drill-1.1.0 containing the Drill software.</p>
<p>At this point, you can start Drill.</p>
@@ -1071,7 +1071,7 @@ Java HotSpot(TM) 64-Bit Server VM (build 24.79-b02, mixed mode)
<ol>
<li><p>Navigate to the Drill installation directory. For example: </p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">cd apache-drill-1.0.0
+<div class="highlight"><pre><code class="language-text" data-lang="text">cd apache-drill-1.1.0
</code></pre></div></li>
<li><p>Issue the following command to launch Drill in embedded mode:</p>
<div class="highlight"><pre><code class="language-text" data-lang="text">bin/drill-embedded
@@ -1087,9 +1087,9 @@ Java HotSpot(TM) 64-Bit Server VM (build 24.79-b02, mixed mode)
<p>You can install Drill on Windows 7 or 8. First, set the JAVA_HOME environment variable, and then install Drill. Complete the following steps to install Drill:</p>
<ol>
-<li>Click the following link to download the latest version of Apache Drill: <a href="http://getdrill.org/drill/download/apache-drill-1.0.0.tar.gz">http://getdrill.org/drill/download/apache-drill-1.0.0.tar.gz</a><br></li>
-<li>Move the <code>apache-drill-1.0.0.tar.gz</code> file to a directory where you want to install Drill.<br></li>
-<li>Unzip the <code>TAR.GZ</code> file using a third-party tool. If the tool you use does not unzip the TAR file as well as the <code>TAR.GZ</code> file, unzip the <code>apache-drill-1.0.0.tar</code> to extract the Drill software. The extraction process creates the installation directory named apache-drill-1.0.0 containing the Drill software. For example:<br>
+<li>Click the following link to download the latest version of Apache Drill: <a href="http://getdrill.org/drill/download/apache-drill-1.1.0.tar.gz">http://getdrill.org/drill/download/apache-drill-1.1.0.tar.gz</a><br></li>
+<li>Move the <code>apache-drill-1.1.0.tar.gz</code> file to a directory where you want to install Drill.<br></li>
+<li>Unzip the <code>TAR.GZ</code> file using a third-party tool. If the tool you use does not unzip the TAR file as well as the <code>TAR.GZ</code> file, unzip the <code>apache-drill-1.1.0.tar</code> to extract the Drill software. The extraction process creates the installation directory named apache-drill-1.1.0 containing the Drill software. For example:<br>
<img src="/docs/img/drill-directory.png" alt="drill install dir"></li>
</ol>
@@ -1103,8 +1103,8 @@ Java HotSpot(TM) 64-Bit Server VM (build 24.79-b02, mixed mode)
<ol>
<li>Open Command Prompt.<br></li>
-<li>Open the apache-drill-1.0.0 folder. For example:<br>
-<code>cd apache-drill-1.0.0</code></li>
+<li>Open the apache-drill-1.1.0 folder. For example:<br>
+<code>cd apache-drill-1.1.0</code></li>
<li>Go to the bin directory. For example:<br>
<code>cd bin</code></li>
<li>Type the following command on the command line:
@@ -1195,7 +1195,7 @@ your operating system:</p>
<div class="highlight"><pre><code class="language-text" data-lang="text"> SELECT * FROM dfs.`<path-to-installation>/apache-drill-<version>/sample-data/nation.parquet`;
</code></pre></div>
<p>The query returns the following results:</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT * FROM dfs.`Users/khahn/drill/apache-drill-1.0.0-SNAPSHOT/sample-data/nation.parquet`;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT * FROM dfs.`Users/khahn/drill/apache-drill-1.1.0-SNAPSHOT/sample-data/nation.parquet`;
+--------------+-----------------+--------------+-----------------------+
| N_NATIONKEY | N_NAME | N_REGIONKEY | N_COMMENT |
+--------------+-----------------+--------------+-----------------------+
http://git-wip-us.apache.org/repos/asf/drill-site/blob/c3ff31ca/docs/getting-to-know-the-drill-sandbox/index.html
----------------------------------------------------------------------
diff --git a/docs/getting-to-know-the-drill-sandbox/index.html b/docs/getting-to-know-the-drill-sandbox/index.html
index d598df5..a1d9960 100644
--- a/docs/getting-to-know-the-drill-sandbox/index.html
+++ b/docs/getting-to-know-the-drill-sandbox/index.html
@@ -1014,8 +1014,8 @@ Welcome to your Mapr Demo virtual machine.
<p>Drill includes a shell for connecting to relational databases and executing SQL commands. On the sandbox, the Drill shell runs in embedded mode. After logging into the sandbox, use the <code>SQLLine</code> command. The Drill shell appears, and you can run Drill queries. </p>
<div class="highlight"><pre><code class="language-text" data-lang="text">[mapr@maprdemo ~]$ sqlline
-apache drill 1.0.0
-"the only truly happy people are children, the creative minority and drill users"
+apache drill 1.1.0
+"Does your data know the Drill?"
0: jdbc:drill:>
</code></pre></div>
<p>In this tutorial you query a number of data sets, including Hive and HBase, and files on the file system, such as CSV, JSON, and Parquet files. To access these diverse data sources, you connect Drill to storage plugins. </p>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/c3ff31ca/docs/installing-the-apache-drill-sandbox/index.html
----------------------------------------------------------------------
diff --git a/docs/installing-the-apache-drill-sandbox/index.html b/docs/installing-the-apache-drill-sandbox/index.html
index 7e54076..a23059c 100644
--- a/docs/installing-the-apache-drill-sandbox/index.html
+++ b/docs/installing-the-apache-drill-sandbox/index.html
@@ -1053,10 +1053,10 @@ VMware Player or VMware Fusion:</p>
<p>If you are running VMware Fusion, select <strong>Import</strong>. </p>
<p><img src="/docs/img/vmWelcome.png" alt="drill query flow"></p></li>
-<li><p>Navigate to the directory where you downloaded the MapR Sandbox with Apache Drill file, and select <code>MapR-Sandbox-For-Apache-Drill-1.0.0-4.1.0-vmware.ova</code>.<br>
+<li><p>Navigate to the directory where you downloaded the MapR Sandbox with Apache Drill file, and select <code>MapR-Sandbox-For-Apache-Drill-<version>-<version>-vmware.ova</code>.<br>
The Import Virtual Machine dialog appears.</p></li>
<li><p>Click <strong>Import</strong>. The virtual machine player imports the sandbox. </p></li>
-<li><p>Select <code>MapR-Sandbox-For-Apache-Drill-4.1.0_VM</code>, and click <strong>Play virtual machine</strong>. It takes a few minutes for the MapR services to start. </p>
+<li><p>Select <code>MapR-Sandbox-For-Apache-Drill-<version>_VM</code>, and click <strong>Play virtual machine</strong>. It takes a few minutes for the MapR services to start. </p>
<p>After the MapR services start and installation completes, the following screen
appears:</p>
@@ -1097,7 +1097,7 @@ VirtualBox:</p>
<li><p>Select <strong>File > Import Appliance</strong>. The Import Virtual Appliance dialog appears.</p>
<p><img src="/docs/img/vbImport.png" alt="drill query flow"></p></li>
-<li><p>Navigate to the directory where you downloaded the MapR Sandbox with Apache Drill, select MapR-Sandbox-For-Apache-Drill-1.0.0-4.1.0.ova, and click <strong>Next</strong>. The Appliance Settings window appears.</p>
+<li><p>Navigate to the directory where you downloaded the MapR Sandbox with Apache Drill, select MapR-Sandbox-For-Apache-Drill-<version>-<version>.ova, and click <strong>Next</strong>. The Appliance Settings window appears.</p>
<p><img src="/docs/img/vbApplSettings.png" alt="drill query flow"></p></li>
<li><p>Select the check box at the bottom of the screen: <strong>Reinitialize the MAC address of all network cards</strong>, then click <strong>Import</strong>. The Import Appliance imports the sandbox.</p></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/c3ff31ca/docs/plugin-configuration-basics/index.html
----------------------------------------------------------------------
diff --git a/docs/plugin-configuration-basics/index.html b/docs/plugin-configuration-basics/index.html
index 7c15bf9..1346d22 100644
--- a/docs/plugin-configuration-basics/index.html
+++ b/docs/plugin-configuration-basics/index.html
@@ -1131,19 +1131,9 @@ name. Names are case-sensitive.</li>
<p>* Pertains only to distributed drill installations using the mapr-drill package. </p>
-<h2 id="using-the-formats">Using the Formats</h2>
+<h2 id="using-the-formats-attributes">Using the Formats Attributes</h2>
-<p>You can use the following attributes in the <code>formats</code> area of the storage plugin configuration. When setting these attributes, you also need to set the <code>sys.options</code> property <code>exec.storage.enable_new_text_reader</code> to true (the default):</p>
-
-<ul>
-<li>comment<br></li>
-<li>escape<br></li>
-<li>fieldDeliimiter<br></li>
-<li>quote<br></li>
-<li>skipFirstLine</li>
-</ul>
-
-<p>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-other-attributes">Using Other Attributes</h2>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/c3ff31ca/docs/text-files-csv-tsv-psv/index.html
----------------------------------------------------------------------
diff --git a/docs/text-files-csv-tsv-psv/index.html b/docs/text-files-csv-tsv-psv/index.html
index 4c411e1..efb3f9c 100644
--- a/docs/text-files-csv-tsv-psv/index.html
+++ b/docs/text-files-csv-tsv-psv/index.html
@@ -1035,7 +1035,7 @@ VARCHARS, rather than individual columns. While parquet supports and Drill reads
<ul>
<li>comment<br></li>
<li>escape<br></li>
-<li>deliimiter<br></li>
+<li>delimiter<br></li>
<li>quote<br></li>
<li>skipFirstLine</li>
</ul>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/c3ff31ca/feed.xml
----------------------------------------------------------------------
diff --git a/feed.xml b/feed.xml
index 8e3f4ea..ed7fa12 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, 16 Jul 2015 18:16:54 -0700</pubDate>
- <lastBuildDate>Thu, 16 Jul 2015 18:16:54 -0700</lastBuildDate>
+ <pubDate>Fri, 17 Jul 2015 14:39:38 -0700</pubDate>
+ <lastBuildDate>Fri, 17 Jul 2015 14:39:38 -0700</lastBuildDate>
<generator>Jekyll v2.5.2</generator>
<item>