You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@drill.apache.org by dz...@apache.org on 2021/07/27 14:59:16 UTC

[drill] 03/03: Move instructions on Drill site dir out of YARN section.

This is an automated email from the ASF dual-hosted git repository.

dzamo pushed a commit to branch gh-pages
in repository https://gitbox.apache.org/repos/asf/drill.git

commit f6db7c2010091719787ecc7842da7c658eabc96e
Author: James Turton <ja...@somecomputer.xyz>
AuthorDate: Tue Jul 27 16:58:42 2021 +0200

    Move instructions on Drill site dir out of YARN section.
---
 _data/docs.json                                    | 2290 ++++++++++----------
 .../020-creating-a-basic-drill-cluster.md          |  263 ++-
 .../install/047-installing-drill-on-the-cluster.md |   76 +-
 .../030-date-time-functions-and-arithmetic.md      |    2 +
 4 files changed, 1338 insertions(+), 1293 deletions(-)

diff --git a/_data/docs.json b/_data/docs.json
index 8389fa5..6544170 100644
--- a/_data/docs.json
+++ b/_data/docs.json
@@ -24112,6 +24112,23 @@
     },
     "zh": {
         "by_title": {
+            "10\u5206\u949f\u4e86\u89e3 Drill": {
+                "breadcrumbs": [
+                    {
+                        "title": "\u6559\u7a0b",
+                        "url": "/docs/tutorials/"
+                    }
+                ],
+                "children": [],
+                "next_title": "\u5206\u6790 Yelp \u5b66\u672f\u6570\u636e\u96c6",
+                "next_url": "/docs/analyzing-the-yelp-academic-dataset/",
+                "parent": "\u6559\u7a0b",
+                "previous_title": "\u6559\u7a0b\u4ecb\u7ecd",
+                "previous_url": "/docs/tutorials-introduction/",
+                "relative_path": "_docs/zh/tutorials/020-drill-in-10-minutes.md",
+                "title": "10\u5206\u949f\u4e86\u89e3 Drill",
+                "url": "/docs/drill-in-10-minutes/"
+            },
             "ALTER SYSTEM": {
                 "breadcrumbs": [
                     {
@@ -24196,27 +24213,6 @@
                 "title": "About SQL Function Examples",
                 "url": "/docs/about-sql-function-examples/"
             },
-            "About the MapR Sandbox": {
-                "breadcrumbs": [
-                    {
-                        "title": "Learn Drill with the MapR Sandbox",
-                        "url": "/docs/learn-drill-with-the-mapr-sandbox/"
-                    },
-                    {
-                        "title": "Tutorials",
-                        "url": "/docs/tutorials/"
-                    }
-                ],
-                "children": [],
-                "next_title": "Installing the Apache Drill Sandbox",
-                "next_url": "/docs/installing-the-apache-drill-sandbox/",
-                "parent": "Learn Drill with the MapR Sandbox",
-                "previous_title": "Learn Drill with the MapR Sandbox",
-                "previous_url": "/docs/learn-drill-with-the-mapr-sandbox/",
-                "relative_path": "_docs/en/tutorials/learn-drill-with-the-mapr-sandbox/005-about-the-mapr-sandbox.md",
-                "title": "About the MapR Sandbox",
-                "url": "/docs/about-the-mapr-sandbox/"
-            },
             "Adding Custom Functions to Drill": {
                 "breadcrumbs": [
                     {
@@ -24382,74 +24378,6 @@
                 "title": "Aggregate and Aggregate Statistical",
                 "url": "/docs/aggregate-and-aggregate-statistical/"
             },
-            "Analyzing Data Using Window Functions": {
-                "breadcrumbs": [
-                    {
-                        "title": "Tutorials",
-                        "url": "/docs/tutorials/"
-                    }
-                ],
-                "children": [],
-                "next_title": "Drill-on-YARN",
-                "next_url": "/docs/drill-on-yarn/",
-                "parent": "Tutorials",
-                "previous_title": "Analyzing Social Media",
-                "previous_url": "/docs/analyzing-social-media/",
-                "relative_path": "_docs/en/tutorials/070-analyzing-data-using-window-functions.md",
-                "title": "Analyzing Data Using Window Functions",
-                "url": "/docs/analyzing-data-using-window-functions/"
-            },
-            "Analyzing Highly Dynamic Datasets": {
-                "breadcrumbs": [
-                    {
-                        "title": "Tutorials",
-                        "url": "/docs/tutorials/"
-                    }
-                ],
-                "children": [],
-                "next_title": "Analyzing Social Media",
-                "next_url": "/docs/analyzing-social-media/",
-                "parent": "Tutorials",
-                "previous_title": "Summary",
-                "previous_url": "/docs/summary/",
-                "relative_path": "_docs/en/tutorials/050-analyzing-highly-dynamic-datasets.md",
-                "title": "Analyzing Highly Dynamic Datasets",
-                "url": "/docs/analyzing-highly-dynamic-datasets/"
-            },
-            "Analyzing Social Media": {
-                "breadcrumbs": [
-                    {
-                        "title": "Tutorials",
-                        "url": "/docs/tutorials/"
-                    }
-                ],
-                "children": [],
-                "next_title": "Analyzing Data Using Window Functions",
-                "next_url": "/docs/analyzing-data-using-window-functions/",
-                "parent": "Tutorials",
-                "previous_title": "Analyzing Highly Dynamic Datasets",
-                "previous_url": "/docs/analyzing-highly-dynamic-datasets/",
-                "relative_path": "_docs/en/tutorials/060-analyzing-social-media.md",
-                "title": "Analyzing Social Media",
-                "url": "/docs/analyzing-social-media/"
-            },
-            "Analyzing the Yelp Academic Dataset": {
-                "breadcrumbs": [
-                    {
-                        "title": "Tutorials",
-                        "url": "/docs/tutorials/"
-                    }
-                ],
-                "children": [],
-                "next_title": "Learn Drill with the MapR Sandbox",
-                "next_url": "/docs/learn-drill-with-the-mapr-sandbox/",
-                "parent": "Tutorials",
-                "previous_title": "Drill in 10 Minutes",
-                "previous_url": "/docs/drill-in-10-minutes/",
-                "relative_path": "_docs/en/tutorials/030-analyzing-the-yelp-academic-dataset.md",
-                "title": "Analyzing the Yelp Academic Dataset",
-                "url": "/docs/analyzing-the-yelp-academic-dataset/"
-            },
             "Apache Drill 0.4.0 Release Notes": {
                 "breadcrumbs": [
                     {
@@ -25081,7 +25009,7 @@
                             }
                         ],
                         "children": [],
-                        "next_title": "Tutorials",
+                        "next_title": "\u6559\u7a0b",
                         "next_url": "/docs/tutorials/",
                         "parent": "Architecture",
                         "previous_title": "Core Modules",
@@ -29075,23 +29003,6 @@
                 "title": "Drill Query Execution",
                 "url": "/docs/drill-query-execution/"
             },
-            "Drill in 10 Minutes": {
-                "breadcrumbs": [
-                    {
-                        "title": "Tutorials",
-                        "url": "/docs/tutorials/"
-                    }
-                ],
-                "children": [],
-                "next_title": "Analyzing the Yelp Academic Dataset",
-                "next_url": "/docs/analyzing-the-yelp-academic-dataset/",
-                "parent": "Tutorials",
-                "previous_title": "Tutorials Introduction",
-                "previous_url": "/docs/tutorials-introduction/",
-                "relative_path": "_docs/en/tutorials/020-drill-in-10-minutes.md",
-                "title": "Drill in 10 Minutes",
-                "url": "/docs/drill-in-10-minutes/"
-            },
             "Drill-on-YARN": {
                 "breadcrumbs": [],
                 "children": [
@@ -29303,7 +29214,7 @@
                 "next_title": "Drill-on-YARN Introduction",
                 "next_url": "/docs/drill-on-yarn-introduction/",
                 "parent": "",
-                "previous_title": "Analyzing Data Using Window Functions",
+                "previous_title": "\u901a\u8fc7\u7a97\u53e3\u51fd\u6570\u5206\u6790\u6570\u636e\u96c6",
                 "previous_url": "/docs/analyzing-data-using-window-functions/",
                 "relative_path": "_docs/en/031-drill-on-yarn.md",
                 "title": "Drill-on-YARN",
@@ -29698,27 +29609,6 @@
                 "title": "GROUP BY Clause",
                 "url": "/docs/group-by-clause/"
             },
-            "Getting to Know the Drill Sandbox": {
-                "breadcrumbs": [
-                    {
-                        "title": "Learn Drill with the MapR Sandbox",
-                        "url": "/docs/learn-drill-with-the-mapr-sandbox/"
-                    },
-                    {
-                        "title": "Tutorials",
-                        "url": "/docs/tutorials/"
-                    }
-                ],
-                "children": [],
-                "next_title": "Lesson 1: Learn about the Data Set",
-                "next_url": "/docs/lesson-1-learn-about-the-data-set/",
-                "parent": "Learn Drill with the MapR Sandbox",
-                "previous_title": "Installing the Apache Drill Sandbox",
-                "previous_url": "/docs/installing-the-apache-drill-sandbox/",
-                "relative_path": "_docs/en/tutorials/learn-drill-with-the-mapr-sandbox/020-getting-to-know-the-drill-sandbox.md",
-                "title": "Getting to Know the Drill Sandbox",
-                "url": "/docs/getting-to-know-the-drill-sandbox/"
-            },
             "Global Query List": {
                 "breadcrumbs": [
                     {
@@ -30707,27 +30597,6 @@
                 "title": "Installing Drill on the Cluster",
                 "url": "/docs/installing-drill-on-the-cluster/"
             },
-            "Installing the Apache Drill Sandbox": {
-                "breadcrumbs": [
-                    {
-                        "title": "Learn Drill with the MapR Sandbox",
-                        "url": "/docs/learn-drill-with-the-mapr-sandbox/"
-                    },
-                    {
-                        "title": "Tutorials",
-                        "url": "/docs/tutorials/"
-                    }
-                ],
-                "children": [],
-                "next_title": "Getting to Know the Drill Sandbox",
-                "next_url": "/docs/getting-to-know-the-drill-sandbox/",
-                "parent": "Learn Drill with the MapR Sandbox",
-                "previous_title": "About the MapR Sandbox",
-                "previous_url": "/docs/about-the-mapr-sandbox/",
-                "relative_path": "_docs/en/tutorials/learn-drill-with-the-mapr-sandbox/010-installing-the-apache-drill-sandbox.md",
-                "title": "Installing the Apache Drill Sandbox",
-                "url": "/docs/installing-the-apache-drill-sandbox/"
-            },
             "Installing the Driver on Linux": {
                 "breadcrumbs": [
                     {
@@ -31041,304 +30910,76 @@
                 "title": "Launch Drill Under YARN",
                 "url": "/docs/launch-drill-under-yarn/"
             },
-            "Learn Drill with the MapR Sandbox": {
+            "Lexical Structure": {
                 "breadcrumbs": [
                     {
-                        "title": "Tutorials",
-                        "url": "/docs/tutorials/"
+                        "title": "SQL Reference",
+                        "url": "/docs/sql-reference/"
                     }
                 ],
+                "children": [],
+                "next_title": "Operators",
+                "next_url": "/docs/operators/",
+                "parent": "SQL Reference",
+                "previous_title": "Handling Different Data Types",
+                "previous_url": "/docs/handling-different-data-types/",
+                "relative_path": "_docs/en/sql-reference/030-lexical-structure.md",
+                "title": "Lexical Structure",
+                "url": "/docs/lexical-structure/"
+            },
+            "Log and Debug": {
+                "breadcrumbs": [],
                 "children": [
                     {
                         "breadcrumbs": [
                             {
-                                "title": "Learn Drill with the MapR Sandbox",
-                                "url": "/docs/learn-drill-with-the-mapr-sandbox/"
-                            },
-                            {
-                                "title": "Tutorials",
-                                "url": "/docs/tutorials/"
+                                "title": "Log and Debug",
+                                "url": "/docs/log-and-debug/"
                             }
                         ],
                         "children": [],
-                        "next_title": "Installing the Apache Drill Sandbox",
-                        "next_url": "/docs/installing-the-apache-drill-sandbox/",
-                        "parent": "Learn Drill with the MapR Sandbox",
-                        "previous_title": "Learn Drill with the MapR Sandbox",
-                        "previous_url": "/docs/learn-drill-with-the-mapr-sandbox/",
-                        "relative_path": "_docs/en/tutorials/learn-drill-with-the-mapr-sandbox/005-about-the-mapr-sandbox.md",
-                        "title": "About the MapR Sandbox",
-                        "url": "/docs/about-the-mapr-sandbox/"
+                        "next_title": "Error Messages",
+                        "next_url": "/docs/error-messages/",
+                        "parent": "Log and Debug",
+                        "previous_title": "Log and Debug",
+                        "previous_url": "/docs/log-and-debug/",
+                        "relative_path": "_docs/en/log-and-debug/001-log-and-debug-introduction.md",
+                        "title": "Log and Debug Introduction",
+                        "url": "/docs/log-and-debug-introduction/"
                     },
                     {
                         "breadcrumbs": [
                             {
-                                "title": "Learn Drill with the MapR Sandbox",
-                                "url": "/docs/learn-drill-with-the-mapr-sandbox/"
-                            },
-                            {
-                                "title": "Tutorials",
-                                "url": "/docs/tutorials/"
+                                "title": "Log and Debug",
+                                "url": "/docs/log-and-debug/"
                             }
                         ],
                         "children": [],
-                        "next_title": "Getting to Know the Drill Sandbox",
-                        "next_url": "/docs/getting-to-know-the-drill-sandbox/",
-                        "parent": "Learn Drill with the MapR Sandbox",
-                        "previous_title": "About the MapR Sandbox",
-                        "previous_url": "/docs/about-the-mapr-sandbox/",
-                        "relative_path": "_docs/en/tutorials/learn-drill-with-the-mapr-sandbox/010-installing-the-apache-drill-sandbox.md",
-                        "title": "Installing the Apache Drill Sandbox",
-                        "url": "/docs/installing-the-apache-drill-sandbox/"
+                        "next_title": "Modify logback.xml",
+                        "next_url": "/docs/modify-logback-xml/",
+                        "parent": "Log and Debug",
+                        "previous_title": "Log and Debug Introduction",
+                        "previous_url": "/docs/log-and-debug-introduction/",
+                        "relative_path": "_docs/en/log-and-debug/002-error-messages.md",
+                        "title": "Error Messages",
+                        "url": "/docs/error-messages/"
                     },
                     {
                         "breadcrumbs": [
                             {
-                                "title": "Learn Drill with the MapR Sandbox",
-                                "url": "/docs/learn-drill-with-the-mapr-sandbox/"
-                            },
-                            {
-                                "title": "Tutorials",
-                                "url": "/docs/tutorials/"
+                                "title": "Log and Debug",
+                                "url": "/docs/log-and-debug/"
                             }
                         ],
                         "children": [],
-                        "next_title": "Lesson 1: Learn about the Data Set",
-                        "next_url": "/docs/lesson-1-learn-about-the-data-set/",
-                        "parent": "Learn Drill with the MapR Sandbox",
-                        "previous_title": "Installing the Apache Drill Sandbox",
-                        "previous_url": "/docs/installing-the-apache-drill-sandbox/",
-                        "relative_path": "_docs/en/tutorials/learn-drill-with-the-mapr-sandbox/020-getting-to-know-the-drill-sandbox.md",
-                        "title": "Getting to Know the Drill Sandbox",
-                        "url": "/docs/getting-to-know-the-drill-sandbox/"
-                    },
-                    {
-                        "breadcrumbs": [
-                            {
-                                "title": "Learn Drill with the MapR Sandbox",
-                                "url": "/docs/learn-drill-with-the-mapr-sandbox/"
-                            },
-                            {
-                                "title": "Tutorials",
-                                "url": "/docs/tutorials/"
-                            }
-                        ],
-                        "children": [],
-                        "next_title": "Lesson 2: Run Queries with ANSI SQL",
-                        "next_url": "/docs/lesson-2-run-queries-with-ansi-sql/",
-                        "parent": "Learn Drill with the MapR Sandbox",
-                        "previous_title": "Getting to Know the Drill Sandbox",
-                        "previous_url": "/docs/getting-to-know-the-drill-sandbox/",
-                        "relative_path": "_docs/en/tutorials/learn-drill-with-the-mapr-sandbox/030-lesson-1-learn-about-the-data-set.md",
-                        "title": "Lesson 1: Learn about the Data Set",
-                        "url": "/docs/lesson-1-learn-about-the-data-set/"
-                    },
-                    {
-                        "breadcrumbs": [
-                            {
-                                "title": "Learn Drill with the MapR Sandbox",
-                                "url": "/docs/learn-drill-with-the-mapr-sandbox/"
-                            },
-                            {
-                                "title": "Tutorials",
-                                "url": "/docs/tutorials/"
-                            }
-                        ],
-                        "children": [],
-                        "next_title": "Lesson 3: Run Queries on Complex Data Types",
-                        "next_url": "/docs/lesson-3-run-queries-on-complex-data-types/",
-                        "parent": "Learn Drill with the MapR Sandbox",
-                        "previous_title": "Lesson 1: Learn about the Data Set",
-                        "previous_url": "/docs/lesson-1-learn-about-the-data-set/",
-                        "relative_path": "_docs/en/tutorials/learn-drill-with-the-mapr-sandbox/040-lesson-2-run-queries-with-ansi-sql.md",
-                        "title": "Lesson 2: Run Queries with ANSI SQL",
-                        "url": "/docs/lesson-2-run-queries-with-ansi-sql/"
-                    },
-                    {
-                        "breadcrumbs": [
-                            {
-                                "title": "Learn Drill with the MapR Sandbox",
-                                "url": "/docs/learn-drill-with-the-mapr-sandbox/"
-                            },
-                            {
-                                "title": "Tutorials",
-                                "url": "/docs/tutorials/"
-                            }
-                        ],
-                        "children": [],
-                        "next_title": "Summary",
-                        "next_url": "/docs/summary/",
-                        "parent": "Learn Drill with the MapR Sandbox",
-                        "previous_title": "Lesson 2: Run Queries with ANSI SQL",
-                        "previous_url": "/docs/lesson-2-run-queries-with-ansi-sql/",
-                        "relative_path": "_docs/en/tutorials/learn-drill-with-the-mapr-sandbox/050-lesson-3-run-queries-on-complex-data-types.md",
-                        "title": "Lesson 3: Run Queries on Complex Data Types",
-                        "url": "/docs/lesson-3-run-queries-on-complex-data-types/"
-                    },
-                    {
-                        "breadcrumbs": [
-                            {
-                                "title": "Learn Drill with the MapR Sandbox",
-                                "url": "/docs/learn-drill-with-the-mapr-sandbox/"
-                            },
-                            {
-                                "title": "Tutorials",
-                                "url": "/docs/tutorials/"
-                            }
-                        ],
-                        "children": [],
-                        "next_title": "Analyzing Highly Dynamic Datasets",
-                        "next_url": "/docs/analyzing-highly-dynamic-datasets/",
-                        "parent": "Learn Drill with the MapR Sandbox",
-                        "previous_title": "Lesson 3: Run Queries on Complex Data Types",
-                        "previous_url": "/docs/lesson-3-run-queries-on-complex-data-types/",
-                        "relative_path": "_docs/en/tutorials/learn-drill-with-the-mapr-sandbox/060-summary.md",
-                        "title": "Summary",
-                        "url": "/docs/summary/"
-                    }
-                ],
-                "next_title": "About the MapR Sandbox",
-                "next_url": "/docs/about-the-mapr-sandbox/",
-                "parent": "Tutorials",
-                "previous_title": "Analyzing the Yelp Academic Dataset",
-                "previous_url": "/docs/analyzing-the-yelp-academic-dataset/",
-                "relative_path": "_docs/en/tutorials/040-learn-drill-with-the-mapr-sandbox.md",
-                "title": "Learn Drill with the MapR Sandbox",
-                "url": "/docs/learn-drill-with-the-mapr-sandbox/"
-            },
-            "Lesson 1: Learn about the Data Set": {
-                "breadcrumbs": [
-                    {
-                        "title": "Learn Drill with the MapR Sandbox",
-                        "url": "/docs/learn-drill-with-the-mapr-sandbox/"
-                    },
-                    {
-                        "title": "Tutorials",
-                        "url": "/docs/tutorials/"
-                    }
-                ],
-                "children": [],
-                "next_title": "Lesson 2: Run Queries with ANSI SQL",
-                "next_url": "/docs/lesson-2-run-queries-with-ansi-sql/",
-                "parent": "Learn Drill with the MapR Sandbox",
-                "previous_title": "Getting to Know the Drill Sandbox",
-                "previous_url": "/docs/getting-to-know-the-drill-sandbox/",
-                "relative_path": "_docs/en/tutorials/learn-drill-with-the-mapr-sandbox/030-lesson-1-learn-about-the-data-set.md",
-                "title": "Lesson 1: Learn about the Data Set",
-                "url": "/docs/lesson-1-learn-about-the-data-set/"
-            },
-            "Lesson 2: Run Queries with ANSI SQL": {
-                "breadcrumbs": [
-                    {
-                        "title": "Learn Drill with the MapR Sandbox",
-                        "url": "/docs/learn-drill-with-the-mapr-sandbox/"
-                    },
-                    {
-                        "title": "Tutorials",
-                        "url": "/docs/tutorials/"
-                    }
-                ],
-                "children": [],
-                "next_title": "Lesson 3: Run Queries on Complex Data Types",
-                "next_url": "/docs/lesson-3-run-queries-on-complex-data-types/",
-                "parent": "Learn Drill with the MapR Sandbox",
-                "previous_title": "Lesson 1: Learn about the Data Set",
-                "previous_url": "/docs/lesson-1-learn-about-the-data-set/",
-                "relative_path": "_docs/en/tutorials/learn-drill-with-the-mapr-sandbox/040-lesson-2-run-queries-with-ansi-sql.md",
-                "title": "Lesson 2: Run Queries with ANSI SQL",
-                "url": "/docs/lesson-2-run-queries-with-ansi-sql/"
-            },
-            "Lesson 3: Run Queries on Complex Data Types": {
-                "breadcrumbs": [
-                    {
-                        "title": "Learn Drill with the MapR Sandbox",
-                        "url": "/docs/learn-drill-with-the-mapr-sandbox/"
-                    },
-                    {
-                        "title": "Tutorials",
-                        "url": "/docs/tutorials/"
-                    }
-                ],
-                "children": [],
-                "next_title": "Summary",
-                "next_url": "/docs/summary/",
-                "parent": "Learn Drill with the MapR Sandbox",
-                "previous_title": "Lesson 2: Run Queries with ANSI SQL",
-                "previous_url": "/docs/lesson-2-run-queries-with-ansi-sql/",
-                "relative_path": "_docs/en/tutorials/learn-drill-with-the-mapr-sandbox/050-lesson-3-run-queries-on-complex-data-types.md",
-                "title": "Lesson 3: Run Queries on Complex Data Types",
-                "url": "/docs/lesson-3-run-queries-on-complex-data-types/"
-            },
-            "Lexical Structure": {
-                "breadcrumbs": [
-                    {
-                        "title": "SQL Reference",
-                        "url": "/docs/sql-reference/"
-                    }
-                ],
-                "children": [],
-                "next_title": "Operators",
-                "next_url": "/docs/operators/",
-                "parent": "SQL Reference",
-                "previous_title": "Handling Different Data Types",
-                "previous_url": "/docs/handling-different-data-types/",
-                "relative_path": "_docs/en/sql-reference/030-lexical-structure.md",
-                "title": "Lexical Structure",
-                "url": "/docs/lexical-structure/"
-            },
-            "Log and Debug": {
-                "breadcrumbs": [],
-                "children": [
-                    {
-                        "breadcrumbs": [
-                            {
-                                "title": "Log and Debug",
-                                "url": "/docs/log-and-debug/"
-                            }
-                        ],
-                        "children": [],
-                        "next_title": "Error Messages",
-                        "next_url": "/docs/error-messages/",
-                        "parent": "Log and Debug",
-                        "previous_title": "Log and Debug",
-                        "previous_url": "/docs/log-and-debug/",
-                        "relative_path": "_docs/en/log-and-debug/001-log-and-debug-introduction.md",
-                        "title": "Log and Debug Introduction",
-                        "url": "/docs/log-and-debug-introduction/"
-                    },
-                    {
-                        "breadcrumbs": [
-                            {
-                                "title": "Log and Debug",
-                                "url": "/docs/log-and-debug/"
-                            }
-                        ],
-                        "children": [],
-                        "next_title": "Modify logback.xml",
-                        "next_url": "/docs/modify-logback-xml/",
-                        "parent": "Log and Debug",
-                        "previous_title": "Log and Debug Introduction",
-                        "previous_url": "/docs/log-and-debug-introduction/",
-                        "relative_path": "_docs/en/log-and-debug/002-error-messages.md",
-                        "title": "Error Messages",
-                        "url": "/docs/error-messages/"
-                    },
-                    {
-                        "breadcrumbs": [
-                            {
-                                "title": "Log and Debug",
-                                "url": "/docs/log-and-debug/"
-                            }
-                        ],
-                        "children": [],
-                        "next_title": "Review the Java Stack Trace",
-                        "next_url": "/docs/review-the-java-stack-trace/",
-                        "parent": "Log and Debug",
-                        "previous_title": "Error Messages",
-                        "previous_url": "/docs/error-messages/",
-                        "relative_path": "_docs/en/log-and-debug/003-modify-logback.xml.md",
-                        "title": "Modify logback.xml",
-                        "url": "/docs/modify-logback-xml/"
+                        "next_title": "Review the Java Stack Trace",
+                        "next_url": "/docs/review-the-java-stack-trace/",
+                        "parent": "Log and Debug",
+                        "previous_title": "Error Messages",
+                        "previous_url": "/docs/error-messages/",
+                        "relative_path": "_docs/en/log-and-debug/003-modify-logback.xml.md",
+                        "title": "Modify logback.xml",
+                        "url": "/docs/modify-logback-xml/"
                     },
                     {
                         "breadcrumbs": [
@@ -32642,7 +32283,7 @@
                     }
                 ],
                 "children": [],
-                "next_title": "Tutorials",
+                "next_title": "\u6559\u7a0b",
                 "next_url": "/docs/tutorials/",
                 "parent": "Architecture",
                 "previous_title": "Core Modules",
@@ -39829,27 +39470,6 @@
                 "title": "Submitting Queries from the REST API when Impersonation is Enabled and Authentication is Disabled",
                 "url": "/docs/submitting-queries-from-the-rest-api-when-impersonation-is-enabled-and-authentication-is-disabled/"
             },
-            "Summary": {
-                "breadcrumbs": [
-                    {
-                        "title": "Learn Drill with the MapR Sandbox",
-                        "url": "/docs/learn-drill-with-the-mapr-sandbox/"
-                    },
-                    {
-                        "title": "Tutorials",
-                        "url": "/docs/tutorials/"
-                    }
-                ],
-                "children": [],
-                "next_title": "Analyzing Highly Dynamic Datasets",
-                "next_url": "/docs/analyzing-highly-dynamic-datasets/",
-                "parent": "Learn Drill with the MapR Sandbox",
-                "previous_title": "Lesson 3: Run Queries on Complex Data Types",
-                "previous_url": "/docs/lesson-3-run-queries-on-complex-data-types/",
-                "relative_path": "_docs/en/tutorials/learn-drill-with-the-mapr-sandbox/060-summary.md",
-                "title": "Summary",
-                "url": "/docs/summary/"
-            },
             "Supported Data Types": {
                 "breadcrumbs": [
                     {
@@ -40039,305 +39659,8 @@
                 "title": "Tutorial: Develop a Simple Function",
                 "url": "/docs/tutorial-develop-a-simple-function/"
             },
-            "Tutorials": {
-                "breadcrumbs": [],
-                "children": [
-                    {
-                        "breadcrumbs": [
-                            {
-                                "title": "Tutorials",
-                                "url": "/docs/tutorials/"
-                            }
-                        ],
-                        "children": [],
-                        "next_title": "Drill in 10 Minutes",
-                        "next_url": "/docs/drill-in-10-minutes/",
-                        "parent": "Tutorials",
-                        "previous_title": "Tutorials",
-                        "previous_url": "/docs/tutorials/",
-                        "relative_path": "_docs/en/tutorials/010-tutorials-introduction.md",
-                        "title": "Tutorials Introduction",
-                        "url": "/docs/tutorials-introduction/"
-                    },
-                    {
-                        "breadcrumbs": [
-                            {
-                                "title": "Tutorials",
-                                "url": "/docs/tutorials/"
-                            }
-                        ],
-                        "children": [],
-                        "next_title": "Analyzing the Yelp Academic Dataset",
-                        "next_url": "/docs/analyzing-the-yelp-academic-dataset/",
-                        "parent": "Tutorials",
-                        "previous_title": "Tutorials Introduction",
-                        "previous_url": "/docs/tutorials-introduction/",
-                        "relative_path": "_docs/en/tutorials/020-drill-in-10-minutes.md",
-                        "title": "Drill in 10 Minutes",
-                        "url": "/docs/drill-in-10-minutes/"
-                    },
-                    {
-                        "breadcrumbs": [
-                            {
-                                "title": "Tutorials",
-                                "url": "/docs/tutorials/"
-                            }
-                        ],
-                        "children": [],
-                        "next_title": "Learn Drill with the MapR Sandbox",
-                        "next_url": "/docs/learn-drill-with-the-mapr-sandbox/",
-                        "parent": "Tutorials",
-                        "previous_title": "Drill in 10 Minutes",
-                        "previous_url": "/docs/drill-in-10-minutes/",
-                        "relative_path": "_docs/en/tutorials/030-analyzing-the-yelp-academic-dataset.md",
-                        "title": "Analyzing the Yelp Academic Dataset",
-                        "url": "/docs/analyzing-the-yelp-academic-dataset/"
-                    },
-                    {
-                        "breadcrumbs": [
-                            {
-                                "title": "Tutorials",
-                                "url": "/docs/tutorials/"
-                            }
-                        ],
-                        "children": [
-                            {
-                                "breadcrumbs": [
-                                    {
-                                        "title": "Learn Drill with the MapR Sandbox",
-                                        "url": "/docs/learn-drill-with-the-mapr-sandbox/"
-                                    },
-                                    {
-                                        "title": "Tutorials",
-                                        "url": "/docs/tutorials/"
-                                    }
-                                ],
-                                "children": [],
-                                "next_title": "Installing the Apache Drill Sandbox",
-                                "next_url": "/docs/installing-the-apache-drill-sandbox/",
-                                "parent": "Learn Drill with the MapR Sandbox",
-                                "previous_title": "Learn Drill with the MapR Sandbox",
-                                "previous_url": "/docs/learn-drill-with-the-mapr-sandbox/",
-                                "relative_path": "_docs/en/tutorials/learn-drill-with-the-mapr-sandbox/005-about-the-mapr-sandbox.md",
-                                "title": "About the MapR Sandbox",
-                                "url": "/docs/about-the-mapr-sandbox/"
-                            },
-                            {
-                                "breadcrumbs": [
-                                    {
-                                        "title": "Learn Drill with the MapR Sandbox",
-                                        "url": "/docs/learn-drill-with-the-mapr-sandbox/"
-                                    },
-                                    {
-                                        "title": "Tutorials",
-                                        "url": "/docs/tutorials/"
-                                    }
-                                ],
-                                "children": [],
-                                "next_title": "Getting to Know the Drill Sandbox",
-                                "next_url": "/docs/getting-to-know-the-drill-sandbox/",
-                                "parent": "Learn Drill with the MapR Sandbox",
-                                "previous_title": "About the MapR Sandbox",
-                                "previous_url": "/docs/about-the-mapr-sandbox/",
-                                "relative_path": "_docs/en/tutorials/learn-drill-with-the-mapr-sandbox/010-installing-the-apache-drill-sandbox.md",
-                                "title": "Installing the Apache Drill Sandbox",
-                                "url": "/docs/installing-the-apache-drill-sandbox/"
-                            },
-                            {
-                                "breadcrumbs": [
-                                    {
-                                        "title": "Learn Drill with the MapR Sandbox",
-                                        "url": "/docs/learn-drill-with-the-mapr-sandbox/"
-                                    },
-                                    {
-                                        "title": "Tutorials",
-                                        "url": "/docs/tutorials/"
-                                    }
-                                ],
-                                "children": [],
-                                "next_title": "Lesson 1: Learn about the Data Set",
-                                "next_url": "/docs/lesson-1-learn-about-the-data-set/",
-                                "parent": "Learn Drill with the MapR Sandbox",
-                                "previous_title": "Installing the Apache Drill Sandbox",
-                                "previous_url": "/docs/installing-the-apache-drill-sandbox/",
-                                "relative_path": "_docs/en/tutorials/learn-drill-with-the-mapr-sandbox/020-getting-to-know-the-drill-sandbox.md",
-                                "title": "Getting to Know the Drill Sandbox",
-                                "url": "/docs/getting-to-know-the-drill-sandbox/"
-                            },
-                            {
-                                "breadcrumbs": [
-                                    {
-                                        "title": "Learn Drill with the MapR Sandbox",
-                                        "url": "/docs/learn-drill-with-the-mapr-sandbox/"
-                                    },
-                                    {
-                                        "title": "Tutorials",
-                                        "url": "/docs/tutorials/"
-                                    }
-                                ],
-                                "children": [],
-                                "next_title": "Lesson 2: Run Queries with ANSI SQL",
-                                "next_url": "/docs/lesson-2-run-queries-with-ansi-sql/",
-                                "parent": "Learn Drill with the MapR Sandbox",
-                                "previous_title": "Getting to Know the Drill Sandbox",
-                                "previous_url": "/docs/getting-to-know-the-drill-sandbox/",
-                                "relative_path": "_docs/en/tutorials/learn-drill-with-the-mapr-sandbox/030-lesson-1-learn-about-the-data-set.md",
-                                "title": "Lesson 1: Learn about the Data Set",
-                                "url": "/docs/lesson-1-learn-about-the-data-set/"
-                            },
-                            {
-                                "breadcrumbs": [
-                                    {
-                                        "title": "Learn Drill with the MapR Sandbox",
-                                        "url": "/docs/learn-drill-with-the-mapr-sandbox/"
-                                    },
-                                    {
-                                        "title": "Tutorials",
-                                        "url": "/docs/tutorials/"
-                                    }
-                                ],
-                                "children": [],
-                                "next_title": "Lesson 3: Run Queries on Complex Data Types",
-                                "next_url": "/docs/lesson-3-run-queries-on-complex-data-types/",
-                                "parent": "Learn Drill with the MapR Sandbox",
-                                "previous_title": "Lesson 1: Learn about the Data Set",
-                                "previous_url": "/docs/lesson-1-learn-about-the-data-set/",
-                                "relative_path": "_docs/en/tutorials/learn-drill-with-the-mapr-sandbox/040-lesson-2-run-queries-with-ansi-sql.md",
-                                "title": "Lesson 2: Run Queries with ANSI SQL",
-                                "url": "/docs/lesson-2-run-queries-with-ansi-sql/"
-                            },
-                            {
-                                "breadcrumbs": [
-                                    {
-                                        "title": "Learn Drill with the MapR Sandbox",
-                                        "url": "/docs/learn-drill-with-the-mapr-sandbox/"
-                                    },
-                                    {
-                                        "title": "Tutorials",
-                                        "url": "/docs/tutorials/"
-                                    }
-                                ],
-                                "children": [],
-                                "next_title": "Summary",
-                                "next_url": "/docs/summary/",
-                                "parent": "Learn Drill with the MapR Sandbox",
-                                "previous_title": "Lesson 2: Run Queries with ANSI SQL",
-                                "previous_url": "/docs/lesson-2-run-queries-with-ansi-sql/",
-                                "relative_path": "_docs/en/tutorials/learn-drill-with-the-mapr-sandbox/050-lesson-3-run-queries-on-complex-data-types.md",
-                                "title": "Lesson 3: Run Queries on Complex Data Types",
-                                "url": "/docs/lesson-3-run-queries-on-complex-data-types/"
-                            },
-                            {
-                                "breadcrumbs": [
-                                    {
-                                        "title": "Learn Drill with the MapR Sandbox",
-                                        "url": "/docs/learn-drill-with-the-mapr-sandbox/"
-                                    },
-                                    {
-                                        "title": "Tutorials",
-                                        "url": "/docs/tutorials/"
-                                    }
-                                ],
-                                "children": [],
-                                "next_title": "Analyzing Highly Dynamic Datasets",
-                                "next_url": "/docs/analyzing-highly-dynamic-datasets/",
-                                "parent": "Learn Drill with the MapR Sandbox",
-                                "previous_title": "Lesson 3: Run Queries on Complex Data Types",
-                                "previous_url": "/docs/lesson-3-run-queries-on-complex-data-types/",
-                                "relative_path": "_docs/en/tutorials/learn-drill-with-the-mapr-sandbox/060-summary.md",
-                                "title": "Summary",
-                                "url": "/docs/summary/"
-                            }
-                        ],
-                        "next_title": "About the MapR Sandbox",
-                        "next_url": "/docs/about-the-mapr-sandbox/",
-                        "parent": "Tutorials",
-                        "previous_title": "Analyzing the Yelp Academic Dataset",
-                        "previous_url": "/docs/analyzing-the-yelp-academic-dataset/",
-                        "relative_path": "_docs/en/tutorials/040-learn-drill-with-the-mapr-sandbox.md",
-                        "title": "Learn Drill with the MapR Sandbox",
-                        "url": "/docs/learn-drill-with-the-mapr-sandbox/"
-                    },
-                    {
-                        "breadcrumbs": [
-                            {
-                                "title": "Tutorials",
-                                "url": "/docs/tutorials/"
-                            }
-                        ],
-                        "children": [],
-                        "next_title": "Analyzing Social Media",
-                        "next_url": "/docs/analyzing-social-media/",
-                        "parent": "Tutorials",
-                        "previous_title": "Summary",
-                        "previous_url": "/docs/summary/",
-                        "relative_path": "_docs/en/tutorials/050-analyzing-highly-dynamic-datasets.md",
-                        "title": "Analyzing Highly Dynamic Datasets",
-                        "url": "/docs/analyzing-highly-dynamic-datasets/"
-                    },
-                    {
-                        "breadcrumbs": [
-                            {
-                                "title": "Tutorials",
-                                "url": "/docs/tutorials/"
-                            }
-                        ],
-                        "children": [],
-                        "next_title": "Analyzing Data Using Window Functions",
-                        "next_url": "/docs/analyzing-data-using-window-functions/",
-                        "parent": "Tutorials",
-                        "previous_title": "Analyzing Highly Dynamic Datasets",
-                        "previous_url": "/docs/analyzing-highly-dynamic-datasets/",
-                        "relative_path": "_docs/en/tutorials/060-analyzing-social-media.md",
-                        "title": "Analyzing Social Media",
-                        "url": "/docs/analyzing-social-media/"
-                    },
-                    {
-                        "breadcrumbs": [
-                            {
-                                "title": "Tutorials",
-                                "url": "/docs/tutorials/"
-                            }
-                        ],
-                        "children": [],
-                        "next_title": "Drill-on-YARN",
-                        "next_url": "/docs/drill-on-yarn/",
-                        "parent": "Tutorials",
-                        "previous_title": "Analyzing Social Media",
-                        "previous_url": "/docs/analyzing-social-media/",
-                        "relative_path": "_docs/en/tutorials/070-analyzing-data-using-window-functions.md",
-                        "title": "Analyzing Data Using Window Functions",
-                        "url": "/docs/analyzing-data-using-window-functions/"
-                    }
-                ],
-                "next_title": "Tutorials Introduction",
-                "next_url": "/docs/tutorials-introduction/",
-                "parent": "",
-                "previous_title": "Performance",
-                "previous_url": "/docs/performance/",
-                "relative_path": "_docs/en/030-tutorials.md",
-                "title": "Tutorials",
-                "url": "/docs/tutorials/"
-            },
-            "Tutorials Introduction": {
-                "breadcrumbs": [
-                    {
-                        "title": "Tutorials",
-                        "url": "/docs/tutorials/"
-                    }
-                ],
-                "children": [],
-                "next_title": "Drill in 10 Minutes",
-                "next_url": "/docs/drill-in-10-minutes/",
-                "parent": "Tutorials",
-                "previous_title": "Tutorials",
-                "previous_url": "/docs/tutorials/",
-                "relative_path": "_docs/en/tutorials/010-tutorials-introduction.md",
-                "title": "Tutorials Introduction",
-                "url": "/docs/tutorials-introduction/"
-            },
-            "Types of Indexes": {
-                "breadcrumbs": [
+            "Types of Indexes": {
+                "breadcrumbs": [
                     {
                         "title": "Querying Indexes",
                         "url": "/docs/querying-indexes/"
@@ -40884,16 +40207,155 @@
                         "url": "/docs/configuring-jreport-with-drill/"
                     }
                 ],
-                "next_title": "Using Drill with BI Tools Introduction",
-                "next_url": "/docs/using-drill-with-bi-tools-introduction/",
-                "parent": "ODBC/JDBC Interfaces",
-                "previous_title": "Browsing Data and Defining Views",
-                "previous_url": "/docs/browsing-data-and-defining-views/",
-                "relative_path": "_docs/en/odbc-jdbc-interfaces/060-using-drill-with-bi-tools.md",
-                "title": "Using Drill with BI Tools",
-                "url": "/docs/using-drill-with-bi-tools/"
+                "next_title": "Using Drill with BI Tools Introduction",
+                "next_url": "/docs/using-drill-with-bi-tools-introduction/",
+                "parent": "ODBC/JDBC Interfaces",
+                "previous_title": "Browsing Data and Defining Views",
+                "previous_url": "/docs/browsing-data-and-defining-views/",
+                "relative_path": "_docs/en/odbc-jdbc-interfaces/060-using-drill-with-bi-tools.md",
+                "title": "Using Drill with BI Tools",
+                "url": "/docs/using-drill-with-bi-tools/"
+            },
+            "Using Drill with BI Tools Introduction": {
+                "breadcrumbs": [
+                    {
+                        "title": "Using Drill with BI Tools",
+                        "url": "/docs/using-drill-with-bi-tools/"
+                    },
+                    {
+                        "title": "ODBC/JDBC Interfaces",
+                        "url": "/docs/odbc-jdbc-interfaces/"
+                    }
+                ],
+                "children": [],
+                "next_title": "Tableau Examples",
+                "next_url": "/docs/tableau-examples/",
+                "parent": "Using Drill with BI Tools",
+                "previous_title": "Using Drill with BI Tools",
+                "previous_url": "/docs/using-drill-with-bi-tools/",
+                "relative_path": "_docs/en/odbc-jdbc-interfaces/using-drill-with-bi-tools/010-using-odbc-with-bi-tools-introduction.md",
+                "title": "Using Drill with BI Tools Introduction",
+                "url": "/docs/using-drill-with-bi-tools-introduction/"
+            },
+            "Using Information Builders\u2019 WebFOCUS with Apache Drill": {
+                "breadcrumbs": [
+                    {
+                        "title": "Using Drill with BI Tools",
+                        "url": "/docs/using-drill-with-bi-tools/"
+                    },
+                    {
+                        "title": "ODBC/JDBC Interfaces",
+                        "url": "/docs/odbc-jdbc-interfaces/"
+                    }
+                ],
+                "children": [],
+                "next_title": "Configuring JReport with Drill",
+                "next_url": "/docs/configuring-jreport-with-drill/",
+                "parent": "Using Drill with BI Tools",
+                "previous_title": "Using Apache Drill with Tableau 9 Server",
+                "previous_url": "/docs/using-apache-drill-with-tableau-9-server/",
+                "relative_path": "_docs/en/odbc-jdbc-interfaces/using-drill-with-bi-tools/075-using-apache-drill-with-webfocus.md",
+                "title": "Using Information Builders\u2019 WebFOCUS with Apache Drill",
+                "url": "/docs/using-information-builders-webfocus-with-apache-drill/"
+            },
+            "Using JDBC with SQuirreL on Windows": {
+                "breadcrumbs": [
+                    {
+                        "title": "ODBC/JDBC Interfaces",
+                        "url": "/docs/odbc-jdbc-interfaces/"
+                    }
+                ],
+                "children": [],
+                "next_title": "Installing the ODBC Driver",
+                "next_url": "/docs/installing-the-odbc-driver/",
+                "parent": "ODBC/JDBC Interfaces",
+                "previous_title": "Using the JDBC Driver",
+                "previous_url": "/docs/using-the-jdbc-driver/",
+                "relative_path": "_docs/en/odbc-jdbc-interfaces/020-using-jdbc-with-squirrel-on-windows.md",
+                "title": "Using JDBC with SQuirreL on Windows",
+                "url": "/docs/using-jdbc-with-squirrel-on-windows/"
+            },
+            "Using MicroStrategy Analytics with Apache Drill": {
+                "breadcrumbs": [
+                    {
+                        "title": "Using Drill with BI Tools",
+                        "url": "/docs/using-drill-with-bi-tools/"
+                    },
+                    {
+                        "title": "ODBC/JDBC Interfaces",
+                        "url": "/docs/odbc-jdbc-interfaces/"
+                    }
+                ],
+                "children": [],
+                "next_title": "Using Tibco Spotfire Desktop with Drill",
+                "next_url": "/docs/using-tibco-spotfire-desktop-with-drill/",
+                "parent": "Using Drill with BI Tools",
+                "previous_title": "Tableau Examples",
+                "previous_url": "/docs/tableau-examples/",
+                "relative_path": "_docs/en/odbc-jdbc-interfaces/using-drill-with-bi-tools/030-using-microstrategy-analytics-with-apache-drill.md",
+                "title": "Using MicroStrategy Analytics with Apache Drill",
+                "url": "/docs/using-microstrategy-analytics-with-apache-drill/"
+            },
+            "Using Qlik Sense with Drill": {
+                "breadcrumbs": [
+                    {
+                        "title": "Using Drill with BI Tools",
+                        "url": "/docs/using-drill-with-bi-tools/"
+                    },
+                    {
+                        "title": "ODBC/JDBC Interfaces",
+                        "url": "/docs/odbc-jdbc-interfaces/"
+                    }
+                ],
+                "children": [],
+                "next_title": "Using Apache Drill with Tableau 10.2",
+                "next_url": "/docs/using-apache-drill-with-tableau-10-2/",
+                "parent": "Using Drill with BI Tools",
+                "previous_title": "Configuring Tibco Spotfire Server with Drill",
+                "previous_url": "/docs/configuring-tibco-spotfire-server-with-drill/",
+                "relative_path": "_docs/en/odbc-jdbc-interfaces/using-drill-with-bi-tools/055-using-qliksense-with-drill.md",
+                "title": "Using Qlik Sense with Drill",
+                "url": "/docs/using-qlik-sense-with-drill/"
+            },
+            "Using SQL Functions, Clauses, and Joins": {
+                "breadcrumbs": [
+                    {
+                        "title": "Querying Complex Data",
+                        "url": "/docs/querying-complex-data/"
+                    },
+                    {
+                        "title": "Query Data",
+                        "url": "/docs/query-data/"
+                    }
+                ],
+                "children": [],
+                "next_title": "Selecting Nested Data for a Column",
+                "next_url": "/docs/selecting-nested-data-for-a-column/",
+                "parent": "Querying Complex Data",
+                "previous_title": "Selecting Flat Data",
+                "previous_url": "/docs/selecting-flat-data/",
+                "relative_path": "_docs/en/query-data/querying-complex-data/030-using-sql-functions-clauses-and-joins.md",
+                "title": "Using SQL Functions, Clauses, and Joins",
+                "url": "/docs/using-sql-functions-clauses-and-joins/"
             },
-            "Using Drill with BI Tools Introduction": {
+            "Using Saiku Analytics with Apache Drill": {
+                "breadcrumbs": [
+                    {
+                        "title": "Ecosystem",
+                        "url": "/docs/ecosystem/"
+                    }
+                ],
+                "children": [],
+                "next_title": "",
+                "next_url": "",
+                "parent": "Ecosystem",
+                "previous_title": "Ecosystem",
+                "previous_url": "/docs/ecosystem/",
+                "relative_path": "_docs/en/ecosystem/010-using-saiku-analytics-with-apache-drill.md",
+                "title": "Using Saiku Analytics with Apache Drill",
+                "url": "/docs/using-saiku-analytics-with-apache-drill/"
+            },
+            "Using Tibco Spotfire Desktop with Drill": {
                 "breadcrumbs": [
                     {
                         "title": "Using Drill with BI Tools",
@@ -40905,37 +40367,75 @@
                     }
                 ],
                 "children": [],
-                "next_title": "Tableau Examples",
-                "next_url": "/docs/tableau-examples/",
+                "next_title": "Configuring Tibco Spotfire Server with Drill",
+                "next_url": "/docs/configuring-tibco-spotfire-server-with-drill/",
                 "parent": "Using Drill with BI Tools",
-                "previous_title": "Using Drill with BI Tools",
-                "previous_url": "/docs/using-drill-with-bi-tools/",
-                "relative_path": "_docs/en/odbc-jdbc-interfaces/using-drill-with-bi-tools/010-using-odbc-with-bi-tools-introduction.md",
-                "title": "Using Drill with BI Tools Introduction",
-                "url": "/docs/using-drill-with-bi-tools-introduction/"
+                "previous_title": "Using MicroStrategy Analytics with Apache Drill",
+                "previous_url": "/docs/using-microstrategy-analytics-with-apache-drill/",
+                "relative_path": "_docs/en/odbc-jdbc-interfaces/using-drill-with-bi-tools/040-using-tibco-spotfire-desktop-with-drill.md",
+                "title": "Using Tibco Spotfire Desktop with Drill",
+                "url": "/docs/using-tibco-spotfire-desktop-with-drill/"
             },
-            "Using Information Builders\u2019 WebFOCUS with Apache Drill": {
+            "Using jpam as the PAM Authenticator": {
                 "breadcrumbs": [
                     {
-                        "title": "Using Drill with BI Tools",
-                        "url": "/docs/using-drill-with-bi-tools/"
+                        "title": "Securing Drill",
+                        "url": "/docs/securing-drill/"
                     },
                     {
-                        "title": "ODBC/JDBC Interfaces",
-                        "url": "/docs/odbc-jdbc-interfaces/"
+                        "title": "Configure Drill",
+                        "url": "/docs/configure-drill/"
                     }
                 ],
                 "children": [],
-                "next_title": "Configuring JReport with Drill",
-                "next_url": "/docs/configuring-jreport-with-drill/",
-                "parent": "Using Drill with BI Tools",
-                "previous_title": "Using Apache Drill with Tableau 9 Server",
-                "previous_url": "/docs/using-apache-drill-with-tableau-9-server/",
-                "relative_path": "_docs/en/odbc-jdbc-interfaces/using-drill-with-bi-tools/075-using-apache-drill-with-webfocus.md",
-                "title": "Using Information Builders\u2019 WebFOCUS with Apache Drill",
-                "url": "/docs/using-information-builders-webfocus-with-apache-drill/"
+                "next_title": "Configuring Kerberos Security",
+                "next_url": "/docs/configuring-kerberos-security/",
+                "parent": "Securing Drill",
+                "previous_title": "Using libpam4j as the PAM Authenticator",
+                "previous_url": "/docs/using-libpam4j-as-the-pam-authenticator/",
+                "relative_path": "_docs/en/configure-drill/securing-drill/083-using-jpam-as-the-pam-authenticator.md",
+                "title": "Using jpam as the PAM Authenticator",
+                "url": "/docs/using-jpam-as-the-pam-authenticator/"
             },
-            "Using JDBC with SQuirreL on Windows": {
+            "Using libpam4j as the PAM Authenticator": {
+                "breadcrumbs": [
+                    {
+                        "title": "Securing Drill",
+                        "url": "/docs/securing-drill/"
+                    },
+                    {
+                        "title": "Configure Drill",
+                        "url": "/docs/configure-drill/"
+                    }
+                ],
+                "children": [],
+                "next_title": "Using jpam as the PAM Authenticator",
+                "next_url": "/docs/using-jpam-as-the-pam-authenticator/",
+                "parent": "Securing Drill",
+                "previous_title": "Configuring SSL/TLS for Encryption",
+                "previous_url": "/docs/configuring-ssl-tls-for-encryption/",
+                "relative_path": "_docs/en/configure-drill/securing-drill/082-using-libpam4j-as-the-pam-authenticator.md",
+                "title": "Using libpam4j as the PAM Authenticator",
+                "url": "/docs/using-libpam4j-as-the-pam-authenticator/"
+            },
+            "Using the Drill-on-YARN Web UI": {
+                "breadcrumbs": [
+                    {
+                        "title": "Drill-on-YARN",
+                        "url": "/docs/drill-on-yarn/"
+                    }
+                ],
+                "children": [],
+                "next_title": "Multiple Drill Clusters",
+                "next_url": "/docs/multiple-drill-clusters/",
+                "parent": "Drill-on-YARN",
+                "previous_title": "Drill-on-YARN Command-Line Tool",
+                "previous_url": "/docs/drill-on-yarn-command-line-tool/",
+                "relative_path": "_docs/en/drill-on-yarn/060-using-the-drill-on-yarn-web-ui.md",
+                "title": "Using the Drill-on-YARN Web UI",
+                "url": "/docs/using-the-drill-on-yarn-web-ui/"
+            },
+            "Using the JDBC Driver": {
                 "breadcrumbs": [
                     {
                         "title": "ODBC/JDBC Interfaces",
@@ -40943,385 +40443,805 @@
                     }
                 ],
                 "children": [],
-                "next_title": "Installing the ODBC Driver",
-                "next_url": "/docs/installing-the-odbc-driver/",
+                "next_title": "Using JDBC with SQuirreL on Windows",
+                "next_url": "/docs/using-jdbc-with-squirrel-on-windows/",
                 "parent": "ODBC/JDBC Interfaces",
-                "previous_title": "Using the JDBC Driver",
-                "previous_url": "/docs/using-the-jdbc-driver/",
-                "relative_path": "_docs/en/odbc-jdbc-interfaces/020-using-jdbc-with-squirrel-on-windows.md",
-                "title": "Using JDBC with SQuirreL on Windows",
-                "url": "/docs/using-jdbc-with-squirrel-on-windows/"
+                "previous_title": "Interfaces Introduction",
+                "previous_url": "/docs/interfaces-introduction/",
+                "relative_path": "_docs/en/odbc-jdbc-interfaces/015-using-jdbc-driver.md",
+                "title": "Using the JDBC Driver",
+                "url": "/docs/using-the-jdbc-driver/"
             },
-            "Using MicroStrategy Analytics with Apache Drill": {
+            "Value Vectors": {
                 "breadcrumbs": [
                     {
-                        "title": "Using Drill with BI Tools",
-                        "url": "/docs/using-drill-with-bi-tools/"
+                        "title": "Design Docs",
+                        "url": "/docs/design-docs/"
+                    },
+                    {
+                        "title": "Developer Information",
+                        "url": "/docs/developer-information/"
+                    }
+                ],
+                "children": [],
+                "next_title": "Release Notes",
+                "next_url": "/docs/release-notes/",
+                "parent": "Design Docs",
+                "previous_title": "Useful Research",
+                "previous_url": "/docs/useful-research/",
+                "relative_path": "_docs/en/developer-information/design-docs/050-value-vectors.md",
+                "title": "Value Vectors",
+                "url": "/docs/value-vectors/"
+            },
+            "Value Window Functions": {
+                "breadcrumbs": [
+                    {
+                        "title": "SQL Window Functions",
+                        "url": "/docs/sql-window-functions/"
+                    },
+                    {
+                        "title": "SQL Reference",
+                        "url": "/docs/sql-reference/"
+                    }
+                ],
+                "children": [],
+                "next_title": "SQL Window Functions Examples",
+                "next_url": "/docs/sql-window-functions-examples/",
+                "parent": "SQL Window Functions",
+                "previous_title": "Ranking Window Functions",
+                "previous_url": "/docs/ranking-window-functions/",
+                "relative_path": "_docs/en/sql-reference/sql-window-functions/035-value-window-functions.md",
+                "title": "Value Window Functions",
+                "url": "/docs/value-window-functions/"
+            },
+            "Verifying Index Use": {
+                "breadcrumbs": [
+                    {
+                        "title": "Querying Indexes",
+                        "url": "/docs/querying-indexes/"
+                    },
+                    {
+                        "title": "Query Data",
+                        "url": "/docs/query-data/"
+                    }
+                ],
+                "children": [],
+                "next_title": "Querying System Tables",
+                "next_url": "/docs/querying-system-tables/",
+                "parent": "Querying Indexes",
+                "previous_title": "Configuring Index Planning",
+                "previous_url": "/docs/configuring-index-planning/",
+                "relative_path": "_docs/en/query-data/querying-indexes/060-verifying-index-use.md",
+                "title": "Verifying Index Use",
+                "url": "/docs/verifying-index-use/"
+            },
+            "WHERE Clause": {
+                "breadcrumbs": [
+                    {
+                        "title": "SQL Commands",
+                        "url": "/docs/sql-commands/"
+                    },
+                    {
+                        "title": "SQL Reference",
+                        "url": "/docs/sql-reference/"
+                    }
+                ],
+                "children": [],
+                "next_title": "WITH Clause",
+                "next_url": "/docs/with-clause/",
+                "parent": "SQL Commands",
+                "previous_title": "UNION Set Operator",
+                "previous_url": "/docs/union-set-operator/",
+                "relative_path": "_docs/en/sql-reference/sql-commands/088-where-clause.md",
+                "title": "WHERE Clause",
+                "url": "/docs/where-clause/"
+            },
+            "WITH Clause": {
+                "breadcrumbs": [
+                    {
+                        "title": "SQL Commands",
+                        "url": "/docs/sql-commands/"
+                    },
+                    {
+                        "title": "SQL Reference",
+                        "url": "/docs/sql-reference/"
+                    }
+                ],
+                "children": [],
+                "next_title": "SHOW DATABASES and SHOW SCHEMAS",
+                "next_url": "/docs/show-databases-and-show-schemas/",
+                "parent": "SQL Commands",
+                "previous_title": "WHERE Clause",
+                "previous_url": "/docs/where-clause/",
+                "relative_path": "_docs/en/sql-reference/sql-commands/089-with-clause.md",
+                "title": "WITH Clause",
+                "url": "/docs/with-clause/"
+            },
+            "Wikipedia Edit History": {
+                "breadcrumbs": [
+                    {
+                        "title": "Sample Datasets",
+                        "url": "/docs/sample-datasets/"
+                    }
+                ],
+                "children": [],
+                "next_title": "Project Bylaws",
+                "next_url": "/docs/project-bylaws/",
+                "parent": "Sample Datasets",
+                "previous_title": "Enron Emails",
+                "previous_url": "/docs/enron-emails/",
+                "relative_path": "_docs/en/sample-datasets/002-wikipedia.md",
+                "title": "Wikipedia Edit History",
+                "url": "/docs/wikipedia-edit-history/"
+            },
+            "Workspaces": {
+                "breadcrumbs": [
+                    {
+                        "title": "Storage Plugin Configuration",
+                        "url": "/docs/storage-plugin-configuration/"
                     },
                     {
-                        "title": "ODBC/JDBC Interfaces",
-                        "url": "/docs/odbc-jdbc-interfaces/"
+                        "title": "Connect a Data Source",
+                        "url": "/docs/connect-a-data-source/"
                     }
                 ],
                 "children": [],
-                "next_title": "Using Tibco Spotfire Desktop with Drill",
-                "next_url": "/docs/using-tibco-spotfire-desktop-with-drill/",
-                "parent": "Using Drill with BI Tools",
-                "previous_title": "Tableau Examples",
-                "previous_url": "/docs/tableau-examples/",
-                "relative_path": "_docs/en/odbc-jdbc-interfaces/using-drill-with-bi-tools/030-using-microstrategy-analytics-with-apache-drill.md",
-                "title": "Using MicroStrategy Analytics with Apache Drill",
-                "url": "/docs/using-microstrategy-analytics-with-apache-drill/"
+                "next_title": "Drill Default Input Format",
+                "next_url": "/docs/drill-default-input-format/",
+                "parent": "Storage Plugin Configuration",
+                "previous_title": "Configuring Storage Plugins",
+                "previous_url": "/docs/configuring-storage-plugins/",
+                "relative_path": "_docs/en/connect-a-data-source/050-workspaces.md",
+                "title": "Workspaces",
+                "url": "/docs/workspaces/"
             },
-            "Using Qlik Sense with Drill": {
+            "XML Format Plugin": {
                 "breadcrumbs": [
                     {
-                        "title": "Using Drill with BI Tools",
-                        "url": "/docs/using-drill-with-bi-tools/"
-                    },
-                    {
-                        "title": "ODBC/JDBC Interfaces",
-                        "url": "/docs/odbc-jdbc-interfaces/"
+                        "title": "Data Sources and File Formats",
+                        "url": "/docs/data-sources-and-file-formats/"
                     }
                 ],
                 "children": [],
-                "next_title": "Using Apache Drill with Tableau 10.2",
-                "next_url": "/docs/using-apache-drill-with-tableau-10-2/",
-                "parent": "Using Drill with BI Tools",
-                "previous_title": "Configuring Tibco Spotfire Server with Drill",
-                "previous_url": "/docs/configuring-tibco-spotfire-server-with-drill/",
-                "relative_path": "_docs/en/odbc-jdbc-interfaces/using-drill-with-bi-tools/055-using-qliksense-with-drill.md",
-                "title": "Using Qlik Sense with Drill",
-                "url": "/docs/using-qlik-sense-with-drill/"
+                "next_title": "Develop Custom Functions",
+                "next_url": "/docs/develop-custom-functions/",
+                "parent": "Data Sources and File Formats",
+                "previous_title": "HDF5 Format Plugin",
+                "previous_url": "/docs/hdf5-format-plugin/",
+                "relative_path": "_docs/en/data-sources-and-file-formats/120-xml-format-plugin.md",
+                "title": "XML Format Plugin",
+                "url": "/docs/xml-format-plugin/"
             },
-            "Using SQL Functions, Clauses, and Joins": {
+            "\u4e3a\u4ec0\u4e48\u9009\u62e9 Drill": {
                 "breadcrumbs": [
                     {
-                        "title": "Querying Complex Data",
-                        "url": "/docs/querying-complex-data/"
-                    },
-                    {
-                        "title": "Query Data",
-                        "url": "/docs/query-data/"
+                        "title": "\u65b0\u624b\u5f00\u59cb",
+                        "url": "/docs/getting-started/"
                     }
                 ],
                 "children": [],
-                "next_title": "Selecting Nested Data for a Column",
-                "next_url": "/docs/selecting-nested-data-for-a-column/",
-                "parent": "Querying Complex Data",
-                "previous_title": "Selecting Flat Data",
-                "previous_url": "/docs/selecting-flat-data/",
-                "relative_path": "_docs/en/query-data/querying-complex-data/030-using-sql-functions-clauses-and-joins.md",
-                "title": "Using SQL Functions, Clauses, and Joins",
-                "url": "/docs/using-sql-functions-clauses-and-joins/"
+                "next_title": "Architecture",
+                "next_url": "/docs/architecture/",
+                "parent": "\u65b0\u624b\u5f00\u59cb",
+                "previous_title": "\u4ec0\u4e48\u662f Drill",
+                "previous_url": "/docs/drill-introduction/",
+                "relative_path": "_docs/zh/getting-started/020-why-drill.md",
+                "title": "\u4e3a\u4ec0\u4e48\u9009\u62e9 Drill",
+                "url": "/docs/why-drill/"
             },
-            "Using Saiku Analytics with Apache Drill": {
+            "\u4e86\u89e3 Drill Sandbox": {
                 "breadcrumbs": [
                     {
-                        "title": "Ecosystem",
-                        "url": "/docs/ecosystem/"
+                        "title": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                        "url": "/docs/learn-drill-with-the-mapr-sandbox/"
+                    },
+                    {
+                        "title": "\u6559\u7a0b",
+                        "url": "/docs/tutorials/"
                     }
                 ],
                 "children": [],
-                "next_title": "",
-                "next_url": "",
-                "parent": "Ecosystem",
-                "previous_title": "Ecosystem",
-                "previous_url": "/docs/ecosystem/",
-                "relative_path": "_docs/en/ecosystem/010-using-saiku-analytics-with-apache-drill.md",
-                "title": "Using Saiku Analytics with Apache Drill",
-                "url": "/docs/using-saiku-analytics-with-apache-drill/"
+                "next_title": "\u7b2c\u4e00\u8bfe: \u5b66\u4e60\u6570\u636e\u96c6",
+                "next_url": "/docs/lesson-1-learn-about-the-data-set/",
+                "parent": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                "previous_title": "\u5b89\u88c5 Apache Drill SandBox",
+                "previous_url": "/docs/installing-the-apache-drill-sandbox/",
+                "relative_path": "_docs/zh/tutorials/learn-drill-with-the-mapr-sandbox/020-getting-to-know-the-drill-sandbox.md",
+                "title": "\u4e86\u89e3 Drill Sandbox",
+                "url": "/docs/getting-to-know-the-drill-sandbox/"
             },
-            "Using Tibco Spotfire Desktop with Drill": {
+            "\u4ec0\u4e48\u662f Drill": {
                 "breadcrumbs": [
                     {
-                        "title": "Using Drill with BI Tools",
-                        "url": "/docs/using-drill-with-bi-tools/"
-                    },
-                    {
-                        "title": "ODBC/JDBC Interfaces",
-                        "url": "/docs/odbc-jdbc-interfaces/"
+                        "title": "\u65b0\u624b\u5f00\u59cb",
+                        "url": "/docs/getting-started/"
                     }
                 ],
                 "children": [],
-                "next_title": "Configuring Tibco Spotfire Server with Drill",
-                "next_url": "/docs/configuring-tibco-spotfire-server-with-drill/",
-                "parent": "Using Drill with BI Tools",
-                "previous_title": "Using MicroStrategy Analytics with Apache Drill",
-                "previous_url": "/docs/using-microstrategy-analytics-with-apache-drill/",
-                "relative_path": "_docs/en/odbc-jdbc-interfaces/using-drill-with-bi-tools/040-using-tibco-spotfire-desktop-with-drill.md",
-                "title": "Using Tibco Spotfire Desktop with Drill",
-                "url": "/docs/using-tibco-spotfire-desktop-with-drill/"
+                "next_title": "\u4e3a\u4ec0\u4e48\u9009\u62e9 Drill",
+                "next_url": "/docs/why-drill/",
+                "parent": "\u65b0\u624b\u5f00\u59cb",
+                "previous_title": "\u65b0\u624b\u5f00\u59cb",
+                "previous_url": "/docs/getting-started/",
+                "relative_path": "_docs/zh/getting-started/010-drill-introduction.md",
+                "title": "\u4ec0\u4e48\u662f Drill",
+                "url": "/docs/drill-introduction/"
             },
-            "Using jpam as the PAM Authenticator": {
+            "\u5173\u4e8e MapR \u6c99\u76d2": {
                 "breadcrumbs": [
                     {
-                        "title": "Securing Drill",
-                        "url": "/docs/securing-drill/"
+                        "title": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                        "url": "/docs/learn-drill-with-the-mapr-sandbox/"
                     },
                     {
-                        "title": "Configure Drill",
-                        "url": "/docs/configure-drill/"
+                        "title": "\u6559\u7a0b",
+                        "url": "/docs/tutorials/"
                     }
                 ],
                 "children": [],
-                "next_title": "Configuring Kerberos Security",
-                "next_url": "/docs/configuring-kerberos-security/",
-                "parent": "Securing Drill",
-                "previous_title": "Using libpam4j as the PAM Authenticator",
-                "previous_url": "/docs/using-libpam4j-as-the-pam-authenticator/",
-                "relative_path": "_docs/en/configure-drill/securing-drill/083-using-jpam-as-the-pam-authenticator.md",
-                "title": "Using jpam as the PAM Authenticator",
-                "url": "/docs/using-jpam-as-the-pam-authenticator/"
+                "next_title": "\u5b89\u88c5 Apache Drill SandBox",
+                "next_url": "/docs/installing-the-apache-drill-sandbox/",
+                "parent": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                "previous_title": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                "previous_url": "/docs/learn-drill-with-the-mapr-sandbox/",
+                "relative_path": "_docs/zh/tutorials/learn-drill-with-the-mapr-sandbox/005-about-the-mapr-sandbox.md",
+                "title": "\u5173\u4e8e MapR \u6c99\u76d2",
+                "url": "/docs/about-the-mapr-sandbox/"
             },
-            "Using libpam4j as the PAM Authenticator": {
+            "\u5206\u6790 Yelp \u5b66\u672f\u6570\u636e\u96c6": {
                 "breadcrumbs": [
                     {
-                        "title": "Securing Drill",
-                        "url": "/docs/securing-drill/"
-                    },
-                    {
-                        "title": "Configure Drill",
-                        "url": "/docs/configure-drill/"
+                        "title": "\u6559\u7a0b",
+                        "url": "/docs/tutorials/"
                     }
                 ],
                 "children": [],
-                "next_title": "Using jpam as the PAM Authenticator",
-                "next_url": "/docs/using-jpam-as-the-pam-authenticator/",
-                "parent": "Securing Drill",
-                "previous_title": "Configuring SSL/TLS for Encryption",
-                "previous_url": "/docs/configuring-ssl-tls-for-encryption/",
-                "relative_path": "_docs/en/configure-drill/securing-drill/082-using-libpam4j-as-the-pam-authenticator.md",
-                "title": "Using libpam4j as the PAM Authenticator",
-                "url": "/docs/using-libpam4j-as-the-pam-authenticator/"
+                "next_title": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                "next_url": "/docs/learn-drill-with-the-mapr-sandbox/",
+                "parent": "\u6559\u7a0b",
+                "previous_title": "10\u5206\u949f\u4e86\u89e3 Drill",
+                "previous_url": "/docs/drill-in-10-minutes/",
+                "relative_path": "_docs/zh/tutorials/030-analyzing-the-yelp-academic-dataset.md",
+                "title": "\u5206\u6790 Yelp \u5b66\u672f\u6570\u636e\u96c6",
+                "url": "/docs/analyzing-the-yelp-academic-dataset/"
             },
-            "Using the Drill-on-YARN Web UI": {
+            "\u5206\u6790\u793e\u4ea4\u5a92\u4f53": {
                 "breadcrumbs": [
                     {
-                        "title": "Drill-on-YARN",
-                        "url": "/docs/drill-on-yarn/"
+                        "title": "\u6559\u7a0b",
+                        "url": "/docs/tutorials/"
                     }
                 ],
                 "children": [],
-                "next_title": "Multiple Drill Clusters",
-                "next_url": "/docs/multiple-drill-clusters/",
-                "parent": "Drill-on-YARN",
-                "previous_title": "Drill-on-YARN Command-Line Tool",
-                "previous_url": "/docs/drill-on-yarn-command-line-tool/",
-                "relative_path": "_docs/en/drill-on-yarn/060-using-the-drill-on-yarn-web-ui.md",
-                "title": "Using the Drill-on-YARN Web UI",
-                "url": "/docs/using-the-drill-on-yarn-web-ui/"
+                "next_title": "\u901a\u8fc7\u7a97\u53e3\u51fd\u6570\u5206\u6790\u6570\u636e\u96c6",
+                "next_url": "/docs/analyzing-data-using-window-functions/",
+                "parent": "\u6559\u7a0b",
+                "previous_title": "\u5206\u6790\u9ad8\u52a8\u6001\u6570\u636e\u96c6",
+                "previous_url": "/docs/analyzing-highly-dynamic-datasets/",
+                "relative_path": "_docs/zh/tutorials/060-analyzing-social-media.md",
+                "title": "\u5206\u6790\u793e\u4ea4\u5a92\u4f53",
+                "url": "/docs/analyzing-social-media/"
             },
-            "Using the JDBC Driver": {
+            "\u5206\u6790\u9ad8\u52a8\u6001\u6570\u636e\u96c6": {
                 "breadcrumbs": [
                     {
-                        "title": "ODBC/JDBC Interfaces",
-                        "url": "/docs/odbc-jdbc-interfaces/"
+                        "title": "\u6559\u7a0b",
+                        "url": "/docs/tutorials/"
                     }
                 ],
                 "children": [],
-                "next_title": "Using JDBC with SQuirreL on Windows",
-                "next_url": "/docs/using-jdbc-with-squirrel-on-windows/",
-                "parent": "ODBC/JDBC Interfaces",
-                "previous_title": "Interfaces Introduction",
-                "previous_url": "/docs/interfaces-introduction/",
-                "relative_path": "_docs/en/odbc-jdbc-interfaces/015-using-jdbc-driver.md",
-                "title": "Using the JDBC Driver",
-                "url": "/docs/using-the-jdbc-driver/"
+                "next_title": "\u5206\u6790\u793e\u4ea4\u5a92\u4f53",
+                "next_url": "/docs/analyzing-social-media/",
+                "parent": "\u6559\u7a0b",
+                "previous_title": "\u603b\u7ed3",
+                "previous_url": "/docs/summary/",
+                "relative_path": "_docs/zh/tutorials/050-analyzing-highly-dynamic-datasets.md",
+                "title": "\u5206\u6790\u9ad8\u52a8\u6001\u6570\u636e\u96c6",
+                "url": "/docs/analyzing-highly-dynamic-datasets/"
             },
-            "Value Vectors": {
+            "\u5b89\u88c5 Apache Drill SandBox": {
                 "breadcrumbs": [
                     {
-                        "title": "Design Docs",
-                        "url": "/docs/design-docs/"
+                        "title": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                        "url": "/docs/learn-drill-with-the-mapr-sandbox/"
                     },
                     {
-                        "title": "Developer Information",
-                        "url": "/docs/developer-information/"
+                        "title": "\u6559\u7a0b",
+                        "url": "/docs/tutorials/"
                     }
                 ],
                 "children": [],
-                "next_title": "Release Notes",
-                "next_url": "/docs/release-notes/",
-                "parent": "Design Docs",
-                "previous_title": "Useful Research",
-                "previous_url": "/docs/useful-research/",
-                "relative_path": "_docs/en/developer-information/design-docs/050-value-vectors.md",
-                "title": "Value Vectors",
-                "url": "/docs/value-vectors/"
+                "next_title": "\u4e86\u89e3 Drill Sandbox",
+                "next_url": "/docs/getting-to-know-the-drill-sandbox/",
+                "parent": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                "previous_title": "\u5173\u4e8e MapR \u6c99\u76d2",
+                "previous_url": "/docs/about-the-mapr-sandbox/",
+                "relative_path": "_docs/zh/tutorials/learn-drill-with-the-mapr-sandbox/010-installing-the-apache-drill-sandbox.md",
+                "title": "\u5b89\u88c5 Apache Drill SandBox",
+                "url": "/docs/installing-the-apache-drill-sandbox/"
             },
-            "Value Window Functions": {
+            "\u603b\u7ed3": {
                 "breadcrumbs": [
                     {
-                        "title": "SQL Window Functions",
-                        "url": "/docs/sql-window-functions/"
+                        "title": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                        "url": "/docs/learn-drill-with-the-mapr-sandbox/"
                     },
                     {
-                        "title": "SQL Reference",
-                        "url": "/docs/sql-reference/"
+                        "title": "\u6559\u7a0b",
+                        "url": "/docs/tutorials/"
                     }
                 ],
                 "children": [],
-                "next_title": "SQL Window Functions Examples",
-                "next_url": "/docs/sql-window-functions-examples/",
-                "parent": "SQL Window Functions",
-                "previous_title": "Ranking Window Functions",
-                "previous_url": "/docs/ranking-window-functions/",
-                "relative_path": "_docs/en/sql-reference/sql-window-functions/035-value-window-functions.md",
-                "title": "Value Window Functions",
-                "url": "/docs/value-window-functions/"
+                "next_title": "\u5206\u6790\u9ad8\u52a8\u6001\u6570\u636e\u96c6",
+                "next_url": "/docs/analyzing-highly-dynamic-datasets/",
+                "parent": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                "previous_title": "\u7b2c\u4e09\u8bfe: \u67e5\u8be2\u590d\u6742\u6570\u636e\u7c7b\u578b",
+                "previous_url": "/docs/lesson-3-run-queries-on-complex-data-types/",
+                "relative_path": "_docs/zh/tutorials/learn-drill-with-the-mapr-sandbox/060-summary.md",
+                "title": "\u603b\u7ed3",
+                "url": "/docs/summary/"
             },
-            "Verifying Index Use": {
+            "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill": {
                 "breadcrumbs": [
                     {
-                        "title": "Querying Indexes",
-                        "url": "/docs/querying-indexes/"
+                        "title": "\u6559\u7a0b",
+                        "url": "/docs/tutorials/"
+                    }
+                ],
+                "children": [
+                    {
+                        "breadcrumbs": [
+                            {
+                                "title": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                                "url": "/docs/learn-drill-with-the-mapr-sandbox/"
+                            },
+                            {
+                                "title": "\u6559\u7a0b",
+                                "url": "/docs/tutorials/"
+                            }
+                        ],
+                        "children": [],
+                        "next_title": "\u5b89\u88c5 Apache Drill SandBox",
+                        "next_url": "/docs/installing-the-apache-drill-sandbox/",
+                        "parent": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                        "previous_title": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                        "previous_url": "/docs/learn-drill-with-the-mapr-sandbox/",
+                        "relative_path": "_docs/zh/tutorials/learn-drill-with-the-mapr-sandbox/005-about-the-mapr-sandbox.md",
+                        "title": "\u5173\u4e8e MapR \u6c99\u76d2",
+                        "url": "/docs/about-the-mapr-sandbox/"
+                    },
+                    {
+                        "breadcrumbs": [
+                            {
+                                "title": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                                "url": "/docs/learn-drill-with-the-mapr-sandbox/"
+                            },
+                            {
+                                "title": "\u6559\u7a0b",
+                                "url": "/docs/tutorials/"
+                            }
+                        ],
+                        "children": [],
+                        "next_title": "\u4e86\u89e3 Drill Sandbox",
+                        "next_url": "/docs/getting-to-know-the-drill-sandbox/",
+                        "parent": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                        "previous_title": "\u5173\u4e8e MapR \u6c99\u76d2",
+                        "previous_url": "/docs/about-the-mapr-sandbox/",
+                        "relative_path": "_docs/zh/tutorials/learn-drill-with-the-mapr-sandbox/010-installing-the-apache-drill-sandbox.md",
+                        "title": "\u5b89\u88c5 Apache Drill SandBox",
+                        "url": "/docs/installing-the-apache-drill-sandbox/"
+                    },
+                    {
+                        "breadcrumbs": [
+                            {
+                                "title": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                                "url": "/docs/learn-drill-with-the-mapr-sandbox/"
+                            },
+                            {
+                                "title": "\u6559\u7a0b",
+                                "url": "/docs/tutorials/"
+                            }
+                        ],
+                        "children": [],
+                        "next_title": "\u7b2c\u4e00\u8bfe: \u5b66\u4e60\u6570\u636e\u96c6",
+                        "next_url": "/docs/lesson-1-learn-about-the-data-set/",
+                        "parent": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                        "previous_title": "\u5b89\u88c5 Apache Drill SandBox",
+                        "previous_url": "/docs/installing-the-apache-drill-sandbox/",
+                        "relative_path": "_docs/zh/tutorials/learn-drill-with-the-mapr-sandbox/020-getting-to-know-the-drill-sandbox.md",
+                        "title": "\u4e86\u89e3 Drill Sandbox",
+                        "url": "/docs/getting-to-know-the-drill-sandbox/"
                     },
                     {
-                        "title": "Query Data",
-                        "url": "/docs/query-data/"
-                    }
-                ],
-                "children": [],
-                "next_title": "Querying System Tables",
-                "next_url": "/docs/querying-system-tables/",
-                "parent": "Querying Indexes",
-                "previous_title": "Configuring Index Planning",
-                "previous_url": "/docs/configuring-index-planning/",
-                "relative_path": "_docs/en/query-data/querying-indexes/060-verifying-index-use.md",
-                "title": "Verifying Index Use",
-                "url": "/docs/verifying-index-use/"
-            },
-            "WHERE Clause": {
-                "breadcrumbs": [
+                        "breadcrumbs": [
+                            {
+                                "title": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                                "url": "/docs/learn-drill-with-the-mapr-sandbox/"
+                            },
+                            {
+                                "title": "\u6559\u7a0b",
+                                "url": "/docs/tutorials/"
+                            }
+                        ],
+                        "children": [],
+                        "next_title": "\u7b2c\u4e8c\u8bfe: \u4f7f\u7528 ANSI SQL \u67e5\u8be2",
+                        "next_url": "/docs/lesson-2-run-queries-with-ansi-sql/",
+                        "parent": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                        "previous_title": "\u4e86\u89e3 Drill Sandbox",
+                        "previous_url": "/docs/getting-to-know-the-drill-sandbox/",
+                        "relative_path": "_docs/zh/tutorials/learn-drill-with-the-mapr-sandbox/030-lesson-1-learn-about-the-data-set.md",
+                        "title": "\u7b2c\u4e00\u8bfe: \u5b66\u4e60\u6570\u636e\u96c6",
+                        "url": "/docs/lesson-1-learn-about-the-data-set/"
+                    },
                     {
-                        "title": "SQL Commands",
-                        "url": "/docs/sql-commands/"
+                        "breadcrumbs": [
+                            {
+                                "title": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                                "url": "/docs/learn-drill-with-the-mapr-sandbox/"
+                            },
+                            {
+                                "title": "\u6559\u7a0b",
+                                "url": "/docs/tutorials/"
+                            }
+                        ],
+                        "children": [],
+                        "next_title": "\u7b2c\u4e09\u8bfe: \u67e5\u8be2\u590d\u6742\u6570\u636e\u7c7b\u578b",
+                        "next_url": "/docs/lesson-3-run-queries-on-complex-data-types/",
+                        "parent": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                        "previous_title": "\u7b2c\u4e00\u8bfe: \u5b66\u4e60\u6570\u636e\u96c6",
+                        "previous_url": "/docs/lesson-1-learn-about-the-data-set/",
+                        "relative_path": "_docs/zh/tutorials/learn-drill-with-the-mapr-sandbox/040-lesson-2-run-queries-with-ansi-sql.md",
+                        "title": "\u7b2c\u4e8c\u8bfe: \u4f7f\u7528 ANSI SQL \u67e5\u8be2",
+                        "url": "/docs/lesson-2-run-queries-with-ansi-sql/"
                     },
                     {
-                        "title": "SQL Reference",
-                        "url": "/docs/sql-reference/"
+                        "breadcrumbs": [
+                            {
+                                "title": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                                "url": "/docs/learn-drill-with-the-mapr-sandbox/"
+                            },
+                            {
+                                "title": "\u6559\u7a0b",
+                                "url": "/docs/tutorials/"
+                            }
+                        ],
+                        "children": [],
+                        "next_title": "\u603b\u7ed3",
+                        "next_url": "/docs/summary/",
+                        "parent": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                        "previous_title": "\u7b2c\u4e8c\u8bfe: \u4f7f\u7528 ANSI SQL \u67e5\u8be2",
+                        "previous_url": "/docs/lesson-2-run-queries-with-ansi-sql/",
+                        "relative_path": "_docs/zh/tutorials/learn-drill-with-the-mapr-sandbox/050-lesson-3-run-queries-on-complex-data-types.md",
+                        "title": "\u7b2c\u4e09\u8bfe: \u67e5\u8be2\u590d\u6742\u6570\u636e\u7c7b\u578b",
+                        "url": "/docs/lesson-3-run-queries-on-complex-data-types/"
+                    },
+                    {
+                        "breadcrumbs": [
+                            {
+                                "title": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                                "url": "/docs/learn-drill-with-the-mapr-sandbox/"
+                            },
+                            {
+                                "title": "\u6559\u7a0b",
+                                "url": "/docs/tutorials/"
+                            }
+                        ],
+                        "children": [],
+                        "next_title": "\u5206\u6790\u9ad8\u52a8\u6001\u6570\u636e\u96c6",
+                        "next_url": "/docs/analyzing-highly-dynamic-datasets/",
+                        "parent": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                        "previous_title": "\u7b2c\u4e09\u8bfe: \u67e5\u8be2\u590d\u6742\u6570\u636e\u7c7b\u578b",
+                        "previous_url": "/docs/lesson-3-run-queries-on-complex-data-types/",
+                        "relative_path": "_docs/zh/tutorials/learn-drill-with-the-mapr-sandbox/060-summary.md",
+                        "title": "\u603b\u7ed3",
+                        "url": "/docs/summary/"
                     }
                 ],
-                "children": [],
-                "next_title": "WITH Clause",
-                "next_url": "/docs/with-clause/",
-                "parent": "SQL Commands",
-                "previous_title": "UNION Set Operator",
-                "previous_url": "/docs/union-set-operator/",
-                "relative_path": "_docs/en/sql-reference/sql-commands/088-where-clause.md",
-                "title": "WHERE Clause",
-                "url": "/docs/where-clause/"
+                "next_title": "\u5173\u4e8e MapR \u6c99\u76d2",
+                "next_url": "/docs/about-the-mapr-sandbox/",
+                "parent": "\u6559\u7a0b",
+                "previous_title": "\u5206\u6790 Yelp \u5b66\u672f\u6570\u636e\u96c6",
+                "previous_url": "/docs/analyzing-the-yelp-academic-dataset/",
+                "relative_path": "_docs/zh/tutorials/040-learn-drill-with-the-mapr-sandbox.md",
+                "title": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                "url": "/docs/learn-drill-with-the-mapr-sandbox/"
             },
-            "WITH Clause": {
-                "breadcrumbs": [
+            "\u6559\u7a0b": {
+                "breadcrumbs": [],
+                "children": [
                     {
-                        "title": "SQL Commands",
-                        "url": "/docs/sql-commands/"
+                        "breadcrumbs": [
+                            {
+                                "title": "\u6559\u7a0b",
+                                "url": "/docs/tutorials/"
+                            }
+                        ],
+                        "children": [],
+                        "next_title": "10\u5206\u949f\u4e86\u89e3 Drill",
+                        "next_url": "/docs/drill-in-10-minutes/",
+                        "parent": "\u6559\u7a0b",
+                        "previous_title": "\u6559\u7a0b",
+                        "previous_url": "/docs/tutorials/",
+                        "relative_path": "_docs/zh/tutorials/010-tutorials-introduction.md",
+                        "title": "\u6559\u7a0b\u4ecb\u7ecd",
+                        "url": "/docs/tutorials-introduction/"
                     },
                     {
-                        "title": "SQL Reference",
-                        "url": "/docs/sql-reference/"
-                    }
-                ],
-                "children": [],
-                "next_title": "SHOW DATABASES and SHOW SCHEMAS",
-                "next_url": "/docs/show-databases-and-show-schemas/",
-                "parent": "SQL Commands",
-                "previous_title": "WHERE Clause",
-                "previous_url": "/docs/where-clause/",
-                "relative_path": "_docs/en/sql-reference/sql-commands/089-with-clause.md",
-                "title": "WITH Clause",
-                "url": "/docs/with-clause/"
-            },
-            "Wikipedia Edit History": {
-                "breadcrumbs": [
+                        "breadcrumbs": [
+                            {
+                                "title": "\u6559\u7a0b",
+                                "url": "/docs/tutorials/"
+                            }
+                        ],
+                        "children": [],
+                        "next_title": "\u5206\u6790 Yelp \u5b66\u672f\u6570\u636e\u96c6",
+                        "next_url": "/docs/analyzing-the-yelp-academic-dataset/",
+                        "parent": "\u6559\u7a0b",
+                        "previous_title": "\u6559\u7a0b\u4ecb\u7ecd",
+                        "previous_url": "/docs/tutorials-introduction/",
+                        "relative_path": "_docs/zh/tutorials/020-drill-in-10-minutes.md",
+                        "title": "10\u5206\u949f\u4e86\u89e3 Drill",
+                        "url": "/docs/drill-in-10-minutes/"
+                    },
                     {
-                        "title": "Sample Datasets",
-                        "url": "/docs/sample-datasets/"
-                    }
-                ],
-                "children": [],
-                "next_title": "Project Bylaws",
-                "next_url": "/docs/project-bylaws/",
-                "parent": "Sample Datasets",
-                "previous_title": "Enron Emails",
-                "previous_url": "/docs/enron-emails/",
-                "relative_path": "_docs/en/sample-datasets/002-wikipedia.md",
-                "title": "Wikipedia Edit History",
-                "url": "/docs/wikipedia-edit-history/"
-            },
-            "Workspaces": {
-                "breadcrumbs": [
+                        "breadcrumbs": [
+                            {
+                                "title": "\u6559\u7a0b",
+                                "url": "/docs/tutorials/"
+                            }
+                        ],
+                        "children": [],
+                        "next_title": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                        "next_url": "/docs/learn-drill-with-the-mapr-sandbox/",
+                        "parent": "\u6559\u7a0b",
+                        "previous_title": "10\u5206\u949f\u4e86\u89e3 Drill",
+                        "previous_url": "/docs/drill-in-10-minutes/",
+                        "relative_path": "_docs/zh/tutorials/030-analyzing-the-yelp-academic-dataset.md",
+                        "title": "\u5206\u6790 Yelp \u5b66\u672f\u6570\u636e\u96c6",
+                        "url": "/docs/analyzing-the-yelp-academic-dataset/"
+                    },
                     {
-                        "title": "Storage Plugin Configuration",
-                        "url": "/docs/storage-plugin-configuration/"
+                        "breadcrumbs": [
+                            {
+                                "title": "\u6559\u7a0b",
+                                "url": "/docs/tutorials/"
+                            }
+                        ],
+                        "children": [
+                            {
+                                "breadcrumbs": [
+                                    {
+                                        "title": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                                        "url": "/docs/learn-drill-with-the-mapr-sandbox/"
+                                    },
+                                    {
+                                        "title": "\u6559\u7a0b",
+                                        "url": "/docs/tutorials/"
+                                    }
+                                ],
+                                "children": [],
+                                "next_title": "\u5b89\u88c5 Apache Drill SandBox",
+                                "next_url": "/docs/installing-the-apache-drill-sandbox/",
+                                "parent": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                                "previous_title": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                                "previous_url": "/docs/learn-drill-with-the-mapr-sandbox/",
+                                "relative_path": "_docs/zh/tutorials/learn-drill-with-the-mapr-sandbox/005-about-the-mapr-sandbox.md",
+                                "title": "\u5173\u4e8e MapR \u6c99\u76d2",
+                                "url": "/docs/about-the-mapr-sandbox/"
+                            },
+                            {
+                                "breadcrumbs": [
+                                    {
+                                        "title": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                                        "url": "/docs/learn-drill-with-the-mapr-sandbox/"
+                                    },
+                                    {
+                                        "title": "\u6559\u7a0b",
+                                        "url": "/docs/tutorials/"
+                                    }
+                                ],
+                                "children": [],
+                                "next_title": "\u4e86\u89e3 Drill Sandbox",
+                                "next_url": "/docs/getting-to-know-the-drill-sandbox/",
+                                "parent": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                                "previous_title": "\u5173\u4e8e MapR \u6c99\u76d2",
+                                "previous_url": "/docs/about-the-mapr-sandbox/",
+                                "relative_path": "_docs/zh/tutorials/learn-drill-with-the-mapr-sandbox/010-installing-the-apache-drill-sandbox.md",
+                                "title": "\u5b89\u88c5 Apache Drill SandBox",
+                                "url": "/docs/installing-the-apache-drill-sandbox/"
+                            },
+                            {
+                                "breadcrumbs": [
+                                    {
+                                        "title": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                                        "url": "/docs/learn-drill-with-the-mapr-sandbox/"
+                                    },
+                                    {
+                                        "title": "\u6559\u7a0b",
+                                        "url": "/docs/tutorials/"
+                                    }
+                                ],
+                                "children": [],
+                                "next_title": "\u7b2c\u4e00\u8bfe: \u5b66\u4e60\u6570\u636e\u96c6",
+                                "next_url": "/docs/lesson-1-learn-about-the-data-set/",
+                                "parent": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                                "previous_title": "\u5b89\u88c5 Apache Drill SandBox",
+                                "previous_url": "/docs/installing-the-apache-drill-sandbox/",
+                                "relative_path": "_docs/zh/tutorials/learn-drill-with-the-mapr-sandbox/020-getting-to-know-the-drill-sandbox.md",
+                                "title": "\u4e86\u89e3 Drill Sandbox",
+                                "url": "/docs/getting-to-know-the-drill-sandbox/"
+                            },
+                            {
+                                "breadcrumbs": [
+                                    {
+                                        "title": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                                        "url": "/docs/learn-drill-with-the-mapr-sandbox/"
+                                    },
+                                    {
+                                        "title": "\u6559\u7a0b",
+                                        "url": "/docs/tutorials/"
+                                    }
+                                ],
+                                "children": [],
+                                "next_title": "\u7b2c\u4e8c\u8bfe: \u4f7f\u7528 ANSI SQL \u67e5\u8be2",
+                                "next_url": "/docs/lesson-2-run-queries-with-ansi-sql/",
+                                "parent": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                                "previous_title": "\u4e86\u89e3 Drill Sandbox",
+                                "previous_url": "/docs/getting-to-know-the-drill-sandbox/",
+                                "relative_path": "_docs/zh/tutorials/learn-drill-with-the-mapr-sandbox/030-lesson-1-learn-about-the-data-set.md",
+                                "title": "\u7b2c\u4e00\u8bfe: \u5b66\u4e60\u6570\u636e\u96c6",
+                                "url": "/docs/lesson-1-learn-about-the-data-set/"
+                            },
+                            {
+                                "breadcrumbs": [
+                                    {
+                                        "title": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                                        "url": "/docs/learn-drill-with-the-mapr-sandbox/"
+                                    },
+                                    {
+                                        "title": "\u6559\u7a0b",
+                                        "url": "/docs/tutorials/"
+                                    }
+                                ],
+                                "children": [],
+                                "next_title": "\u7b2c\u4e09\u8bfe: \u67e5\u8be2\u590d\u6742\u6570\u636e\u7c7b\u578b",
+                                "next_url": "/docs/lesson-3-run-queries-on-complex-data-types/",
+                                "parent": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                                "previous_title": "\u7b2c\u4e00\u8bfe: \u5b66\u4e60\u6570\u636e\u96c6",
+                                "previous_url": "/docs/lesson-1-learn-about-the-data-set/",
+                                "relative_path": "_docs/zh/tutorials/learn-drill-with-the-mapr-sandbox/040-lesson-2-run-queries-with-ansi-sql.md",
+                                "title": "\u7b2c\u4e8c\u8bfe: \u4f7f\u7528 ANSI SQL \u67e5\u8be2",
+                                "url": "/docs/lesson-2-run-queries-with-ansi-sql/"
+                            },
+                            {
+                                "breadcrumbs": [
+                                    {
+                                        "title": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                                        "url": "/docs/learn-drill-with-the-mapr-sandbox/"
+                                    },
+                                    {
+                                        "title": "\u6559\u7a0b",
+                                        "url": "/docs/tutorials/"
+                                    }
+                                ],
+                                "children": [],
+                                "next_title": "\u603b\u7ed3",
+                                "next_url": "/docs/summary/",
+                                "parent": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                                "previous_title": "\u7b2c\u4e8c\u8bfe: \u4f7f\u7528 ANSI SQL \u67e5\u8be2",
+                                "previous_url": "/docs/lesson-2-run-queries-with-ansi-sql/",
+                                "relative_path": "_docs/zh/tutorials/learn-drill-with-the-mapr-sandbox/050-lesson-3-run-queries-on-complex-data-types.md",
+                                "title": "\u7b2c\u4e09\u8bfe: \u67e5\u8be2\u590d\u6742\u6570\u636e\u7c7b\u578b",
+                                "url": "/docs/lesson-3-run-queries-on-complex-data-types/"
+                            },
+                            {
+                                "breadcrumbs": [
+                                    {
+                                        "title": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                                        "url": "/docs/learn-drill-with-the-mapr-sandbox/"
+                                    },
+                                    {
+                                        "title": "\u6559\u7a0b",
+                                        "url": "/docs/tutorials/"
+                                    }
+                                ],
+                                "children": [],
+                                "next_title": "\u5206\u6790\u9ad8\u52a8\u6001\u6570\u636e\u96c6",
+                                "next_url": "/docs/analyzing-highly-dynamic-datasets/",
+                                "parent": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                                "previous_title": "\u7b2c\u4e09\u8bfe: \u67e5\u8be2\u590d\u6742\u6570\u636e\u7c7b\u578b",
+                                "previous_url": "/docs/lesson-3-run-queries-on-complex-data-types/",
+                                "relative_path": "_docs/zh/tutorials/learn-drill-with-the-mapr-sandbox/060-summary.md",
+                                "title": "\u603b\u7ed3",
+                                "url": "/docs/summary/"
+                            }
+                        ],
+                        "next_title": "\u5173\u4e8e MapR \u6c99\u76d2",
+                        "next_url": "/docs/about-the-mapr-sandbox/",
+                        "parent": "\u6559\u7a0b",
+                        "previous_title": "\u5206\u6790 Yelp \u5b66\u672f\u6570\u636e\u96c6",
+                        "previous_url": "/docs/analyzing-the-yelp-academic-dataset/",
+                        "relative_path": "_docs/zh/tutorials/040-learn-drill-with-the-mapr-sandbox.md",
+                        "title": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                        "url": "/docs/learn-drill-with-the-mapr-sandbox/"
                     },
                     {
-                        "title": "Connect a Data Source",
-                        "url": "/docs/connect-a-data-source/"
-                    }
-                ],
-                "children": [],
-                "next_title": "Drill Default Input Format",
-                "next_url": "/docs/drill-default-input-format/",
-                "parent": "Storage Plugin Configuration",
-                "previous_title": "Configuring Storage Plugins",
-                "previous_url": "/docs/configuring-storage-plugins/",
-                "relative_path": "_docs/en/connect-a-data-source/050-workspaces.md",
-                "title": "Workspaces",
-                "url": "/docs/workspaces/"
-            },
-            "XML Format Plugin": {
-                "breadcrumbs": [
+                        "breadcrumbs": [
+                            {
+                                "title": "\u6559\u7a0b",
+                                "url": "/docs/tutorials/"
+                            }
+                        ],
+                        "children": [],
+                        "next_title": "\u5206\u6790\u793e\u4ea4\u5a92\u4f53",
+                        "next_url": "/docs/analyzing-social-media/",
+                        "parent": "\u6559\u7a0b",
+                        "previous_title": "\u603b\u7ed3",
+                        "previous_url": "/docs/summary/",
+                        "relative_path": "_docs/zh/tutorials/050-analyzing-highly-dynamic-datasets.md",
+                        "title": "\u5206\u6790\u9ad8\u52a8\u6001\u6570\u636e\u96c6",
+                        "url": "/docs/analyzing-highly-dynamic-datasets/"
+                    },
                     {
-                        "title": "Data Sources and File Formats",
-                        "url": "/docs/data-sources-and-file-formats/"
-                    }
-                ],
-                "children": [],
-                "next_title": "Develop Custom Functions",
-                "next_url": "/docs/develop-custom-functions/",
-                "parent": "Data Sources and File Formats",
-                "previous_title": "HDF5 Format Plugin",
-                "previous_url": "/docs/hdf5-format-plugin/",
-                "relative_path": "_docs/en/data-sources-and-file-formats/120-xml-format-plugin.md",
-                "title": "XML Format Plugin",
-                "url": "/docs/xml-format-plugin/"
-            },
-            "\u4e3a\u4ec0\u4e48\u9009\u62e9 Drill": {
-                "breadcrumbs": [
+                        "breadcrumbs": [
+                            {
+                                "title": "\u6559\u7a0b",
+                                "url": "/docs/tutorials/"
+                            }
+                        ],
+                        "children": [],
+                        "next_title": "\u901a\u8fc7\u7a97\u53e3\u51fd\u6570\u5206\u6790\u6570\u636e\u96c6",
+                        "next_url": "/docs/analyzing-data-using-window-functions/",
+                        "parent": "\u6559\u7a0b",
+                        "previous_title": "\u5206\u6790\u9ad8\u52a8\u6001\u6570\u636e\u96c6",
+                        "previous_url": "/docs/analyzing-highly-dynamic-datasets/",
+                        "relative_path": "_docs/zh/tutorials/060-analyzing-social-media.md",
+                        "title": "\u5206\u6790\u793e\u4ea4\u5a92\u4f53",
+                        "url": "/docs/analyzing-social-media/"
+                    },
                     {
-                        "title": "\u65b0\u624b\u5f00\u59cb",
-                        "url": "/docs/getting-started/"
+                        "breadcrumbs": [
+                            {
+                                "title": "\u6559\u7a0b",
+                                "url": "/docs/tutorials/"
+                            }
+                        ],
+                        "children": [],
+                        "next_title": "Drill-on-YARN",
+                        "next_url": "/docs/drill-on-yarn/",
+                        "parent": "\u6559\u7a0b",
+                        "previous_title": "\u5206\u6790\u793e\u4ea4\u5a92\u4f53",
+                        "previous_url": "/docs/analyzing-social-media/",
+                        "relative_path": "_docs/zh/tutorials/070-analyzing-data-using-window-functions.md",
+                        "title": "\u901a\u8fc7\u7a97\u53e3\u51fd\u6570\u5206\u6790\u6570\u636e\u96c6",
+                        "url": "/docs/analyzing-data-using-window-functions/"
                     }
                 ],
-                "children": [],
-                "next_title": "Architecture",
-                "next_url": "/docs/architecture/",
-                "parent": "\u65b0\u624b\u5f00\u59cb",
-                "previous_title": "\u4ec0\u4e48\u662f Drill",
-                "previous_url": "/docs/drill-introduction/",
-                "relative_path": "_docs/zh/getting-started/020-why-drill.md",
-                "title": "\u4e3a\u4ec0\u4e48\u9009\u62e9 Drill",
-                "url": "/docs/why-drill/"
+                "next_title": "\u6559\u7a0b\u4ecb\u7ecd",
+                "next_url": "/docs/tutorials-introduction/",
+                "parent": "",
+                "previous_title": "Performance",
+                "previous_url": "/docs/performance/",
+                "relative_path": "_docs/zh/030-tutorials.md",
+                "title": "\u6559\u7a0b",
+                "url": "/docs/tutorials/"
             },
-            "\u4ec0\u4e48\u662f Drill": {
+            "\u6559\u7a0b\u4ecb\u7ecd": {
                 "breadcrumbs": [
                     {
-                        "title": "\u65b0\u624b\u5f00\u59cb",
-                        "url": "/docs/getting-started/"
+                        "title": "\u6559\u7a0b",
+                        "url": "/docs/tutorials/"
                     }
                 ],
                 "children": [],
-                "next_title": "\u4e3a\u4ec0\u4e48\u9009\u62e9 Drill",
-                "next_url": "/docs/why-drill/",
-                "parent": "\u65b0\u624b\u5f00\u59cb",
-                "previous_title": "\u65b0\u624b\u5f00\u59cb",
-                "previous_url": "/docs/getting-started/",
-                "relative_path": "_docs/zh/getting-started/010-drill-introduction.md",
-                "title": "\u4ec0\u4e48\u662f Drill",
-                "url": "/docs/drill-introduction/"
+                "next_title": "10\u5206\u949f\u4e86\u89e3 Drill",
+                "next_url": "/docs/drill-in-10-minutes/",
+                "parent": "\u6559\u7a0b",
+                "previous_title": "\u6559\u7a0b",
+                "previous_url": "/docs/tutorials/",
+                "relative_path": "_docs/zh/tutorials/010-tutorials-introduction.md",
+                "title": "\u6559\u7a0b\u4ecb\u7ecd",
+                "url": "/docs/tutorials-introduction/"
             },
             "\u65b0\u624b\u5f00\u59cb": {
                 "breadcrumbs": [],
@@ -41369,6 +41289,86 @@
                 "relative_path": "_docs/zh/010-getting-started.md",
                 "title": "\u65b0\u624b\u5f00\u59cb",
                 "url": "/docs/getting-started/"
+            },
+            "\u7b2c\u4e00\u8bfe: \u5b66\u4e60\u6570\u636e\u96c6": {
+                "breadcrumbs": [
+                    {
+                        "title": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                        "url": "/docs/learn-drill-with-the-mapr-sandbox/"
+                    },
+                    {
+                        "title": "\u6559\u7a0b",
+                        "url": "/docs/tutorials/"
+                    }
+                ],
+                "children": [],
+                "next_title": "\u7b2c\u4e8c\u8bfe: \u4f7f\u7528 ANSI SQL \u67e5\u8be2",
+                "next_url": "/docs/lesson-2-run-queries-with-ansi-sql/",
+                "parent": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                "previous_title": "\u4e86\u89e3 Drill Sandbox",
+                "previous_url": "/docs/getting-to-know-the-drill-sandbox/",
+                "relative_path": "_docs/zh/tutorials/learn-drill-with-the-mapr-sandbox/030-lesson-1-learn-about-the-data-set.md",
+                "title": "\u7b2c\u4e00\u8bfe: \u5b66\u4e60\u6570\u636e\u96c6",
+                "url": "/docs/lesson-1-learn-about-the-data-set/"
+            },
+            "\u7b2c\u4e09\u8bfe: \u67e5\u8be2\u590d\u6742\u6570\u636e\u7c7b\u578b": {
+                "breadcrumbs": [
+                    {
+                        "title": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                        "url": "/docs/learn-drill-with-the-mapr-sandbox/"
+                    },
+                    {
+                        "title": "\u6559\u7a0b",
+                        "url": "/docs/tutorials/"
+                    }
+                ],
+                "children": [],
+                "next_title": "\u603b\u7ed3",
+                "next_url": "/docs/summary/",
+                "parent": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                "previous_title": "\u7b2c\u4e8c\u8bfe: \u4f7f\u7528 ANSI SQL \u67e5\u8be2",
+                "previous_url": "/docs/lesson-2-run-queries-with-ansi-sql/",
+                "relative_path": "_docs/zh/tutorials/learn-drill-with-the-mapr-sandbox/050-lesson-3-run-queries-on-complex-data-types.md",
+                "title": "\u7b2c\u4e09\u8bfe: \u67e5\u8be2\u590d\u6742\u6570\u636e\u7c7b\u578b",
+                "url": "/docs/lesson-3-run-queries-on-complex-data-types/"
+            },
+            "\u7b2c\u4e8c\u8bfe: \u4f7f\u7528 ANSI SQL \u67e5\u8be2": {
+                "breadcrumbs": [
+                    {
+                        "title": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                        "url": "/docs/learn-drill-with-the-mapr-sandbox/"
+                    },
+                    {
+                        "title": "\u6559\u7a0b",
+                        "url": "/docs/tutorials/"
+                    }
+                ],
+                "children": [],
+                "next_title": "\u7b2c\u4e09\u8bfe: \u67e5\u8be2\u590d\u6742\u6570\u636e\u7c7b\u578b",
+                "next_url": "/docs/lesson-3-run-queries-on-complex-data-types/",
+                "parent": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                "previous_title": "\u7b2c\u4e00\u8bfe: \u5b66\u4e60\u6570\u636e\u96c6",
+                "previous_url": "/docs/lesson-1-learn-about-the-data-set/",
+                "relative_path": "_docs/zh/tutorials/learn-drill-with-the-mapr-sandbox/040-lesson-2-run-queries-with-ansi-sql.md",
+                "title": "\u7b2c\u4e8c\u8bfe: \u4f7f\u7528 ANSI SQL \u67e5\u8be2",
+                "url": "/docs/lesson-2-run-queries-with-ansi-sql/"
+            },
+            "\u901a\u8fc7\u7a97\u53e3\u51fd\u6570\u5206\u6790\u6570\u636e\u96c6": {
+                "breadcrumbs": [
+                    {
+                        "title": "\u6559\u7a0b",
+                        "url": "/docs/tutorials/"
+                    }
+                ],
+                "children": [],
+                "next_title": "Drill-on-YARN",
+                "next_url": "/docs/drill-on-yarn/",
+                "parent": "\u6559\u7a0b",
+                "previous_title": "\u5206\u6790\u793e\u4ea4\u5a92\u4f53",
+                "previous_url": "/docs/analyzing-social-media/",
+                "relative_path": "_docs/zh/tutorials/070-analyzing-data-using-window-functions.md",
+                "title": "\u901a\u8fc7\u7a97\u53e3\u51fd\u6570\u5206\u6790\u6570\u636e\u96c6",
+                "url": "/docs/analyzing-data-using-window-functions/"
             }
         },
         "hierarchy": [
@@ -41481,7 +41481,7 @@
                             }
                         ],
                         "children": [],
-                        "next_title": "Tutorials",
+                        "next_title": "\u6559\u7a0b",
                         "next_url": "/docs/tutorials/",
                         "parent": "Architecture",
                         "previous_title": "Core Modules",
@@ -41506,58 +41506,58 @@
                     {
                         "breadcrumbs": [
                             {
-                                "title": "Tutorials",
+                                "title": "\u6559\u7a0b",
                                 "url": "/docs/tutorials/"
                             }
                         ],
                         "children": [],
-                        "next_title": "Drill in 10 Minutes",
+                        "next_title": "10\u5206\u949f\u4e86\u89e3 Drill",
                         "next_url": "/docs/drill-in-10-minutes/",
-                        "parent": "Tutorials",
-                        "previous_title": "Tutorials",
+                        "parent": "\u6559\u7a0b",
+                        "previous_title": "\u6559\u7a0b",
                         "previous_url": "/docs/tutorials/",
-                        "relative_path": "_docs/en/tutorials/010-tutorials-introduction.md",
-                        "title": "Tutorials Introduction",
+                        "relative_path": "_docs/zh/tutorials/010-tutorials-introduction.md",
+                        "title": "\u6559\u7a0b\u4ecb\u7ecd",
                         "url": "/docs/tutorials-introduction/"
                     },
                     {
                         "breadcrumbs": [
                             {
-                                "title": "Tutorials",
+                                "title": "\u6559\u7a0b",
                                 "url": "/docs/tutorials/"
                             }
                         ],
                         "children": [],
-                        "next_title": "Analyzing the Yelp Academic Dataset",
+                        "next_title": "\u5206\u6790 Yelp \u5b66\u672f\u6570\u636e\u96c6",
                         "next_url": "/docs/analyzing-the-yelp-academic-dataset/",
-                        "parent": "Tutorials",
-                        "previous_title": "Tutorials Introduction",
+                        "parent": "\u6559\u7a0b",
+                        "previous_title": "\u6559\u7a0b\u4ecb\u7ecd",
                         "previous_url": "/docs/tutorials-introduction/",
-                        "relative_path": "_docs/en/tutorials/020-drill-in-10-minutes.md",
-                        "title": "Drill in 10 Minutes",
+                        "relative_path": "_docs/zh/tutorials/020-drill-in-10-minutes.md",
+                        "title": "10\u5206\u949f\u4e86\u89e3 Drill",
                         "url": "/docs/drill-in-10-minutes/"
                     },
                     {
                         "breadcrumbs": [
                             {
-                                "title": "Tutorials",
+                                "title": "\u6559\u7a0b",
                                 "url": "/docs/tutorials/"
                             }
                         ],
                         "children": [],
-                        "next_title": "Learn Drill with the MapR Sandbox",
+                        "next_title": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
                         "next_url": "/docs/learn-drill-with-the-mapr-sandbox/",
-                        "parent": "Tutorials",
-                        "previous_title": "Drill in 10 Minutes",
+                        "parent": "\u6559\u7a0b",
+                        "previous_title": "10\u5206\u949f\u4e86\u89e3 Drill",
                         "previous_url": "/docs/drill-in-10-minutes/",
-                        "relative_path": "_docs/en/tutorials/030-analyzing-the-yelp-academic-dataset.md",
-                        "title": "Analyzing the Yelp Academic Dataset",
+                        "relative_path": "_docs/zh/tutorials/030-analyzing-the-yelp-academic-dataset.md",
+                        "title": "\u5206\u6790 Yelp \u5b66\u672f\u6570\u636e\u96c6",
                         "url": "/docs/analyzing-the-yelp-academic-dataset/"
                     },
                     {
                         "breadcrumbs": [
                             {
-                                "title": "Tutorials",
+                                "title": "\u6559\u7a0b",
                                 "url": "/docs/tutorials/"
                             }
                         ],
@@ -41565,219 +41565,219 @@
                             {
                                 "breadcrumbs": [
                                     {
-                                        "title": "Learn Drill with the MapR Sandbox",
+                                        "title": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
                                         "url": "/docs/learn-drill-with-the-mapr-sandbox/"
                                     },
                                     {
-                                        "title": "Tutorials",
+                                        "title": "\u6559\u7a0b",
                                         "url": "/docs/tutorials/"
                                     }
                                 ],
                                 "children": [],
-                                "next_title": "Installing the Apache Drill Sandbox",
+                                "next_title": "\u5b89\u88c5 Apache Drill SandBox",
                                 "next_url": "/docs/installing-the-apache-drill-sandbox/",
-                                "parent": "Learn Drill with the MapR Sandbox",
-                                "previous_title": "Learn Drill with the MapR Sandbox",
+                                "parent": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                                "previous_title": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
                                 "previous_url": "/docs/learn-drill-with-the-mapr-sandbox/",
-                                "relative_path": "_docs/en/tutorials/learn-drill-with-the-mapr-sandbox/005-about-the-mapr-sandbox.md",
-                                "title": "About the MapR Sandbox",
+                                "relative_path": "_docs/zh/tutorials/learn-drill-with-the-mapr-sandbox/005-about-the-mapr-sandbox.md",
+                                "title": "\u5173\u4e8e MapR \u6c99\u76d2",
                                 "url": "/docs/about-the-mapr-sandbox/"
                             },
                             {
                                 "breadcrumbs": [
                                     {
-                                        "title": "Learn Drill with the MapR Sandbox",
+                                        "title": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
                                         "url": "/docs/learn-drill-with-the-mapr-sandbox/"
                                     },
                                     {
-                                        "title": "Tutorials",
+                                        "title": "\u6559\u7a0b",
                                         "url": "/docs/tutorials/"
                                     }
                                 ],
                                 "children": [],
-                                "next_title": "Getting to Know the Drill Sandbox",
+                                "next_title": "\u4e86\u89e3 Drill Sandbox",
                                 "next_url": "/docs/getting-to-know-the-drill-sandbox/",
-                                "parent": "Learn Drill with the MapR Sandbox",
-                                "previous_title": "About the MapR Sandbox",
+                                "parent": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                                "previous_title": "\u5173\u4e8e MapR \u6c99\u76d2",
                                 "previous_url": "/docs/about-the-mapr-sandbox/",
-                                "relative_path": "_docs/en/tutorials/learn-drill-with-the-mapr-sandbox/010-installing-the-apache-drill-sandbox.md",
-                                "title": "Installing the Apache Drill Sandbox",
+                                "relative_path": "_docs/zh/tutorials/learn-drill-with-the-mapr-sandbox/010-installing-the-apache-drill-sandbox.md",
+                                "title": "\u5b89\u88c5 Apache Drill SandBox",
                                 "url": "/docs/installing-the-apache-drill-sandbox/"
                             },
                             {
                                 "breadcrumbs": [
                                     {
-                                        "title": "Learn Drill with the MapR Sandbox",
+                                        "title": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
                                         "url": "/docs/learn-drill-with-the-mapr-sandbox/"
                                     },
                                     {
-                                        "title": "Tutorials",
+                                        "title": "\u6559\u7a0b",
                                         "url": "/docs/tutorials/"
                                     }
                                 ],
                                 "children": [],
-                                "next_title": "Lesson 1: Learn about the Data Set",
+                                "next_title": "\u7b2c\u4e00\u8bfe: \u5b66\u4e60\u6570\u636e\u96c6",
                                 "next_url": "/docs/lesson-1-learn-about-the-data-set/",
-                                "parent": "Learn Drill with the MapR Sandbox",
-                                "previous_title": "Installing the Apache Drill Sandbox",
+                                "parent": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                                "previous_title": "\u5b89\u88c5 Apache Drill SandBox",
                                 "previous_url": "/docs/installing-the-apache-drill-sandbox/",
-                                "relative_path": "_docs/en/tutorials/learn-drill-with-the-mapr-sandbox/020-getting-to-know-the-drill-sandbox.md",
-                                "title": "Getting to Know the Drill Sandbox",
+                                "relative_path": "_docs/zh/tutorials/learn-drill-with-the-mapr-sandbox/020-getting-to-know-the-drill-sandbox.md",
+                                "title": "\u4e86\u89e3 Drill Sandbox",
                                 "url": "/docs/getting-to-know-the-drill-sandbox/"
                             },
                             {
                                 "breadcrumbs": [
                                     {
-                                        "title": "Learn Drill with the MapR Sandbox",
+                                        "title": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
                                         "url": "/docs/learn-drill-with-the-mapr-sandbox/"
                                     },
                                     {
-                                        "title": "Tutorials",
+                                        "title": "\u6559\u7a0b",
                                         "url": "/docs/tutorials/"
                                     }
                                 ],
                                 "children": [],
-                                "next_title": "Lesson 2: Run Queries with ANSI SQL",
+                                "next_title": "\u7b2c\u4e8c\u8bfe: \u4f7f\u7528 ANSI SQL \u67e5\u8be2",
                                 "next_url": "/docs/lesson-2-run-queries-with-ansi-sql/",
-                                "parent": "Learn Drill with the MapR Sandbox",
-                                "previous_title": "Getting to Know the Drill Sandbox",
+                                "parent": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                                "previous_title": "\u4e86\u89e3 Drill Sandbox",
                                 "previous_url": "/docs/getting-to-know-the-drill-sandbox/",
-                                "relative_path": "_docs/en/tutorials/learn-drill-with-the-mapr-sandbox/030-lesson-1-learn-about-the-data-set.md",
-                                "title": "Lesson 1: Learn about the Data Set",
+                                "relative_path": "_docs/zh/tutorials/learn-drill-with-the-mapr-sandbox/030-lesson-1-learn-about-the-data-set.md",
+                                "title": "\u7b2c\u4e00\u8bfe: \u5b66\u4e60\u6570\u636e\u96c6",
                                 "url": "/docs/lesson-1-learn-about-the-data-set/"
                             },
                             {
                                 "breadcrumbs": [
                                     {
-                                        "title": "Learn Drill with the MapR Sandbox",
+                                        "title": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
                                         "url": "/docs/learn-drill-with-the-mapr-sandbox/"
                                     },
                                     {
-                                        "title": "Tutorials",
+                                        "title": "\u6559\u7a0b",
                                         "url": "/docs/tutorials/"
                                     }
                                 ],
                                 "children": [],
-                                "next_title": "Lesson 3: Run Queries on Complex Data Types",
+                                "next_title": "\u7b2c\u4e09\u8bfe: \u67e5\u8be2\u590d\u6742\u6570\u636e\u7c7b\u578b",
                                 "next_url": "/docs/lesson-3-run-queries-on-complex-data-types/",
-                                "parent": "Learn Drill with the MapR Sandbox",
-                                "previous_title": "Lesson 1: Learn about the Data Set",
+                                "parent": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                                "previous_title": "\u7b2c\u4e00\u8bfe: \u5b66\u4e60\u6570\u636e\u96c6",
                                 "previous_url": "/docs/lesson-1-learn-about-the-data-set/",
-                                "relative_path": "_docs/en/tutorials/learn-drill-with-the-mapr-sandbox/040-lesson-2-run-queries-with-ansi-sql.md",
-                                "title": "Lesson 2: Run Queries with ANSI SQL",
+                                "relative_path": "_docs/zh/tutorials/learn-drill-with-the-mapr-sandbox/040-lesson-2-run-queries-with-ansi-sql.md",
+                                "title": "\u7b2c\u4e8c\u8bfe: \u4f7f\u7528 ANSI SQL \u67e5\u8be2",
                                 "url": "/docs/lesson-2-run-queries-with-ansi-sql/"
                             },
                             {
                                 "breadcrumbs": [
                                     {
-                                        "title": "Learn Drill with the MapR Sandbox",
+                                        "title": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
                                         "url": "/docs/learn-drill-with-the-mapr-sandbox/"
                                     },
                                     {
-                                        "title": "Tutorials",
+                                        "title": "\u6559\u7a0b",
                                         "url": "/docs/tutorials/"
                                     }
                                 ],
                                 "children": [],
-                                "next_title": "Summary",
+                                "next_title": "\u603b\u7ed3",
                                 "next_url": "/docs/summary/",
-                                "parent": "Learn Drill with the MapR Sandbox",
-                                "previous_title": "Lesson 2: Run Queries with ANSI SQL",
+                                "parent": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                                "previous_title": "\u7b2c\u4e8c\u8bfe: \u4f7f\u7528 ANSI SQL \u67e5\u8be2",
                                 "previous_url": "/docs/lesson-2-run-queries-with-ansi-sql/",
-                                "relative_path": "_docs/en/tutorials/learn-drill-with-the-mapr-sandbox/050-lesson-3-run-queries-on-complex-data-types.md",
-                                "title": "Lesson 3: Run Queries on Complex Data Types",
+                                "relative_path": "_docs/zh/tutorials/learn-drill-with-the-mapr-sandbox/050-lesson-3-run-queries-on-complex-data-types.md",
+                                "title": "\u7b2c\u4e09\u8bfe: \u67e5\u8be2\u590d\u6742\u6570\u636e\u7c7b\u578b",
                                 "url": "/docs/lesson-3-run-queries-on-complex-data-types/"
                             },
                             {
                                 "breadcrumbs": [
                                     {
-                                        "title": "Learn Drill with the MapR Sandbox",
+                                        "title": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
                                         "url": "/docs/learn-drill-with-the-mapr-sandbox/"
                                     },
                                     {
-                                        "title": "Tutorials",
+                                        "title": "\u6559\u7a0b",
                                         "url": "/docs/tutorials/"
                                     }
                                 ],
                                 "children": [],
-                                "next_title": "Analyzing Highly Dynamic Datasets",
+                                "next_title": "\u5206\u6790\u9ad8\u52a8\u6001\u6570\u636e\u96c6",
                                 "next_url": "/docs/analyzing-highly-dynamic-datasets/",
-                                "parent": "Learn Drill with the MapR Sandbox",
-                                "previous_title": "Lesson 3: Run Queries on Complex Data Types",
+                                "parent": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
+                                "previous_title": "\u7b2c\u4e09\u8bfe: \u67e5\u8be2\u590d\u6742\u6570\u636e\u7c7b\u578b",
                                 "previous_url": "/docs/lesson-3-run-queries-on-complex-data-types/",
-                                "relative_path": "_docs/en/tutorials/learn-drill-with-the-mapr-sandbox/060-summary.md",
-                                "title": "Summary",
+                                "relative_path": "_docs/zh/tutorials/learn-drill-with-the-mapr-sandbox/060-summary.md",
+                                "title": "\u603b\u7ed3",
                                 "url": "/docs/summary/"
                             }
                         ],
-                        "next_title": "About the MapR Sandbox",
+                        "next_title": "\u5173\u4e8e MapR \u6c99\u76d2",
                         "next_url": "/docs/about-the-mapr-sandbox/",
-                        "parent": "Tutorials",
-                        "previous_title": "Analyzing the Yelp Academic Dataset",
+                        "parent": "\u6559\u7a0b",
+                        "previous_title": "\u5206\u6790 Yelp \u5b66\u672f\u6570\u636e\u96c6",
                         "previous_url": "/docs/analyzing-the-yelp-academic-dataset/",
-                        "relative_path": "_docs/en/tutorials/040-learn-drill-with-the-mapr-sandbox.md",
-                        "title": "Learn Drill with the MapR Sandbox",
+                        "relative_path": "_docs/zh/tutorials/040-learn-drill-with-the-mapr-sandbox.md",
+                        "title": "\u642d\u914d MapR Sandbox \u5b66\u4e60 Drill",
                         "url": "/docs/learn-drill-with-the-mapr-sandbox/"
                     },
                     {
                         "breadcrumbs": [
                             {
-                                "title": "Tutorials",
+                                "title": "\u6559\u7a0b",
                                 "url": "/docs/tutorials/"
                             }
                         ],
                         "children": [],
-                        "next_title": "Analyzing Social Media",
+                        "next_title": "\u5206\u6790\u793e\u4ea4\u5a92\u4f53",
                         "next_url": "/docs/analyzing-social-media/",
-                        "parent": "Tutorials",
-                        "previous_title": "Summary",
+                        "parent": "\u6559\u7a0b",
+                        "previous_title": "\u603b\u7ed3",
                         "previous_url": "/docs/summary/",
-                        "relative_path": "_docs/en/tutorials/050-analyzing-highly-dynamic-datasets.md",
-                        "title": "Analyzing Highly Dynamic Datasets",
+                        "relative_path": "_docs/zh/tutorials/050-analyzing-highly-dynamic-datasets.md",
+                        "title": "\u5206\u6790\u9ad8\u52a8\u6001\u6570\u636e\u96c6",
                         "url": "/docs/analyzing-highly-dynamic-datasets/"
                     },
                     {
                         "breadcrumbs": [
                             {
-                                "title": "Tutorials",
+                                "title": "\u6559\u7a0b",
                                 "url": "/docs/tutorials/"
                             }
                         ],
                         "children": [],
-                        "next_title": "Analyzing Data Using Window Functions",
+                        "next_title": "\u901a\u8fc7\u7a97\u53e3\u51fd\u6570\u5206\u6790\u6570\u636e\u96c6",
                         "next_url": "/docs/analyzing-data-using-window-functions/",
-                        "parent": "Tutorials",
-                        "previous_title": "Analyzing Highly Dynamic Datasets",
+                        "parent": "\u6559\u7a0b",
+                        "previous_title": "\u5206\u6790\u9ad8\u52a8\u6001\u6570\u636e\u96c6",
                         "previous_url": "/docs/analyzing-highly-dynamic-datasets/",
-                        "relative_path": "_docs/en/tutorials/060-analyzing-social-media.md",
-                        "title": "Analyzing Social Media",
+                        "relative_path": "_docs/zh/tutorials/060-analyzing-social-media.md",
+                        "title": "\u5206\u6790\u793e\u4ea4\u5a92\u4f53",
                         "url": "/docs/analyzing-social-media/"
                     },
                     {
                         "breadcrumbs": [
                             {
-                                "title": "Tutorials",
+                                "title": "\u6559\u7a0b",
                                 "url": "/docs/tutorials/"
                             }
                         ],
                         "children": [],
                         "next_title": "Drill-on-YARN",
                         "next_url": "/docs/drill-on-yarn/",
-                        "parent": "Tutorials",
-                        "previous_title": "Analyzing Social Media",
+                        "parent": "\u6559\u7a0b",
+                        "previous_title": "\u5206\u6790\u793e\u4ea4\u5a92\u4f53",
                         "previous_url": "/docs/analyzing-social-media/",
-                        "relative_path": "_docs/en/tutorials/070-analyzing-data-using-window-functions.md",
-                        "title": "Analyzing Data Using Window Functions",
+                        "relative_path": "_docs/zh/tutorials/070-analyzing-data-using-window-functions.md",
+                        "title": "\u901a\u8fc7\u7a97\u53e3\u51fd\u6570\u5206\u6790\u6570\u636e\u96c6",
                         "url": "/docs/analyzing-data-using-window-functions/"
                     }
                 ],
-                "next_title": "Tutorials Introduction",
+                "next_title": "\u6559\u7a0b\u4ecb\u7ecd",
                 "next_url": "/docs/tutorials-introduction/",
                 "parent": "",
                 "previous_title": "Performance",
                 "previous_url": "/docs/performance/",
-                "relative_path": "_docs/en/030-tutorials.md",
-                "title": "Tutorials",
+                "relative_path": "_docs/zh/030-tutorials.md",
+                "title": "\u6559\u7a0b",
                 "url": "/docs/tutorials/"
             },
             {
@@ -41991,7 +41991,7 @@
                 "next_title": "Drill-on-YARN Introduction",
                 "next_url": "/docs/drill-on-yarn-introduction/",
                 "parent": "",
-                "previous_title": "Analyzing Data Using Window Functions",
+                "previous_title": "\u901a\u8fc7\u7a97\u53e3\u51fd\u6570\u5206\u6790\u6570\u636e\u96c6",
                 "previous_url": "/docs/analyzing-data-using-window-functions/",
                 "relative_path": "_docs/en/031-drill-on-yarn.md",
                 "title": "Drill-on-YARN",
diff --git a/_docs/en/drill-on-yarn/020-creating-a-basic-drill-cluster.md b/_docs/en/drill-on-yarn/020-creating-a-basic-drill-cluster.md
index 5a56452..0bce464 100644
--- a/_docs/en/drill-on-yarn/020-creating-a-basic-drill-cluster.md
+++ b/_docs/en/drill-on-yarn/020-creating-a-basic-drill-cluster.md
@@ -2,15 +2,15 @@
 title: "Creating a Basic Drill Cluster"
 slug: "Creating a Basic Drill Cluster"
 parent: "Drill-on-YARN"
----  
+---
 
-This topic walks you through the steps needed to create a basic Drill cluster.  
+This topic walks you through the steps needed to create a basic Drill cluster.
 
-## The Client Machine  
+## The Client Machine
 
 YARN works by launching an application using a “client” application. For Drill, this is the
 Drill-on-YARN client. The client can run on any machine that has both the Drill and Hadoop
-software. Any host from which you currently launch YARN jobs can be the client. The client is not required to be part of the YARN cluster. 
+software. Any host from which you currently launch YARN jobs can be the client. The client is not required to be part of the YARN cluster.
 
 When running Drill outside of YARN, you must install Drill on every node in the cluster. With YARN, you only need install Drill only on the client machine; Drill-on-YARN automatically deploys (“localizes”) Drill to the worker nodes.
 
@@ -19,84 +19,59 @@ within the Drill distribution directory. When running under YARN, all your confi
 custom code resides in the site directory; do not change anything in the Drill install.
 (This allows Drill-on-YARN to upload your original Drill install archive without rebuilding it.)
 
-Complete the following steps on the client machine:  
+Complete the following steps on the client machine:
+
+### Create a Master Directory
 
-### Create a Master Directory  
+To localize Drill files, the client tool requires a copy of the original Drill distribution archive and the location of your site directory. Assume all these components reside in a single “master directory” described as $MASTER_DIR . On the client machine, create the master directory, as shown:
 
-To localize Drill files, the client tool requires a copy of the original Drill distribution archive and the location of your site directory. Assume all these components reside in a single “master directory” described as $MASTER_DIR . On the client machine, create the master directory, as shown:  
+```sh
+export MASTER_DIR=/path/to/master/dir
+mkdir $MASTER_DIR
+cd $MASTER_DIR
+```
 
-       export MASTER_DIR=/path/to/master/dir
-       mkdir $MASTER_DIR
-       cd $MASTER_DIR  
+To build the master directory, you will:
 
-To build the master directory, you will: 
 - Download the Drill archive to $MASTER_DRILL.
 - Unpack the archive to create $DRILL_HOME.
 - Create the site directory with the required configuration files.
 
-The following steps provide the instructions for building the master directory:  
+The following steps provide the instructions for building the master directory:
 
 ### Install Drill
+
 These instructions assume you are installing Drill as part of the Drill-on-YARN
-setup. You can use your existing Drill 1.8 or later install as long as it meets the required criteria. 
+setup. You can use your existing Drill 1.8 or later install as long as it meets the required criteria.
 
-Follow the Drill [install directions]({{site.baseurl}}/docs/install-drill-introduction/) to install Drill on your client host. The install steps are different for YARN than for the Embedded or Cluster install. 
+Follow the Drill [install directions]({{site.baseurl}}/docs/install-drill-introduction/) to install Drill on your client host. The install steps are different for YARN than for the Embedded or Cluster install.
 
-1. Select a Drill version. The name is used in multiple places below. For convenience, define an environment variable for the name:  
- 
-              export DRILL_NAME=apachedrillx.y.z
+1.  Select a Drill version. The name is used in multiple places below. For convenience, define an environment variable for the name:
+```sh
+export DRILL_NAME=apachedrillx.y.z
+```
 Replace x.y.z with the selected version.
-2. Download the Drill version.  
-
-              wget \ http://apache.mesi.com.ar/drill/drillx.y.z/$DRILL_NAME.tar.gz
-Or use  
-
-              curl o $DRILL_NAME.tar.gz \http://apache.mesi.com.ar/drill/drillx.y.z/$DRILL_NAME.tar.gz
+2.  Download the Drill version.
+```sh
+wget http://apache.mesi.com.ar/drill/drillx.y.z/$DRILL_NAME.tar.gz
+```
+Or use
+```sh
+curl -o $DRILL_NAME.tar.gz \http://apache.mesi.com.ar/drill/drillx.y.z/$DRILL_NAME.tar.gz
+```
 Again, replace x.y.z with the selected version.
+3.  Expand the Drill distribution into this folder to create the master directory
+```sh
+tar -xzf $DRILL_NAME.tar.gz
+```
+4.  For ease of following the remaining steps, call your expanded Drill folder $DRILL_HOME :
+```sh
+export DRILL_HOME=$MASTER_DIR/$DRILL_NAME
+```
 
-3. Expand the Drill distribution into this folder to create the master directory  
-
-              tar -xzf $DRILL_NAME.tar.gz
-4. For ease of following the remaining steps, call your expanded Drill folder $DRILL_HOME :
-
-              export DRILL_HOME=$MASTER_DIR/$DRILL_NAME
-
-Your master directory should now contain the original Drill archive along with an expanded copy
-of that archive.  
-
-### Create the Site Directory  
-
-The site directory contains your site-specific files for Drill. If you are converting an existing Drill install, see the “Site Directory” section.  
-
-Create the site directory within your master directory:
-
-              export DRILL_SITE=$MASTER_DIR/site
-              mkdir $DRILL_SITE
-
-When you do a fresh install, Drill includes a conf directory under $DRILL_HOME. Use the files
-in that directory to create your site directory.  
-
-              cp $DRILL_HOME/conf/drilloverrideexample.conf \
-              $DRILL_SITE/drilloverride.conf
-              cp $DRILL_HOME/conf/drill-on-yarnexample.conf \
-              $DRILL_SITE/drill-on-yarn.conf
-              cp $DRILL_HOME/conf/drillenv.sh $DRILL_SITE  
-
-Edit the above configuration files as per the Drill install instructions, and the Drill-on-YARN
-instructions below. (Note that, under YARN, you set the Drill memory limits in
-drill-on-yarn.sh instead of drillenv.sh.)
+Your master directory should now contain the original Drill archive along with an expanded copy of that archive. You may now follow the instructions on how to create the site directory, see [Installing Drill on the Cluster]({{site.baseurl}} /docs/installing-drill-on-the-cluster/).
 
-If you develop custom code (data sources or user-defined functions (UDFs)), place the Java JAR
-files in $DRILL_SITE/jars. 
-
-Your master directory should now contain the Drill software and your site directory with default files. You will use the site directory each time you start Drill by using the --site
-(or --config) option. The following are examples, do not run these yet:
-
-              drillbit.sh --site $DRILL_SITE
-              drill-on-yarn.sh --site $DRILL_SITE
-
-Once you have created your site directory, upgrades are trivial. Simply delete the old Drill
-distribution and install the new one. Your files remain unchanged in the site directory.  
+Edit the configuration files as per the Drill install instructions, and the Drill-on-YARN instructions below. Note that, under YARN, you set the Drill memory limits in drill-on-yarn.sh instead of drillenv.sh.
 
 ### Configure Drill-on-YARN using Existing Settings
 
@@ -104,134 +79,156 @@ The next step is to configure Drill. If you have used Drill, start with Drill
 in distributed mode to learn which configuration options you need. YARN is an awkward
 environment in which to learn Drill configuration. These instructions assume that you have already worked out the required configuration on a separate Drill install. Let's call that location $PROD_DRILL_HOME.
 
-From $PROD_DRILL_HOME, copy the following to corresponding locations in $DRILL_SITE:  
+From $PROD_DRILL_HOME, copy the following to corresponding locations in $DRILL_SITE:
 
-              cp $PROD_DRILL_HOME/conf/drilloverride.conf $DRILL_SITE
-              cp $PROD_DRILL_HOME/conf/drillenv.sh $DRILL_SITE
-              cp $PROD_DRILL_HOME/jars/3rdparty/ yourJarName .jar $DRILL_SITE/jars
+```sh
+cp $PROD_DRILL_HOME/conf/drilloverride.conf $DRILL_SITE
+cp $PROD_DRILL_HOME/conf/drillenv.sh $DRILL_SITE
+cp $PROD_DRILL_HOME/jars/3rdparty/ yourJarName .jar $DRILL_SITE/jars
+```
 
 ### Create Your Cluster Configuration File
-The next step is to specify additional configuration which Drill-on-YARN requires to launch your Drill cluster. 
 
-Start by editing $DRILL_SITE/drill-on-yarn.conf using your favorite editor. This file is
-in the same HOCON format used by drill-override.conf.
+The next step is to specify additional configuration which Drill-on-YARN requires to launch your Drill cluster.
+
+Start by editing $DRILL_SITE/drill-on-yarn.conf using your favorite editor. This file is in the same HOCON format used by drill-override.conf.
 
 Consult $DRILL_HOME/conf/drill-on-yarn-example.conf as an example. However,
 do not just copy the example file; instead, copy only the specific configuration settings that you need; the others will automatically take the Drill-defined
-default values.  
+default values.
 
-The following sections discuss each configuration option that you must set.  
+The following sections discuss each configuration option that you must set.
 
 ### Drill Resource Configuration
-The two key Drill memory parameters are Java heap size and direct memory. In a non-YARN
-cluster, you set these in $DRILL_HOME/conf/drillenv.sh as follows (shown with the
+
+The two key Drill memory parameters are Java heap size and direct memory. In a non-YARN cluster, you set these in $DRILL_HOME/conf/drillenv.sh as follows (shown with the
 default values):
 
-              DRILL_MAX_DIRECT_MEMORY="8G"
-              DRILL_HEAP="4G"  
+```sh
+DRILL_MAX_DIRECT_MEMORY="8G"
+DRILL_HEAP="4G"
+```
 
 Drill-on-YARN uses a different mechanism to set these values. You set the values in
 drill-on-yarn.conf , then Drill-on-YARN copies the values into the environment variables
-when launching each Drillbit.  
+when launching each Drillbit.
 
-              drillbit: {
-                    heap: "4G"
-                    max-direct-memory: "8G"
-                  }  
+```hocon
+drillbit: {
+      heap: "4G"
+      max-direct-memory: "8G"
+    }
+```
 
 To create the Drill-on-YARN setup, simply copy the values directly from your pre-YARN
 drillenv.sh file into the above configuration. (Drill-on-YARN copies the values back into
-the environment variables when launching Drill.) 
+the environment variables when launching Drill.)
 
 Next, determine the container size needed to run Drill under YARN. Typically this size
 is simply the sum of the heap and direct memory. However, if you are using custom libraries that perform their own memory allocation, or launch sub-processes, you must account for that
 memory usage as well. The YARN memory is expressed in MB. For example, for the default
-settings above, we need 12G of memory or 12288MB:  
+settings above, we need 12G of memory or 12288MB:
 
-              drillbit: {
-                     memory-mb: 6144
-                 }  
+```hocon
+drillbit: {
+       memory-mb: 6144
+   }
+```
 
 Finally, you must determine how much CPU to grant to Drill. Drill is a CPU intensive
-operation and greatly benefits from each additional core. However, you can limit Drill’s CPU usage under YARN by specifying the number of YARN virtual cores (vcores) to allocate to Drill:  
+operation and greatly benefits from each additional core. However, you can limit Drill’s CPU usage under YARN by specifying the number of YARN virtual cores (vcores) to allocate to Drill:
 
-              drillbit: {
-                     vcores: 4
-              }  
+```hocon
+drillbit: {
+       vcores: 4
+}
+```
 
 Note that in the above, each configuration setting was shown separately. In your actual file,
-however, they appear within a single group as follows:  
-
-              drillbit: {
-                     heap: "4G"
-                     max-direct-memory: "8G"
-                     memory-mb: 6144
-                     vcores: 4
-                   }  
+however, they appear within a single group as follows:
 
+```hocon
+drillbit: {
+       heap: "4G"
+       max-direct-memory: "8G"
+       memory-mb: 6144
+       vcores: 4
+     }
+```
 
 ### Drillbit Cluster Configuration
-Drill-on-YARN uses the concept of a “cluster group” of Drillbits to describe the set of Drillbits to launch. A group can be one of three kinds:  
-
 
+Drill-on-YARN uses the concept of a “cluster group” of Drillbits to describe the set of Drillbits to launch. A group can be one of three kinds:
 
 - Basic: launches drillbits anywhere in the YARN cluster where a container is available.
 - Labeled: Uses YARN labels to identify the set of nodes that should run Drill.
 
 This section describes how to create a basic group suitable for testing. See later sections for the type.
 
-For a basic group, you need only specify the group type and the number of Drillbits to launch:  
-
-              cluster: [
-                  {
-                    name: "mypool"
-                    type: "basic"
-                    count: 1
-                 }
-              ] 
+For a basic group, you need only specify the group type and the number of Drillbits to launch:
 
+```hocon
+cluster: [
+    {
+      name: "mypool"
+      type: "basic"
+      count: 1
+   }
+]
+```
 
 The above syntax says that pools is a list that contains a series of pool objects contained in
-braces. In this release, however, Drill supports just one pool.  
+braces. In this release, however, Drill supports just one pool.
 
 ### ZooKeeper Configuration
+
 Drill uses ZooKeeper to coordinate between Drillbits. When run under YARN, the Drill
 Application Master uses ZooKeeper to monitor Drillbit health. Drill-on-YARN reads your
-$DRILL_SITE/drilloverride.conf file for ZooKeeper settings.  
-
+$DRILL_SITE/drilloverride.conf file for ZooKeeper settings.
 
 ### Configure the Drill Distribution Archive
-Next configure the name of the Drill distribution archive that you downloaded earlier.  
 
-              drill-install:  {
-                     client-path: "archive-path"
-                   }
+Next configure the name of the Drill distribution archive that you downloaded earlier.
 
-Where archive-path is the location of your archive. In our example, this is $MASTER_DIR/apache-drill.x.y.z.tar.gz. Use the full name of the master directory, not the environment variable. (Substitute your actual version number for x.y.z.)  
+```hocon
+drill-install:  {
+       client-path: "archive-path"
+     }
+```
+
+Where archive-path is the location of your archive. In our example, this is $MASTER_DIR/apache-drill.x.y.z.tar.gz. Use the full name of the master directory, not the environment variable. (Substitute your actual version number for x.y.z.)
 
 ### Select the Distributed File System Location
+
 Drill copies your archive onto your distributed file system (such as HDFS) in a location you
-provide. Set the DFS options as follows:  
+provide. Set the DFS options as follows:
 
-              dfs: {
-                     connection: "hdfs://localhost/"
-                     dir: "/user/drill"
-                 }  
+```hocon
+dfs: {
+       connection: "hdfs://localhost/"
+       dir: "/user/drill"
+   }
+```
 
-Drill can read the connection information from your Hadoop configuration files ($HADOOP_HOME/etc/hadoop/coresite.xml ). Or, you can specify a connection directly in the Drill cluster configuration file using the connection attribute. Then, choose a DFS file system location. Drill uses “ /user/drill ” by default.  
+Drill can read the connection information from your Hadoop configuration files ($HADOOP_HOME/etc/hadoop/coresite.xml ). Or, you can specify a connection directly in the Drill cluster configuration file using the connection attribute. Then, choose a DFS file system location. Drill uses “ /user/drill ” by default.
 
 ### Hadoop Location
-Apache Drill users must tell Drill-on-YARN the location of your Hadoop install. Set the
-HADOOP_HOME environment variable in $DRILL_SITE/drillenv.sh to point to your Hadoop installation:  
-
-              export HADOOP_HOME= /path/to/hadoop-home  
 
-This assumes that Hadoop configuration is in the default location:  
+Apache Drill users must tell Drill-on-YARN the location of your Hadoop install. Set the
+HADOOP_HOME environment variable in $DRILL_SITE/drillenv.sh to point to your Hadoop installation:
 
-              $HADOOP_HOME/etc/hadoop 
+```sh
+export HADOOP_HOME= /path/to/hadoop-home
+```
 
-If your configuration is elsewhere, set HADOOP_CONF_DIR instead:  
+This assumes that Hadoop configuration is in the default location:
 
-       export HADOOP_CONF_DIR= /path/to/hadoop-config
+```sh
+$HADOOP_HOME/etc/hadoop
+```
 
+If your configuration is elsewhere, set HADOOP_CONF_DIR instead:
 
+```sh
+export HADOOP_CONF_DIR= /path/to/hadoop-config
+```
diff --git a/_docs/en/install/047-installing-drill-on-the-cluster.md b/_docs/en/install/047-installing-drill-on-the-cluster.md
index e52dc26..de359b0 100644
--- a/_docs/en/install/047-installing-drill-on-the-cluster.md
+++ b/_docs/en/install/047-installing-drill-on-the-cluster.md
@@ -3,21 +3,67 @@ title: "Installing Drill on the Cluster"
 slug: "Installing Drill on the Cluster"
 parent: "Installing Drill in Distributed Mode"
 ---
+
 You install Drill on nodes in the cluster, configure a cluster ID, and add Zookeeper information, as described in the following steps:
 
-  1. Download the latest version of Apache Drill [here](http://apache.mirrors.hoobly.com/drill/drill-1.19.0/apache-drill-1.19.0.tar.gz) or from the [Apache Drill mirror site](http://www.apache.org/dyn/closer.cgi/drill/drill-1.19.0/apache-drill-1.19.0.tar.gz) with the command appropriate for your system:  
-       * `wget http://apache.mirrors.hoobly.com/drill/drill-1.19.0/apache-drill-1.19.0.tar.gz`  
-       * `curl -o apache-drill-1.19.0.tar.gz http://apache.mirrors.hoobly.com/drill/drill-1.19.0/apache-drill-1.19.0.tar.gz`  
-  2. Extract the tarball to the directory of your choice, such as `/opt`:  
-  `tar -xzvf apache-drill-<version>.tar.gz`
-  3. In `drill-override.conf,` use the Drill `cluster ID`, and provide ZooKeeper host names and port numbers to configure a connection to your ZooKeeper quorum.  
-         a. Edit `drill-override.conf` located in the `conf` directory.  
-         b. Provide a unique `cluster-id` and the ZooKeeper host names and port numbers in `zk.connect`. If you install Drill on multiple nodes, assign the same `cluster ID` to each Drill node so that all Drill nodes share the same ID. The default ZooKeeper port on the open source version of Apache Drill is 2181.
-
-       **Example**
-       
-         drill.exec:{
-          cluster-id: "<mydrillcluster>",
-          zk.connect: "<zkhostname1>:<port>,<zkhostname2>:<port>,<zkhostname3>:<port>"
-         }
+### Install
+
+1. Download the latest version of Apache Drill [here](http://apache.mirrors.hoobly.com/drill/drill-1.19.0/apache-drill-1.19.0.tar.gz) or from the [Apache Drill mirror site](http://www.apache.org/dyn/closer.cgi/drill/drill-1.19.0/apache-drill-1.19.0.tar.gz) with the command appropriate for your system:
+   - `wget http://apache.mirrors.hoobly.com/drill/drill-1.19.0/apache-drill-1.19.0.tar.gz`
+   - `curl -o apache-drill-1.19.0.tar.gz http://apache.mirrors.hoobly.com/drill/drill-1.19.0/apache-drill-1.19.0.tar.gz`
+2. Extract the tarball to the directory of your choice, such as `/opt`:
+   `tar -xf apache-drill-<version>.tar.gz`
+
+### (Optional) Create the site directory
+
+The site directory contains your site-specific files for Drill.  Putting these in a separate directory to the Drill installation means that upgrading Drill will not clobber your configuration and custom code.  It is possible to skip this step, meaning that your configuration and custom code will live in the `$DRILL_HOME/conf` and `$DRILL_HOME/jars/3rdparty` subdirectories respectively.
+
+Create the site directory in a suitable location, e.g.
+
+```sh
+export DRILL_SITE=/etc/drill-site
+mkdir $DRILL_SITE
+```
+
+When you do a fresh install, Drill includes a conf directory under $DRILL_HOME. Use the files
+in that directory to create your site directory.
+
+```sh
+cp $DRILL_HOME/conf/drilloverrideexample.conf \
+$DRILL_SITE/drilloverride.conf
+cp $DRILL_HOME/conf/drill-on-yarnexample.conf \
+$DRILL_SITE/drill-on-yarn.conf
+cp $DRILL_HOME/conf/drillenv.sh $DRILL_SITE
+```
+
+You will use the site directory each time you start Drill by using the `--site` (or `--config`) option. The following are examples.
+
+```sh
+drillbit.sh --site $DRILL_SITE
+drill-on-yarn.sh --site $DRILL_SITE
+```
+
+Once you have created your site directory, upgrades are trivial. Simply delete the old Drill
+distribution and install the new one. Your files remain unchanged in the site directory.
+
+### ZooKeeper configuration
+
+In `drill-override.conf,` use the Drill `cluster ID`, and provide ZooKeeper host names and port numbers to configure a connection to your ZooKeeper quorum.
+
+1. Edit `drill-override.conf` located in the `conf` directory.
+2. Provide a unique `cluster-id` and the ZooKeeper host names and port numbers in `zk.connect`. If you install Drill on multiple nodes, assign the same cluster ID to each Drill node so that all Drill nodes share the same ID. The default ZooKeeper port on the open source version of Apache Drill is 2181.
+
+**Example**
+
+```hocon
+drill.exec:{
+  cluster-id: "<mydrillcluster>",
+  zk.connect: "<zkhostname1>:<port>,<zkhostname2>:<port>,<zkhostname3>:<port>"
+}
+```
+
+### Custom JARs
+
+If you develop custom code (data sources or user-defined functions, a.k.a. UDFs), place the Java JAR
+files in $DRILL_SITE/jars.
 
diff --git a/_docs/en/sql-reference/sql-functions/030-date-time-functions-and-arithmetic.md b/_docs/en/sql-reference/sql-functions/030-date-time-functions-and-arithmetic.md
index 188861d..5760282 100644
--- a/_docs/en/sql-reference/sql-functions/030-date-time-functions-and-arithmetic.md
+++ b/_docs/en/sql-reference/sql-functions/030-date-time-functions-and-arithmetic.md
@@ -33,6 +33,8 @@ This section covers the Drill [time zone limitation]({{site.baseurl}}/docs/data-
 **Supported in Drill 1.16 and later.
 
 ## AGE
+{% include startimportant.html %} DRILL-7926: this function is buggy in the current release.  Please make use of alternative date functions until the mentioned issue is resolved. {% include endimportant.html %}
+
 Returns the interval between two timestamps or subtracts a timestamp from midnight of the current date.
 
 ### AGE Syntax