drill-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bridg...@apache.org
Subject drill-site git commit: updates for 1.2 and edits from user feedback
Date Thu, 01 Oct 2015 22:55:49 GMT
Repository: drill-site
Updated Branches:
  refs/heads/asf-site 72602b140 -> c3316159f


updates for 1.2 and edits from user feedback


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

Branch: refs/heads/asf-site
Commit: c3316159f175875e16b1ad717fb22ee68f040a42
Parents: 72602b1
Author: Bridget Bevens <bbevens@maprtech.com>
Authored: Thu Oct 1 15:55:05 2015 -0700
Committer: Bridget Bevens <bbevens@maprtech.com>
Committed: Thu Oct 1 15:55:05 2015 -0700

----------------------------------------------------------------------
 docs/configuring-the-drill-shell/index.html     |  10 ++++++++-
 docs/configuring-user-authentication/index.html |  21 ++++++++++++++++++-
 .../index.html                                  |   2 +-
 docs/drill-introduction/index.html              |  19 +++++++++++++++++
 docs/img/web-ui-admin-view.png                  | Bin 45382 -> 45701 bytes
 docs/img/web-ui.png                             | Bin 42637 -> 42297 bytes
 docs/parquet-format/index.html                  |   8 ++++++-
 docs/plugin-configuration-basics/index.html     |   2 +-
 docs/starting-the-web-console/index.html        |  12 ++++-------
 feed.xml                                        |   4 ++--
 10 files changed, 63 insertions(+), 15 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/drill-site/blob/c3316159/docs/configuring-the-drill-shell/index.html
----------------------------------------------------------------------
diff --git a/docs/configuring-the-drill-shell/index.html b/docs/configuring-the-drill-shell/index.html
index 4a04bc1..31d14f8 100644
--- a/docs/configuring-the-drill-shell/index.html
+++ b/docs/configuring-the-drill-shell/index.html
@@ -1015,7 +1015,7 @@
 </tr>
 <tr>
 <td>!connect</td>
-<td>Open a new connection to the database.</td>
+<td>Open a new connection to the database. Use this command to hide the password when
starting Drill in authentication mode.</td>
 </tr>
 <tr>
 <td>!help</td>
@@ -1075,6 +1075,14 @@
 </tr>
 </tbody></table>
 
+<h2 id="example-of-hiding-the-password-when-starting-drill">Example of Hiding the Password
When Starting Drill</h2>
+
+<p>When starting Drill in authentication mode, you can use the <strong>!connect</strong>
command as shown in the section, <a href="/docs/configuring-user-authentication/#user-authentication-process">&quot;User
Authentication Process&quot;</a>, instead of the <strong>sqlline</strong>,
<strong>drill-embedded</strong>, or <strong>drill-distributed</strong>
commands. For example, after running the sqlline script, you enter this command to connect
to Drill:</p>
+
+<p><code>sqlline&gt; !connect jdbc:drill:zk=localhost:2181</code> 
</p>
+
+<p>When prompted you enter a user name and password, which is hidden as you type it.</p>
+
 <h2 id="examples-of-configuring-the-drill-shell">Examples of Configuring the Drill
Shell</h2>
 
 <p>For example, quit the Drill shell:</p>

http://git-wip-us.apache.org/repos/asf/drill-site/blob/c3316159/docs/configuring-user-authentication/index.html
----------------------------------------------------------------------
diff --git a/docs/configuring-user-authentication/index.html b/docs/configuring-user-authentication/index.html
index a83e2d0..44cd15e 100644
--- a/docs/configuring-user-authentication/index.html
+++ b/docs/configuring-user-authentication/index.html
@@ -1010,9 +1010,28 @@
 
 <p>When user authentication is enabled, each user that accesses the Drillbit process
through a client, such as SQLLine, must provide their username and password for access. </p>
 
-<p>When launching SQLLine, a user must include the <code>–n</code> and
<code>–p</code> parameters with their username and password in the SQLLine argument:<br>
+<p>A user can include the <code>–n</code> and <code>–p</code>
parameters with their username and password when launching SQLLine, as shown in the following
example:<br>
        <code>sqlline –u jdbc:drill:zk=10.10.11.112:5181 –n bob –p bobdrill</code></p>
 
