Return-Path: X-Original-To: apmail-drill-commits-archive@www.apache.org Delivered-To: apmail-drill-commits-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 7764F18BD1 for ; Thu, 1 Oct 2015 22:55:52 +0000 (UTC) Received: (qmail 65224 invoked by uid 500); 1 Oct 2015 22:55:49 -0000 Delivered-To: apmail-drill-commits-archive@drill.apache.org Received: (qmail 65193 invoked by uid 500); 1 Oct 2015 22:55:49 -0000 Mailing-List: contact commits-help@drill.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: commits@drill.apache.org Delivered-To: mailing list commits@drill.apache.org Received: (qmail 65182 invoked by uid 99); 1 Oct 2015 22:55:49 -0000 Received: from git1-us-west.apache.org (HELO git1-us-west.apache.org) (140.211.11.23) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 01 Oct 2015 22:55:49 +0000 Received: by git1-us-west.apache.org (ASF Mail Server at git1-us-west.apache.org, from userid 33) id 2BCCCE1549; Thu, 1 Oct 2015 22:55:49 +0000 (UTC) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 8bit From: bridgetb@apache.org To: commits@drill.apache.org Message-Id: X-Mailer: ASF-Git Admin Mailer Subject: drill-site git commit: updates for 1.2 and edits from user feedback Date: Thu, 1 Oct 2015 22:55:49 +0000 (UTC) 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 Authored: Thu Oct 1 15:55:05 2015 -0700 Committer: Bridget Bevens 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 @@ !connect -Open a new connection to the database. +Open a new connection to the database. Use this command to hide the password when starting Drill in authentication mode. !help @@ -1075,6 +1075,14 @@ +

Example of Hiding the Password When Starting Drill

+ +

When starting Drill in authentication mode, you can use the !connect command as shown in the section, "User Authentication Process", instead of the sqlline, drill-embedded, or drill-distributed commands. For example, after running the sqlline script, you enter this command to connect to Drill:

+ +

sqlline> !connect jdbc:drill:zk=localhost:2181

+ +

When prompted you enter a user name and password, which is hidden as you type it.

Examples of Configuring the Drill Shell

For example, quit the Drill shell:

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 @@

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.

When launching SQLLine, a user must include the –n and –p parameters with their username and password in the SQLLine argument:
+

A user can include the –n and –p parameters with their username and password when launching SQLLine, as shown in the following example:
sqlline –u jdbc:drill:zk=10.10.11.112:5181 –n bob –p bobdrill

Alternatively, a user can launch SQLLine and then issue the !connect command to hide the password, as shown in the following procedure:

+ +

Start SQLLine, by running the sqlline script. On Linux, for example:

      bobsmachine:~$ /etc/drill/bin/sqlline
+      apache drill 1.2.0
+      "a drill in the hand is better than two in the bush"  
+

At the sqlline prompt, enter the !connect command followed by jdbc:drill:zk=zk=<zk name>[:<port>][,<zk name2>[:<port>]... ]. For example:

      sqlline> !connect jdbc:drill:zk=localhost:2181
+      scan complete in 1385ms
+

At the prompts, enter a user name and password.

      Enter username for jdbc:drill:zk=localhost:2181: bob
+      Enter password for jdbc:drill:zk=localhost:2181: *************
+

The password is hidden as it is typed.

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:

ODBC Driver

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.< ALL -getMetrics +getThreads /threads GET text/html 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.

What's New in Apache Drill 1.2

+ +

This release of Drill fixes many issues and introduces a number of enhancements, including the following ones:

+ +

A number of new SQL window functions
+ +
- NTILE
- LEAD and LEAD
- FIRST_VALUE and LAST_VALUE
Security for Web Console and REST API operations
Performance improvements for querying HBase, which includes leveraging ordered byte encoding.
Parquet metadata caching for performantly reading large numbers of Parquet files
Optimized reads of Parquet-backed, Hive tables
Read support for the Parquet INT96 type and a new TIMESTAMP_IMPALA type used with the CONVERT_FROM function decodes a timestamp from Hive or Impala.

What's New in Apache Drill 1.1

Many enhancements in Apache Drill 1.1 include the following key features:

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; 4-byte signed integer -None* +VARBINARY(12)* INT96 12-byte signed int @@ -1189,6 +1189,12 @@ FROM dfs.tmp.`sampleparquet` t;

Because INT96 is supported for reads only, you cannot use the TIMESTAMP_IMPALA as a data type argument with CONVERT_TO.

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.

+ +

CREATE TABLE t2(c1) AS SELECT CONVERT_FROM(created_ts, 'TIMESTAMP_IMPALA') FROM t1 ORDER BY 1 LIMIT 1;

+ +

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.

SQL Types to Parquet Logical Types

Parquet also supports logical types, fully described on the Apache Parquet site. 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:

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

Start the Drill shell.
Start the Web Console.
-The storage tab appears on the Web Console if you are authorized to view, update, or add storage plugins.

authorized

On the Storage tab, enter a name in New Storage Plugin. Each configuration registered with Drill must have a distinct name. Names are case-sensitive.
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 authorization to see and use the Storage tab of the Web Console.
- -
If user authentication is not enabled, the Web Console controls appear:
+
If user authentication is not enabled, all the Web Console controls appear to users as well as administrators:

-
Select the Storage tab to view, update, or add a new storage plugin configuration.
- -
If user authentication is enabled, Drill prompts you for a user name and password:
+
If user authentication is enabled, Drill prompts you for a user name/password:

-
If an administrator logs in, all the Web Console controls appear: Query, Profiles, Storage, Metrics, Threads, and Options.
+
If an administrator 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 storage plugin configuration. Only administrators can see and use the Threads tab, which provides information about threads running in Drill.

-
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.
+
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.

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 @@ / - Wed, 30 Sep 2015 18:06:05 -0700 - Wed, 30 Sep 2015 18:06:05 -0700 + Thu, 01 Oct 2015 15:48:20 -0700 + Thu, 01 Oct 2015 15:48:20 -0700 Jekyll v2.5.2