You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@drill.apache.org by kr...@apache.org on 2015/12/28 22:57:31 UTC
[3/4] drill git commit: add date to front matter
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/odbc-jdbc-interfaces/configuring-odbc/025-configuring-odbc-on-mac-os-x.md
----------------------------------------------------------------------
diff --git a/_docs/odbc-jdbc-interfaces/configuring-odbc/025-configuring-odbc-on-mac-os-x.md b/_docs/odbc-jdbc-interfaces/configuring-odbc/025-configuring-odbc-on-mac-os-x.md
index d2fe631..a335a71 100644
--- a/_docs/odbc-jdbc-interfaces/configuring-odbc/025-configuring-odbc-on-mac-os-x.md
+++ b/_docs/odbc-jdbc-interfaces/configuring-odbc/025-configuring-odbc-on-mac-os-x.md
@@ -1,5 +1,6 @@
---
title: "Configuring ODBC on Mac OS X"
+date: 2015-12-28 21:37:19 UTC
parent: "Configuring ODBC"
---
ODBC driver managers use configuration files to define and configure ODBC data
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/odbc-jdbc-interfaces/configuring-odbc/030-configuring-odbc-on-windows.md
----------------------------------------------------------------------
diff --git a/_docs/odbc-jdbc-interfaces/configuring-odbc/030-configuring-odbc-on-windows.md b/_docs/odbc-jdbc-interfaces/configuring-odbc/030-configuring-odbc-on-windows.md
index 79475e2..43a3d89 100644
--- a/_docs/odbc-jdbc-interfaces/configuring-odbc/030-configuring-odbc-on-windows.md
+++ b/_docs/odbc-jdbc-interfaces/configuring-odbc/030-configuring-odbc-on-windows.md
@@ -1,5 +1,6 @@
---
title: "Configuring ODBC on Windows"
+date: 2015-12-28 21:37:19 UTC
parent: "Configuring ODBC"
---
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/odbc-jdbc-interfaces/configuring-odbc/040-testing-the-odbc-connection.md
----------------------------------------------------------------------
diff --git a/_docs/odbc-jdbc-interfaces/configuring-odbc/040-testing-the-odbc-connection.md b/_docs/odbc-jdbc-interfaces/configuring-odbc/040-testing-the-odbc-connection.md
index e88871f..44f21be 100644
--- a/_docs/odbc-jdbc-interfaces/configuring-odbc/040-testing-the-odbc-connection.md
+++ b/_docs/odbc-jdbc-interfaces/configuring-odbc/040-testing-the-odbc-connection.md
@@ -1,5 +1,6 @@
---
title: "Testing the ODBC Connection"
+date: 2015-12-28 21:37:19 UTC
parent: "Configuring ODBC"
---
The procedure for testing the ODBC connection differs depending on your platform, as described in the following sections:
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/odbc-jdbc-interfaces/installing-the-odbc-driver/010-installing-the-driver-on-linux.md
----------------------------------------------------------------------
diff --git a/_docs/odbc-jdbc-interfaces/installing-the-odbc-driver/010-installing-the-driver-on-linux.md b/_docs/odbc-jdbc-interfaces/installing-the-odbc-driver/010-installing-the-driver-on-linux.md
index a06297e..74781e6 100644
--- a/_docs/odbc-jdbc-interfaces/installing-the-odbc-driver/010-installing-the-driver-on-linux.md
+++ b/_docs/odbc-jdbc-interfaces/installing-the-odbc-driver/010-installing-the-driver-on-linux.md
@@ -1,5 +1,6 @@
---
title: "Installing the Driver on Linux"
+date: 2015-12-28 21:37:19 UTC
parent: "Installing the ODBC Driver"
---
Install the MapR Drill ODBC Driver on the machine from which you connect to
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/odbc-jdbc-interfaces/installing-the-odbc-driver/020-installing-the-driver-on-mac-os-x.md
----------------------------------------------------------------------
diff --git a/_docs/odbc-jdbc-interfaces/installing-the-odbc-driver/020-installing-the-driver-on-mac-os-x.md b/_docs/odbc-jdbc-interfaces/installing-the-odbc-driver/020-installing-the-driver-on-mac-os-x.md
index 4b7dd21..ff17897 100644
--- a/_docs/odbc-jdbc-interfaces/installing-the-odbc-driver/020-installing-the-driver-on-mac-os-x.md
+++ b/_docs/odbc-jdbc-interfaces/installing-the-odbc-driver/020-installing-the-driver-on-mac-os-x.md
@@ -1,5 +1,6 @@
---
title: "Installing the Driver on Mac OS X"
+date: 2015-12-28 21:37:19 UTC
parent: "Installing the ODBC Driver"
---
Install the MapR Drill ODBC Driver on the machine from which you connect to
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/odbc-jdbc-interfaces/installing-the-odbc-driver/030-installing-the-driver-on-windows.md
----------------------------------------------------------------------
diff --git a/_docs/odbc-jdbc-interfaces/installing-the-odbc-driver/030-installing-the-driver-on-windows.md b/_docs/odbc-jdbc-interfaces/installing-the-odbc-driver/030-installing-the-driver-on-windows.md
index 668e03b..8ca0095 100644
--- a/_docs/odbc-jdbc-interfaces/installing-the-odbc-driver/030-installing-the-driver-on-windows.md
+++ b/_docs/odbc-jdbc-interfaces/installing-the-odbc-driver/030-installing-the-driver-on-windows.md
@@ -1,5 +1,6 @@
---
title: "Installing the Driver on Windows"
+date: 2015-12-28 21:37:19 UTC
parent: "Installing the ODBC Driver"
---
The MapR Drill ODBC Driver installer is available for 32- and 64-bit
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/odbc-jdbc-interfaces/installing-the-odbc-driver/040-installing-the-tdc-file-on-windows.md
----------------------------------------------------------------------
diff --git a/_docs/odbc-jdbc-interfaces/installing-the-odbc-driver/040-installing-the-tdc-file-on-windows.md b/_docs/odbc-jdbc-interfaces/installing-the-odbc-driver/040-installing-the-tdc-file-on-windows.md
index 1979ea5..71c84f0 100644
--- a/_docs/odbc-jdbc-interfaces/installing-the-odbc-driver/040-installing-the-tdc-file-on-windows.md
+++ b/_docs/odbc-jdbc-interfaces/installing-the-odbc-driver/040-installing-the-tdc-file-on-windows.md
@@ -1,5 +1,6 @@
---
title: "Installing the TDC File on Windows"
+date: 2015-12-28 21:37:19 UTC
parent: "Installing the ODBC Driver"
---
The MapR Drill ODBC driver installer automatically installs the TDC file if the installer can find the Tableau installation. If you installed the MapR Drill ODBC driver first and then installed Tableau, the TDC file is not installed automatically, and you need to install the TDC file manually.
@@ -14,4 +15,4 @@ The MapR Drill ODBC driver installer automatically installs the TDC file if the
3. When the installation completes, press any key to continue.
For example, you can press the SPACEBAR key.
-If the installation of the TDC file fails, this is likely due to your Tableau repository being in location other than the default one. In this case, manually copy the My Tableau Repository to C:\Users\<user>\Documents\My Tableau Repository. Repeat the procedure to install the MapRDrillODBC.TDC file manually.
\ No newline at end of file
+If the installation of the TDC file fails, this is likely due to your Tableau repository being in location other than the default one. In this case, manually copy the My Tableau Repository to C:\Users\<user>\Documents\My Tableau Repository. Repeat the procedure to install the MapRDrillODBC.TDC file manually.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/odbc-jdbc-interfaces/using-drill-explorer/010-drill-explorer-introduction.md
----------------------------------------------------------------------
diff --git a/_docs/odbc-jdbc-interfaces/using-drill-explorer/010-drill-explorer-introduction.md b/_docs/odbc-jdbc-interfaces/using-drill-explorer/010-drill-explorer-introduction.md
index fe0b93d..3f79a7b 100644
--- a/_docs/odbc-jdbc-interfaces/using-drill-explorer/010-drill-explorer-introduction.md
+++ b/_docs/odbc-jdbc-interfaces/using-drill-explorer/010-drill-explorer-introduction.md
@@ -1,5 +1,6 @@
---
title: "Drill Explorer Introduction"
+date: 2015-12-28 21:37:19 UTC
parent: "Using Drill Explorer"
---
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/odbc-jdbc-interfaces/using-drill-explorer/020-connecting-drill-explorer-to-data.md
----------------------------------------------------------------------
diff --git a/_docs/odbc-jdbc-interfaces/using-drill-explorer/020-connecting-drill-explorer-to-data.md b/_docs/odbc-jdbc-interfaces/using-drill-explorer/020-connecting-drill-explorer-to-data.md
index 6316d69..b7ee121 100644
--- a/_docs/odbc-jdbc-interfaces/using-drill-explorer/020-connecting-drill-explorer-to-data.md
+++ b/_docs/odbc-jdbc-interfaces/using-drill-explorer/020-connecting-drill-explorer-to-data.md
@@ -1,5 +1,6 @@
---
title: "Connecting Drill Explorer to Data"
+date: 2015-12-28 21:37:19 UTC
parent: "Using Drill Explorer"
---
The way you start Drill Explorer differs depending on your platform, but regardless of the platform, Drill must be running.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/odbc-jdbc-interfaces/using-drill-explorer/030-browsing-data-and-creating-views.md
----------------------------------------------------------------------
diff --git a/_docs/odbc-jdbc-interfaces/using-drill-explorer/030-browsing-data-and-creating-views.md b/_docs/odbc-jdbc-interfaces/using-drill-explorer/030-browsing-data-and-creating-views.md
index bd01f76..90e19c0 100644
--- a/_docs/odbc-jdbc-interfaces/using-drill-explorer/030-browsing-data-and-creating-views.md
+++ b/_docs/odbc-jdbc-interfaces/using-drill-explorer/030-browsing-data-and-creating-views.md
@@ -1,5 +1,6 @@
---
title: "Browsing Data and Defining Views"
+date: 2015-12-28 21:37:19 UTC
parent: "Using Drill Explorer"
---
After connecting Drill Explorer to data, the Browse and SQL tabs appear on the right side of the console. On the Browse tab, you view any metadata that might exist for a schema that you access with Drill. On the SQL tab, you preview the results
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/010-using-odbc-with-bi-tools-introduction.md
----------------------------------------------------------------------
diff --git a/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/010-using-odbc-with-bi-tools-introduction.md b/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/010-using-odbc-with-bi-tools-introduction.md
index 41498ad..115619a 100644
--- a/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/010-using-odbc-with-bi-tools-introduction.md
+++ b/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/010-using-odbc-with-bi-tools-introduction.md
@@ -1,5 +1,6 @@
---
title: "Using Drill with BI Tools Introduction"
+date: 2015-12-28 21:37:19 UTC
parent: "Using Drill with BI Tools"
---
The MapR Drill ODBC driver provides BI tools access to Drill’s flexible query
@@ -26,4 +27,4 @@ The following components provide applications access to Drill data sources:
| Drillbit | Accepts queries from clients, executes queries against Drill data sources, and returns the query results. |
| ODBC Data Source Administrator | The ODBC Data Source Administrator enables the creation of DSNs to Apache Drill data sources. In the figure above, the ODBC Data Source Administrator was used to create Hive-DrillDataSources. |
| ODBC DSN | Provides applications information about how to connect to the Drill Source.In the figure above, the Hive-DrillDataSources is a DSN that provides connection information to the Hive tables. |
-| BI Tool | Accesses Drill data sources using the connection information from the ODBC DSN. In the figure above, the BI tool uses Hive-DrillDataSources to access the hive_student table. |
\ No newline at end of file
+| BI Tool | Accesses Drill data sources using the connection information from the ODBC DSN. In the figure above, the BI tool uses Hive-DrillDataSources to access the hive_student table. |
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/020-tableau-examples.md
----------------------------------------------------------------------
diff --git a/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/020-tableau-examples.md b/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/020-tableau-examples.md
old mode 100755
new mode 100644
index 0da0a7c..7158639
--- a/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/020-tableau-examples.md
+++ b/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/020-tableau-examples.md
@@ -1,5 +1,6 @@
---
title: "Tableau Examples"
+date: 2015-12-28 21:37:19 UTC
parent: "Using Drill with BI Tools"
---
You can generate reports in Tableau using ODBC connections to Drill data
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/030-using-microstrategy-analytics-with-apache-drill.md
----------------------------------------------------------------------
diff --git a/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/030-using-microstrategy-analytics-with-apache-drill.md b/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/030-using-microstrategy-analytics-with-apache-drill.md
old mode 100755
new mode 100644
index e9d2a60..4971fbf
--- a/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/030-using-microstrategy-analytics-with-apache-drill.md
+++ b/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/030-using-microstrategy-analytics-with-apache-drill.md
@@ -1,5 +1,6 @@
---
title: "Using MicroStrategy Analytics with Apache Drill"
+date: 2015-12-28 21:37:19 UTC
parent: "Using Drill with BI Tools"
---
Apache Drill is certified with the MicroStrategy Analytics Enterprise Platform™. You can connect MicroStrategy Analytics Enterprise to Apache Drill and explore multiple data formats instantly on Hadoop. Use the combined power of these tools to get direct access to semi-structured data without having to rely on IT teams for schema creation.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/040-using-tibco-spotfire-desktop-with-drill.md
----------------------------------------------------------------------
diff --git a/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/040-using-tibco-spotfire-desktop-with-drill.md b/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/040-using-tibco-spotfire-desktop-with-drill.md
old mode 100755
new mode 100644
index 62bed9f..30c59ff
--- a/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/040-using-tibco-spotfire-desktop-with-drill.md
+++ b/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/040-using-tibco-spotfire-desktop-with-drill.md
@@ -1,5 +1,6 @@
---
title: "Using Tibco Spotfire Desktop with Drill"
+date: 2015-12-28 21:37:19 UTC
parent: "Using Drill with BI Tools"
---
Tibco Spotfire Desktop is a powerful analytic tool that enables SQL statements when connecting to data sources. Spotfire Desktop can utilize the powerful query capabilities of Apache Drill to query complex data structures. Use the MapR Drill ODBC Driver to configure Tibco Spotfire Desktop with Apache Drill.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/050-configuring-spotfire-server.md
----------------------------------------------------------------------
diff --git a/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/050-configuring-spotfire-server.md b/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/050-configuring-spotfire-server.md
index c68b07d..6cc8aba 100644
--- a/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/050-configuring-spotfire-server.md
+++ b/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/050-configuring-spotfire-server.md
@@ -1,5 +1,6 @@
---
title: "Configuring Tibco Spotfire Server with Drill"
+date: 2015-12-28 21:37:19 UTC
parent: "Using Drill with BI Tools"
---
@@ -119,4 +120,4 @@ After the Drill data source has been configured in the Information Designer, the
1. In this example all the columns of a Hive table have been defined, using the Drill data source, and added to an information link. 
2. The SQL syntax to retrieve the data can be validated by clicking the **SQL** button. Many other operations can be performed in Information Link, including joins, filters, and so on. See the Tibco Spotfire documentation for details.
3. You can now import the data of this table into TSS by clicking the **Open Data** button. 
-The data is now available in Tibco Spotfire Desktop to create various reports and tables as needed, and to be shared. For more information about creating charts, tables and reports, see the Tibco Spotfire documentation.
\ No newline at end of file
+The data is now available in Tibco Spotfire Desktop to create various reports and tables as needed, and to be shared. For more information about creating charts, tables and reports, see the Tibco Spotfire documentation.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/055-using-qliksense-with-drill.md
----------------------------------------------------------------------
diff --git a/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/055-using-qliksense-with-drill.md b/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/055-using-qliksense-with-drill.md
index ad27cd9..5b5a290 100644
--- a/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/055-using-qliksense-with-drill.md
+++ b/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/055-using-qliksense-with-drill.md
@@ -1,5 +1,6 @@
---
title: "Using Qlik Sense with Drill"
+date: 2015-12-28 21:37:19 UTC
parent: "Using Drill with BI Tools"
---
You can use the Qlik Sense BI tool with Apache Drill, the SQL query engine for Big Data exploration, to access and analyze structured and semi-structured data in multiple data stores.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/060-using-apache-drill-with-tableau-9-desktop.md
----------------------------------------------------------------------
diff --git a/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/060-using-apache-drill-with-tableau-9-desktop.md b/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/060-using-apache-drill-with-tableau-9-desktop.md
index df8ca1f..29b3237 100644
--- a/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/060-using-apache-drill-with-tableau-9-desktop.md
+++ b/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/060-using-apache-drill-with-tableau-9-desktop.md
@@ -1,5 +1,6 @@
---
title: "Using Apache Drill with Tableau 9 Desktop"
+date: 2015-12-28 21:37:19 UTC
parent: "Using Drill with BI Tools"
---
This document describes how to connect Tableau 9 Desktop to Apache Drill and explore multiple data formats instantly on Hadoop. Use the combined power of these tools to get direct access to semi-structured data, without having to rely on IT teams for schema creation.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/070-using-apache-drill-with-tableau-9-server.md
----------------------------------------------------------------------
diff --git a/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/070-using-apache-drill-with-tableau-9-server.md b/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/070-using-apache-drill-with-tableau-9-server.md
index a2ffea5..48715c8 100644
--- a/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/070-using-apache-drill-with-tableau-9-server.md
+++ b/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/070-using-apache-drill-with-tableau-9-server.md
@@ -1,5 +1,6 @@
---
title: "Using Apache Drill with Tableau 9 Server"
+date: 2015-12-28 21:37:19 UTC
parent: "Using Drill with BI Tools"
---
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/090-configuring-jreport-with-drill.md
----------------------------------------------------------------------
diff --git a/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/090-configuring-jreport-with-drill.md b/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/090-configuring-jreport-with-drill.md
index 8895e1c..e273be0 100644
--- a/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/090-configuring-jreport-with-drill.md
+++ b/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/090-configuring-jreport-with-drill.md
@@ -1,5 +1,6 @@
---
title: "Configuring JReport with Drill"
+date: 2015-12-28 21:37:19 UTC
parent: "Using Drill with BI Tools"
---
@@ -57,4 +58,4 @@ For general instructions on installing the Drill JDBC driver, see [Using JDBC]({
4. Use JReport Designer to query the data and create a report. 
- 
\ No newline at end of file
+ 
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/performance-tuning/010-performance-tuning-introduction.md
----------------------------------------------------------------------
diff --git a/_docs/performance-tuning/010-performance-tuning-introduction.md b/_docs/performance-tuning/010-performance-tuning-introduction.md
index 1dffb56..278691d 100644
--- a/_docs/performance-tuning/010-performance-tuning-introduction.md
+++ b/_docs/performance-tuning/010-performance-tuning-introduction.md
@@ -1,5 +1,6 @@
---
title: "Performance Tuning Introduction"
+date: 2015-12-28 21:37:19 UTC
parent: "Performance Tuning"
---
You can apply performance tuning measures to improve how efficiently Drill queries data. To significantly improve performance in Drill, you must have knowledge about the underlying data and data sources, as well as familiarity with how Drill executes queries.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/performance-tuning/025-optimizing-parquet-reading.md
----------------------------------------------------------------------
diff --git a/_docs/performance-tuning/025-optimizing-parquet-reading.md b/_docs/performance-tuning/025-optimizing-parquet-reading.md
index b840ef7..f5b6372 100644
--- a/_docs/performance-tuning/025-optimizing-parquet-reading.md
+++ b/_docs/performance-tuning/025-optimizing-parquet-reading.md
@@ -1,5 +1,6 @@
---
title: "Optimizing Parquet Metadata Reading"
+date: 2015-12-28 21:37:19 UTC
parent: "Performance Tuning"
---
@@ -43,4 +44,4 @@ After running the REFRESH TABLE METADATA command, Drill traverses directories in
At planning time, Drill reads only the metadata file. Parquet metadata caching has no effect on execution time. At execution time, Drill reads the actual files.
## Security Limitations
-TBD
\ No newline at end of file
+TBD
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/performance-tuning/030-choosing-a-storage-format.md
----------------------------------------------------------------------
diff --git a/_docs/performance-tuning/030-choosing-a-storage-format.md b/_docs/performance-tuning/030-choosing-a-storage-format.md
old mode 100755
new mode 100644
index d339bc3..94ade4d
--- a/_docs/performance-tuning/030-choosing-a-storage-format.md
+++ b/_docs/performance-tuning/030-choosing-a-storage-format.md
@@ -1,5 +1,6 @@
---
title: "Choosing a Storage Format"
+date: 2015-12-28 21:37:19 UTC
parent: "Performance Tuning"
---
Drill supports several file formats for data including CSV, TSV, PSV, JSON, and Parquet. Changing the default format is a typical functional change that can optimize performance. Drill runs fastest against Parquet files because Parquet data representation is almost identical to how Drill represents data.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/performance-tuning/identifying-performance-issues/010-query-plans.md
----------------------------------------------------------------------
diff --git a/_docs/performance-tuning/identifying-performance-issues/010-query-plans.md b/_docs/performance-tuning/identifying-performance-issues/010-query-plans.md
old mode 100755
new mode 100644
index c433d37..255bab6
--- a/_docs/performance-tuning/identifying-performance-issues/010-query-plans.md
+++ b/_docs/performance-tuning/identifying-performance-issues/010-query-plans.md
@@ -1,5 +1,6 @@
---
title: "Query Plans"
+date: 2015-12-28 21:37:19 UTC
parent: "Identifying Performance Issues"
---
If you experience performance issues in Drill, you can typically identify the source of the issues in the query plans or profiles. This section describes the logical plan and physical plans.
@@ -71,4 +72,4 @@ To modify and re-submit a physical plan to Drill, complete the following steps:
5. Select the **Physical Plan** radio button under Query Type.
-6. Paste the physical plan into the Query field, and click **Submit**. Drill runs the plan and executes the query.
\ No newline at end of file
+6. Paste the physical plan into the Query field, and click **Submit**. Drill runs the plan and executes the query.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/performance-tuning/identifying-performance-issues/020-query-profiles.md
----------------------------------------------------------------------
diff --git a/_docs/performance-tuning/identifying-performance-issues/020-query-profiles.md b/_docs/performance-tuning/identifying-performance-issues/020-query-profiles.md
old mode 100755
new mode 100644
index 24ee122..9edf138
--- a/_docs/performance-tuning/identifying-performance-issues/020-query-profiles.md
+++ b/_docs/performance-tuning/identifying-performance-issues/020-query-profiles.md
@@ -1,5 +1,6 @@
---
title: "Query Profiles"
+date: 2015-12-28 21:37:19 UTC
parent: "Identifying Performance Issues"
---
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/performance-tuning/partition-pruning/010-partition-pruning-introduction.md
----------------------------------------------------------------------
diff --git a/_docs/performance-tuning/partition-pruning/010-partition-pruning-introduction.md b/_docs/performance-tuning/partition-pruning/010-partition-pruning-introduction.md
old mode 100755
new mode 100644
index dd1205e..2b2cbf2
--- a/_docs/performance-tuning/partition-pruning/010-partition-pruning-introduction.md
+++ b/_docs/performance-tuning/partition-pruning/010-partition-pruning-introduction.md
@@ -1,5 +1,6 @@
---
title: "Partition Pruning Introduction"
+date: 2015-12-28 21:37:19 UTC
parent: "Partition Pruning"
---
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/performance-tuning/partition-pruning/030-using-partition-pruning.md
----------------------------------------------------------------------
diff --git a/_docs/performance-tuning/partition-pruning/030-using-partition-pruning.md b/_docs/performance-tuning/partition-pruning/030-using-partition-pruning.md
old mode 100755
new mode 100644
index ed20bcf..c12831a
--- a/_docs/performance-tuning/partition-pruning/030-using-partition-pruning.md
+++ b/_docs/performance-tuning/partition-pruning/030-using-partition-pruning.md
@@ -1,5 +1,6 @@
---
title: "How to Partition Data"
+date: 2015-12-28 21:37:19 UTC
parent: "Partition Pruning"
---
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/performance-tuning/performance-tuning-reference/010-query-profile-tables.md
----------------------------------------------------------------------
diff --git a/_docs/performance-tuning/performance-tuning-reference/010-query-profile-tables.md b/_docs/performance-tuning/performance-tuning-reference/010-query-profile-tables.md
index 7a3db58..d92bce5 100644
--- a/_docs/performance-tuning/performance-tuning-reference/010-query-profile-tables.md
+++ b/_docs/performance-tuning/performance-tuning-reference/010-query-profile-tables.md
@@ -1,5 +1,6 @@
---
title: "Query Profile Column Descriptions"
+date: 2015-12-28 21:37:19 UTC
parent: "Performance Tuning Reference"
---
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/performance-tuning/performance-tuning-reference/020-physical-operators.md
----------------------------------------------------------------------
diff --git a/_docs/performance-tuning/performance-tuning-reference/020-physical-operators.md b/_docs/performance-tuning/performance-tuning-reference/020-physical-operators.md
index 6680509..4d41007 100644
--- a/_docs/performance-tuning/performance-tuning-reference/020-physical-operators.md
+++ b/_docs/performance-tuning/performance-tuning-reference/020-physical-operators.md
@@ -1,5 +1,6 @@
---
title: "Physical Operators"
+date: 2015-12-28 21:37:19 UTC
parent: "Performance Tuning Reference"
---
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/performance-tuning/query-plans-and-tuning/010-query-plans-and-tuning-introduction.md
----------------------------------------------------------------------
diff --git a/_docs/performance-tuning/query-plans-and-tuning/010-query-plans-and-tuning-introduction.md b/_docs/performance-tuning/query-plans-and-tuning/010-query-plans-and-tuning-introduction.md
old mode 100755
new mode 100644
index 1f42966..d0ce2d6
--- a/_docs/performance-tuning/query-plans-and-tuning/010-query-plans-and-tuning-introduction.md
+++ b/_docs/performance-tuning/query-plans-and-tuning/010-query-plans-and-tuning-introduction.md
@@ -1,5 +1,6 @@
---
title: "Query Plans and Tuning Introduction"
+date: 2015-12-28 21:37:19 UTC
parent: "Query Plans and Tuning"
---
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/performance-tuning/query-plans-and-tuning/020-join-planning-guidelines.md
----------------------------------------------------------------------
diff --git a/_docs/performance-tuning/query-plans-and-tuning/020-join-planning-guidelines.md b/_docs/performance-tuning/query-plans-and-tuning/020-join-planning-guidelines.md
old mode 100755
new mode 100644
index 4c2b7ef..d57c6c0
--- a/_docs/performance-tuning/query-plans-and-tuning/020-join-planning-guidelines.md
+++ b/_docs/performance-tuning/query-plans-and-tuning/020-join-planning-guidelines.md
@@ -1,5 +1,6 @@
---
title: "Join Planning Guidelines"
+date: 2015-12-28 21:37:19 UTC
parent: "Query Plans and Tuning"
---
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/performance-tuning/query-plans-and-tuning/030-guidelines-for-optimizing-aggregation.md
----------------------------------------------------------------------
diff --git a/_docs/performance-tuning/query-plans-and-tuning/030-guidelines-for-optimizing-aggregation.md b/_docs/performance-tuning/query-plans-and-tuning/030-guidelines-for-optimizing-aggregation.md
old mode 100755
new mode 100644
index 5f79017..53be28a
--- a/_docs/performance-tuning/query-plans-and-tuning/030-guidelines-for-optimizing-aggregation.md
+++ b/_docs/performance-tuning/query-plans-and-tuning/030-guidelines-for-optimizing-aggregation.md
@@ -1,5 +1,6 @@
---
title: "Guidelines for Optimizing Aggregation"
+date: 2015-12-28 21:37:19 UTC
parent: "Query Plans and Tuning"
---
@@ -18,4 +19,4 @@ You can use the ALTER SYSTEM or ALTER SESSION commands with the following option
The default for this option is `true`.Typically, you set the options at the session level unless you want the setting to persist across all sessions.
-
\ No newline at end of file
+
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/performance-tuning/query-plans-and-tuning/040-modifying-query-planning-options.md
----------------------------------------------------------------------
diff --git a/_docs/performance-tuning/query-plans-and-tuning/040-modifying-query-planning-options.md b/_docs/performance-tuning/query-plans-and-tuning/040-modifying-query-planning-options.md
index f6fdb5d..bd1726d 100644
--- a/_docs/performance-tuning/query-plans-and-tuning/040-modifying-query-planning-options.md
+++ b/_docs/performance-tuning/query-plans-and-tuning/040-modifying-query-planning-options.md
@@ -1,5 +1,6 @@
---
title: "Modifying Query Planning Options"
+date: 2015-12-28 21:37:19 UTC
parent: "Query Plans and Tuning"
---
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/performance-tuning/query-plans-and-tuning/050-sort-based-and-hash-based-memory-constrained-operators.md
----------------------------------------------------------------------
diff --git a/_docs/performance-tuning/query-plans-and-tuning/050-sort-based-and-hash-based-memory-constrained-operators.md b/_docs/performance-tuning/query-plans-and-tuning/050-sort-based-and-hash-based-memory-constrained-operators.md
old mode 100755
new mode 100644
index 3325a2c..d8d79d7
--- a/_docs/performance-tuning/query-plans-and-tuning/050-sort-based-and-hash-based-memory-constrained-operators.md
+++ b/_docs/performance-tuning/query-plans-and-tuning/050-sort-based-and-hash-based-memory-constrained-operators.md
@@ -1,5 +1,6 @@
---
title: "Sort-Based and Hash-Based Memory-Constrained Operators"
+date: 2015-12-28 21:37:19 UTC
parent: "Query Plans and Tuning"
---
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/performance-tuning/query-plans-and-tuning/060-enabling-query-queuing.md
----------------------------------------------------------------------
diff --git a/_docs/performance-tuning/query-plans-and-tuning/060-enabling-query-queuing.md b/_docs/performance-tuning/query-plans-and-tuning/060-enabling-query-queuing.md
old mode 100755
new mode 100644
index ad06070..7440835
--- a/_docs/performance-tuning/query-plans-and-tuning/060-enabling-query-queuing.md
+++ b/_docs/performance-tuning/query-plans-and-tuning/060-enabling-query-queuing.md
@@ -1,5 +1,6 @@
---
title: "Enabling Query Queuing"
+date: 2015-12-28 21:37:19 UTC
parent: "Query Plans and Tuning"
---
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/performance-tuning/query-plans-and-tuning/070-controlling-parallelization-to-balance-performance-with-multi-tenancy.md
----------------------------------------------------------------------
diff --git a/_docs/performance-tuning/query-plans-and-tuning/070-controlling-parallelization-to-balance-performance-with-multi-tenancy.md b/_docs/performance-tuning/query-plans-and-tuning/070-controlling-parallelization-to-balance-performance-with-multi-tenancy.md
old mode 100755
new mode 100644
index 2178d14..61fa326
--- a/_docs/performance-tuning/query-plans-and-tuning/070-controlling-parallelization-to-balance-performance-with-multi-tenancy.md
+++ b/_docs/performance-tuning/query-plans-and-tuning/070-controlling-parallelization-to-balance-performance-with-multi-tenancy.md
@@ -1,5 +1,6 @@
---
title: "Controlling Parallelization to Balance Performance with Multi-Tenancy"
+date: 2015-12-28 21:37:19 UTC
parent: "Query Plans and Tuning"
---
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/query-data/010-query-data-introduction.md
----------------------------------------------------------------------
diff --git a/_docs/query-data/010-query-data-introduction.md b/_docs/query-data/010-query-data-introduction.md
index 536dcc3..16f3bd5 100644
--- a/_docs/query-data/010-query-data-introduction.md
+++ b/_docs/query-data/010-query-data-introduction.md
@@ -1,5 +1,6 @@
---
title: "Query Data Introduction"
+date: 2015-12-28 21:37:19 UTC
parent: "Query Data"
---
You can query local and distributed file systems, Hive, HBase data, complex data, INFORMATION SCHEMA, and system tables as described in the subtopics of this section.
@@ -39,4 +40,4 @@ Remember the following tips when querying data with Drill:
`Example: `!set maxwidth 10000`
* Use backticks around [keywords]({{site.baseurl}}/docs/reserved-keywords), special characters, and [identifiers]({{site.baseurl}}/docs/lexical-structure/#identifier) that SQL cannot parse, such as the keyword default and a path that contains a forward slash character:
Example: ``SELECT * FROM dfs.`default`.`/Users/drilluser/apache-drill-1.1.0/sample-data/nation.parquet`;``
- * When selecting all (SELECT *) schema-less data, the order of returned columns might differ from the stored order and might vary from query to query.
\ No newline at end of file
+ * When selecting all (SELECT *) schema-less data, the order of returned columns might differ from the stored order and might vary from query to query.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/query-data/030-querying-hbase.md
----------------------------------------------------------------------
diff --git a/_docs/query-data/030-querying-hbase.md b/_docs/query-data/030-querying-hbase.md
index d79f814..a51f007 100644
--- a/_docs/query-data/030-querying-hbase.md
+++ b/_docs/query-data/030-querying-hbase.md
@@ -1,5 +1,6 @@
---
title: "Querying HBase"
+date: 2015-12-28 21:37:19 UTC
parent: "Query Data"
---
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/query-data/050-querying-hive.md
----------------------------------------------------------------------
diff --git a/_docs/query-data/050-querying-hive.md b/_docs/query-data/050-querying-hive.md
index 64e9a23..e82bf77 100644
--- a/_docs/query-data/050-querying-hive.md
+++ b/_docs/query-data/050-querying-hive.md
@@ -1,5 +1,6 @@
---
title: "Querying Hive"
+date: 2015-12-28 21:37:19 UTC
parent: "Query Data"
---
This is a simple exercise that provides steps for creating a Hive table and
@@ -46,4 +47,4 @@ To create a Hive table and query it with Drill, complete the following steps:
Use the `store.hive.optimize_scan_with_native_readers` option to optimize reads of Parquet-backed external tables from Hive. When set to TRUE, this option uses Drill native readers instead of the Hive Serde interface, resulting in more performant queries of Parquet-backed external tables. (Drill 1.2 and later)
-Set the `store.hive.optimize_scan_with_native_readers` option as described in the section, ["Planning and Execution Options"]({{site.baseurl}}/docs/planning-and-execution-options/).
\ No newline at end of file
+Set the `store.hive.optimize_scan_with_native_readers` option as described in the section, ["Planning and Execution Options"]({{site.baseurl}}/docs/planning-and-execution-options/).
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/query-data/060-querying-the-information-schema.md
----------------------------------------------------------------------
diff --git a/_docs/query-data/060-querying-the-information-schema.md b/_docs/query-data/060-querying-the-information-schema.md
index c4c1008..d86ceb8 100644
--- a/_docs/query-data/060-querying-the-information-schema.md
+++ b/_docs/query-data/060-querying-the-information-schema.md
@@ -1,5 +1,6 @@
---
title: "Querying the INFORMATION SCHEMA"
+date: 2015-12-28 21:37:19 UTC
parent: "Query Data"
---
When you are using Drill to connect to multiple data sources, you need a
@@ -107,4 +108,4 @@ of those columns:
| OrderTotal | Decimal |
+-------------+------------+
-In this release, Drill disables the DECIMAL data type, including casting to DECIMAL and reading DECIMAL types from Parquet and Hive. You can [enable the DECIMAL type](docs/supported-data-types/#enabling-the-decimal-type), but this is not recommended.
\ No newline at end of file
+In this release, Drill disables the DECIMAL data type, including casting to DECIMAL and reading DECIMAL types from Parquet and Hive. You can [enable the DECIMAL type](docs/supported-data-types/#enabling-the-decimal-type), but this is not recommended.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/query-data/070-query-sys-tbl.md
----------------------------------------------------------------------
diff --git a/_docs/query-data/070-query-sys-tbl.md b/_docs/query-data/070-query-sys-tbl.md
index 9a4bd19..6c7b34f 100644
--- a/_docs/query-data/070-query-sys-tbl.md
+++ b/_docs/query-data/070-query-sys-tbl.md
@@ -1,5 +1,6 @@
---
title: "Querying System Tables"
+date: 2015-12-28 21:37:19 UTC
parent: "Query Data"
---
Drill has a sys database that contains system tables. You can query the system
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/query-data/080-monitoring-and-canceling-queries-in-the-Drill-Web-UI.md
----------------------------------------------------------------------
diff --git a/_docs/query-data/080-monitoring-and-canceling-queries-in-the-Drill-Web-UI.md b/_docs/query-data/080-monitoring-and-canceling-queries-in-the-Drill-Web-UI.md
index a277177..489ce05 100644
--- a/_docs/query-data/080-monitoring-and-canceling-queries-in-the-Drill-Web-UI.md
+++ b/_docs/query-data/080-monitoring-and-canceling-queries-in-the-Drill-Web-UI.md
@@ -1,5 +1,6 @@
---
title: "Monitoring and Canceling Queries in the Drill Web Console"
+date: 2015-12-28 21:37:19 UTC
parent: "Query Data"
---
You can monitor and cancel queries from the Drill Web Console if you are [authorized]({{site.baseurl}}/docs/configuring-web-console-and-rest-api-security/) to do so. To access the Drill
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/query-data/query-a-file-system/005-querying-a-file-system-introduction.md
----------------------------------------------------------------------
diff --git a/_docs/query-data/query-a-file-system/005-querying-a-file-system-introduction.md b/_docs/query-data/query-a-file-system/005-querying-a-file-system-introduction.md
index 2e58f54..6a08b23 100644
--- a/_docs/query-data/query-a-file-system/005-querying-a-file-system-introduction.md
+++ b/_docs/query-data/query-a-file-system/005-querying-a-file-system-introduction.md
@@ -1,5 +1,6 @@
---
title: "Querying a File System Introduction"
+date: 2015-12-28 21:37:19 UTC
parent: "Querying a File System"
---
Files and directories are like standard SQL tables to Drill. You can specify a
@@ -32,4 +33,4 @@ Drill supports the following file types:
The extensions for these file types must match the configuration settings for
your registered storage plugins. For example, PSV files may be defined with a
-`.tbl` extension, while CSV files are defined with a `.csv` extension.
\ No newline at end of file
+`.tbl` extension, while CSV files are defined with a `.csv` extension.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/query-data/query-a-file-system/010-querying-json-files.md
----------------------------------------------------------------------
diff --git a/_docs/query-data/query-a-file-system/010-querying-json-files.md b/_docs/query-data/query-a-file-system/010-querying-json-files.md
index 72ed462..89fed17 100644
--- a/_docs/query-data/query-a-file-system/010-querying-json-files.md
+++ b/_docs/query-data/query-a-file-system/010-querying-json-files.md
@@ -1,5 +1,6 @@
---
title: "Querying JSON Files"
+date: 2015-12-28 21:37:19 UTC
parent: "Querying a File System"
---
To query complex JSON files, you need to understand the ["JSON Data Model"]({{site.baseurl}}/docs/json-data-model/). This section provides a trivial example of querying a sample file that Drill installs.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/query-data/query-a-file-system/020-querying-parquet-files.md
----------------------------------------------------------------------
diff --git a/_docs/query-data/query-a-file-system/020-querying-parquet-files.md b/_docs/query-data/query-a-file-system/020-querying-parquet-files.md
index c86006f..22ad6ba 100644
--- a/_docs/query-data/query-a-file-system/020-querying-parquet-files.md
+++ b/_docs/query-data/query-a-file-system/020-querying-parquet-files.md
@@ -1,5 +1,6 @@
---
title: "Querying Parquet Files"
+date: 2015-12-28 21:37:19 UTC
parent: "Querying a File System"
---
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/query-data/query-a-file-system/030-querying-plain-text-files.md
----------------------------------------------------------------------
diff --git a/_docs/query-data/query-a-file-system/030-querying-plain-text-files.md b/_docs/query-data/query-a-file-system/030-querying-plain-text-files.md
index f772e3a..4d83420 100644
--- a/_docs/query-data/query-a-file-system/030-querying-plain-text-files.md
+++ b/_docs/query-data/query-a-file-system/030-querying-plain-text-files.md
@@ -1,5 +1,6 @@
---
title: "Querying Plain Text Files"
+date: 2015-12-28 21:37:19 UTC
parent: "Querying a File System"
---
You can use Drill to access structured file types and plain text files
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/query-data/query-a-file-system/040-querying-directories.md
----------------------------------------------------------------------
diff --git a/_docs/query-data/query-a-file-system/040-querying-directories.md b/_docs/query-data/query-a-file-system/040-querying-directories.md
index 51c1e87..f064466 100644
--- a/_docs/query-data/query-a-file-system/040-querying-directories.md
+++ b/_docs/query-data/query-a-file-system/040-querying-directories.md
@@ -1,5 +1,6 @@
---
title: "Querying Directories"
+date: 2015-12-28 21:37:19 UTC
parent: "Querying a File System"
---
You can store multiple files in a directory and query them as if they were a
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/query-data/query-a-file-system/050-querying-sequence-files.md
----------------------------------------------------------------------
diff --git a/_docs/query-data/query-a-file-system/050-querying-sequence-files.md b/_docs/query-data/query-a-file-system/050-querying-sequence-files.md
index ceb77e2..c82c45b 100644
--- a/_docs/query-data/query-a-file-system/050-querying-sequence-files.md
+++ b/_docs/query-data/query-a-file-system/050-querying-sequence-files.md
@@ -1,5 +1,6 @@
---
title: "Querying Sequence Files"
+date: 2015-12-28 21:37:19 UTC
parent: "Querying a File System"
---
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/query-data/querying-complex-data/005-querying-complex-data-introduction.md
----------------------------------------------------------------------
diff --git a/_docs/query-data/querying-complex-data/005-querying-complex-data-introduction.md b/_docs/query-data/querying-complex-data/005-querying-complex-data-introduction.md
index 16aebe4..fe8a701 100644
--- a/_docs/query-data/querying-complex-data/005-querying-complex-data-introduction.md
+++ b/_docs/query-data/querying-complex-data/005-querying-complex-data-introduction.md
@@ -1,5 +1,6 @@
---
title: "Querying Complex Data Introduction"
+date: 2015-12-28 21:37:19 UTC
parent: "Querying Complex Data"
---
Apache Drill queries do not require prior knowledge of the actual data you are
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/query-data/querying-complex-data/010-sample--data-donuts.md
----------------------------------------------------------------------
diff --git a/_docs/query-data/querying-complex-data/010-sample--data-donuts.md b/_docs/query-data/querying-complex-data/010-sample--data-donuts.md
index c899b00..4b5dc3c 100644
--- a/_docs/query-data/querying-complex-data/010-sample--data-donuts.md
+++ b/_docs/query-data/querying-complex-data/010-sample--data-donuts.md
@@ -1,5 +1,6 @@
---
title: "Sample Data: Donuts"
+date: 2015-12-28 21:37:19 UTC
parent: "Querying Complex Data"
---
The complex data queries use the sample `donuts.json` file. To download this file, go to [Drill test resources](https://github.com/apache/drill/blob/master/exec/java-exec/src/test/resources) page, locate donuts.json in the list of files, and download it.
@@ -40,4 +41,4 @@ in a table.
The data is made up of maps, arrays, and nested arrays. Name-value pairs and
embedded name-value pairs define the contents of each record. For example,
`type: donut` is a map. Under `topping`, the pairs of `id` and `type` values
-belong to an array (inside the square brackets).
\ No newline at end of file
+belong to an array (inside the square brackets).
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/query-data/querying-complex-data/020-selecting-flat-data.md
----------------------------------------------------------------------
diff --git a/_docs/query-data/querying-complex-data/020-selecting-flat-data.md b/_docs/query-data/querying-complex-data/020-selecting-flat-data.md
index 2910feb..b8df840 100644
--- a/_docs/query-data/querying-complex-data/020-selecting-flat-data.md
+++ b/_docs/query-data/querying-complex-data/020-selecting-flat-data.md
@@ -1,5 +1,6 @@
---
title: "Selecting Flat Data"
+date: 2015-12-28 21:37:19 UTC
parent: "Querying Complex Data"
---
A very simple query against the `donuts.json` file returns the values for the
@@ -20,4 +21,4 @@ nested data):
5 rows selected (0.18 seconds)
Note that `dfs` is the schema name, the path to the file is enclosed by
-backticks, and the query must end with a semicolon.
\ No newline at end of file
+backticks, and the query must end with a semicolon.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/query-data/querying-complex-data/030-using-sql-functions-clauses-and-joins.md
----------------------------------------------------------------------
diff --git a/_docs/query-data/querying-complex-data/030-using-sql-functions-clauses-and-joins.md b/_docs/query-data/querying-complex-data/030-using-sql-functions-clauses-and-joins.md
index 45c1001..32be91b 100644
--- a/_docs/query-data/querying-complex-data/030-using-sql-functions-clauses-and-joins.md
+++ b/_docs/query-data/querying-complex-data/030-using-sql-functions-clauses-and-joins.md
@@ -1,5 +1,6 @@
---
title: "Using SQL Functions, Clauses, and Joins"
+date: 2015-12-28 21:37:19 UTC
parent: "Querying Complex Data"
---
You can use standard SQL clauses, such as WHERE and ORDER BY, to elaborate on
@@ -55,4 +56,4 @@ Standard aggregate functions work against JSON data. For example:
| donut | 1194 |
+------------+-------------+
- 1 row selected (0.389 seconds)
\ No newline at end of file
+ 1 row selected (0.389 seconds)
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/query-data/querying-complex-data/040-selecting-nested-data.md
----------------------------------------------------------------------
diff --git a/_docs/query-data/querying-complex-data/040-selecting-nested-data.md b/_docs/query-data/querying-complex-data/040-selecting-nested-data.md
index 318fb2b..f209a68 100644
--- a/_docs/query-data/querying-complex-data/040-selecting-nested-data.md
+++ b/_docs/query-data/querying-complex-data/040-selecting-nested-data.md
@@ -1,5 +1,6 @@
---
title: "Selecting Nested Data for a Column"
+date: 2015-12-28 21:37:19 UTC
parent: "Querying Complex Data"
---
The following queries show how to access the nested data inside the parts of
@@ -42,4 +43,4 @@ For example, assume that a segment of the JSON file looks like this:
The following query would return `6` (the _third_ value of the _second_ inner
array).
-`select group[1][2]`
\ No newline at end of file
+`select group[1][2]`
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/query-data/querying-complex-data/050-selecting-multiple-columns-within-nested-data.md
----------------------------------------------------------------------
diff --git a/_docs/query-data/querying-complex-data/050-selecting-multiple-columns-within-nested-data.md b/_docs/query-data/querying-complex-data/050-selecting-multiple-columns-within-nested-data.md
index e84600d..5c24cc9 100644
--- a/_docs/query-data/querying-complex-data/050-selecting-multiple-columns-within-nested-data.md
+++ b/_docs/query-data/querying-complex-data/050-selecting-multiple-columns-within-nested-data.md
@@ -1,5 +1,6 @@
---
title: "Selecting Multiple Columns Within Nested Data"
+date: 2015-12-28 21:37:19 UTC
parent: "Querying Complex Data"
---
The following query goes one step further to extract the JSON data, selecting
@@ -21,4 +22,4 @@ data: the use of a table alias (named tbl in this example). Without the table
alias, the query would return an error because the parser would assume that id
is a column inside a table named topping. As in all standard SQL queries,
select tbl.col means that tbl is the name of an existing table (at least for
-the duration of the query) and col is a column that exists in that table.
\ No newline at end of file
+the duration of the query) and col is a column that exists in that table.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sample-datasets/001-aol.md
----------------------------------------------------------------------
diff --git a/_docs/sample-datasets/001-aol.md b/_docs/sample-datasets/001-aol.md
index 472f52f..c3b8bf0 100644
--- a/_docs/sample-datasets/001-aol.md
+++ b/_docs/sample-datasets/001-aol.md
@@ -1,5 +1,6 @@
---
title: "AOL Search"
+date: 2015-12-28 21:37:19 UTC
parent: "Sample Datasets"
---
## Quick Stats
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sample-datasets/002-enron.md
----------------------------------------------------------------------
diff --git a/_docs/sample-datasets/002-enron.md b/_docs/sample-datasets/002-enron.md
index 9883382..74b686c 100644
--- a/_docs/sample-datasets/002-enron.md
+++ b/_docs/sample-datasets/002-enron.md
@@ -1,5 +1,6 @@
---
title: "Enron Emails"
+date: 2015-12-28 21:37:19 UTC
parent: "Sample Datasets"
---
## Quick Stats
@@ -16,4 +17,4 @@ dump](ftp://ftp.isi.edu/sims/philpot/data/enron-mysqldump.sql.gz) (~177MB).
## The Queries
-Interesting queries, for example Via [Query Dataset for Email Search](https://dbappserv.cis.upenn.edu/spell/)
\ No newline at end of file
+Interesting queries, for example Via [Query Dataset for Email Search](https://dbappserv.cis.upenn.edu/spell/)
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sample-datasets/003-wikipedia.md
----------------------------------------------------------------------
diff --git a/_docs/sample-datasets/003-wikipedia.md b/_docs/sample-datasets/003-wikipedia.md
index 0e62dd2..4db889b 100644
--- a/_docs/sample-datasets/003-wikipedia.md
+++ b/_docs/sample-datasets/003-wikipedia.md
@@ -1,5 +1,6 @@
---
title: "Wikipedia Edit History"
+date: 2015-12-28 21:37:19 UTC
parent: "Sample Datasets"
---
## Quick Stats
@@ -102,4 +103,4 @@ _Discussion_:
* I have added the `..` operator in this example. Besides of being syntactic sugar, it also allows us to search for `revision` and `upload` which are both children of `page` and may both have a `contributor`. The more RBMS like alternative would be a `union`, but this was not natural enough.
* I am sure the `ctbr.canonize()` will cause lots of discussions :-). The thing is, that a contributor may repeat itself in many different records, and we dont really have an id. If you look at the wikimedia XSD, all three attributes are optional, and the data says the same, so we cannot just simply say `ctbr.userid`. Hence the canonize function should create a scalar value containing all available information of the node in a canonical form.
- * Last but not least, I always hated, that mySQL would not be able to reuse column definitions from the `select` statement in the `order` statements. So I added on my wishlist, that the `bytesContributed` definition is reusable.
\ No newline at end of file
+ * Last but not least, I always hated, that mySQL would not be able to reuse column definitions from the `select` statement in the `order` statements. So I added on my wishlist, that the `bytesContributed` definition is reusable.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sql-reference/010-sql-reference-introduction.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/010-sql-reference-introduction.md b/_docs/sql-reference/010-sql-reference-introduction.md
index 16b6c31..37f7873 100644
--- a/_docs/sql-reference/010-sql-reference-introduction.md
+++ b/_docs/sql-reference/010-sql-reference-introduction.md
@@ -1,5 +1,6 @@
---
title: "SQL Reference Introduction"
+date: 2015-12-28 21:37:19 UTC
parent: "SQL Reference"
---
Drill supports the ANSI standard for SQL. You can use SQL to query your Hive,
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sql-reference/030-lexical-structure.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/030-lexical-structure.md b/_docs/sql-reference/030-lexical-structure.md
index 36fca8a..ae49c36 100644
--- a/_docs/sql-reference/030-lexical-structure.md
+++ b/_docs/sql-reference/030-lexical-structure.md
@@ -1,5 +1,6 @@
---
title: "Lexical Structure"
+date: 2015-12-28 21:37:19 UTC
parent: "SQL Reference"
---
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sql-reference/040-operators.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/040-operators.md b/_docs/sql-reference/040-operators.md
index 68366ee..10e8781 100644
--- a/_docs/sql-reference/040-operators.md
+++ b/_docs/sql-reference/040-operators.md
@@ -1,5 +1,6 @@
---
title: "Operators"
+date: 2015-12-28 21:37:20 UTC
parent: "SQL Reference"
---
You can use various types of operators in your Drill queries to perform
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sql-reference/065-query-directory-functions.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/065-query-directory-functions.md b/_docs/sql-reference/065-query-directory-functions.md
index feb9a05..ef51f0f 100644
--- a/_docs/sql-reference/065-query-directory-functions.md
+++ b/_docs/sql-reference/065-query-directory-functions.md
@@ -1,5 +1,6 @@
---
title: "Query Directory Functions"
+date: 2015-12-28 21:37:20 UTC
parent: "SQL Reference"
---
You can use the following query directory functions when [querying multiple files or directories]({{site.baseurl}}/docs/querying-directories):
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sql-reference/080-reserved-keywords.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/080-reserved-keywords.md b/_docs/sql-reference/080-reserved-keywords.md
index d3cd280..76d2fa8 100644
--- a/_docs/sql-reference/080-reserved-keywords.md
+++ b/_docs/sql-reference/080-reserved-keywords.md
@@ -1,5 +1,6 @@
---
title: "Reserved Keywords"
+date: 2015-12-28 21:37:20 UTC
parent: "SQL Reference"
---
When you use a reserved keyword in a Drill query, enclose the word in
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sql-reference/090-sql-extensions.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/090-sql-extensions.md b/_docs/sql-reference/090-sql-extensions.md
index 2a4d801..fa4d42d 100644
--- a/_docs/sql-reference/090-sql-extensions.md
+++ b/_docs/sql-reference/090-sql-extensions.md
@@ -1,5 +1,6 @@
---
title: "SQL Extensions"
+date: 2015-12-28 21:37:20 UTC
parent: "SQL Reference"
---
Drill extends SQL to explore smaller-scale data in ways not possible with SQL. Using intuitive SQL extensions you work with self-describing data and complex data types. Extensions to SQL include capabilities for exploring self-describing data, such as files and HBase, directly in the native format.
@@ -49,4 +50,4 @@ The [`sys` tables](/docs/querying-system-tables/) provide port, version, and opt
+-------------------------------------------+
| e3fc7e97bfe712dc09d43a8a055a5135c96b7344 |
+-------------------------------------------+
- 1 row selected (0.105 seconds)
\ No newline at end of file
+ 1 row selected (0.105 seconds)
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sql-reference/data-types/010-supported-data-types.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/data-types/010-supported-data-types.md b/_docs/sql-reference/data-types/010-supported-data-types.md
index 9bc0c23..3a9d630 100644
--- a/_docs/sql-reference/data-types/010-supported-data-types.md
+++ b/_docs/sql-reference/data-types/010-supported-data-types.md
@@ -1,5 +1,6 @@
---
title: "Supported Data Types"
+date: 2015-12-28 21:37:20 UTC
parent: "Data Types"
---
Drill reads from and writes to data sources having a wide variety of types.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sql-reference/data-types/020-date-time-and-timestamp.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/data-types/020-date-time-and-timestamp.md b/_docs/sql-reference/data-types/020-date-time-and-timestamp.md
index 0def79c..ded47d3 100644
--- a/_docs/sql-reference/data-types/020-date-time-and-timestamp.md
+++ b/_docs/sql-reference/data-types/020-date-time-and-timestamp.md
@@ -1,5 +1,6 @@
---
title: "Date, Time, and Timestamp"
+date: 2015-12-28 21:37:20 UTC
parent: "Data Types"
---
Using familiar date and time formats, listed in the [SQL data types table]({{ site.baseurl }}/docs/supported-data-types), you can construct query date and time data. You need to cast textual data to date and time data types. The format of date, time, and timestamp text in a textual data source needs to match the SQL query format for successful casting. Drill supports date, time, timestamp, and interval literals shown in the following example:
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sql-reference/data-types/030-handling-different-data-types.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/data-types/030-handling-different-data-types.md b/_docs/sql-reference/data-types/030-handling-different-data-types.md
index 56e01ef..f47e836 100644
--- a/_docs/sql-reference/data-types/030-handling-different-data-types.md
+++ b/_docs/sql-reference/data-types/030-handling-different-data-types.md
@@ -1,5 +1,6 @@
---
title: "Handling Different Data Types"
+date: 2015-12-28 21:37:20 UTC
parent: "Data Types"
---
## Handling HBase Data
@@ -67,4 +68,4 @@ FLOAT and DOUBLE yield approximate results. These are variable-precision numeric
* For complex calculations or mission-critical applications, especially those involving infinity and underflow situations, carefully consider the limitations of type casting that involves FLOAT or DOUBLE.
* Equality comparisons between floating-point values can produce unexpected results.
-Values of FLOAT and DOUBLE that are less than the lowest value in the range (more negative) cause an error. Rounding can occur if the precision of an input number is too high.
\ No newline at end of file
+Values of FLOAT and DOUBLE that are less than the lowest value in the range (more negative) cause an error. Rounding can occur if the precision of an input number is too high.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sql-reference/nested-data-functions/005-nested-data-limitations.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/nested-data-functions/005-nested-data-limitations.md b/_docs/sql-reference/nested-data-functions/005-nested-data-limitations.md
index ff3aa94..ad1859d 100644
--- a/_docs/sql-reference/nested-data-functions/005-nested-data-limitations.md
+++ b/_docs/sql-reference/nested-data-functions/005-nested-data-limitations.md
@@ -1,5 +1,6 @@
---
title: "Nested Data Limitations"
+date: 2015-12-28 21:37:20 UTC
parent: "Nested Data Functions"
---
-Do not use Map, Array, and repeated scalar types in GROUP BY or ORDER BY clauses or in a comparison operator. Drill does not support comparisons between VARCHAR:REPEATED and VARCHAR:REPEATED.
\ No newline at end of file
+Do not use Map, Array, and repeated scalar types in GROUP BY or ORDER BY clauses or in a comparison operator. Drill does not support comparisons between VARCHAR:REPEATED and VARCHAR:REPEATED.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sql-reference/nested-data-functions/010-flatten.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/nested-data-functions/010-flatten.md b/_docs/sql-reference/nested-data-functions/010-flatten.md
index a0e2573..fa1f33f 100644
--- a/_docs/sql-reference/nested-data-functions/010-flatten.md
+++ b/_docs/sql-reference/nested-data-functions/010-flatten.md
@@ -1,5 +1,6 @@
---
title: "FLATTEN"
+date: 2015-12-28 21:37:20 UTC
parent: "Nested Data Functions"
---
FLATTEN separates the elements in a repeated field into individual records.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sql-reference/nested-data-functions/020-kvgen.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/nested-data-functions/020-kvgen.md b/_docs/sql-reference/nested-data-functions/020-kvgen.md
index 42511e8..a764989 100644
--- a/_docs/sql-reference/nested-data-functions/020-kvgen.md
+++ b/_docs/sql-reference/nested-data-functions/020-kvgen.md
@@ -1,5 +1,6 @@
---
title: "KVGEN"
+date: 2015-12-28 21:37:20 UTC
parent: "Nested Data Functions"
---
Returns a list of the keys that exist in the map.
@@ -214,4 +215,4 @@ distinct rows:
9 rows selected (0.151 seconds)
-For more examples of KVGEN and FLATTEN, see the examples in the section, ["JSON Data Model"]({{ site.baseurl }}/docs/json-data-model).
\ No newline at end of file
+For more examples of KVGEN and FLATTEN, see the examples in the section, ["JSON Data Model"]({{ site.baseurl }}/docs/json-data-model).
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sql-reference/nested-data-functions/030-repeated-count.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/nested-data-functions/030-repeated-count.md b/_docs/sql-reference/nested-data-functions/030-repeated-count.md
index 79ce75e..f9555ec 100644
--- a/_docs/sql-reference/nested-data-functions/030-repeated-count.md
+++ b/_docs/sql-reference/nested-data-functions/030-repeated-count.md
@@ -1,5 +1,6 @@
---
title: "REPEATED_COUNT"
+date: 2015-12-28 21:37:20 UTC
parent: "Nested Data Functions"
---
This function counts the values in an array.
@@ -41,4 +42,4 @@ file. The counts are restricted to rows that contain the string `pizza`.
7 rows selected (2.03 seconds)
For another example of this function, see the following lesson in the Apache
-Drill Tutorial for Hadoop: [Lesson 3: Run Queries on Complex Data Types]({{ site.baseurl }}/docs/lesson-3-run-queries-on-complex-data-types/).
\ No newline at end of file
+Drill Tutorial for Hadoop: [Lesson 3: Run Queries on Complex Data Types]({{ site.baseurl }}/docs/lesson-3-run-queries-on-complex-data-types/).
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sql-reference/nested-data-functions/040-repeated-contains.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/nested-data-functions/040-repeated-contains.md b/_docs/sql-reference/nested-data-functions/040-repeated-contains.md
index 030bfcf..b365d40 100644
--- a/_docs/sql-reference/nested-data-functions/040-repeated-contains.md
+++ b/_docs/sql-reference/nested-data-functions/040-repeated-contains.md
@@ -1,5 +1,6 @@
---
title: "REPEATED_CONTAINS"
+date: 2015-12-28 21:37:20 UTC
parent: "Nested Data Functions"
---
REPEATED CONTAINS searches for a keyword in an array.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sql-reference/sql-commands/005-supported-sql-commands.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-commands/005-supported-sql-commands.md b/_docs/sql-reference/sql-commands/005-supported-sql-commands.md
index a438def..18377f5 100644
--- a/_docs/sql-reference/sql-commands/005-supported-sql-commands.md
+++ b/_docs/sql-reference/sql-commands/005-supported-sql-commands.md
@@ -1,5 +1,6 @@
---
title: Supported SQL Commands
+date: 2015-12-28 21:37:20 UTC
parent: "SQL Commands"
---
The following table provides a list of the SQL commands that Drill supports,
@@ -24,4 +25,4 @@ with their descriptions and example syntax:
| [SHOW FILES]({{site.baseurl}}/docs/show-files) | Returns a list of files in a file system schema. | SHOW FILES IN|FROM filesystem.\`schema_name`; |
| [SHOW SCHEMAS]({{site.baseurl}}/docs/show-databases-and-show-schemas) | Returns a list of available schemas. Equivalent to SHOW DATABASES. | SHOW SCHEMAS; |
| [SHOW TABLES]({{site.baseurl}}/docs/show-tables) | Returns a list of tables and views. | SHOW TABLES; |
-| [USE]({{site.baseurl}}/docs/use) | Change to a particular schema. When you opt to use a particular schema, Drill issues queries on that schema only. | USE schema_name; | |
\ No newline at end of file
+| [USE]({{site.baseurl}}/docs/use) | Change to a particular schema. When you opt to use a particular schema, Drill issues queries on that schema only. | USE schema_name; | |
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sql-reference/sql-commands/010-set.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-commands/010-set.md b/_docs/sql-reference/sql-commands/010-set.md
index 82cb7ba..f014878 100644
--- a/_docs/sql-reference/sql-commands/010-set.md
+++ b/_docs/sql-reference/sql-commands/010-set.md
@@ -1,5 +1,6 @@
---
title: "SET"
+date: 2015-12-28 21:37:20 UTC
parent: "SQL Commands"
---
The SET command replaces the ALTER SESSION SET command in Drill version 1.3 and later. The SET command changes a system setting for the duration of a session. Session level settings override system level settings.
@@ -63,4 +64,4 @@ option type is case-sensitive.
| name | type | bool_val |
+---------------------------+----------+-----------+
| store.json.all_text_mode | SESSION | true |
- +---------------------------+----------+-----------+
\ No newline at end of file
+ +---------------------------+----------+-----------+
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sql-reference/sql-commands/012-reset.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-commands/012-reset.md b/_docs/sql-reference/sql-commands/012-reset.md
index 6799dff..8d6eb38 100644
--- a/_docs/sql-reference/sql-commands/012-reset.md
+++ b/_docs/sql-reference/sql-commands/012-reset.md
@@ -1,5 +1,6 @@
---
title: "RESET"
+date: 2015-12-28 21:37:20 UTC
parent: "SQL Commands"
---
The RESET command is available in Drill version 1.3 and later. The RESET command resets a session level option back to its default system setting.
@@ -60,4 +61,4 @@ You can issue a query to see the default system setting for the option:
| name | type | bool_val |
+---------------------------+---------+-----------+
| store.json.all_text_mode | SYSTEM | false |
- +---------------------------+---------+-----------+
\ No newline at end of file
+ +---------------------------+---------+-----------+
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sql-reference/sql-commands/020-alter-system.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-commands/020-alter-system.md b/_docs/sql-reference/sql-commands/020-alter-system.md
index 2617786..0642a71 100644
--- a/_docs/sql-reference/sql-commands/020-alter-system.md
+++ b/_docs/sql-reference/sql-commands/020-alter-system.md
@@ -1,5 +1,6 @@
---
title: "ALTER SYSTEM"
+date: 2015-12-28 21:37:20 UTC
parent: "SQL Commands"
---
The ALTER SYSTEM command permanently changes a system setting. The new setting
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sql-reference/sql-commands/030-create-table-as.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-commands/030-create-table-as.md b/_docs/sql-reference/sql-commands/030-create-table-as.md
index 8a21333..4995daf 100644
--- a/_docs/sql-reference/sql-commands/030-create-table-as.md
+++ b/_docs/sql-reference/sql-commands/030-create-table-as.md
@@ -1,5 +1,6 @@
---
title: "CREATE TABLE AS (CTAS)"
+date: 2015-12-28 21:37:20 UTC
parent: "SQL Commands"
---
You can create tables in Drill by using the CTAS command.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sql-reference/sql-commands/035-partition-by-clause.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-commands/035-partition-by-clause.md b/_docs/sql-reference/sql-commands/035-partition-by-clause.md
index d011766..322bd33 100644
--- a/_docs/sql-reference/sql-commands/035-partition-by-clause.md
+++ b/_docs/sql-reference/sql-commands/035-partition-by-clause.md
@@ -1,5 +1,6 @@
---
title: "PARTITION BY Clause"
+date: 2015-12-28 21:37:20 UTC
parent: "SQL Commands"
---
The PARTITION BY clause in the CTAS command partitions data, which Drill [prunes]({{site.baseurl}}/docs/partition-pruning/) to improve performance when you query the data. (Drill 1.1.0)
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sql-reference/sql-commands/050-create-view.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-commands/050-create-view.md b/_docs/sql-reference/sql-commands/050-create-view.md
index 83dda83..7ae66a8 100644
--- a/_docs/sql-reference/sql-commands/050-create-view.md
+++ b/_docs/sql-reference/sql-commands/050-create-view.md
@@ -1,5 +1,6 @@
---
title: "CREATE VIEW"
+date: 2015-12-28 21:37:20 UTC
parent: "SQL Commands"
---
The CREATE VIEW command creates a virtual structure for the result set of a
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sql-reference/sql-commands/053-describe.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-commands/053-describe.md b/_docs/sql-reference/sql-commands/053-describe.md
index 837494c..93fa639 100644
--- a/_docs/sql-reference/sql-commands/053-describe.md
+++ b/_docs/sql-reference/sql-commands/053-describe.md
@@ -1,5 +1,6 @@
---
title: "DESCRIBE"
+date: 2015-12-28 21:37:20 UTC
parent: "SQL Commands"
---
The DESCRIBE command returns information about columns in a table or view.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sql-reference/sql-commands/055-drop-table.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-commands/055-drop-table.md b/_docs/sql-reference/sql-commands/055-drop-table.md
old mode 100755
new mode 100644
index e8ced44..7bb07de
--- a/_docs/sql-reference/sql-commands/055-drop-table.md
+++ b/_docs/sql-reference/sql-commands/055-drop-table.md
@@ -1,5 +1,6 @@
---
title: "DROP TABLE"
+date: 2015-12-28 21:37:20 UTC
parent: "SQL Commands"
---
@@ -16,21 +17,21 @@ The DROP TABLE command supports the following syntax:
## Usage Notes
###Schema
-* You must identify the schema in which a table exists to successfully drop the table. You can identify the schema before dropping the table with the USE <schema_name> command (see [USE command]({{ site.baseurl }}/docs/use/)) or when you issue the DROP TABLE command. See [Example 1: Identifying a schema]({{ site.baseurl }}/docs/drop-table/#example-1:-identifying-a-schema).
+* You must identify the schema in which a table exists to successfully drop the table. You can identify the schema before dropping the table with the USE <schema_name> command (see [USE command]({{ site.baseurl }}/docs/use/)) or when you issue the DROP TABLE command. See [Example 1: Identifying a schema]({{ site.baseurl }}/docs/drop-table/#example-1:-identifying-a-schema).
* The schema must be mutable. For example, to drop a table from a schema named `dfs.sales`, the `"writable"` attribute for the `"sales"` workspace in the DFS storage plugin configuration must be set to `true`. See [Storage Plugin Attributes]({{ site.baseurl }}/docs/plugin-configuration-basics/#storage-plugin-attributes).
###File Type
-* The DROP TABLE command only works against file types that Drill can read. File types are identified as supported file formats, such as Parquet, JSON, or Text. See [Querying a File System Introduction]({{ site.baseurl }}/docs/querying-a-file-system-introduction/) for a complete list of supported file types.
-* Text formats must be configured in the DFS storage plugin configuration. For example, to support CSV files, the `"formats"` attribute in the configuration must include `"csv"` as a value. See [Storage Plugin Attributes]({{ site.baseurl }}/docs/plugin-configuration-basics/#storage-plugin-attributes).
-* The directory on which you issue the DROP TABLE command must contain files of the same type. For example, if you have a workspace configured, such as `dfs.sales`, that points to a directory containing subdirectories, such as `/2012` and `/2013`, files in all of the directories must be of the same type to successfully issue the DROP TABLE command against the directory.
-
+* The DROP TABLE command only works against file types that Drill can read. File types are identified as supported file formats, such as Parquet, JSON, or Text. See [Querying a File System Introduction]({{ site.baseurl }}/docs/querying-a-file-system-introduction/) for a complete list of supported file types.
+* Text formats must be configured in the DFS storage plugin configuration. For example, to support CSV files, the `"formats"` attribute in the configuration must include `"csv"` as a value. See [Storage Plugin Attributes]({{ site.baseurl }}/docs/plugin-configuration-basics/#storage-plugin-attributes).
+* The directory on which you issue the DROP TABLE command must contain files of the same type. For example, if you have a workspace configured, such as `dfs.sales`, that points to a directory containing subdirectories, such as `/2012` and `/2013`, files in all of the directories must be of the same type to successfully issue the DROP TABLE command against the directory.
+
###Permissions
* A user must have the appropriate permissions on the file system to successfully issue the DROP TABLE command. Inadequate permissions result in a failed drop and can potentially remove a subset of the files in a directory.
###User Impersonation
-* When user impersonation is enabled in Drill, Drill impersonates the user issuing the DROP TABLE command. Therefore, the user must have sufficient permissions on the file system for the command to succeed. See [Configuring User Impersonation]({{ site.baseurl }}/docs/configuring-user-impersonation/).
-* When user impersonation is not enabled in Drill, Drill accesses the file system as the user running the Drillbit. This user is typically a super user who has permission to delete most files. In this scenario, use the DROP TABLE command with caution to avoid deleting critical files and directories.
-
+* When user impersonation is enabled in Drill, Drill impersonates the user issuing the DROP TABLE command. Therefore, the user must have sufficient permissions on the file system for the command to succeed. See [Configuring User Impersonation]({{ site.baseurl }}/docs/configuring-user-impersonation/).
+* When user impersonation is not enabled in Drill, Drill accesses the file system as the user running the Drillbit. This user is typically a super user who has permission to delete most files. In this scenario, use the DROP TABLE command with caution to avoid deleting critical files and directories.
+
###Views
* Views are independent of tables. Views that reference dropped tables become invalid. You must explicitly drop any view that references a dropped table using the [DROP VIEW command]({{ site.baseurl }}/docs/drop-view/).
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sql-reference/sql-commands/056-drop-view.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-commands/056-drop-view.md b/_docs/sql-reference/sql-commands/056-drop-view.md
index 4e8b477..c10ae03 100644
--- a/_docs/sql-reference/sql-commands/056-drop-view.md
+++ b/_docs/sql-reference/sql-commands/056-drop-view.md
@@ -1,5 +1,6 @@
---
title: "DROP VIEW"
+date: 2015-12-28 21:37:20 UTC
parent: "SQL Commands"
---
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sql-reference/sql-commands/070-explain.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-commands/070-explain.md b/_docs/sql-reference/sql-commands/070-explain.md
index c5347a9..90c347d 100644
--- a/_docs/sql-reference/sql-commands/070-explain.md
+++ b/_docs/sql-reference/sql-commands/070-explain.md
@@ -1,5 +1,6 @@
---
title: "EXPLAIN"
+date: 2015-12-28 21:37:20 UTC
parent: "SQL Commands"
---
EXPLAIN is a useful tool for examining the steps that a query goes through
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sql-reference/sql-commands/079-select.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-commands/079-select.md b/_docs/sql-reference/sql-commands/079-select.md
old mode 100755
new mode 100644
index ff502aa..1370871
--- a/_docs/sql-reference/sql-commands/079-select.md
+++ b/_docs/sql-reference/sql-commands/079-select.md
@@ -1,5 +1,6 @@
---
title: "SELECT"
+date: 2015-12-28 21:37:20 UTC
parent: "SQL Commands"
---
Drill supports the following ANSI standard clauses in the SELECT statement:
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sql-reference/sql-commands/080-select-list.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-commands/080-select-list.md b/_docs/sql-reference/sql-commands/080-select-list.md
index fc9500d..03d647b 100644
--- a/_docs/sql-reference/sql-commands/080-select-list.md
+++ b/_docs/sql-reference/sql-commands/080-select-list.md
@@ -1,5 +1,6 @@
---
title: "SELECT List"
+date: 2015-12-28 21:37:20 UTC
parent: "SQL Commands"
---
@@ -26,8 +27,8 @@ An expression formed from one or more columns that exist in the tables, files, o
*scalar aggregate subquery*
A scalar aggregate subquery is a regular SELECT query in parentheses that returns exactly one column value from one row. The returned value is used in the outer query. The scalar aggregate subquery must include an aggregate function, such as MAX(), AVG(), or COUNT(). If the subquery returns zero rows, the value of the subquery expression is null. If it returns more than one row, Drill returns an error. Scalar subqueries are not valid expressions in the following cases:
-* As default values for expressions
-* In GROUP BY and HAVING clauses
+* As default values for expressions
+* In GROUP BY and HAVING clauses
AS *column_alias*
A temporary name for a column in the final result set. The AS keyword is optional.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sql-reference/sql-commands/081-from-clause.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-commands/081-from-clause.md b/_docs/sql-reference/sql-commands/081-from-clause.md
old mode 100755
new mode 100644
index a8f7f46..c26f519
--- a/_docs/sql-reference/sql-commands/081-from-clause.md
+++ b/_docs/sql-reference/sql-commands/081-from-clause.md
@@ -1,5 +1,6 @@
---
title: "FROM Clause"
+date: 2015-12-28 21:37:20 UTC
parent: "SQL Commands"
---
The FROM clause lists the references (tables, views, and subqueries) that data is selected from. Drill expands the traditional concept of a “table reference” in a standard SQL FROM clause to refer to files and directories in a local or distributed file system.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sql-reference/sql-commands/082-group-by-clause.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-commands/082-group-by-clause.md b/_docs/sql-reference/sql-commands/082-group-by-clause.md
old mode 100755
new mode 100644
index 9f09220..1680a40
--- a/_docs/sql-reference/sql-commands/082-group-by-clause.md
+++ b/_docs/sql-reference/sql-commands/082-group-by-clause.md
@@ -1,5 +1,6 @@
---
title: "GROUP BY Clause"
+date: 2015-12-28 21:37:20 UTC
parent: "SQL Commands"
---
The GROUP BY clause identifies the grouping columns for the query. You typically use a GROUP BY clause in conjunction with an aggregate expression. Grouping columns must be declared when the query computes aggregates with standard functions such as SUM, AVG, and COUNT. Currently, Drill does not support grouping on aliases.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sql-reference/sql-commands/083-having-clause.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-commands/083-having-clause.md b/_docs/sql-reference/sql-commands/083-having-clause.md
old mode 100755
new mode 100644
index be64be4..a5a0bab
--- a/_docs/sql-reference/sql-commands/083-having-clause.md
+++ b/_docs/sql-reference/sql-commands/083-having-clause.md
@@ -1,5 +1,6 @@
---
title: "HAVING Clause"
+date: 2015-12-28 21:37:20 UTC
parent: "SQL Commands"
---
The HAVING clause filters group rows created by the GROUP BY clause. The HAVING clause is applied to each group of the grouped table, much as a WHERE clause is applied to a select list. If there is no GROUP BY clause, the HAVING clause is applied to the entire result as a single group. The SELECT clause cannot refer directly to any column that does not have a GROUP BY clause.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sql-reference/sql-commands/084-limit-clause.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-commands/084-limit-clause.md b/_docs/sql-reference/sql-commands/084-limit-clause.md
old mode 100755
new mode 100644
index d691119..fe408cf
--- a/_docs/sql-reference/sql-commands/084-limit-clause.md
+++ b/_docs/sql-reference/sql-commands/084-limit-clause.md
@@ -1,5 +1,6 @@
---
title: "LIMIT Clause"
+date: 2015-12-28 21:37:20 UTC
parent: "SQL Commands"
---
The LIMIT clause limits the result set to the specified number of rows. You can use LIMIT with or without an ORDER BY clause.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sql-reference/sql-commands/085-offset-clause.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-commands/085-offset-clause.md b/_docs/sql-reference/sql-commands/085-offset-clause.md
old mode 100755
new mode 100644
index 8eb2f05..878363a
--- a/_docs/sql-reference/sql-commands/085-offset-clause.md
+++ b/_docs/sql-reference/sql-commands/085-offset-clause.md
@@ -1,5 +1,6 @@
---
title: "OFFSET Clause"
+date: 2015-12-28 21:37:20 UTC
parent: "SQL Commands"
---
The OFFSET clause provides a way to skip a specified number of first rows in a result set before starting to return any rows.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sql-reference/sql-commands/086-order-by-clause.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-commands/086-order-by-clause.md b/_docs/sql-reference/sql-commands/086-order-by-clause.md
old mode 100755
new mode 100644
index 10252af..3119c56
--- a/_docs/sql-reference/sql-commands/086-order-by-clause.md
+++ b/_docs/sql-reference/sql-commands/086-order-by-clause.md
@@ -1,5 +1,6 @@
---
title: "ORDER BY Clause"
+date: 2015-12-28 21:37:20 UTC
parent: "SQL Commands"
---
The ORDER BY clause sorts the result set of a query.