+<p>Alternatively, a user can launch SQLLine and then issue the <code>!connect</code>
command to hide the password, as shown in the following procedure:  </p>
+
+<ol>
+<li><p>Start SQLLine, by running the sqlline script. On Linux, for example: 
</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">
     bobsmachine:~$ /etc/drill/bin/sqlline
+      apache drill 1.2.0
+      &quot;a drill in the hand is better than two in the bush&quot;  
+</code></pre></div></li>
+<li><p>At the sqlline prompt, enter the <code>!connect</code> command
followed by <code>jdbc:drill:zk=zk=&lt;zk name&gt;[:&lt;port&gt;][,&lt;zk
name2&gt;[:&lt;port&gt;]... ]</code>. For example:</p></li>
+<li><div class="highlight"><pre><code class="language-text" data-lang="text">
     sqlline&gt; !connect jdbc:drill:zk=localhost:2181
+      scan complete in 1385ms
+</code></pre></div></li>
+<li><p>At the prompts, enter a user name and password.</p></li>
+<li><div class="highlight"><pre><code class="language-text" data-lang="text">
     Enter username for jdbc:drill:zk=localhost:2181: bob
+      Enter password for jdbc:drill:zk=localhost:2181: *************
+</code></pre></div>
+<p>The password is hidden as it is typed.</p></li>
+</ol>
+
 <p>When a user connects to Drill from a BI tool, such as Tableau, the MapR Drill ODBC
driver prompts the user for their username and password:</p>
 
 <p><img src="/docs/img/UserAuth_ODBC_Driver.png" alt="ODBC Driver"></p>

http://git-wip-us.apache.org/repos/asf/drill-site/blob/c3316159/docs/configuring-web-console-and-rest-api-security/index.html
----------------------------------------------------------------------
diff --git a/docs/configuring-web-console-and-rest-api-security/index.html b/docs/configuring-web-console-and-rest-api-security/index.html
index e0c815a..94d173f 100644
--- a/docs/configuring-web-console-and-rest-api-security/index.html
+++ b/docs/configuring-web-console-and-rest-api-security/index.html
@@ -1253,7 +1253,7 @@ Set the value of this option to a comma-separated list of administrator
groups.<
 <td>ALL</td>
 </tr>
 <tr>
-<td>getMetrics</td>
+<td>getThreads</td>
 <td>/threads</td>
 <td>GET</td>
 <td>text/html</td>

http://git-wip-us.apache.org/repos/asf/drill-site/blob/c3316159/docs/drill-introduction/index.html
----------------------------------------------------------------------
diff --git a/docs/drill-introduction/index.html b/docs/drill-introduction/index.html
index bad1fbb..8233245 100644
--- a/docs/drill-introduction/index.html
+++ b/docs/drill-introduction/index.html
@@ -994,6 +994,25 @@ applications, while still providing the familiarity and ecosystem of
ANSI SQL,
 the industry-standard query language. Drill provides plug-and-play integration
 with existing Apache Hive and Apache HBase deployments. </p>
 
+<h2 id="what&#39;s-new-in-apache-drill-1.2">What&#39;s New in Apache Drill
1.2</h2>
+
+<p>This release of Drill fixes <a href="">many issues</a> and introduces
a number of enhancements, including the following ones:</p>
+
+<ul>
+<li>A number of new <a href="/docs/sql-window-functions">SQL window functions</a><br>
+
+<ul>
+<li><a href="/docs/ranking-window-functions/#ntile">NTILE</a><br></li>
+<li><a href="/docs/value-window-functions/#lag-lead">LEAD and LEAD</a><br></li>
+<li><a href="/docs/value-window-functions/#first_value-last_value">FIRST_VALUE
and LAST_VALUE</a><br></li>
+</ul></li>
+<li><a href="/docs/configuring-web-console-and-rest-api-security/">Security</a>
for Web Console and REST API operations<br></li>
+<li>Performance improvements for <a href="/docs/querying-hbase/#querying-big-endian-encoded-data">querying
HBase</a>, which includes leveraging <a href="/docs/querying-hbase/#leveraging-hbase-ordered-byte-encoding">ordered
byte encoding</a>.</li>
+<li>Parquet metadata caching for performantly reading large numbers of Parquet files</li>
+<li><a href="/docs/querying-hive/#optimizing-reads-of-parquet-backed-tables">Optimized
reads</a> of Parquet-backed, Hive tables</li>
+<li>Read support for the <a href="/docs/parquet-format/#about-int96-support">Parquet
INT96 type</a> and a new TIMESTAMP_IMPALA type used with the <a href="/docs/supported-data-types/#data-types-for-convert_to-and-convert_from-functions">CONVERT_FROM</a>
function decodes a timestamp from Hive or Impala.<br></li>
+</ul>
+
 <h2 id="what&#39;s-new-in-apache-drill-1.1">What&#39;s New in Apache Drill
