This is an automated email from the ASF dual-hosted git repository.
bridgetb pushed a commit to branch asf-site
in repository https://gitbox.apache.org/repos/asf/drill-site.git
The following commit(s) were added to refs/heads/asf-site by this push:
new 2ad9be1 update install drill on windows
2ad9be1 is described below
commit 2ad9be138a844fd13ea5cdbce5886396f3f56414
Author: Bridget Bevens <[email protected]>
AuthorDate: Fri Apr 5 13:30:48 2019 -0700
update install drill on windows
---
docs/img/install-windows-2-2.png | Bin 0 -> 62872 bytes
docs/img/install-windows-2.png | Bin 0 -> 44607 bytes
docs/img/install-windows-3.png | Bin 0 -> 22135 bytes
docs/img/install-windows-5.png | Bin 0 -> 124029 bytes
docs/img/install-windows-6.png | Bin 0 -> 107507 bytes
docs/img/query_directories_structure.png | Bin 0 -> 64806 bytes
docs/installing-drill-on-windows/index.html | 49 ++++++++++++--
docs/querying-directories/index.html | 85 +++++++++++++++---------
docs/querying-the-information-schema/index.html | 4 +-
feed.xml | 4 +-
10 files changed, 102 insertions(+), 40 deletions(-)
diff --git a/docs/img/install-windows-2-2.png b/docs/img/install-windows-2-2.png
new file mode 100644
index 0000000..ce194d6
Binary files /dev/null and b/docs/img/install-windows-2-2.png differ
diff --git a/docs/img/install-windows-2.png b/docs/img/install-windows-2.png
new file mode 100644
index 0000000..7366f77
Binary files /dev/null and b/docs/img/install-windows-2.png differ
diff --git a/docs/img/install-windows-3.png b/docs/img/install-windows-3.png
new file mode 100644
index 0000000..f958cda
Binary files /dev/null and b/docs/img/install-windows-3.png differ
diff --git a/docs/img/install-windows-5.png b/docs/img/install-windows-5.png
new file mode 100644
index 0000000..2a74e41
Binary files /dev/null and b/docs/img/install-windows-5.png differ
diff --git a/docs/img/install-windows-6.png b/docs/img/install-windows-6.png
new file mode 100644
index 0000000..4a77de0
Binary files /dev/null and b/docs/img/install-windows-6.png differ
diff --git a/docs/img/query_directories_structure.png
b/docs/img/query_directories_structure.png
new file mode 100644
index 0000000..4f3fb9a
Binary files /dev/null and b/docs/img/query_directories_structure.png differ
diff --git a/docs/installing-drill-on-windows/index.html
b/docs/installing-drill-on-windows/index.html
index 56e5c57..107b4f3 100644
--- a/docs/installing-drill-on-windows/index.html
+++ b/docs/installing-drill-on-windows/index.html
@@ -1300,22 +1300,61 @@
</div>
- Dec 30, 2018
+ Apr 5, 2019
<link href="/css/docpage.css" rel="stylesheet" type="text/css">
<div class="int_text" align="left">
- <p>First, check that you <a
href="/docs/embedded-mode-prerequisites">meet the prerequisites</a>, including
setting the JAVA_HOME environment variable, and then install Drill. Currently,
Drill supports 64-bit Windows only. Complete the following steps to install
Drill:</p>
+ <p>Currently, Drill supports 64-bit Windows only. </p>
+
+<h2 id="tools-required">Tools Required</h2>
+
+<p>• Download and install <a
href="https://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html";>JDK</a>.
Select the download for Windows x64.<br>
+• Download and install a utility for unzipping a tar.gz file, such as <a
href="https://www.7-zip.org/download.html";>7-zip</a>. </p>
+
+<h2 id="setting-up-your-windows-environment">Setting Up Your Windows
Environment</h2>
+
+<p>Before you download and install Drill on your Windows machine, complete the
following procedures: </p>
+
+<h3 id="set-the-java_home-and-path-environment-variables">Set the JAVA_HOME
and PATH environment variables.</h3>
+
+<ol>
+<li> Go to System Properties. </li>
+<li> On the Advanced Tab, click Environment Variables.<img
src="https://i.imgur.com/ZQ04USE.png"; alt=""><br></li>
+<li> Click New, and enter JAVA_HOME as the variable name. For the variable
value, enter the path to your JDK installation. Note that instead of using
Program Files in the path name, use progra~1. This is required because Drill
cannot use file paths with spaces.<img src="https://i.imgur.com/sne3pE2.png";
alt=""><br></li>
+<li> Click OK to continue. </li>
+<li> In the System Variables section, select Path and then click Edit.<img
src="https://i.imgur.com/yZAg2aB.png"; alt=""></li>
+<li> In the edit environment variable window, click New and enter
<code>%JAVA_HOME%\bin</code>.<img src="https://i.imgur.com/Bpbjooe.png";
alt=""></li>
+<li> Click OK to continue and exit the System Properties window.<br></li>
+</ol>
+
+<h3 id="create-drill-udf-directories-and-change-the-owner">Create Drill UDF
directories and change the owner.</h3>
+
+<p>Drill has a UDF directories that you must create and assign yourself as
owner (or the user that will start Drill) before starting Drill for the first
time. </p>
+
+<ol>
+<li><p>Run the command prompt as administrator, and issue the following
commands: </p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">
mkdir "%userprofile%\drill"
+ mkdir "%userprofile%\drill\udf"
+ mkdir "%userprofile%\drill\udf\registry"
+ mkdir "%userprofile%\drill\udf\tmp"
+ mkdir "%userprofile%\drill\udf\staging"
+ takeown /R /F "%userprofile%\drill"
+</code></pre></div></li>
+<li><p>To verify that you (or the user that will run Drill) owns the
directories and files, go to the <code>"%userprofile%\drill"</code>
directory, right-click on it, and select Properties from the list.<img
src="https://i.imgur.com/z8WRvqK.png"; alt=""></p></li>
+<li><p>Complete step 2 for all the directories within drill, including the
/udf, /registry, /tmp, and /staging directories. </p></li>
+</ol>
+
+<h2 id="download-and-install-drill">Download and Install Drill</h2>
<ol>
<li>Download the latest version of Apache Drill <a
href="http://www-us.apache.org/dist/drill/drill-1.15.0/apache-drill-1.15.0.tar.gz";>here</a>.</li>
<li>Move the downloaded file to the directory where you want to install
Drill.</li>
-<li>Unzip the GZ file using a third-party tool. If the tool you use does not
unzip the underlying TAR file as well as the GZ file, perform a second unzip to
extract the Drill software. The extraction process creates the installation
directory containing the Drill software. </li>
+<li>Unzip the GZ file using a third-party tool. If the tool you use does not
unzip the underlying TAR file as well as the GZ file, perform a second unzip to
extract the Drill software. The extraction process creates the installation
directory containing the Drill software.<br></li>
+<li><a href="/docs/starting-drill-on-windows">Start Drill</a>. </li>
</ol>
-<p>Now you can <a href="/docs/starting-drill-on-windows">start Drill</a>. </p>
-
<div class="doc-nav">
diff --git a/docs/querying-directories/index.html
b/docs/querying-directories/index.html
index 868c979..a21b055 100644
--- a/docs/querying-directories/index.html
+++ b/docs/querying-directories/index.html
@@ -1300,7 +1300,7 @@
</div>
- Nov 21, 2016
+ Apr 5, 2019
<link href="/css/docpage.css" rel="stylesheet" type="text/css">
@@ -1355,38 +1355,61 @@ records in all of the files inside the
<code>2013</code> directory:</p>
+------------+
| 24000 |
+------------+
-1 row selected (2.607 seconds)
+1 row selected (2.607 seconds)
</code></pre></div>
-<p>You can also use variables <code>dir0</code>, <code>dir1</code>, and so on,
to refer to
-subdirectories in your workspace path. For example, assume that
<code>bob.logdata</code>
-is a workspace that points to the <code>logs</code> directory, which contains
multiple
-subdirectories: <code>2012</code>, <code>2013</code>, and <code>2014</code>.
The following query constrains
-files inside the subdirectory named <code>2013</code>. The variable
<code>dir0</code> refers to the
-first level down from logs, <code>dir1</code> to the next level, and so on.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">0:
jdbc:drill:> USE bob.logdata;
-+------------+-----------------------------------------+
-| ok | summary |
-+------------+-----------------------------------------+
-| true | Default schema changed to 'bob.logdata' |
-+------------+-----------------------------------------+
-1 row selected (0.305 seconds)
+<h2 id="querying-partitioned-directories">Querying Partitioned Directories</h2>
-0: jdbc:drill:> SELECT * FROM logs WHERE dir0='2013' LIMIT 10;
-+------------+------------+------------+------------+------------+------------+------------+------------+------------+-------------+
-| dir0 | dir1 | trans_id | date | time | cust_id
| device | state | camp_id | keywords |
-+------------+------------+------------+------------+------------+------------+------------+------------+------------+-------------+
-| 2013 | 2 | 12115 | 02/23/2013 | 19:48:24 | 3
| IOS5 | az | 5 | who's |
-| 2013 | 2 | 12127 | 02/26/2013 | 19:42:03 | 11459
| IOS5 | wa | 10 | for |
-| 2013 | 2 | 12138 | 02/09/2013 | 05:49:01 | 1
| IOS6 | ca | 7 | minutes |
-| 2013 | 2 | 12139 | 02/23/2013 | 06:58:20 | 1
| AOS4.4 | ms | 7 | i |
-| 2013 | 2 | 12145 | 02/10/2013 | 10:14:56 | 10
| IOS5 | mi | 6 | wrong |
-| 2013 | 2 | 12157 | 02/15/2013 | 02:49:22 | 102
| IOS5 | ny | 5 | want |
-| 2013 | 2 | 12176 | 02/19/2013 | 08:39:02 | 28
| IOS5 | or | 0 | and |
-| 2013 | 2 | 12194 | 02/24/2013 | 08:26:17 | 125445
| IOS5 | ar | 0 | say |
-| 2013 | 2 | 12236 | 02/05/2013 | 01:40:05 | 10
| IOS5 | nj | 2 | sir |
-| 2013 | 2 | 12249 | 02/03/2013 | 04:45:47 | 21725
| IOS5 | nj | 5 | no |
-+------------+------------+------------+------------+------------+------------+------------+------------+------------+-------------+
-10 rows selected (0.583 seconds)
+<p>You can use special variables in Drill to refer to subdirectories in your
+workspace path:</p>
+
+<ul>
+<li>dir0</li>
+<li>dir1</li>
+<li>…</li>
+</ul>
+
+<p>Note that these variables are dynamically determined based on the
partitioning
+of the file system. No up-front definitions are required to identify the
partitions
+that exist. </p>
+
+<p>The following image provides a visual example of a partitioned directory
and a query
+on the directory using variables:</p>
+
+<p><img src="/docs/img/example_query.png" alt="drill query flow"> </p>
+
+<p>When you use directory variables in a query, note that the variables are
relative to the root directory used in the FROM clause.</p>
+
+<p>For example, let's say you create a workspace within the dfs storage
plugin named logs (dfs.logs) that points
+to the /tmp directory in the file system. The /tmp directory contains a /logs
directory (/tmp/logs)
+with the same subdirectories shown in the example image above. You can query
the data in the /logs directory using variables, as shown in the following
examples: </p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">use
dfs.logs;
++------+--------------------------------------+
+| ok | summary |
++------+--------------------------------------+
+| true | Default schema changed to [dfs.logs] |
++------+--------------------------------------+
+
+//The following query constrains files inside the subdirectory named 2013. The
variable dir0 refers to the first level down from logs (root directory).
+
+select * from logs where dir0='2013' limit 3;
++------+------+--------------------------------------+----+------------+-----------+-------------------------+--------+----------------+------------------+-----------+-----------+-----------+---------------------+----------+
+| dir0 | dir1 | registration_dttm | id | first_name |
last_name | email | gender | ip_address | cc
| country | birthdate | salary | title | comments |
++------+------+--------------------------------------+----+------------+-----------+-------------------------+--------+----------------+------------------+-----------+-----------+-----------+---------------------+----------+
+| 2013 | 1 | \x00*\xE9l\xF2\x19\x00\x00N\x7F%\x00 | 1 | Amanda |
Jordan | [email protected] | Female | 1.197.201.2 |
6759521864920116 | Indonesia | 3/8/1971 | 49756.53 | Internal Auditor |
1E+02 |
+| 2013 | 1 | \x00^0\xD0\xE17\x00\x00N\x7F%\x00 | 2 | Albert |
Freeman | [email protected] | Male | 218.111.175.34 |
| Canada | 1/16/1968 | 150280.17 | Accountant IV | |
+| 2013 | 1 | \x00.\xF9"\xCB\x03\x00\x00N\x7F%\x00 | 3 | Evelyn |
Morgan | [email protected] | Female | 7.161.136.94 |
6767119071901597 | Russia | 2/1/1960 | 144972.51 | Structural Engineer |
|
++------+------+--------------------------------------+----+------------+-----------+-------------------------+--------+----------------+------------------+-----------+-----------+-----------+---------------------+----------+
+
+//The following query constrains files inside the subdirectory named 1. The
variable dir0 refers to the first level down from 2013 (the root directory
now).
+
+select * from `logs/2013` where dir0='1' limit 3;
++------+--------------------------------------+----+------------+-----------+-------------------------+--------+----------------+------------------+-----------+-----------+-----------+---------------------+----------+
+| dir0 | registration_dttm | id | first_name | last_name |
email | gender | ip_address | cc | country
| birthdate | salary | title | comments |
++------+--------------------------------------+----+------------+-----------+-------------------------+--------+----------------+------------------+-----------+-----------+-----------+---------------------+----------+
+| 1 | \x00*\xE9l\xF2\x19\x00\x00N\x7F%\x00 | 1 | Amanda | Jordan |
[email protected] | Female | 1.197.201.2 | 6759521864920116 |
Indonesia | 3/8/1971 | 49756.53 | Internal Auditor | 1E+02 |
+| 1 | \x00^0\xD0\xE17\x00\x00N\x7F%\x00 | 2 | Albert | Freeman |
[email protected] | Male | 218.111.175.34 | | Canada
| 1/16/1968 | 150280.17 | Accountant IV | |
+| 1 | \x00.\xF9"\xCB\x03\x00\x00N\x7F%\x00 | 3 | Evelyn | Morgan
| [email protected] | Female | 7.161.136.94 | 6767119071901597 |
Russia | 2/1/1960 | 144972.51 | Structural Engineer | |
++------+--------------------------------------+----+------------+-----------+-------------------------+--------+----------------+------------------+-----------+-----------+-----------+---------------------+----------+
</code></pre></div>
<p>You can use <a href="/docs/query-directory-functions/">query directory
functions</a> to restrict a query to one of a number of subdirectories and to
prevent Drill from scanning all data in directories.</p>
diff --git a/docs/querying-the-information-schema/index.html
b/docs/querying-the-information-schema/index.html
index 23ac997..afbd216 100644
--- a/docs/querying-the-information-schema/index.html
+++ b/docs/querying-the-information-schema/index.html
@@ -1298,7 +1298,7 @@
</div>
- Nov 7, 2018
+ Apr 5, 2019
<link href="/css/docpage.css" rel="stylesheet" type="text/css">
@@ -1545,7 +1545,7 @@ dfs.default CustomerSocialProfile VIEW
</code></pre></div>
<div class="admonition note">
<p class="first admonition-title">Note</p>
- <p class="last">Currently, Drill only supports querying Drill views; Hive
views are not yet supported. </p>
+ <p class="last">Starting in Drill 1.16, Drill can query Hive views. </p>
</div>
<p>You can run a similar query to identify columns in tables and the data types
diff --git a/feed.xml b/feed.xml
index 2fe81da..3915638 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>Wed, 27 Feb 2019 15:00:17 -0800</pubDate>
- <lastBuildDate>Wed, 27 Feb 2019 15:00:17 -0800</lastBuildDate>
+ <pubDate>Fri, 05 Apr 2019 13:26:25 -0700</pubDate>
+ <lastBuildDate>Fri, 05 Apr 2019 13:26:25 -0700</lastBuildDate>
<generator>Jekyll v2.5.2</generator>
<item>
![https://i.imgur.com/ZQ04USE.png"](https://i.imgur.com/ZQ04USE.png"){kind=link}
![https://i.imgur.com/sne3pE2.png"](https://i.imgur.com/sne3pE2.png"){kind=link}
![https://i.imgur.com/yZAg2aB.png"](https://i.imgur.com/yZAg2aB.png"){kind=link}
![https://i.imgur.com/Bpbjooe.png"](https://i.imgur.com/Bpbjooe.png"){kind=link}
![https://i.imgur.com/z8WRvqK.png"](https://i.imgur.com/z8WRvqK.png"){kind=link}