drill-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From tshi...@apache.org
Subject [43/50] [abbrv] drill git commit: exhume wiki maprdb format
Date Fri, 01 May 2015 18:08:39 GMT
exhume wiki maprdb format


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

Branch: refs/heads/gh-pages
Commit: 3249804560e4496cec66dc731f3031790677deea
Parents: f68f73b
Author: Kristine Hahn <khahn@maprtech.com>
Authored: Thu Apr 30 17:18:00 2015 -0700
Committer: Kristine Hahn <khahn@maprtech.com>
Committed: Thu Apr 30 17:18:00 2015 -0700

----------------------------------------------------------------------
 .../connect-a-data-source/100-mapr-db-format.md | 42 ++++++++++----------
 1 file changed, 20 insertions(+), 22 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/drill/blob/32498045/_docs/connect-a-data-source/100-mapr-db-format.md
----------------------------------------------------------------------
diff --git a/_docs/connect-a-data-source/100-mapr-db-format.md b/_docs/connect-a-data-source/100-mapr-db-format.md
index f00d2d2..269b783 100644
--- a/_docs/connect-a-data-source/100-mapr-db-format.md
+++ b/_docs/connect-a-data-source/100-mapr-db-format.md
@@ -2,33 +2,31 @@
 title: "MapR-DB Format"
 parent: "Connect a Data Source"
 ---
-Drill includes a `maprdb` format plugin for accessing data stored in MapR-DB. The Drill Sandbox
also includes the following `maprdb` format plugin on a MapR node:
+Drill includes a `maprdb` format plugin for MapR-DB that is defined within the
+default `dfs` storage plugin instance when you install Drill from the `mapr-drill` package
on a MapR node. The `maprdb` format plugin 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.
 
-    {
-      "type": "hbase",
-      "config": {
-        "hbase.table.namespace.mappings": "*:/tables"
-      },
-      "size.calculator.enabled": false,
-      "enabled": true
-    }
+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.
 
-Using the Sandbox and this `maprdb` format plugin, you can query HBase tables located in
the `/tables` directory, as shown in the ["Query HBase"]({{ site.baseurl }}/docs/querying-hbase)
examples.
+Instead of including the name of a file, you include the table name in the
+query.
 
-The `dfs` storage plugin includes the maprdb format when you install Drill from the `mapr-drill`
package on a MapR node. Click **Update** next to the `dfs` instance
-in the Web UI of the Drill Sandbox to view the configuration for the `dfs` instance:
-
-![drill query flow]({{ site.baseurl }}/docs/img/18.png)
-
-
-The examples of the [CONVERT_TO/FROM functions]({{ site.baseurl }}/docs/data-type-conversion#convert_to-and-convert_from)
show how to adapt the `dfs` storage plugin to use the `maprdb` format plugin to query HBase
tables on the Sandbox.
+**Example**
 
-You modify the `dfs` storage plugin to create a table mapping to a directory in the MapR-FS
file system. You then select the table by name.
+    SELECT * FROM mfs.`/users/max/mytable`;
 
-**Example**
+Drill stores the `maprdb` format plugin in the `dfs` storage plugin instance,
+which you can view in the Drill Web UI. You can access the Web UI at
+[http://localhost:8047/storage](http://localhost:8047/storage). Click **Update** next to
the `dfs` instance
+in the Web UI to view the configuration for the `dfs` instance.
 
-    SELECT * FROM myplugin.`mytable`;
+The following image shows a portion of the configuration with the `maprdb`
+format plugin for the `dfs` instance:
 
-The `maprdb` format plugin improves the
-estimated number of rows that Drill uses to plan a query. Using the `dfs` storage plugin,
you can query HBase and MapR-DB tables as you would query files in a file system. MapR-DB,
MapR-FS, and Hadoop files share the same namespace.
+![drill query flow]({{ site.baseurl }}/docs/img/18.png)
 


Mime
View raw message