1.1</h2>
 
 <p>Many enhancements in Apache Drill 1.1 include the following key features:</p>

http://git-wip-us.apache.org/repos/asf/drill-site/blob/c3316159/docs/img/web-ui-admin-view.png
----------------------------------------------------------------------
diff --git a/docs/img/web-ui-admin-view.png b/docs/img/web-ui-admin-view.png
index b7d8657..fbdb709 100644
Binary files a/docs/img/web-ui-admin-view.png and b/docs/img/web-ui-admin-view.png differ

http://git-wip-us.apache.org/repos/asf/drill-site/blob/c3316159/docs/img/web-ui.png
----------------------------------------------------------------------
diff --git a/docs/img/web-ui.png b/docs/img/web-ui.png
index 2e14e1c..2e777c2 100644
Binary files a/docs/img/web-ui.png and b/docs/img/web-ui.png differ

http://git-wip-us.apache.org/repos/asf/drill-site/blob/c3316159/docs/parquet-format/index.html
----------------------------------------------------------------------
diff --git a/docs/parquet-format/index.html b/docs/parquet-format/index.html
index ba5556a..662f928 100644
--- a/docs/parquet-format/index.html
+++ b/docs/parquet-format/index.html
@@ -1173,7 +1173,7 @@ FROM dfs.tmp.`sampleparquet` t;
 <td>4-byte signed integer</td>
 </tr>
 <tr>
-<td>None*</td>
+<td>VARBINARY(12)*</td>
 <td>INT96</td>
 <td>12-byte signed int</td>
 </tr>
@@ -1189,6 +1189,12 @@ FROM dfs.tmp.`sampleparquet` t;
 
 <p>Because INT96 is supported for reads only, you cannot use the TIMESTAMP_IMPALA as
a data type argument with CONVERT_TO.</p>
 
