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 2018/01/30 18:40:08 UTC
drill git commit: edits
Repository: drill
Updated Branches:
refs/heads/gh-pages d2d60865d -> ce915721a
edits
Project: http://git-wip-us.apache.org/repos/asf/drill/repo
Commit: http://git-wip-us.apache.org/repos/asf/drill/commit/ce915721
Tree: http://git-wip-us.apache.org/repos/asf/drill/tree/ce915721
Diff: http://git-wip-us.apache.org/repos/asf/drill/diff/ce915721
Branch: refs/heads/gh-pages
Commit: ce915721a841cbf4b401ffc79f766e55e300dd21
Parents: d2d6086
Author: Bridget Bevens <bb...@maprtech.com>
Authored: Tue Jan 30 10:38:54 2018 -0800
Committer: Bridget Bevens <bb...@maprtech.com>
Committed: Tue Jan 30 10:38:54 2018 -0800
----------------------------------------------------------------------
_docs/connect-a-data-source/plugins/095-mapr-db-format.md | 8 ++++----
_docs/data-sources-and-file-formats/050-json-data-model.md | 6 +++---
2 files changed, 7 insertions(+), 7 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/drill/blob/ce915721/_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
index ef27483..af16fde 100644
--- a/_docs/connect-a-data-source/plugins/095-mapr-db-format.md
+++ b/_docs/connect-a-data-source/plugins/095-mapr-db-format.md
@@ -1,10 +1,12 @@
---
title: "MapR-DB Format"
-date:
+date: 2018-01-30 18:38:55 UTC
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.
+The MapR-DB format is not included in the Apache Drill release. Drill includes a [maprdb format](https://maprdocs.mapr.com/home/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.
@@ -14,6 +16,4 @@ Instead of including the name of a file, you include the table name in the query
SELECT * FROM mfs.`/users/max/mytable`;
-The following image shows a portion of the dfs configuration with the maprdb format:
-
http://git-wip-us.apache.org/repos/asf/drill/blob/ce915721/_docs/data-sources-and-file-formats/050-json-data-model.md
----------------------------------------------------------------------
diff --git a/_docs/data-sources-and-file-formats/050-json-data-model.md b/_docs/data-sources-and-file-formats/050-json-data-model.md
index 71b812b..ebc2d46 100644
--- a/_docs/data-sources-and-file-formats/050-json-data-model.md
+++ b/_docs/data-sources-and-file-formats/050-json-data-model.md
@@ -1,6 +1,6 @@
---
title: "JSON Data Model"
-date: 2018-01-30 05:41:07 UTC
+date: 2018-01-30 18:38:55 UTC
parent: "Data Sources and File Formats"
---
Drill supports [JSON (JavaScript Object Notation)](http://www.json.org/), a self-describing data format. The data itself implies its schema and has the following characteristics:
@@ -29,12 +29,12 @@ JSON data consists of the following types:
* Whitespace: used between tokens
* Number: double-precision floating point number, including exponential numbers, NaN, and Infinity. Octal and hexadecimal are not supported.
-Drill 1.13 and later supports NaN (Not-a-Number) and Infinity as numeric values. This support introduces the following session options, which are set to “true” by default:
+Drill 1.13 and later supports NaN (Not-a-Number) and Infinity (both POSITIVE and NEGATIVE) as numeric values. This support introduces the following session options, which are set to true by default:
store.json.writer.allow_nan_inf
store.json.reader.allow_nan_inf
-Drill writes NaN and Infinity values as literals to a JSON file when `store.json.writer.allow_nan_inf` is set to true. When set to false, Drill writes NaN and Infinity values as string values to a JSON file. If a query selects NaN or Infinity values in a JSON file, and `store.json.reader.allow_nan_inf` is set to false, Drill returns an error message. You can use the [SET]({{site.baseurl}}/docs/set/) command to change the options.
+Drill writes NaN and Infinity values as literals to a JSON file when `store.json.writer.allow_nan_inf` is set to true. When set to false, Drill writes NaN and Infinity values as string values to a JSON file. If a query selects NaN or Infinity values in a JSON file, and `store.json.reader.allow_nan_inf` is set to false, Drill returns an error message. You can use the [SET]({{site.baseurl}}/docs/set/) command to change the option settings.
The following table shows SQL-JSON data type mapping: