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 <[email protected]> Authored: Wed May 18 11:44:18 2016 -0700 Committer: Bridget Bevens <[email protected]> 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: + +
