Repository: drill-site Updated Branches: refs/heads/asf-site 9833d32c5 -> 38ed649a4
Website update Project: http://git-wip-us.apache.org/repos/asf/drill-site/repo Commit: http://git-wip-us.apache.org/repos/asf/drill-site/commit/38ed649a Tree: http://git-wip-us.apache.org/repos/asf/drill-site/tree/38ed649a Diff: http://git-wip-us.apache.org/repos/asf/drill-site/diff/38ed649a Branch: refs/heads/asf-site Commit: 38ed649a4d872efa8947f440280b74a5a04fe625 Parents: 9833d32 Author: Tomer Shiran <tshi...@gmail.com> Authored: Wed May 20 15:02:13 2015 -0700 Committer: Tomer Shiran <tshi...@gmail.com> Committed: Wed May 20 15:02:13 2015 -0700 ---------------------------------------------------------------------- docs/handling-different-data-types/index.html | 4 +--- docs/img/execution-tree.PNG | Bin 13849 -> 16724 bytes docs/json-data-model/index.html | 4 +++- docs/supported-data-types/index.html | 22 ++++++++++++++++----- feed.xml | 4 ++-- index.html | 2 +- 6 files changed, 24 insertions(+), 12 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/drill-site/blob/38ed649a/docs/handling-different-data-types/index.html ---------------------------------------------------------------------- diff --git a/docs/handling-different-data-types/index.html b/docs/handling-different-data-types/index.html index 7743846..f679b4c 100644 --- a/docs/handling-different-data-types/index.html +++ b/docs/handling-different-data-types/index.html @@ -982,9 +982,7 @@ <h2 id="handling-json-and-parquet-data">Handling JSON and Parquet Data</h2> -<p>Complex and nested data structures in JSON and Parquet files are of map and array types.</p> - -<p>A map is a set of name/value pairs. A value in a map can be a scalar type, such as string or int, or a complex type, such as an array or another map. An array is a repeated list of values. A value in an array can be a scalar type, such as string or int, or an array can be a complex type, such as a map or another array.</p> +<p>Complex and nested data structures in JSON and Parquet files are <a href="(/docs/supported-data-types/#composite-types)">composite types</a>: map and array.</p> <p>Drill reads/writes maps and arrays from/to JSON and Parquet files. In Drill, you do not cast a map or array to another type.</p> http://git-wip-us.apache.org/repos/asf/drill-site/blob/38ed649a/docs/img/execution-tree.PNG ---------------------------------------------------------------------- diff --git a/docs/img/execution-tree.PNG b/docs/img/execution-tree.PNG index 9fb8026..18e7cc4 100755 Binary files a/docs/img/execution-tree.PNG and b/docs/img/execution-tree.PNG differ http://git-wip-us.apache.org/repos/asf/drill-site/blob/38ed649a/docs/json-data-model/index.html ---------------------------------------------------------------------- diff --git a/docs/json-data-model/index.html b/docs/json-data-model/index.html index f09370c..fba84b1 100644 --- a/docs/json-data-model/index.html +++ b/docs/json-data-model/index.html @@ -1055,7 +1055,9 @@ Reads all data from JSON files as VARCHAR. You need to cast numbers from VARCHAR <li>Cast JSON strings to <a href="/docs/date-time-and-timestamp">Drill Date/Time Data Type Formats</a>.</li> </ul> -<p>Drill uses <a href="/docs/handling-different-data-types/#handling-json-and-parquet-data">map and array data types</a> internally for reading complex and nested data structures from JSON. You can cast data in a map or array of data to return a value from the structure, as shown in <a href="/docs/lesson-2-run-queries-with-ansi-sql/#create-a-view-on-a-mapr-db-table">âCreate a view on a MapR-DB tableâ</a>. <a href="/docs/querying-complex-data-introduction">âQuery Complex Dataâ</a> shows how to access nested arrays.</p> +<p><a href="/docs/querying-complex-data-introduction">âQuery Complex Dataâ</a> show how to use <a href="/docs/supported-data-types/#composite-types">composite types</a> to access nested arrays.</p> + +<p>Drill uses these types internally for reading complex and nested data structures from data sources such as JSON. </p> <h2 id="reading-json">Reading JSON</h2> http://git-wip-us.apache.org/repos/asf/drill-site/blob/38ed649a/docs/supported-data-types/index.html ---------------------------------------------------------------------- diff --git a/docs/supported-data-types/index.html b/docs/supported-data-types/index.html index cee7797..547e10f 100644 --- a/docs/supported-data-types/index.html +++ b/docs/supported-data-types/index.html @@ -1074,13 +1074,25 @@ <p>Drill supports the following composite types:</p> <ul> -<li>Array -Array element references, for example <code>a[1]</code> is the primary type-specific operation.</li> -<li>Map -Drill supports constructs in the form <code>m['k']</code></li> +<li>Array</li> +<li>Map</li> </ul> -<p>For more information about array and map types, see the section, <a href="/docs/handling-different-data-types/#handling-json-and-parquet-data">"Handling Different Data Types"</a>, <a href="/docs/kvgen/">KVGEN</a>, and <a href="/docs/flatten/">FLATTEN</a>.</p> +<p>A map is a set of name/value pairs. A value in a map can be a scalar type, such as string or int, or a complex type, such as an array or another map. An array is a repeated list of values. A value in an array can be a scalar type, such as string or int, or an array can be a complex type, such as a map or another array.</p> + +<p>Drill uses map and array data types internally for reading complex and nested data structures from data sources. For more information, see examples of <a href="/docs/handling-different-data-types/#handling-json-and-parquet-data">handling JSON maps and arrays</a>. </p> + +<p>In this release of Drill, you cannot reference a composite type by name in a query, but Drill supports array values coming from data sources. For example, you can use the index syntax to query data and get the value of an array element: </p> + +<p><code>a[1]</code> </p> + +<p>You can refer to the value for a key in a map using this syntax:</p> + +<p><code>m['k']</code></p> + +<p>The section <a href="/docs/querying-complex-data-introduction">âQuery Complex Dataâ</a> show how to use <a href="/docs/supported-data-types/#composite-types">composite types</a> to access nested arrays.</p> + +<p>For more information about using array and map types, see the sections, <a href="/docs/kvgen/">"KVGEN"</a> and <a href="/docs/flatten/">"FLATTEN"</a>.</p> <h2 id="casting-and-converting-data-types">Casting and Converting Data Types</h2> http://git-wip-us.apache.org/repos/asf/drill-site/blob/38ed649a/feed.xml ---------------------------------------------------------------------- diff --git a/feed.xml b/feed.xml index 9e69fd9..6e58f1d 100644 --- a/feed.xml +++ b/feed.xml @@ -6,8 +6,8 @@ </description> <link>/</link> <atom:link href="/feed.xml" rel="self" type="application/rss+xml"/> - <pubDate>Tue, 19 May 2015 23:06:50 -0700</pubDate> - <lastBuildDate>Tue, 19 May 2015 23:06:50 -0700</lastBuildDate> + <pubDate>Wed, 20 May 2015 15:01:17 -0700</pubDate> + <lastBuildDate>Wed, 20 May 2015 15:01:17 -0700</lastBuildDate> <generator>Jekyll v2.5.1</generator> <item> http://git-wip-us.apache.org/repos/asf/drill-site/blob/38ed649a/index.html ---------------------------------------------------------------------- diff --git a/index.html b/index.html index 0beffb5..c5fdd84 100644 --- a/index.html +++ b/index.html @@ -184,7 +184,7 @@ $(document).ready(function() { </td> <td class="fl"> <h1>Flexibility</h1> - <p>Analyze the multi-structured and nested data in non-relational datatastores directly without transforming or restricting the data</p> + <p>Analyze the multi-structured and nested data in non-relational datastores directly without transforming or restricting the data</p> </td> <td class="fam"> <h1>Familiarity</h1>
