drill-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bridg...@apache.org
Subject drill git commit: DRILL-3489
Date Fri, 17 Jul 2015 21:37:03 GMT
Repository: drill
Updated Branches:
  refs/heads/gh-pages 73fe89d8e -> d39bfe8cc


DRILL-3489

one-liners about agg-stat

Bridget's changes


Project: http://git-wip-us.apache.org/repos/asf/drill/repo
Commit: http://git-wip-us.apache.org/repos/asf/drill/commit/d39bfe8c
Tree: http://git-wip-us.apache.org/repos/asf/drill/tree/d39bfe8c
Diff: http://git-wip-us.apache.org/repos/asf/drill/diff/d39bfe8c

Branch: refs/heads/gh-pages
Commit: d39bfe8cc711fc905bb92fb64febca1d1e62f090
Parents: 73fe89d
Author: Kristine Hahn <khahn@maprtech.com>
Authored: Fri Jul 17 14:18:17 2015 -0700
Committer: Kristine Hahn <khahn@maprtech.com>
Committed: Fri Jul 17 14:33:19 2015 -0700

----------------------------------------------------------------------
 .../035-plugin-configuration-basics.md          | 12 ++--------
 .../060-text-files-csv-tsv-psv.md               |  2 +-
 .../050-aggregate-and-aggregate-statistical.md  |  8 ++++++-
 _docs/tutorials/020-drill-in-10-minutes.md      | 24 ++++++++++----------
 .../010-installing-the-apache-drill-sandbox.md  |  6 ++---
 .../020-getting-to-know-the-drill-sandbox.md    |  4 ++--
 6 files changed, 27 insertions(+), 29 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/drill/blob/d39bfe8c/_docs/connect-a-data-source/035-plugin-configuration-basics.md
----------------------------------------------------------------------
diff --git a/_docs/connect-a-data-source/035-plugin-configuration-basics.md b/_docs/connect-a-data-source/035-plugin-configuration-basics.md
index cfa7cde..3319581 100644
--- a/_docs/connect-a-data-source/035-plugin-configuration-basics.md
+++ b/_docs/connect-a-data-source/035-plugin-configuration-basics.md
@@ -125,17 +125,9 @@ The following table describes the attributes you configure for storage
plugins i
 
 \* Pertains only to distributed drill installations using the mapr-drill package.  
 
-## Using the Formats
+## Using the Formats Attributes
 
