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 2015/11/14 00:31:00 UTC
[2/2] drill git commit: fixes fm Yulyia & DRILL-3971
fixes fm Yulyia & DRILL-3971
minor edit
Project: http://git-wip-us.apache.org/repos/asf/drill/repo
Commit: http://git-wip-us.apache.org/repos/asf/drill/commit/825546b9
Tree: http://git-wip-us.apache.org/repos/asf/drill/tree/825546b9
Diff: http://git-wip-us.apache.org/repos/asf/drill/diff/825546b9
Branch: refs/heads/gh-pages
Commit: 825546b952bcd25cd2fbcb91b643234b8fe457cb
Parents: c902b0b
Author: Kristine Hahn <kh...@maprtech.com>
Authored: Fri Nov 13 13:08:33 2015 -0800
Committer: Kristine Hahn <kh...@maprtech.com>
Committed: Fri Nov 13 13:10:55 2015 -0800
----------------------------------------------------------------------
.../plugins/070-hive-storage-plugin.md | 14 +++++++++-----
.../sql-functions/020-data-type-conversion.md | 2 +-
.../070-analyzing-data-using-window-functions.md | 2 +-
.../020-getting-to-know-the-drill-sandbox.md | 2 ++
4 files changed, 13 insertions(+), 7 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/drill/blob/825546b9/_docs/connect-a-data-source/plugins/070-hive-storage-plugin.md
----------------------------------------------------------------------
diff --git a/_docs/connect-a-data-source/plugins/070-hive-storage-plugin.md b/_docs/connect-a-data-source/plugins/070-hive-storage-plugin.md
index 9428c1b..320d7c0 100644
--- a/_docs/connect-a-data-source/plugins/070-hive-storage-plugin.md
+++ b/_docs/connect-a-data-source/plugins/070-hive-storage-plugin.md
@@ -9,7 +9,7 @@ must have the SerDes or InputFormat/OutputFormat `JAR` files in the
## Hive Remote Metastore Configuration
-The Hive metastore configuration runs as a separate service outside
+The Hive metastore runs as a separate service outside
of Hive. Drill communicates with the Hive metastore through Thrift. The
metastore service communicates with the Hive database over JDBC. Point Drill
to the Hive metastore service address, and provide the connection parameters
@@ -46,7 +46,8 @@ To register a remote Hive metastore with Drill:
* `hdfs://<hostname>:<port>`
6. Click **Enable**.
-After configuring a Hive storage plugin, you can [query Hive tables]({{ site.baseurl }}/docs/querying-hive/).
+The "fs.default.name" should point to a the main control node. Do not point fs.default.name to a non-control node, such as a NameNode. If you're using MapR Drill, "fs.default.name" should be maprfs:///. The MapR FileClient figures out CLDB locations from mapr-clusters.conf.
+
## Hive Embedded Metastore Configuration
@@ -75,6 +76,9 @@ steps:
"hive.metastore.sasl.enabled": "false"
}
}
-5. Change the `"fs.default.name"` attribute to specify the default location of files. The value needs to be a URI that is available and capable of handling file system requests. For example, change the local file system URI `"file:///"` to the HDFS URI: `hdfs://`, or to the path on HDFS with a namenode: `hdfs://<hostname>:<port>`
-6. Click **Enable**.
-
\ No newline at end of file
+5. Change the `"fs.default.name"` attribute to specify the default location of files. The value needs to be a URI that is available and capable of handling file system requests. For example, change the local file system URI `"file:///"` to the HDFS URI: `hdfs://`, or to the path on HDFS with a namenode: `hdfs://<hostname>:<port>`
+6. Click **Enable**.
+
+The "javax.jdo.option.ConnectionURL" might be a MySQL database that stores the metadata. The Hive metastore service provides access to the physical DB like MySQL. MySQL stores the metadata.
+
+After configuring a Hive storage plugin, you can [query Hive tables]({{ site.baseurl }}/docs/querying-hive/).
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/drill/blob/825546b9/_docs/sql-reference/sql-functions/020-data-type-conversion.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-functions/020-data-type-conversion.md b/_docs/sql-reference/sql-functions/020-data-type-conversion.md
index e2d918d..25dc37b 100644
--- a/_docs/sql-reference/sql-functions/020-data-type-conversion.md
+++ b/_docs/sql-reference/sql-functions/020-data-type-conversion.md
@@ -6,7 +6,7 @@ Drill supports the following functions for casting and converting data types:
* [CAST]({{ site.baseurl }}/docs/data-type-conversion/#cast)
* [CONVERT_TO and CONVERT_FROM]({{ site.baseurl }}/docs/data-type-conversion/#convert_to-and-convert_from)
-* [STRING_BINARY]({{ site.baseurl }}/docs/data-type-conversion/#string_binary-function) and [BINARY_STRING]({{ site.baseurl }}/docs/data-type-conversion#binary_string-function)
+* [STRING_BINARY]({{ site.baseurl }}/docs/data-type-conversion/#string_binary-function) and [BINARY_STRING]({{ site.baseurl }}/docs/data-type-conversion/#binary_string-function)
* [Other Data Type Conversions]({{ site.baseurl }}/docs/data-type-conversion/#other-data-type-conversions)
## CAST
http://git-wip-us.apache.org/repos/asf/drill/blob/825546b9/_docs/tutorials/070-analyzing-data-using-window-functions.md
----------------------------------------------------------------------
diff --git a/_docs/tutorials/070-analyzing-data-using-window-functions.md b/_docs/tutorials/070-analyzing-data-using-window-functions.md
index 9200a6f..9c42dee 100644
--- a/_docs/tutorials/070-analyzing-data-using-window-functions.md
+++ b/_docs/tutorials/070-analyzing-data-using-window-functions.md
@@ -3,7 +3,7 @@ title: "Analyzing Data Using Window Functions"
parent: "Tutorials"
---
-This tutorial briefly introduces the analytics in Drill 1.2, namely ANSI SQL-compliant Analytic and Window functions. Drill supports the following SQL window functions:
+This tutorial briefly introduces the analytics in Drill 1.2, namely ANSI SQL-compliant analytic and window functions. Drill supports the following SQL window functions:
* PARTITION BY and OVER clauses
* A variety of aggregated window functions for Sum, Max, Min, Count, Avg
http://git-wip-us.apache.org/repos/asf/drill/blob/825546b9/_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
index 757edad..a404562 100755
--- 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
@@ -108,6 +108,8 @@ URI. Metadata for Hive tables is automatically available for users to query.
}
}
+Do not use this storage plugin configuration outside the sandbox. Use either the configuration for either the [remote or embedded metastore configuration].
+
## What's Next
Start running queries by going to [Lesson 1: Learn About the Data