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 2016/05/18 18:47:01 UTC
drill git commit: add maprdb format page back into docs
Repository: drill
Updated Branches:
refs/heads/gh-pages 308381737 -> acfeb435c
add maprdb format page back into docs
Project: http://git-wip-us.apache.org/repos/asf/drill/repo
Commit: http://git-wip-us.apache.org/repos/asf/drill/commit/acfeb435
Tree: http://git-wip-us.apache.org/repos/asf/drill/tree/acfeb435
Diff: http://git-wip-us.apache.org/repos/asf/drill/diff/acfeb435
Branch: refs/heads/gh-pages
Commit: acfeb435c471754c79e4266ca2ed344d1d6e823b
Parents: 3083817
Author: Bridget Bevens <bb...@maprtech.com>
Authored: Wed May 18 11:44:18 2016 -0700
Committer: Bridget Bevens <bb...@maprtech.com>
Committed: Wed May 18 11:44:18 2016 -0700
----------------------------------------------------------------------
.../plugins/095-mapr-db-format.md | 19 +++++++++++++++++++
1 file changed, 19 insertions(+)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/drill/blob/acfeb435/_docs/connect-a-data-source/plugins/095-mapr-db-format.md
----------------------------------------------------------------------
diff --git a/_docs/connect-a-data-source/plugins/095-mapr-db-format.md b/_docs/connect-a-data-source/plugins/095-mapr-db-format.md
new file mode 100644
index 0000000..ef27483
--- /dev/null
+++ b/_docs/connect-a-data-source/plugins/095-mapr-db-format.md
@@ -0,0 +1,19 @@
+---
+title: "MapR-DB Format"
+date:
+parent: "Connect a Data Source"
+---
+
+The MapR-DB format is not included in the Apache Drill release. Drill includes a [maprdb format](http://maprdocs.mapr.com/51/index.html#Drill/UsingMapRdbFormat.html) for MapR-DB that is defined within the default dfs storage plugin configuration when you install Drill from the mapr-drill package on a MapR node. The maprdb format improves the estimated number of rows that Drill uses to plan a query. It also enables you to query tables like you would query files in a file system because MapR-DB and MapR-FS share the same namespace.
+
+You can query tables stored across multiple directories. You do not need to create a table mapping to a directory before you query a table in the directory. You can select from any table in any directory the same way you would select from files in MapR-FS, using the same syntax.
+
+Instead of including the name of a file, you include the table name in the query. The userid running the query must have read permission to access the MapR table.
+
+**Example**
+
+ SELECT * FROM mfs.`/users/max/mytable`;
+
+The following image shows a portion of the dfs configuration with the maprdb format:
+
+