+<p>You can convert a SQL TIMESTAMP to VARBINARY using the CAST function, but the resultant
VARBINARY is not the same as the INT96. For example, create a Drill table after reading an
INT96 and converting some data to a timestamp.</p>
+
+<p><code>CREATE TABLE t2(c1) AS SELECT CONVERT_FROM(created_ts, &#39;TIMESTAMP_IMPALA&#39;)
FROM t1 ORDER BY 1 LIMIT 1;</code></p>
+
+<p>t1.created_ts is an INT96 (or Hive/Impala timestamp) , t2.created_ts is a SQL timestamp.
These types are not comparable--you cannot use a condition like t1.created_ts = t2.created_ts.</p>
+
 <h3 id="sql-types-to-parquet-logical-types">SQL Types to Parquet Logical Types</h3>
 
 <p>Parquet also supports logical types, fully described on the <a href="https://github.com/Parquet/parquet-format/blob/master/LogicalTypes.md">Apache
Parquet site</a>. Embedded types, JSON and BSON, annotate a binary primitive type representing
a JSON or BSON document. The logical types and their mapping to SQL types are:</p>

http://git-wip-us.apache.org/repos/asf/drill-site/blob/c3316159/docs/plugin-configuration-basics/index.html
----------------------------------------------------------------------
diff --git a/docs/plugin-configuration-basics/index.html b/docs/plugin-configuration-basics/index.html
index 4aaa4da..e30167a 100644
--- a/docs/plugin-configuration-basics/index.html
+++ b/docs/plugin-configuration-basics/index.html
@@ -1003,7 +1003,7 @@ restart any of the Drillbits when you add or update a storage plugin
configurati
 <ol>
 <li><a href="/docs/starting-drill-on-linux-and-mac-os-x/">Start the Drill shell</a>.<br></li>
 <li><a href="/docs/starting-the-web-console/">Start the Web Console</a>.<br>
-The storage tab appears on the Web Console if you are <a href="/docs/configuring-web-console-and-rest-api-security/">authorized</a>
to view, update, or add storage plugins.<br></li>
+The Storage tab appears on the Web Console if you are <a href="/docs/configuring-web-console-and-rest-api-security/">authorized</a>
to view, update, or add storage plugins.<br></li>
 <li><p>On the Storage tab, enter a name in <strong>New Storage Plugin</strong>.
 Each configuration registered with Drill must have a distinct
 name. Names are case-sensitive.<br>

http://git-wip-us.apache.org/repos/asf/drill-site/blob/c3316159/docs/starting-the-web-console/index.html
----------------------------------------------------------------------
diff --git a/docs/starting-the-web-console/index.html b/docs/starting-the-web-console/index.html
index abc2ec2..2237286 100644
--- a/docs/starting-the-web-console/index.html
+++ b/docs/starting-the-web-console/index.html
@@ -1008,23 +1008,19 @@ Use this URL when <a href="/docs/configuring-web-console-and-rest-api-security/#
 Use this URL when HTTPS support is enabled.</li>
 </ul>
 
-<p>If HTTPS support is enabled, you need <a href="/docs/configuring-web-console-and-rest-api-security/">authorization</a>
to see and use the Storage tab of the Web Console. </p>
-
-<p>If <a href="/docs/configuring-user-authentication/">user authentication</a>
is not enabled, the Web Console controls appear: </p>
+<p>If <a href="/docs/configuring-user-authentication/">user authentication</a>
is not enabled, all the Web Console controls appear to users as well as administrators:  </p>
 
 <p><img src="/docs/img/web-ui.png" alt="Web Console"></p>
 
-<p>Select the Storage tab to view, update, or add a new <a href="/docs/plugin-configuration-basics/">storage
plugin configuration</a>.</p>
-
-<p>If <a href="/docs/configuring-user-authentication/">user authentication</a>
is enabled, Drill prompts you for a user name and password:</p>
+<p>If <a href="/docs/configuring-user-authentication/">user authentication</a>
is enabled, Drill prompts you for a user name/password:</p>
 
 <p><img src="/docs/img/web-ui-login.png" alt="Web Console Login"></p>
 
-<p>If an <a href="/docs/configuring-user-authentication/#administrator-privileges">administrator</a>
logs in, all the Web Console controls appear: Query, Profiles, Storage, Metrics, Threads,
and Options.</p>
+<p>If an <a href="/docs/configuring-user-authentication/#administrator-privileges">administrator</a>
logs in, all the Web Console controls appear: Query, Profiles, Storage, Metrics, Threads,
and Options. The Profiles page for administrators contains the profiles of all queries executed
on a cluster. Only administrators can see and use the Storage tab to view, update, or add
a new <a href="/docs/plugin-configuration-basics/">storage plugin configuration</a>.
Only administrators can see and use the Threads tab, which provides information about threads
running in Drill.</p>
 
 <p><img src="/docs/img/web-ui-admin-view.png" alt="Web Console Admin View"></p>
 
-<p>If a user, who is not an administrator, logs in, the Web Console controls are limited
to Query, Metrics, and Profiles. The Profiles page for a non-administrator user contains the
profiles of all queries the user issued either through ODBC, JDBC, or the Web Console. The
Profiles pages for administrators contains the profiles of all queries executed on a cluster.
Only administrators can see and use the Storage control for managing storage plugin configurations.</p>
+<p>If a user, who is not an administrator, logs in, the Web Console controls are limited
to Query, Metrics, and Profiles. The Profiles tab for a non-administrator user contains the
profiles of all queries the user issued either through ODBC, JDBC, or the Web Console. </p>
 
 <p><img src="/docs/img/web-ui-user-view.png" alt="Web Console User View"></p>
 

http://git-wip-us.apache.org/repos/asf/drill-site/blob/c3316159/feed.xml
----------------------------------------------------------------------
diff --git a/feed.xml b/feed.xml
index b5c752a..8754162 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, 30 Sep 2015 18:06:05 -0700</pubDate>
-    <lastBuildDate>Wed, 30 Sep 2015 18:06:05 -0700</lastBuildDate>
+    <pubDate>Thu, 01 Oct 2015 15:48:20 -0700</pubDate>
+    <lastBuildDate>Thu, 01 Oct 2015 15:48:20 -0700</lastBuildDate>
     <generator>Jekyll v2.5.2</generator>
     
       <item>


Mime
View raw message