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 2017/04/05 00:16:11 UTC
drill-site git commit: Doc fix for DRILL-4772 and fix broken links in
various pages
Repository: drill-site
Updated Branches:
refs/heads/asf-site 5e312b28b -> d5f462823
Doc fix for DRILL-4772 and fix broken links in various pages
Project: http://git-wip-us.apache.org/repos/asf/drill-site/repo
Commit: http://git-wip-us.apache.org/repos/asf/drill-site/commit/d5f46282
Tree: http://git-wip-us.apache.org/repos/asf/drill-site/tree/d5f46282
Diff: http://git-wip-us.apache.org/repos/asf/drill-site/diff/d5f46282
Branch: refs/heads/asf-site
Commit: d5f4628231cb05d0b28ffb500636f8db616a80e6
Parents: 5e312b2
Author: Bridget Bevens <bb...@maprtech.com>
Authored: Tue Apr 4 17:15:51 2017 -0700
Committer: Bridget Bevens <bb...@maprtech.com>
Committed: Tue Apr 4 17:15:51 2017 -0700
----------------------------------------------------------------------
docs/apache-drill-0-9-0-release-notes/index.html | 2 +-
docs/apache-drill-1-2-0-release-notes/index.html | 2 +-
docs/create-view/index.html | 4 ++--
docs/date-time-and-timestamp/index.html | 10 +++++-----
docs/hive-to-drill-data-type-mapping/index.html | 9 +++++++--
docs/querying-the-information-schema/index.html | 4 ++--
docs/supported-data-types/index.html | 6 +++---
docs/use/index.html | 6 +++---
.../using-apache-drill-with-tableau-9-desktop/index.html | 11 +++++++----
docs/with-clause/index.html | 4 ++--
feed.xml | 4 ++--
11 files changed, 35 insertions(+), 27 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/drill-site/blob/d5f46282/docs/apache-drill-0-9-0-release-notes/index.html
----------------------------------------------------------------------
diff --git a/docs/apache-drill-0-9-0-release-notes/index.html b/docs/apache-drill-0-9-0-release-notes/index.html
index 0d53451..1af01cb 100644
--- a/docs/apache-drill-0-9-0-release-notes/index.html
+++ b/docs/apache-drill-0-9-0-release-notes/index.html
@@ -1126,7 +1126,7 @@
<div class="int_text" align="left">
- <p>It has been about a month since the release of Drill 0.8, which included <a href="/blog/drill-0.8-released/">more than 240 improvements</a>. Today we're happy to announce the availability of Drill 0.9, providing additional enhancements and bug fixes. In fact, this release includes <a href="https://issues.apache.org/jira/secure/ReleaseNote.jspa?projectId=12313820&version=12328813">200 resolved JIRAs</a>. Some of the noteworthy features in Drill 0.9 are:</p>
+ <p>It has been about a month since the release of Drill 0.8, which included <a href="/blog/2016/08/30/drill-1.8-released/">more than 240 improvements</a>. Today we're happy to announce the availability of Drill 0.9, providing additional enhancements and bug fixes. In fact, this release includes <a href="https://issues.apache.org/jira/secure/ReleaseNote.jspa?projectId=12313820&version=12328813">200 resolved JIRAs</a>. Some of the noteworthy features in Drill 0.9 are:</p>
<ul>
<li><strong>Authentication</strong> (<a href="https://issues.apache.org/jira/browse/DRILL-2674">DRILL-2674</a>). Drill now supports username/password authentication through the Java and C++ clients, as well as JDBC and ODBC. On the server-side, Drill leverages Linux PAM to securely validate the credentials. Users can choose to use an external user directory such as Active Directory or LDAP. To enable authentication, set the <code>security.user.auth</code> option in <code>drill-override.conf</code>.</li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/d5f46282/docs/apache-drill-1-2-0-release-notes/index.html
----------------------------------------------------------------------
diff --git a/docs/apache-drill-1-2-0-release-notes/index.html b/docs/apache-drill-1-2-0-release-notes/index.html
index 2d4e481..24a68da 100644
--- a/docs/apache-drill-1-2-0-release-notes/index.html
+++ b/docs/apache-drill-1-2-0-release-notes/index.html
@@ -1140,7 +1140,7 @@
<p>This release of Drill introduces a number of enhancements, including the following ones:</p>
<ul>
-<li>Support for JDBC data sources, such as MySQL, through a <a href="/docs/jdbc-storage-plugin/">new JDBC Storage plugin</a><br></li>
+<li>Support for JDBC data sources, such as MySQL, through a <a href="/docs/rdbms-storage-plugin/#example:-working-with-mysql">new JDBC Storage plugin</a><br></li>
<li>Improvements in the Drill JDBC driver including inclusion of
<a href="/api/1.2/jdbc/">Javadocs</a> and better application dependency compatibility<br></li>
<li>Enhancements to Avro file formats<br>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/d5f46282/docs/create-view/index.html
----------------------------------------------------------------------
diff --git a/docs/create-view/index.html b/docs/create-view/index.html
index 43d55dd..1f84dcb 100644
--- a/docs/create-view/index.html
+++ b/docs/create-view/index.html
@@ -1122,7 +1122,7 @@
</div>
- May 5, 2016
+ Apr 5, 2017
<link href="/css/docpage.css" rel="stylesheet" type="text/css">
@@ -1152,7 +1152,7 @@ generate the same set of columns with the same column names and data types.</p>
<p><em>workspace</em><br>
The location where you want the view to exist. By default, the view is created
in the current workspace. See
-<a href="/docs/Workspaces">Workspaces</a>.</p>
+<a href="/docs/workspaces/">Workspaces</a>.</p>
<p><em>view_name</em><br>
The name that you give the view. The view must have a unique name. It cannot
http://git-wip-us.apache.org/repos/asf/drill-site/blob/d5f46282/docs/date-time-and-timestamp/index.html
----------------------------------------------------------------------
diff --git a/docs/date-time-and-timestamp/index.html b/docs/date-time-and-timestamp/index.html
index da3fee2..9f14dc7 100644
--- a/docs/date-time-and-timestamp/index.html
+++ b/docs/date-time-and-timestamp/index.html
@@ -1122,7 +1122,7 @@
</div>
-
+ Apr 5, 2017
<link href="/css/docpage.css" rel="stylesheet" type="text/css">
@@ -1144,11 +1144,11 @@ FROM (VALUES (1));
</code></pre></div>
<h2 id="interval">INTERVAL</h2>
-<p>The INTERVALYEAR and INTERVALDAY internal types represent a period of time. The INTERVALYEAR type specifies values from a year to a month. The INTERVALDAY type specifies values from a day to seconds.</p>
+<p>The INTERVAL YEAR and INTERVAL DAY internal types represent a period of time. The INTERVAL YEAR type specifies values from a year to a month. The INTERVAL DAY type specifies values from a day to seconds.</p>
<h3 id="interval-in-data-source">Interval in Data Source</h3>
-<p>If your interval data is in the data source, you need to cast the data to an SQL interval type to query the data using Drill. For example, to use interval data in a JSON file, cast the JSON data, which is of the VARCHAR type, to INTERVALYEAR and INTERVALDAY using the following ISO 8601 syntax:</p>
+<p>If your interval data is in the data source, you need to cast the data to an SQL interval type to query the data using Drill. For example, to use interval data in a JSON file, cast the JSON data, which is of the VARCHAR type, to INTERVAL YEAR and INTERVAL DAY using the following ISO 8601 syntax:</p>
<div class="highlight"><pre><code class="language-text" data-lang="text">P [qty] Y [qty] M [qty] D T [qty] H [qty] M [qty] S
P [qty] D T [qty] H [qty] M [qty] S
@@ -1202,7 +1202,7 @@ P [qty] Y [qty] M
+--------------------------+
1 row selected (0.096 seconds)
</code></pre></div>
-<p>The following examples show the input and output format of INTERVALYEAR (Year, Month) and INTERVALDAY (Day, Hours, Minutes, Seconds, Milliseconds). The following SELECT statements show how to format the query input. The output shows how to format the data in the data source.</p>
+<p>The following examples show the input and output format of INTERVAL YEAR (Year, Month) and INTERVAL DAY (Day, Hours, Minutes, Seconds, Milliseconds). The following SELECT statements show how to format the query input. The output shows how to format the data in the data source.</p>
<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT INTERVAL '1 10:20:30.123' day to second FROM sys.version;
+------------+
| EXPR$0 |
@@ -1239,7 +1239,7 @@ SELECT INTERVAL '13' month FROM (VALUES(1));
<p>DATE, TIME, and TIMESTAMP literals. Drill stores values in Coordinated Universal Time (UTC). Drill supports time functions in the range 1971 to 2037.</p>
-<p>Drill does not support TIMESTAMP with time zone; however, if your data includes the time zone, use the <a href="/docs/casting/converting-data-types/#to_timestamp">TO_TIMESTAMP function</a> and <a href="/docs/data-type-conversion/#format-specifiers-for-date/time-conversions">Joda format specifiers</a> as shown the examples in section, <a href="/docs/data-type-conversion/#time-zone-limitation">"Time Zone Limitation"</a>.</p>
+<p>Drill does not support TIMESTAMP with time zone; however, if your data includes the time zone, use the <a href="/docs/data-type-conversion/#other-data-type-conversions">TO_TIMESTAMP function</a> and <a href="/docs/data-type-conversion/#format-specifiers-for-date/time-conversions">Joda format specifiers</a> as shown the examples in section, <a href="/docs/data-type-conversion/#time-zone-limitation">"Time Zone Limitation"</a>.</p>
<p>Next, use the following literals in a SELECT statement. </p>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/d5f46282/docs/hive-to-drill-data-type-mapping/index.html
----------------------------------------------------------------------
diff --git a/docs/hive-to-drill-data-type-mapping/index.html b/docs/hive-to-drill-data-type-mapping/index.html
index 0563ffe..424bfa8 100644
--- a/docs/hive-to-drill-data-type-mapping/index.html
+++ b/docs/hive-to-drill-data-type-mapping/index.html
@@ -1120,7 +1120,7 @@
</div>
- Aug 4, 2016
+ Apr 5, 2017
<link href="/css/docpage.css" rel="stylesheet" type="text/css">
@@ -1132,9 +1132,14 @@
<li>TINYINT and SMALLINT<br>
Cast these types to INTEGER.<br></li>
<li>BINARY<br>
-Cast the Hive BINARY type to VARCHAR.</li>
+Cast the Hive BINARY type to VARCHAR.<br></li>
</ul>
+<div class="admonition note">
+ <p class="first admonition-title">Note</p>
+ <p class="last">In the 1.7 release, Drill automatically converts the Hive CHAR data type to VARCHAR. You no longer need to cast the Hive CHAR data type to VARCHAR when querying Hive tables. </p>
+</div>
+
<h2 id="map-of-sql-and-hive-types">Map of SQL and Hive Types</h2>
<!-- See DRILL-1570 -->
http://git-wip-us.apache.org/repos/asf/drill-site/blob/d5f46282/docs/querying-the-information-schema/index.html
----------------------------------------------------------------------
diff --git a/docs/querying-the-information-schema/index.html b/docs/querying-the-information-schema/index.html
index 7b38616..92813ff 100644
--- a/docs/querying-the-information-schema/index.html
+++ b/docs/querying-the-information-schema/index.html
@@ -1120,7 +1120,7 @@
</div>
-
+ Apr 5, 2017
<link href="/css/docpage.css" rel="stylesheet" type="text/css">
@@ -1232,7 +1232,7 @@ WHERE TABLE_NAME = 'Orders' AND TABLE_SCHEMA = 'HiveTest.SalesDB'
| OrderTotal | Decimal |
+-------------+------------+
</code></pre></div>
-<p>In this release, Drill disables the DECIMAL data type, including casting to DECIMAL and reading DECIMAL types from Parquet and Hive. You can <a href="docs/supported-data-types/#enabling-the-decimal-type">enable the DECIMAL type</a>, but this is not recommended.</p>
+<p>In this release, Drill disables the DECIMAL data type, including casting to DECIMAL and reading DECIMAL types from Parquet and Hive. You can <a href="/docs/supported-data-types/#enabling-the-decimal-type">enable the DECIMAL type</a>, but this is not recommended.</p>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/d5f46282/docs/supported-data-types/index.html
----------------------------------------------------------------------
diff --git a/docs/supported-data-types/index.html b/docs/supported-data-types/index.html
index 32f2094..03dbef0 100644
--- a/docs/supported-data-types/index.html
+++ b/docs/supported-data-types/index.html
@@ -1122,7 +1122,7 @@
</div>
-
+ Apr 5, 2017
<link href="/css/docpage.css" rel="stylesheet" type="text/css">
@@ -1204,10 +1204,10 @@
</tr>
</tbody></table>
-<p>* In this release, Drill disables the DECIMAL data type (an alpha feature), including casting to DECIMAL and reading DECIMAL types from Parquet and Hive. The NUMERIC data type is an alias for the DECIMAL data type.<br>
+<p>* In the 1.0 release, Drill disables the DECIMAL data type (an alpha feature), including casting to DECIMAL and reading DECIMAL types from Parquet and Hive. The NUMERIC data type is an alias for the DECIMAL data type.<br>
** Internally, INTERVAL is represented as INTERVALDAY or INTERVALYEAR.<br>
*** SMALLINT is not currently supported.<br>
-**** Currently, Drill supports only variable-length strings. </p>
+**** The CHAR data type is internally represented as VARCHAR by Drill. </p>
<h2 id="enabling-the-decimal-type">Enabling the DECIMAL Type</h2>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/d5f46282/docs/use/index.html
----------------------------------------------------------------------
diff --git a/docs/use/index.html b/docs/use/index.html
index d0f3b99..c4dacc1 100644
--- a/docs/use/index.html
+++ b/docs/use/index.html
@@ -1122,7 +1122,7 @@
</div>
- Mar 14, 2017
+ Apr 5, 2017
<link href="/css/docpage.css" rel="stylesheet" type="text/css">
@@ -1131,7 +1131,7 @@
<p>The USE command changes the schema context to the specified schema. When you
issue the USE command to switch to a particular schema, Drill queries that
schema only.
-<strong>Note:</strong> You must include the full path to a file or table whenever there is a temporary table in the session with the same name. See <a href="/docs/create-temp-table-as">CTTAS</a>. </p>
+<strong>Note:</strong> You must include the full path to a file or table whenever there is a temporary table in the session with the same name. See <a href="/docs/create-temporary-table-as-cttas/">CTTAS</a>. </p>
<h2 id="syntax">Syntax</h2>
@@ -1146,7 +1146,7 @@ plugin, such as hive, or a storage plugin and workspace. For example, in dfs.don
The workspace points to a directory
within the file system. You can configure and use multiple storage plugins and
workspaces in Drill. See <a href="/docs/storage-plugin-registration">Storage Plugin Registration</a> and
-<a href="/docs/Workspaces">Workspaces</a>.</p>
+<a href="/docs/workspaces/">Workspaces</a>.</p>
<h2 id="usage-notes">Usage Notes</h2>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/d5f46282/docs/using-apache-drill-with-tableau-9-desktop/index.html
----------------------------------------------------------------------
diff --git a/docs/using-apache-drill-with-tableau-9-desktop/index.html b/docs/using-apache-drill-with-tableau-9-desktop/index.html
index c62d129..559f214 100644
--- a/docs/using-apache-drill-with-tableau-9-desktop/index.html
+++ b/docs/using-apache-drill-with-tableau-9-desktop/index.html
@@ -1122,7 +1122,7 @@
</div>
-
+ Apr 5, 2017
<link href="/css/docpage.css" rel="stylesheet" type="text/css">
@@ -1197,9 +1197,12 @@ Tableau is now connected to Drill, and you can select various tables and views.
<p>You can select tables and views to build a Tableau Visualization. You can also use custom SQL by clicking the <strong>New Custom SQL</strong> option. </p>
-<p>Tableau can natively work with Hive tables and Drill views. For Drill data sources, including directly accessible file systems or HBase/MapR-DB tables, you can either use the Custom SQL option, or you can create a view in Drill to easily represent the complex data to Tableau. For more information, see the following links:
-<a href="http://drill.apache.org/docs/step-3-connect-to-drill-data-sources-from-a-bi-tool/">http://drill.apache.org/docs/step-3-connect-to-drill-data-sources-from-a-bi-tool/</a>
-<a href="http://drill.apache.org/docs/tableau-examples/">http://drill.apache.org/docs/tableau-examples/</a></p>
+<p>Tableau can natively work with Hive tables and Drill views. For Drill data sources, including directly accessible file systems or HBase/MapR-DB tables, you can either use the Custom SQL option, or you can create a view in Drill to easily represent the complex data to Tableau. For more information, refer to the following pages: </p>
+
+<ul>
+<li><a href="https://drill.apache.org/docs/using-drill-with-bi-tools/">https://drill.apache.org/docs/using-drill-with-bi-tools/</a><br></li>
+<li><a href="http://drill.apache.org/docs/tableau-examples/">http://drill.apache.org/docs/tableau-examples/</a></li>
+</ul>
<p>Note: If Drill authentication and impersonation is enabled, only the views that the user has access to will be displayed in the Table dialog box. Also, if custom SQL is being used to try and access data sources that the user does not have access to, an error message will be displayed. <img src="/docs/img/tableau-error.png" alt="drill query flow"></p>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/d5f46282/docs/with-clause/index.html
----------------------------------------------------------------------
diff --git a/docs/with-clause/index.html b/docs/with-clause/index.html
index a93c743..2d2d8ff 100644
--- a/docs/with-clause/index.html
+++ b/docs/with-clause/index.html
@@ -1122,7 +1122,7 @@
</div>
-
+ Apr 5, 2017
<link href="/css/docpage.css" rel="stylesheet" type="text/css">
@@ -1155,7 +1155,7 @@ less than the number of columns defined by the subquery.</p>
<p><em>query</em><br>
Any SELECT query that Drill supports. See
-<a href="/docs/SELECT+Statements">SELECT</a>.</p>
+<a href="/docs/select/">SELECT</a>.</p>
<h2 id="usage-notes">Usage Notes</h2>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/d5f46282/feed.xml
----------------------------------------------------------------------
diff --git a/feed.xml b/feed.xml
index 1a1c8ee..4bb2651 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>Fri, 31 Mar 2017 14:55:16 -0700</pubDate>
- <lastBuildDate>Fri, 31 Mar 2017 14:55:16 -0700</lastBuildDate>
+ <pubDate>Tue, 04 Apr 2017 17:13:43 -0700</pubDate>
+ <lastBuildDate>Tue, 04 Apr 2017 17:13:43 -0700</lastBuildDate>
<generator>Jekyll v2.5.2</generator>
<item>