-You can use the following attributes in the `formats` area of the storage plugin configuration.
When setting these attributes, you also need to set the `sys.options` property `exec.storage.enable_new_text_reader`
to true (the default):
-
-* comment  
-* escape  
-* fieldDeliimiter  
-* quote  
-* skipFirstLine
-
-For more information and examples of using formats for text files, see ["Text Files: CSV,
TSV, PSV"]({{site.baseurl}}{{site.baseurl}}/docs/text-files-csv-tsv-psv/).
+You set the formats attributes, such as skipFirstLine, in the `formats` area of the storage
plugin configuration. When setting attributes for text files, such as CSV, you also need to
set the `sys.options` property `exec.storage.enable_new_text_reader` to true (the default).
For more information and examples of using formats for text files, see ["Text Files: CSV,
TSV, PSV"]({{site.baseurl}}{{site.baseurl}}/docs/text-files-csv-tsv-psv/).
 
 ## Using Other Attributes
 

http://git-wip-us.apache.org/repos/asf/drill/blob/d39bfe8c/_docs/data-sources-and-file-formats/060-text-files-csv-tsv-psv.md
----------------------------------------------------------------------
diff --git a/_docs/data-sources-and-file-formats/060-text-files-csv-tsv-psv.md b/_docs/data-sources-and-file-formats/060-text-files-csv-tsv-psv.md
index bd689be..4d34954 100644
--- a/_docs/data-sources-and-file-formats/060-text-files-csv-tsv-psv.md
+++ b/_docs/data-sources-and-file-formats/060-text-files-csv-tsv-psv.md
@@ -33,7 +33,7 @@ In the storage plugin configuration, you [set the attributes]({{site.baseurl}}/d
 
 * comment  
 * escape  
-* deliimiter  
+* delimiter  
 * quote  
 * skipFirstLine
 

http://git-wip-us.apache.org/repos/asf/drill/blob/d39bfe8c/_docs/sql-reference/sql-functions/050-aggregate-and-aggregate-statistical.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-functions/050-aggregate-and-aggregate-statistical.md
b/_docs/sql-reference/sql-functions/050-aggregate-and-aggregate-statistical.md
index 1ce7def..4fc886b 100644
--- a/_docs/sql-reference/sql-functions/050-aggregate-and-aggregate-statistical.md
+++ b/_docs/sql-reference/sql-functions/050-aggregate-and-aggregate-statistical.md
@@ -237,11 +237,17 @@ SELECT SUM(salary) FROM cp.`employee.json` WHERE employee_id IN (1139,
1140, 114
 
 Drill provides following aggregate statistics functions:
 
-* stddev(expression) 
+* stddev(expression)  
+  An alias for stddev_samp
 * stddev_pop(expression)
+  Population standard deviate of input values
 * stddev_samp(expression)
+  Sample standard deviate of input values
 * variance(expression)
+  An alias for var_samp
 * var_pop(expression)
+  Population variance of input values (the population standard deviated squared)
 * var_samp(expression)
+  Sample variance of input values (sample standard deviation squared)
   
 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.

http://git-wip-us.apache.org/repos/asf/drill/blob/d39bfe8c/_docs/tutorials/020-drill-in-10-minutes.md
----------------------------------------------------------------------
diff --git a/_docs/tutorials/020-drill-in-10-minutes.md b/_docs/tutorials/020-drill-in-10-minutes.md
index cf21743..cbc1a62 100755
--- a/_docs/tutorials/020-drill-in-10-minutes.md
+++ b/_docs/tutorials/020-drill-in-10-minutes.md
@@ -45,18 +45,18 @@ Complete the following steps to install Drill:
 
 1. In a terminal windows, change to the directory where you want to install Drill.
 
-2. To download the latest version of Apache Drill, download Drill from the [Drill web site](http://getdrill.org/drill/download/apache-drill-1.0.0.tar.gz)
or run one of the following commands, depending on which you have installed on your system:
+2. To download the latest version of Apache Drill, download Drill from the [Drill web site](http://getdrill.org/drill/download/apache-drill-1.1.0.tar.gz)
or run one of the following commands, depending on which you have installed on your system:
 
-   * `wget http://getdrill.org/drill/download/apache-drill-1.0.0.tar.gz`  
-   *  `curl -o apache-drill-1.0.0.tar.gz http://getdrill.org/drill/download/apache-drill-1.0.0.tar.gz`
 
+   * `wget http://getdrill.org/drill/download/apache-drill-1.1.0.tar.gz`  
+   *  `curl -o apache-drill-1.1.0.tar.gz http://getdrill.org/drill/download/apache-drill-1.1.0.tar.gz`
 
 
 3. Copy the downloaded file to the directory where you want to install Drill. 
 
 4. Extract the contents of the Drill tar.gz file. Use sudo only if necessary:  
 
-        tar -xvzf apache-drill-1.0.0.tar.gz  
+        tar -xvzf apache-drill-1.1.0.tar.gz  
 
-The extraction process creates the installation directory named apache-drill-1.0.0 containing
the Drill software.
+The extraction process creates the installation directory named apache-drill-1.1.0 containing
the Drill software.
 
 At this point, you can start Drill.
 
@@ -65,7 +65,7 @@ Start Drill in embedded mode using the `drill-embedded` command:
 
 1. Navigate to the Drill installation directory. For example:  
 
-        cd apache-drill-1.0.0  
+        cd apache-drill-1.1.0  
 
 2. Issue the following command to launch Drill in embedded mode:
 
@@ -79,9 +79,9 @@ Start Drill in embedded mode using the `drill-embedded` command:
 
 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:
 
-1. Click the following link to download the latest version of Apache Drill:  [http://getdrill.org/drill/download/apache-drill-1.0.0.tar.gz](http://getdrill.org/drill/download/apache-drill-1.0.0.tar.gz)
 
-2. Move the `apache-drill-1.0.0.tar.gz` file to a directory where you want to install Drill.
 
-3. Unzip the `TAR.GZ` file using a third-party tool. If the tool you use does not unzip the
TAR file as well as the `TAR.GZ` file, unzip the `apache-drill-1.0.0.tar` to extract the Drill
software. The extraction process creates the installation directory named apache-drill-1.0.0
containing the Drill software. For example:  
+1. Click the following link to download the latest version of Apache Drill:  [http://getdrill.org/drill/download/apache-drill-1.1.0.tar.gz](http://getdrill.org/drill/download/apache-drill-1.1.0.tar.gz)
 
+2. Move the `apache-drill-1.1.0.tar.gz` file to a directory where you want to install Drill.
 
+3. Unzip the `TAR.GZ` file using a third-party tool. If the tool you use does not unzip the
TAR file as well as the `TAR.GZ` file, unzip the `apache-drill-1.1.0.tar` to extract the Drill
software. The extraction process creates the installation directory named apache-drill-1.1.0
containing the Drill software. For example:  
    ![drill install dir]({{ site.baseurl }}/docs/img/drill-directory.png)
 
 At this point, you can start Drill.  
@@ -92,8 +92,8 @@ Start Drill by running the sqlline.bat file and typing a connection string,
as s
 Start the Drill shell using the **sqlline command**. The `zk=local` means the local node
is the ZooKeeper node. Complete the following steps to launch the Drill shell:
 
 1. Open Command Prompt.  
-2. Open the apache-drill-1.0.0 folder. For example:  
-   ``cd apache-drill-1.0.0``
+2. Open the apache-drill-1.1.0 folder. For example:  
+   ``cd apache-drill-1.1.0``
 3. Go to the bin directory. For example:  
    ``cd bin``
 4. Type the following command on the command line:
@@ -184,7 +184,7 @@ your operating system:
 
 The query returns the following results:
 
-    SELECT * FROM dfs.`Users/khahn/drill/apache-drill-1.0.0-SNAPSHOT/sample-data/nation.parquet`;
+    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/blob/d39bfe8c/_docs/tutorials/learn-drill-with-the-mapr-sandbox/010-installing-the-apache-drill-sandbox.md
----------------------------------------------------------------------
diff --git a/_docs/tutorials/learn-drill-with-the-mapr-sandbox/010-installing-the-apache-drill-sandbox.md
b/_docs/tutorials/learn-drill-with-the-mapr-sandbox/010-installing-the-apache-drill-sandbox.md
index 875dd4b..a5b4c7d 100755
--- a/_docs/tutorials/learn-drill-with-the-mapr-sandbox/010-installing-the-apache-drill-sandbox.md
+++ b/_docs/tutorials/learn-drill-with-the-mapr-sandbox/010-installing-the-apache-drill-sandbox.md
@@ -44,10 +44,10 @@ VMware Player or VMware Fusion:
     If you are running VMware Fusion, select **Import**.  
 
     ![drill query flow]({{ site.baseurl }}/docs/img/vmWelcome.png)
-3. Navigate to the directory where you downloaded the MapR Sandbox with Apache Drill file,
and select `MapR-Sandbox-For-Apache-Drill-1.0.0-4.1.0-vmware.ova`.  
+3. Navigate to the directory where you downloaded the MapR Sandbox with Apache Drill file,
and select `MapR-Sandbox-For-Apache-Drill-<version>-<version>-vmware.ova`.  
     The Import Virtual Machine dialog appears.
 4. Click **Import**. The virtual machine player imports the sandbox.  
-5. Select `MapR-Sandbox-For-Apache-Drill-4.1.0_VM`, and click **Play virtual machine**. It
takes a few minutes for the MapR services to start.  
+5. Select `MapR-Sandbox-For-Apache-Drill-<version>_VM`, and click **Play virtual machine**.
It takes a few minutes for the MapR services to start.  
 
      After the MapR services start and installation completes, the following screen
 appears:
@@ -84,7 +84,7 @@ VirtualBox:
 3. Select **File > Import Appliance**. The Import Virtual Appliance dialog appears.
 
      ![drill query flow]({{ site.baseurl }}/docs/img/vbImport.png)
-4. 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 **Next**. The Appliance Settings
window appears.
+4. Navigate to the directory where you downloaded the MapR Sandbox with Apache Drill, select
MapR-Sandbox-For-Apache-Drill-<version>-<version>.ova, and click **Next**. The
Appliance Settings window appears.
 
      ![drill query flow]({{ site.baseurl }}/docs/img/vbApplSettings.png)
 5. Select the check box at the bottom of the screen: **Reinitialize the MAC address of all
network cards**, then click **Import**. The Import Appliance imports the sandbox.

http://git-wip-us.apache.org/repos/asf/drill/blob/d39bfe8c/_docs/tutorials/learn-drill-with-the-mapr-sandbox/020-getting-to-know-the-drill-sandbox.md
----------------------------------------------------------------------
diff --git a/_docs/tutorials/learn-drill-with-the-mapr-sandbox/020-getting-to-know-the-drill-sandbox.md
b/_docs/tutorials/learn-drill-with-the-mapr-sandbox/020-getting-to-know-the-drill-sandbox.md
old mode 100644
new mode 100755
index 133bb7d..5625b30
--- a/_docs/tutorials/learn-drill-with-the-mapr-sandbox/020-getting-to-know-the-drill-sandbox.md
+++ b/_docs/tutorials/learn-drill-with-the-mapr-sandbox/020-getting-to-know-the-drill-sandbox.md
@@ -15,8 +15,8 @@ Using the secure shell instead of the VM interface has some advantages.
You can
 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 `SQLLine` command. The Drill shell appears, and you can run Drill queries.  
 
     [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:>
 
 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. 


Mime
View raw message