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:29 UTC
[1/4] drill git commit: DRILL-3949
Repository: drill
Updated Branches:
refs/heads/gh-pages fbc012983 -> 25920ab7b
DRILL-3949
Project: http://git-wip-us.apache.org/repos/asf/drill/repo
Commit: http://git-wip-us.apache.org/repos/asf/drill/commit/5c8029ec
Tree: http://git-wip-us.apache.org/repos/asf/drill/tree/5c8029ec
Diff: http://git-wip-us.apache.org/repos/asf/drill/diff/5c8029ec
Branch: refs/heads/gh-pages
Commit: 5c8029ece55b544ca7056ef228c43c697bfb8650
Parents: fbc0129
Author: Kris Hahn <kr...@apache.org>
Authored: Tue Dec 15 17:54:57 2015 -0800
Committer: Kris Hahn <kr...@apache.org>
Committed: Mon Dec 28 13:55:00 2015 -0800
----------------------------------------------------------------------
_docs/connect-a-data-source/020-storage-plugin-registration.md | 2 --
1 file changed, 2 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/drill/blob/5c8029ec/_docs/connect-a-data-source/020-storage-plugin-registration.md
----------------------------------------------------------------------
diff --git a/_docs/connect-a-data-source/020-storage-plugin-registration.md b/_docs/connect-a-data-source/020-storage-plugin-registration.md
index 9763171..dc3192b 100644
--- a/_docs/connect-a-data-source/020-storage-plugin-registration.md
+++ b/_docs/connect-a-data-source/020-storage-plugin-registration.md
@@ -38,8 +38,6 @@ Drill saves storage plugin configurations in a temporary directory (embedded mod
sys.store.provider.local.path="/mypath"
}
-
-
<!-- Enabling authorization to protect this data through the Web Console and REST API does not include protection for the data in the tmp directory or in ZooKeeper.
DOCS NOTE: See Drill-3780 and 3949
[3/4] drill git commit: add date to front matter
Posted by kr...@apache.org.
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.
[4/4] drill git commit: add date to front matter
Posted by kr...@apache.org.
add date to front matter
DRILL-4213 jekyll/liquid command
remove date
remove unwanted timestamp
Project: http://git-wip-us.apache.org/repos/asf/drill/repo
Commit: http://git-wip-us.apache.org/repos/asf/drill/commit/25920ab7
Tree: http://git-wip-us.apache.org/repos/asf/drill/tree/25920ab7
Diff: http://git-wip-us.apache.org/repos/asf/drill/diff/25920ab7
Branch: refs/heads/gh-pages
Commit: 25920ab7bd99cfe40377ace2d330b9ed4fdb23c7
Parents: 5c8029e
Author: Kris Hahn <kr...@apache.org>
Authored: Mon Dec 28 13:25:45 2015 -0800
Committer: Kris Hahn <kr...@apache.org>
Committed: Mon Dec 28 13:56:45 2015 -0800
----------------------------------------------------------------------
_docs/110-troubleshooting.md | 3 +-
_docs/170-bylaws.md | 1 +
.../010-architecture-introduction.md | 3 +-
_docs/architecture/015-drill-query-execution.md | 1 +
_docs/architecture/020-core-modules.md | 1 +
_docs/architecture/030-performance.md | 3 +-
.../010-configure-drill-introduction.md | 1 +
.../020-configuring-drill-memory.md | 3 +-
...guring-a-multitenant-cluster-introduction.md | 3 +-
.../050-configuring-multitenant-resources.md | 3 +-
.../060-configuring-a-shared-drillbit.md | 1 +
.../070-configuring-user-impersonation.md | 3 +-
.../075-configuring-user-authentication.md | 1 +
...ser-impersonation-with-hive-authorization.md | 1 +
...-configuring-web-ui-and-rest-api-security.md | 3 +-
.../configure-drill/100-ports-used-by-drill.md | 1 +
.../120-configuring-the-drill-shell.md | 3 +-
.../010-configuration-options-introduction.md | 3 +-
.../020-start-up-options.md | 1 +
.../030-planning-and-exececution-options.md | 1 +
.../040-persistent-configuration-storage.md | 1 +
.../010-connect-a-data-source-introduction.md | 3 +-
.../020-storage-plugin-registration.md | 1 +
.../035-plugin-configuration-basics.md | 1 +
_docs/connect-a-data-source/050-workspaces.md | 1 +
.../080-drill-default-input-format.md | 3 +-
.../plugins/040-file-system-storage-plugin.md | 3 +-
.../plugins/060-hbase-storage-plugin.md | 1 +
.../plugins/070-hive-storage-plugin.md | 3 +-
.../plugins/080-rdbms-storage-plugin.md | 1 +
.../plugins/090-mongodb-storage-plugin.md | 1 +
.../plugins/110-s3-storage-plugin.md | 1 +
...ata-sources-and-file-formats-introduction.md | 3 +-
.../020-hive-to-drill-data-type-mapping.md | 1 +
.../030-deploying-and-using-a-hive-udf.md | 1 +
.../040-parquet-format.md | 3 +-
.../050-json-data-model.md | 1 +
.../060-text-files-csv-tsv-psv.md | 1 +
.../070-sequencefile-format.md | 3 +-
...010-develop-custom-functions-introduction.md | 3 +-
.../020-developing-a-simple-function.md | 1 +
.../025-tutorial-develop-a-simple-function.md | 3 +-
.../030-developing-an-aggregate-function.md | 3 +-
.../040-adding-custom-functions-to-drill.md | 1 +
.../050-use-custom-functions-in-queries.md | 3 +-
.../060-custom-function-interfaces.md | 3 +-
_docs/developer-information/009-rest-api.md | 1 +
.../010-apache-drill-contribution-guidelines.md | 1 +
.../020-apache-drill-contribution-ideas.md | 1 +
.../design-docs/010-drill-plan-syntax.md | 1 +
.../design-docs/020-rpc-overview.md | 1 +
.../design-docs/030-query-stages.md | 1 +
.../design-docs/040-useful-research.md | 1 +
.../design-docs/050-value-vectors.md | 1 +
.../010-compiling-drill-from-source.md | 1 +
.../020-drill-patch-review-tool.md | 1 +
_docs/getting-started/010-drill-introduction.md | 1 +
_docs/getting-started/020-why-drill.md | 1 +
_docs/install/010-install-drill-introduction.md | 3 +-
_docs/install/020-migrating-parquet-data.md | 1 +
.../045-distributed-mode-prerequisites.md | 1 +
.../047-installing-drill-on-the-cluster.md | 1 +
.../050-starting-drill-in-distributed-mode.md | 1 +
_docs/install/060-starting-the-web-ui.md | 1 +
.../010-embedded-mode-prerequisites.md | 1 +
...20-installing-drill-on-linux-and-mac-os-x.md | 3 +-
.../030-starting-drill-on-linux-and-mac-os-x.md | 1 +
.../040-installing-drill-on-windows.md | 3 +-
.../050-starting-drill-on-windows.md | 1 +
.../001-log-and-debug-introduction.md | 1 +
_docs/log-and-debug/002-error-messages.md | 3 +-
_docs/log-and-debug/003-modify-logback.xml.md | 1 +
.../004-review-the-java-stack-trace.md | 3 +-
_docs/log-and-debug/005-query-audit-logging.md | 3 +-
.../010-interfaces-introduction.md | 1 +
.../015-using-jdbc-driver.md | 3 +-
.../020-using-jdbc-with-squirrel-on-windows.md | 1 +
.../010-odbc-configuration-reference.md | 1 +
.../020-configuring-odbc-on-linux.md | 1 +
.../025-configuring-odbc-on-mac-os-x.md | 1 +
.../030-configuring-odbc-on-windows.md | 1 +
.../040-testing-the-odbc-connection.md | 1 +
.../010-installing-the-driver-on-linux.md | 1 +
.../020-installing-the-driver-on-mac-os-x.md | 1 +
.../030-installing-the-driver-on-windows.md | 1 +
.../040-installing-the-tdc-file-on-windows.md | 3 +-
.../010-drill-explorer-introduction.md | 1 +
.../020-connecting-drill-explorer-to-data.md | 1 +
.../030-browsing-data-and-creating-views.md | 1 +
...010-using-odbc-with-bi-tools-introduction.md | 3 +-
.../020-tableau-examples.md | 1 +
...microstrategy-analytics-with-apache-drill.md | 1 +
...0-using-tibco-spotfire-desktop-with-drill.md | 1 +
.../050-configuring-spotfire-server.md | 3 +-
.../055-using-qliksense-with-drill.md | 1 +
...using-apache-drill-with-tableau-9-desktop.md | 1 +
...-using-apache-drill-with-tableau-9-server.md | 1 +
.../090-configuring-jreport-with-drill.md | 3 +-
.../010-performance-tuning-introduction.md | 1 +
.../025-optimizing-parquet-reading.md | 3 +-
.../030-choosing-a-storage-format.md | 1 +
.../010-query-plans.md | 3 +-
.../020-query-profiles.md | 1 +
.../010-partition-pruning-introduction.md | 1 +
.../030-using-partition-pruning.md | 1 +
.../010-query-profile-tables.md | 1 +
.../020-physical-operators.md | 1 +
.../010-query-plans-and-tuning-introduction.md | 1 +
.../020-join-planning-guidelines.md | 1 +
...030-guidelines-for-optimizing-aggregation.md | 3 +-
.../040-modifying-query-planning-options.md | 1 +
...d-hash-based-memory-constrained-operators.md | 1 +
.../060-enabling-query-queuing.md | 1 +
...to-balance-performance-with-multi-tenancy.md | 1 +
_docs/query-data/010-query-data-introduction.md | 3 +-
_docs/query-data/030-querying-hbase.md | 1 +
_docs/query-data/050-querying-hive.md | 3 +-
.../060-querying-the-information-schema.md | 3 +-
_docs/query-data/070-query-sys-tbl.md | 1 +
...and-canceling-queries-in-the-Drill-Web-UI.md | 1 +
.../005-querying-a-file-system-introduction.md | 3 +-
.../010-querying-json-files.md | 1 +
.../020-querying-parquet-files.md | 1 +
.../030-querying-plain-text-files.md | 1 +
.../040-querying-directories.md | 1 +
.../050-querying-sequence-files.md | 1 +
.../005-querying-complex-data-introduction.md | 1 +
.../010-sample--data-donuts.md | 3 +-
.../020-selecting-flat-data.md | 3 +-
...030-using-sql-functions-clauses-and-joins.md | 3 +-
.../040-selecting-nested-data.md | 3 +-
...cting-multiple-columns-within-nested-data.md | 3 +-
_docs/sample-datasets/001-aol.md | 1 +
_docs/sample-datasets/002-enron.md | 3 +-
_docs/sample-datasets/003-wikipedia.md | 3 +-
.../010-sql-reference-introduction.md | 1 +
_docs/sql-reference/030-lexical-structure.md | 1 +
_docs/sql-reference/040-operators.md | 1 +
.../065-query-directory-functions.md | 1 +
_docs/sql-reference/080-reserved-keywords.md | 1 +
_docs/sql-reference/090-sql-extensions.md | 3 +-
.../data-types/010-supported-data-types.md | 1 +
.../data-types/020-date-time-and-timestamp.md | 1 +
.../030-handling-different-data-types.md | 3 +-
.../005-nested-data-limitations.md | 3 +-
.../nested-data-functions/010-flatten.md | 1 +
.../nested-data-functions/020-kvgen.md | 3 +-
.../nested-data-functions/030-repeated-count.md | 3 +-
.../040-repeated-contains.md | 1 +
.../sql-commands/005-supported-sql-commands.md | 3 +-
_docs/sql-reference/sql-commands/010-set.md | 3 +-
_docs/sql-reference/sql-commands/012-reset.md | 3 +-
.../sql-commands/020-alter-system.md | 1 +
.../sql-commands/030-create-table-as.md | 1 +
.../sql-commands/035-partition-by-clause.md | 1 +
.../sql-commands/050-create-view.md | 1 +
.../sql-reference/sql-commands/053-describe.md | 1 +
.../sql-commands/055-drop-table.md | 17 ++++++-----
.../sql-reference/sql-commands/056-drop-view.md | 1 +
_docs/sql-reference/sql-commands/070-explain.md | 1 +
_docs/sql-reference/sql-commands/079-select.md | 1 +
.../sql-commands/080-select-list.md | 5 ++--
.../sql-commands/081-from-clause.md | 1 +
.../sql-commands/082-group-by-clause.md | 1 +
.../sql-commands/083-having-clause.md | 1 +
.../sql-commands/084-limit-clause.md | 1 +
.../sql-commands/085-offset-clause.md | 1 +
.../sql-commands/086-order-by-clause.md | 1 +
.../sql-commands/087-union-set-operator.md | 3 +-
.../sql-commands/088-where-clause.md | 3 +-
.../sql-commands/089-with-clause.md | 3 +-
.../090-show-databases-and-show-schemas.md | 3 +-
.../sql-commands/100-show-files.md | 3 +-
.../sql-commands/110-show-tables.md | 1 +
_docs/sql-reference/sql-commands/120-use.md | 1 +
.../010-case-expression.md | 3 +-
.../005-about-sql-function-examples.md | 3 +-
.../sql-functions/010-math-and-trig.md | 1 +
.../sql-functions/020-data-type-conversion.md | 3 +-
.../030-date-time-functions-and-arithmetic.md | 3 +-
.../sql-functions/040-string-manipulation.md | 3 +-
.../050-aggregate-and-aggregate-statistical.md | 1 +
.../060-functions-for-handling-nulls.md | 3 +-
.../010-sql-window-functions-introduction.md | 31 ++++++++++----------
.../020-aggregate-window-functions.md | 1 +
.../030-ranking-window-functions.md | 3 +-
.../035-value-window-functions.md | 17 ++++++-----
.../040-sql-window-functions-examples.md | 3 +-
_docs/tutorials/010-tutorials-introduction.md | 1 +
_docs/tutorials/020-drill-in-10-minutes.md | 3 +-
.../030-analyzing-the-yelp-academic-dataset.md | 1 +
.../040-learn-drill-with-the-mapr-sandbox.md | 1 +
.../050-analyzing-highly-dynamic-datasets.md | 1 +
_docs/tutorials/060-analyzing-social-media.md | 3 +-
...070-analyzing-data-using-window-functions.md | 3 +-
.../005-about-the-mapr-sandbox.md | 1 +
.../010-installing-the-apache-drill-sandbox.md | 1 +
.../020-getting-to-know-the-drill-sandbox.md | 1 +
.../030-lesson-1-learn-about-the-data-set.md | 1 +
.../040-lesson-2-run-queries-with-ansi-sql.md | 1 +
...esson-3-run-queries-on-complex-data-types.md | 1 +
.../060-summary.md | 1 +
202 files changed, 306 insertions(+), 104 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/110-troubleshooting.md
----------------------------------------------------------------------
diff --git a/_docs/110-troubleshooting.md b/_docs/110-troubleshooting.md
old mode 100755
new mode 100644
index 7332e31..5eade42
--- a/_docs/110-troubleshooting.md
+++ b/_docs/110-troubleshooting.md
@@ -1,5 +1,6 @@
---
title: "Troubleshooting"
+date: 2015-12-28 21:37:18 UTC
---
You may experience certain known issues when using Drill. This document lists some known issues and resolutions for each.
@@ -269,4 +270,4 @@ Symptom:
`java.net.BindException: Address already in use`
-Solution: You can only run one Drillbit per node in embedded or distributed mode using default settings. You need to either change ports used by Drillbit or stop one Drillbit before starting another.
\ No newline at end of file
+Solution: You can only run one Drillbit per node in embedded or distributed mode using default settings. You need to either change ports used by Drillbit or stop one Drillbit before starting another.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/170-bylaws.md
----------------------------------------------------------------------
diff --git a/_docs/170-bylaws.md b/_docs/170-bylaws.md
index 2c35042..6ef5993 100644
--- a/_docs/170-bylaws.md
+++ b/_docs/170-bylaws.md
@@ -1,5 +1,6 @@
---
title: "Project Bylaws"
+date: 2015-12-28 21:37:18 UTC
---
## Introduction
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/architecture/010-architecture-introduction.md
----------------------------------------------------------------------
diff --git a/_docs/architecture/010-architecture-introduction.md b/_docs/architecture/010-architecture-introduction.md
old mode 100755
new mode 100644
index 54c72e4..fb67bf5
--- a/_docs/architecture/010-architecture-introduction.md
+++ b/_docs/architecture/010-architecture-introduction.md
@@ -1,5 +1,6 @@
---
title: "Architecture Introduction"
+date: 2015-12-28 21:37:18 UTC
parent: "Architecture"
---
Apache Drill is a low latency distributed query engine for large-scale
@@ -79,4 +80,4 @@ plugin, query, query optimization/execution, and client API layers. You can
customize any layer for the specific needs of an organization or you can
extend the layer to a broader array of use cases. Drill uses
classpath scanning to find and load plugins, and to add additional storage plugins,
-functions, and operators with minimal configuration.
\ No newline at end of file
+functions, and operators with minimal configuration.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/architecture/015-drill-query-execution.md
----------------------------------------------------------------------
diff --git a/_docs/architecture/015-drill-query-execution.md b/_docs/architecture/015-drill-query-execution.md
old mode 100755
new mode 100644
index d4828f8..f07ca6f
--- a/_docs/architecture/015-drill-query-execution.md
+++ b/_docs/architecture/015-drill-query-execution.md
@@ -1,5 +1,6 @@
---
title: "Drill Query Execution"
+date: 2015-12-28 21:37:18 UTC
parent: "Architecture"
---
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/architecture/020-core-modules.md
----------------------------------------------------------------------
diff --git a/_docs/architecture/020-core-modules.md b/_docs/architecture/020-core-modules.md
old mode 100755
new mode 100644
index 96d7dfa..3f18be3
--- a/_docs/architecture/020-core-modules.md
+++ b/_docs/architecture/020-core-modules.md
@@ -1,5 +1,6 @@
---
title: "Core Modules"
+date: 2015-12-28 21:37:18 UTC
parent: "Architecture"
---
The following image represents components within each Drillbit:
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/architecture/030-performance.md
----------------------------------------------------------------------
diff --git a/_docs/architecture/030-performance.md b/_docs/architecture/030-performance.md
old mode 100755
new mode 100644
index b771dba..ccf0fad
--- a/_docs/architecture/030-performance.md
+++ b/_docs/architecture/030-performance.md
@@ -1,5 +1,6 @@
---
title: "Performance"
+date: 2015-12-28 21:37:18 UTC
parent: "Architecture"
---
Drill is designed from the ground up for high performance on large datasets.
@@ -51,4 +52,4 @@ does not spend time creating boundaries or checkpoints to minimize recovery
time. In the instance of a single query failure, the query is rerun. Drill execution uses a pipeline
model where all tasks are scheduled at once. The query execution happens in-
memory as much as possible to move data through task pipelines, persisting to
-disk only if there is memory overflow.
\ No newline at end of file
+disk only if there is memory overflow.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/configure-drill/010-configure-drill-introduction.md
----------------------------------------------------------------------
diff --git a/_docs/configure-drill/010-configure-drill-introduction.md b/_docs/configure-drill/010-configure-drill-introduction.md
index d338015..7ac7f5b 100644
--- a/_docs/configure-drill/010-configure-drill-introduction.md
+++ b/_docs/configure-drill/010-configure-drill-introduction.md
@@ -1,5 +1,6 @@
---
title: "Configure Drill Introduction"
+date: 2015-12-28 21:37:18 UTC
parent: "Configure Drill"
---
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/configure-drill/020-configuring-drill-memory.md
----------------------------------------------------------------------
diff --git a/_docs/configure-drill/020-configuring-drill-memory.md b/_docs/configure-drill/020-configuring-drill-memory.md
index d3356e0..69b6673 100644
--- a/_docs/configure-drill/020-configuring-drill-memory.md
+++ b/_docs/configure-drill/020-configuring-drill-memory.md
@@ -1,5 +1,6 @@
---
title: "Configuring Drill Memory"
+date: 2015-12-28 21:37:18 UTC
parent: "Configure Drill"
---
@@ -42,4 +43,4 @@ The `drill-env.sh` file contains the following options:
If performance is an issue, replace the -ea flag with -Dbounds=false, as shown in the following example:
- export DRILL_JAVA_OPTS="-Xms1G -Xmx$DRILL_MAX_HEAP -XX:MaxDirectMemorySize=$DRILL_MAX_DIRECT_MEMORY -XX:MaxPermSize=512M -XX:ReservedCodeCacheSize=1G -Dbounds=false"
\ No newline at end of file
+ export DRILL_JAVA_OPTS="-Xms1G -Xmx$DRILL_MAX_HEAP -XX:MaxDirectMemorySize=$DRILL_MAX_DIRECT_MEMORY -XX:MaxPermSize=512M -XX:ReservedCodeCacheSize=1G -Dbounds=false"
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/configure-drill/030-configuring-a-multitenant-cluster-introduction.md
----------------------------------------------------------------------
diff --git a/_docs/configure-drill/030-configuring-a-multitenant-cluster-introduction.md b/_docs/configure-drill/030-configuring-a-multitenant-cluster-introduction.md
index b63fa73..09176a2 100644
--- a/_docs/configure-drill/030-configuring-a-multitenant-cluster-introduction.md
+++ b/_docs/configure-drill/030-configuring-a-multitenant-cluster-introduction.md
@@ -1,5 +1,6 @@
---
title: "Configuring a Multitenant Cluster Introduction"
+date: 2015-12-28 21:37:18 UTC
parent: "Configuring a Multitenant Cluster"
---
@@ -17,4 +18,4 @@ You need to plan and configure the following resources for use with Drill and ot
* [CPU]({{site.baseurl}}/docs/configuring-multitenant-resources/#how-to-manage-drill-cpu-resources)
* [Disk]({{site.baseurl}}/docs/configuring-multitenant-resources/#how-to-manage-drill-disk-resources)
-When users share a Drillbit, [configure queues]({{site.baseurl}}/docs/configuring-resources-for-a-shared-drillbit/#configuring-query-queuing) and [parallelization]({{site.baseurl}}/docs/configuring-resources-for-a-shared-drillbit/#configuring-parallelization) in addition to memory.
\ No newline at end of file
+When users share a Drillbit, [configure queues]({{site.baseurl}}/docs/configuring-resources-for-a-shared-drillbit/#configuring-query-queuing) and [parallelization]({{site.baseurl}}/docs/configuring-resources-for-a-shared-drillbit/#configuring-parallelization) in addition to memory.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/configure-drill/050-configuring-multitenant-resources.md
----------------------------------------------------------------------
diff --git a/_docs/configure-drill/050-configuring-multitenant-resources.md b/_docs/configure-drill/050-configuring-multitenant-resources.md
index 63898f3..fd48757 100644
--- a/_docs/configure-drill/050-configuring-multitenant-resources.md
+++ b/_docs/configure-drill/050-configuring-multitenant-resources.md
@@ -1,5 +1,6 @@
---
title: "Configuring Multitenant Resources"
+date: 2015-12-28 21:37:18 UTC
parent: "Configuring a Multitenant Cluster"
---
Drill operations are memory and CPU-intensive. Currently, Drill resources are managed outside of any cluster management service. In a multitenant or any other type of cluster, YARN-enabled or not, you configure memory and memory usage limits for Drill by modifying the `drill-env.sh` file as described in ["Configuring Drill Memory"]({{site.baseurl}}/docs/configuring-drill-memory).
@@ -35,4 +36,4 @@ Currently, you cannot manage CPU resources within Drill. [Use Linux `cgroups`](h
## How to Manage Disk Resources
-The `planner.add_producer_consumer` system option enables or disables a secondary reading thread that works out of band of the rest of the scanning fragment to prefetch data from disk. If you interact with a certain type of storage medium that is slow or does not prefetch much data, this option tells Drill to add a producer consumer reading thread to the operation. Drill can then assign one thread that focuses on a single reading fragment. If Drill is using memory, you can disable this option to get better performance. If Drill is using disk space, you should enable this option and set a reasonable queue size for the `planner.producer_consumer_queue_size` option. For more information about these options, see the section, ["Performance Tuning"](/docs/performance-tuning-introduction/).
\ No newline at end of file
+The `planner.add_producer_consumer` system option enables or disables a secondary reading thread that works out of band of the rest of the scanning fragment to prefetch data from disk. If you interact with a certain type of storage medium that is slow or does not prefetch much data, this option tells Drill to add a producer consumer reading thread to the operation. Drill can then assign one thread that focuses on a single reading fragment. If Drill is using memory, you can disable this option to get better performance. If Drill is using disk space, you should enable this option and set a reasonable queue size for the `planner.producer_consumer_queue_size` option. For more information about these options, see the section, ["Performance Tuning"](/docs/performance-tuning-introduction/).
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/configure-drill/060-configuring-a-shared-drillbit.md
----------------------------------------------------------------------
diff --git a/_docs/configure-drill/060-configuring-a-shared-drillbit.md b/_docs/configure-drill/060-configuring-a-shared-drillbit.md
index 3ea0f2f..87b6372 100644
--- a/_docs/configure-drill/060-configuring-a-shared-drillbit.md
+++ b/_docs/configure-drill/060-configuring-a-shared-drillbit.md
@@ -1,5 +1,6 @@
---
title: "Configuring Resources for a Shared Drillbit"
+date: 2015-12-28 21:37:18 UTC
parent: "Configuring a Multitenant Cluster"
---
To manage a cluster in which multiple users share a Drillbit, you configure Drill queuing and parallelization in addition to memory, as described in the previous section, ["Configuring Drill Memory"]({{site.baseurl}}/docs/configuring-drill-memory/).
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/configure-drill/070-configuring-user-impersonation.md
----------------------------------------------------------------------
diff --git a/_docs/configure-drill/070-configuring-user-impersonation.md b/_docs/configure-drill/070-configuring-user-impersonation.md
index aefe638..2345c6c 100644
--- a/_docs/configure-drill/070-configuring-user-impersonation.md
+++ b/_docs/configure-drill/070-configuring-user-impersonation.md
@@ -1,5 +1,6 @@
---
title: "Configuring User Impersonation"
+date: 2015-12-28 21:37:18 UTC
parent: "Configure Drill"
---
Impersonation allows a service to act on behalf of a client while performing the action requested by the client. By default, user impersonation is disabled in Drill. You can configure user impersonation in the <DRILLINSTALL_HOME>/conf/drill-override.conf file.
@@ -161,4 +162,4 @@ The emp_team_view.drill.view file contains the following view definition:
When anyone on Joe’s team issues SELECT * FROM emp_team_view, Drill impersonates Joe to access the emp_team_view and then impersonates Frank to access the emp_mgr_view and the employee data. Drill returns the data that Joe’s team has can see based on the view definition. If anyone on Joe’s team tries to query the emp_mgr_view or employees table directly, Drill returns an error or null values.
-Because Joe’s team has read permissions on the emp_team_view, they can create new views from it and write the views to any directory for which they have write access. Creating views can continue until Drill reaches the maximum number of impersonation hops.
\ No newline at end of file
+Because Joe’s team has read permissions on the emp_team_view, they can create new views from it and write the views to any directory for which they have write access. Creating views can continue until Drill reaches the maximum number of impersonation hops.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/configure-drill/075-configuring-user-authentication.md
----------------------------------------------------------------------
diff --git a/_docs/configure-drill/075-configuring-user-authentication.md b/_docs/configure-drill/075-configuring-user-authentication.md
old mode 100755
new mode 100644
index 7b495dc..8cfcd48
--- a/_docs/configure-drill/075-configuring-user-authentication.md
+++ b/_docs/configure-drill/075-configuring-user-authentication.md
@@ -1,5 +1,6 @@
---
title: "Configuring User Authentication"
+date: 2015-12-28 21:37:18 UTC
parent: "Configure Drill"
---
Authentication is the process of proving a user’s identity to access a process running on a system. Drill currently supports username/password based authentication through the use of the Linux Pluggable Authentication Module (PAM). The authentication option is available through JDBC and ODBC interfaces. Linux PAM provides authentication modules that interface with any installed PAM authentication entity, such as the local operating system password file (passwd or login) or LDAP.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/configure-drill/076-configuring-user-impersonation-with-hive-authorization.md
----------------------------------------------------------------------
diff --git a/_docs/configure-drill/076-configuring-user-impersonation-with-hive-authorization.md b/_docs/configure-drill/076-configuring-user-impersonation-with-hive-authorization.md
old mode 100755
new mode 100644
index 5ac55d0..baeb41a
--- a/_docs/configure-drill/076-configuring-user-impersonation-with-hive-authorization.md
+++ b/_docs/configure-drill/076-configuring-user-impersonation-with-hive-authorization.md
@@ -1,5 +1,6 @@
---
title: "Configuring User Impersonation with Hive Authorization"
+date: 2015-12-28 21:37:18 UTC
parent: "Configure Drill"
---
As of Drill 1.1, you can enable impersonation in Drill and configure authorization in Hive version 1.0 to authorize access to metadata in the Hive metastore repository and data in the Hive warehouse. Impersonation allows a service to act on behalf of a client while performing the action requested by the client. See [Configuring User Impersonation]({{site.baseurl}}/docs/configuring-user-impersonation).
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/configure-drill/078-configuring-web-ui-and-rest-api-security.md
----------------------------------------------------------------------
diff --git a/_docs/configure-drill/078-configuring-web-ui-and-rest-api-security.md b/_docs/configure-drill/078-configuring-web-ui-and-rest-api-security.md
index 96576f9..44bc068 100644
--- a/_docs/configure-drill/078-configuring-web-ui-and-rest-api-security.md
+++ b/_docs/configure-drill/078-configuring-web-ui-and-rest-api-security.md
@@ -1,5 +1,6 @@
---
title: "Configuring Web Console and REST API Security"
+date: 2015-12-28 21:37:18 UTC
parent: "Configure Drill"
---
<!-- Drill 1.2 extends [Drill user authentication]({{site.baseurl}}/docs/configuring-user-authentication/) to the Web Console and underlying REST API. As administrator, you can control the extent of access to the Web Console and REST API client applications. For example,
@@ -108,4 +109,4 @@ The following table and subsections describe the privilege levels for accessing
### GET /profiles/cancel/{queryid}
* ADMIN - can cancel the query.
-* USER - cancel the query only if the query is launched by the user requesting the cancellation. -->
\ No newline at end of file
+* USER - cancel the query only if the query is launched by the user requesting the cancellation. -->
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/configure-drill/100-ports-used-by-drill.md
----------------------------------------------------------------------
diff --git a/_docs/configure-drill/100-ports-used-by-drill.md b/_docs/configure-drill/100-ports-used-by-drill.md
index a90be08..0457018 100644
--- a/_docs/configure-drill/100-ports-used-by-drill.md
+++ b/_docs/configure-drill/100-ports-used-by-drill.md
@@ -1,5 +1,6 @@
---
title: "Ports Used by Drill"
+date: 2015-12-28 21:37:18 UTC
parent: "Configure Drill"
---
The following table provides a list of the ports that Drill uses, the port
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/configure-drill/120-configuring-the-drill-shell.md
----------------------------------------------------------------------
diff --git a/_docs/configure-drill/120-configuring-the-drill-shell.md b/_docs/configure-drill/120-configuring-the-drill-shell.md
index 0a67b59..9e7b6f9 100644
--- a/_docs/configure-drill/120-configuring-the-drill-shell.md
+++ b/_docs/configure-drill/120-configuring-the-drill-shell.md
@@ -1,5 +1,6 @@
---
title: "Configuring the Drill Shell"
+date: 2015-12-28 21:37:18 UTC
parent: "Configure Drill"
---
After [starting the Drill shell]({{site.baseurl}}/docs/starting-drill-on-linux-and-mac-os-x/), you can type queries on the shell command line. At the Drill shell command prompt, typing "help" lists the configuration and other options you can set to manage shell functionality. Apache Drill 1.0 and later formats the resultset output tables for readability if possible. In this release, columns having 70 characters or more cannot be formatted. This document formats all output for readability and example purposes.
@@ -91,4 +92,4 @@ Set the output format to CSV to improve performance of a huge query.
### autoCommit
-Drill performs read-only operations primarily, and autocommits writes. Drill JDBC throws an exception if autoCommit is disabled.
\ No newline at end of file
+Drill performs read-only operations primarily, and autocommits writes. Drill JDBC throws an exception if autoCommit is disabled.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/configure-drill/configuration-options/010-configuration-options-introduction.md
----------------------------------------------------------------------
diff --git a/_docs/configure-drill/configuration-options/010-configuration-options-introduction.md b/_docs/configure-drill/configuration-options/010-configuration-options-introduction.md
index 71bc503..38a6346 100644
--- a/_docs/configure-drill/configuration-options/010-configuration-options-introduction.md
+++ b/_docs/configure-drill/configuration-options/010-configuration-options-introduction.md
@@ -1,5 +1,6 @@
---
title: "Configuration Options Introduction"
+date: 2015-12-28 21:37:18 UTC
parent: "Configuration Options"
---
Drill provides many configuration options that you can enable, disable, or
@@ -87,4 +88,4 @@ The sys.options table lists the following options that you can set as a system o
| store.parquet.use_new_reader | FALSE | Not supported in this release. |
| store.partition.hash_distribute | FALSE | Uses a hash algorithm to distribute data on partition keys in a CTAS partitioning operation. An alpha option--for experimental use at this stage. Do not use in production systems. |
| store.text.estimated_row_size_bytes | 100 | Estimate of the row size in a delimited text file, such as csv. The closer to actual, the better the query plan. Used for all csv files in the system/session where the value is set. Impacts the decision to plan a broadcast join or not. |
-| window.enable | TRUE | Enable or disable window functions in Drill 1.1 and later. |
\ No newline at end of file
+| window.enable | TRUE | Enable or disable window functions in Drill 1.1 and later. |
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/configure-drill/configuration-options/020-start-up-options.md
----------------------------------------------------------------------
diff --git a/_docs/configure-drill/configuration-options/020-start-up-options.md b/_docs/configure-drill/configuration-options/020-start-up-options.md
index c925f0b..289714d 100644
--- a/_docs/configure-drill/configuration-options/020-start-up-options.md
+++ b/_docs/configure-drill/configuration-options/020-start-up-options.md
@@ -1,5 +1,6 @@
---
title: "Start-Up Options"
+date: 2015-12-28 21:37:18 UTC
parent: "Configuration Options"
---
Drill’s start-up options reside in a HOCON configuration file format, which is
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/configure-drill/configuration-options/030-planning-and-exececution-options.md
----------------------------------------------------------------------
diff --git a/_docs/configure-drill/configuration-options/030-planning-and-exececution-options.md b/_docs/configure-drill/configuration-options/030-planning-and-exececution-options.md
index 3549b7f..cc38b34 100644
--- a/_docs/configure-drill/configuration-options/030-planning-and-exececution-options.md
+++ b/_docs/configure-drill/configuration-options/030-planning-and-exececution-options.md
@@ -1,5 +1,6 @@
---
title: "Planning and Execution Options"
+date: 2015-12-28 21:37:18 UTC
parent: "Configuration Options"
---
You can set Drill query planning and execution options per cluster, at the
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/configure-drill/configuration-options/040-persistent-configuration-storage.md
----------------------------------------------------------------------
diff --git a/_docs/configure-drill/configuration-options/040-persistent-configuration-storage.md b/_docs/configure-drill/configuration-options/040-persistent-configuration-storage.md
index 2cd8046..5bd442b 100644
--- a/_docs/configure-drill/configuration-options/040-persistent-configuration-storage.md
+++ b/_docs/configure-drill/configuration-options/040-persistent-configuration-storage.md
@@ -1,5 +1,6 @@
---
title: "Persistent Configuration Storage"
+date: 2015-12-28 21:37:18 UTC
parent: "Configuration Options"
---
Drill stores persistent configuration data in a persistent configuration store
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/connect-a-data-source/010-connect-a-data-source-introduction.md
----------------------------------------------------------------------
diff --git a/_docs/connect-a-data-source/010-connect-a-data-source-introduction.md b/_docs/connect-a-data-source/010-connect-a-data-source-introduction.md
index 7e4e2b5..002c1fc 100644
--- a/_docs/connect-a-data-source/010-connect-a-data-source-introduction.md
+++ b/_docs/connect-a-data-source/010-connect-a-data-source-introduction.md
@@ -1,5 +1,6 @@
---
title: "Connect a Data Source Introduction"
+date: 2015-12-28 21:37:18 UTC
parent: "Connect a Data Source"
---
A storage plugin is a software module for connecting Drill to data sources. A storage plugin typically optimizes execution of Drill queries, provides the location of the data, and configures the workspace and file formats for reading data. Several storage plugins are installed with Drill that you can configure to suit your environment. Through a storage plugin, Drill connects to a data source, such as a database, a file on a local or distributed file system, or a Hive metastore.
@@ -17,4 +18,4 @@ data source:
In addition to the previously mentioned functions, a storage plugin performs scanner and writer functions and informs the execution engine of any native capabilities, such
-as predicate pushdown, joins, and SQL.
\ No newline at end of file
+as predicate pushdown, joins, and SQL.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/connect-a-data-source/020-storage-plugin-registration.md
----------------------------------------------------------------------
diff --git a/_docs/connect-a-data-source/020-storage-plugin-registration.md b/_docs/connect-a-data-source/020-storage-plugin-registration.md
index dc3192b..d48f195 100644
--- a/_docs/connect-a-data-source/020-storage-plugin-registration.md
+++ b/_docs/connect-a-data-source/020-storage-plugin-registration.md
@@ -1,5 +1,6 @@
---
title: "Storage Plugin Registration"
+date: 2015-12-28 21:37:18 UTC
parent: "Connect a Data Source"
---
You connect Drill to a file system, Hive, HBase, or other data source through a storage plugin. On the Storage tab of the Drill Web Console, you can view and reconfigure a storage plugin. If [HTTPS support]({{site.baseurl}}/docs/configuring-web-console-and-rest-api-security/#https-support) is not enabled (the default), go to `http://<IP address>:8047/storage` to view and configure a storage plugin. IP address is the host name or IP address of one of the installed Drillbits in a distributed system or `localhost` in an embedded system. If HTTPS support is enabled, go to `https://<IP address>:8047/storage`.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/connect-a-data-source/035-plugin-configuration-basics.md
----------------------------------------------------------------------
diff --git a/_docs/connect-a-data-source/035-plugin-configuration-basics.md b/_docs/connect-a-data-source/035-plugin-configuration-basics.md
index 46f662e..a59fdc8 100644
--- a/_docs/connect-a-data-source/035-plugin-configuration-basics.md
+++ b/_docs/connect-a-data-source/035-plugin-configuration-basics.md
@@ -1,5 +1,6 @@
---
title: "Plugin Configuration Basics"
+date: 2015-12-28 21:37:18 UTC
parent: "Storage Plugin Configuration"
---
When you add or update storage plugin configurations on one Drill node in a
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/connect-a-data-source/050-workspaces.md
----------------------------------------------------------------------
diff --git a/_docs/connect-a-data-source/050-workspaces.md b/_docs/connect-a-data-source/050-workspaces.md
old mode 100755
new mode 100644
index 080553d..bf7d0f9
--- a/_docs/connect-a-data-source/050-workspaces.md
+++ b/_docs/connect-a-data-source/050-workspaces.md
@@ -1,5 +1,6 @@
---
title: "Workspaces"
+date: 2015-12-28 21:37:18 UTC
parent: "Storage Plugin Configuration"
---
You can define one or more workspaces in a [storage plugin configuration]({{site.baseurl}}/docs/plugin-configuration-basics/). The workspace defines the location of files in subdirectories of a local or distributed file system. Drill searches the workspace to locate data when
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/connect-a-data-source/080-drill-default-input-format.md
----------------------------------------------------------------------
diff --git a/_docs/connect-a-data-source/080-drill-default-input-format.md b/_docs/connect-a-data-source/080-drill-default-input-format.md
index 4b7ae46..cc54b83 100644
--- a/_docs/connect-a-data-source/080-drill-default-input-format.md
+++ b/_docs/connect-a-data-source/080-drill-default-input-format.md
@@ -1,5 +1,6 @@
---
title: "Drill Default Input Format"
+date: 2015-12-28 21:37:18 UTC
parent: "Storage Plugin Configuration"
---
You can define a default input format to tell Drill what file type exists in a
@@ -47,4 +48,4 @@ To define a default input format for a workspace:
"writable" : true,
"defaultInputFormat" : "json"
}
-```
\ No newline at end of file
+```
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/connect-a-data-source/plugins/040-file-system-storage-plugin.md
----------------------------------------------------------------------
diff --git a/_docs/connect-a-data-source/plugins/040-file-system-storage-plugin.md b/_docs/connect-a-data-source/plugins/040-file-system-storage-plugin.md
index d142152..fec7a11 100644
--- a/_docs/connect-a-data-source/plugins/040-file-system-storage-plugin.md
+++ b/_docs/connect-a-data-source/plugins/040-file-system-storage-plugin.md
@@ -1,5 +1,6 @@
---
title: "File System Storage Plugin"
+date: 2015-12-28 21:37:18 UTC
parent: "Connect a Data Source"
---
You can register a storage plugin configuration that connects Drill to a local file system or to a distributed file system registered in the Hadoop `core-site.xml`, such as S3
@@ -96,4 +97,4 @@ configuration for each query that you issue:
If the `json_files` workspace did not exist, the query would have to include the
full file path name to the `donuts.json` file:
- SELECT * FROM dfs.`/users/max/drill/json/donuts.json` WHERE type='frosted';
\ No newline at end of file
+ SELECT * FROM dfs.`/users/max/drill/json/donuts.json` WHERE type='frosted';
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/connect-a-data-source/plugins/060-hbase-storage-plugin.md
----------------------------------------------------------------------
diff --git a/_docs/connect-a-data-source/plugins/060-hbase-storage-plugin.md b/_docs/connect-a-data-source/plugins/060-hbase-storage-plugin.md
index a09a2ee..be771a1 100644
--- a/_docs/connect-a-data-source/plugins/060-hbase-storage-plugin.md
+++ b/_docs/connect-a-data-source/plugins/060-hbase-storage-plugin.md
@@ -1,5 +1,6 @@
---
title: "HBase Storage Plugin"
+date: 2015-12-28 21:37:18 UTC
parent: "Connect a Data Source"
---
When connecting Drill to an HBase data source using the HBase storage plugin installed with Drill, you need to specify a ZooKeeper quorum. Drill supports HBase version 0.98.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/connect-a-data-source/plugins/070-hive-storage-plugin.md
----------------------------------------------------------------------
diff --git a/_docs/connect-a-data-source/plugins/070-hive-storage-plugin.md b/_docs/connect-a-data-source/plugins/070-hive-storage-plugin.md
index 62092ac..0c4b4b3 100644
--- a/_docs/connect-a-data-source/plugins/070-hive-storage-plugin.md
+++ b/_docs/connect-a-data-source/plugins/070-hive-storage-plugin.md
@@ -1,5 +1,6 @@
---
title: "Hive Storage Plugin"
+date: 2015-12-28 21:37:18 UTC
parent: "Connect a Data Source"
---
Drill 1.1 and later supports Hive 1.0. To access Hive tables
@@ -88,4 +89,4 @@ steps:
The "javax.jdo.option.ConnectionURL" might be a MySQL database that stores the metadata. The Hive metastore service provides access to the physical DB like MySQL. MySQL stores the metadata.
-After configuring a Hive storage plugin, you can [query Hive tables]({{ site.baseurl }}/docs/querying-hive/).
\ No newline at end of file
+After configuring a Hive storage plugin, you can [query Hive tables]({{ site.baseurl }}/docs/querying-hive/).
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/connect-a-data-source/plugins/080-rdbms-storage-plugin.md
----------------------------------------------------------------------
diff --git a/_docs/connect-a-data-source/plugins/080-rdbms-storage-plugin.md b/_docs/connect-a-data-source/plugins/080-rdbms-storage-plugin.md
index 570aaf1..82f5daa 100644
--- a/_docs/connect-a-data-source/plugins/080-rdbms-storage-plugin.md
+++ b/_docs/connect-a-data-source/plugins/080-rdbms-storage-plugin.md
@@ -1,5 +1,6 @@
---
title: "RDBMS Storage Plugin"
+date: 2015-12-28 21:37:18 UTC
parent: "Connect a Data Source"
---
Apache Drill supports querying a number of RDBMS instances. This allows you to connect your traditional databases to your Drill cluster so you can have a single view of both your relational and NoSQL datasources in a single system.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/connect-a-data-source/plugins/090-mongodb-storage-plugin.md
----------------------------------------------------------------------
diff --git a/_docs/connect-a-data-source/plugins/090-mongodb-storage-plugin.md b/_docs/connect-a-data-source/plugins/090-mongodb-storage-plugin.md
index daedfae..eb91e3b 100644
--- a/_docs/connect-a-data-source/plugins/090-mongodb-storage-plugin.md
+++ b/_docs/connect-a-data-source/plugins/090-mongodb-storage-plugin.md
@@ -1,5 +1,6 @@
---
title: "MongoDB Storage Plugin"
+date: 2015-12-28 21:37:18 UTC
parent: "Connect a Data Source"
---
## Overview
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/connect-a-data-source/plugins/110-s3-storage-plugin.md
----------------------------------------------------------------------
diff --git a/_docs/connect-a-data-source/plugins/110-s3-storage-plugin.md b/_docs/connect-a-data-source/plugins/110-s3-storage-plugin.md
index b7cad62..15dfd71 100644
--- a/_docs/connect-a-data-source/plugins/110-s3-storage-plugin.md
+++ b/_docs/connect-a-data-source/plugins/110-s3-storage-plugin.md
@@ -1,5 +1,6 @@
---
title: "S3 Storage Plugin"
+date: 2015-12-28 21:37:18 UTC
parent: "Connect a Data Source"
---
Drill works with data stored in the cloud. With a few simple steps, you can configure the S3 storage plugin for Drill and be off to the races running queries.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/data-sources-and-file-formats/010-data-sources-and-file-formats-introduction.md
----------------------------------------------------------------------
diff --git a/_docs/data-sources-and-file-formats/010-data-sources-and-file-formats-introduction.md b/_docs/data-sources-and-file-formats/010-data-sources-and-file-formats-introduction.md
index 5ecd859..eb09df2 100644
--- a/_docs/data-sources-and-file-formats/010-data-sources-and-file-formats-introduction.md
+++ b/_docs/data-sources-and-file-formats/010-data-sources-and-file-formats-introduction.md
@@ -1,5 +1,6 @@
---
title: "Data Sources and File Formats Introduction"
+date: 2015-12-28 21:37:18 UTC
parent: "Data Sources and File Formats"
---
Included in the data sources that Drill supports are these key data sources:
@@ -23,4 +24,4 @@ Drill supports the following input formats for data:
You set the input format for data coming from data sources to Drill in the workspace portion of the [storage plugin]({{ site.baseurl }}/docs/storage-plugin-registration) definition. The default input format in Drill is Parquet.
-You change one of the `store` property in the [sys.options table]({{ site.baseurl }}/docs/configuration-options-introduction/) to set the output format of Drill data. The default storage format for Drill CREATE TABLE AS (CTAS) statements is Parquet.
\ No newline at end of file
+You change one of the `store` property in the [sys.options table]({{ site.baseurl }}/docs/configuration-options-introduction/) to set the output format of Drill data. The default storage format for Drill CREATE TABLE AS (CTAS) statements is Parquet.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/data-sources-and-file-formats/020-hive-to-drill-data-type-mapping.md
----------------------------------------------------------------------
diff --git a/_docs/data-sources-and-file-formats/020-hive-to-drill-data-type-mapping.md b/_docs/data-sources-and-file-formats/020-hive-to-drill-data-type-mapping.md
index 5e2693d..931e83d 100644
--- a/_docs/data-sources-and-file-formats/020-hive-to-drill-data-type-mapping.md
+++ b/_docs/data-sources-and-file-formats/020-hive-to-drill-data-type-mapping.md
@@ -1,5 +1,6 @@
---
title: "Hive-to-Drill Data Type Mapping"
+date: 2015-12-28 21:37:18 UTC
parent: "Data Sources and File Formats"
---
Using Drill you can read tables created in Hive that use data types compatible with Drill. Drill currently does not support writing Hive tables. The map of SQL types and Hive types shows that several Hive types need to be cast to the supported SQL type in a Drill query:
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/data-sources-and-file-formats/030-deploying-and-using-a-hive-udf.md
----------------------------------------------------------------------
diff --git a/_docs/data-sources-and-file-formats/030-deploying-and-using-a-hive-udf.md b/_docs/data-sources-and-file-formats/030-deploying-and-using-a-hive-udf.md
index 2cd0d99..0e97d0d 100644
--- a/_docs/data-sources-and-file-formats/030-deploying-and-using-a-hive-udf.md
+++ b/_docs/data-sources-and-file-formats/030-deploying-and-using-a-hive-udf.md
@@ -1,5 +1,6 @@
---
title: "Deploying and Using a Hive UDF"
+date: 2015-12-28 21:37:18 UTC
parent: "Data Sources and File Formats"
---
If the extensive Hive functions, such as the mathematical and date functions, which Drill supports do not meet your needs, you can use a Hive UDF in Drill queries. Drill supports your existing Hive scalar UDFs. You can do queries on Hive tables and access existing Hive input/output formats, including custom serdes. Drill serves as a complement to Hive deployments by offering low latency queries.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/data-sources-and-file-formats/040-parquet-format.md
----------------------------------------------------------------------
diff --git a/_docs/data-sources-and-file-formats/040-parquet-format.md b/_docs/data-sources-and-file-formats/040-parquet-format.md
index f63d611..ca2e51d 100644
--- a/_docs/data-sources-and-file-formats/040-parquet-format.md
+++ b/_docs/data-sources-and-file-formats/040-parquet-format.md
@@ -1,5 +1,6 @@
---
title: "Parquet Format"
+date: 2015-12-28 21:37:18 UTC
parent: "Data Sources and File Formats"
---
[Apache Parquet](http://parquet.incubator.apache.org/documentation/latest) has the following characteristics:
@@ -173,4 +174,4 @@ Parquet supports the following data description languages:
* Apache Thrift
* Google Protocol Buffers
-Implement custom storage plugins to create Parquet readers/writers for formats such as Thrift.
\ No newline at end of file
+Implement custom storage plugins to create Parquet readers/writers for formats such as Thrift.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/data-sources-and-file-formats/050-json-data-model.md
----------------------------------------------------------------------
diff --git a/_docs/data-sources-and-file-formats/050-json-data-model.md b/_docs/data-sources-and-file-formats/050-json-data-model.md
index 48ea264..b64ddcc 100644
--- a/_docs/data-sources-and-file-formats/050-json-data-model.md
+++ b/_docs/data-sources-and-file-formats/050-json-data-model.md
@@ -1,5 +1,6 @@
---
title: "JSON Data Model"
+date: 2015-12-28 21:37:18 UTC
parent: "Data Sources and File Formats"
---
Drill supports [JSON (JavaScript Object Notation)](http://www.json.org/), a self-describing data format. The data itself implies its schema and has the following characteristics:
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/data-sources-and-file-formats/060-text-files-csv-tsv-psv.md
----------------------------------------------------------------------
diff --git a/_docs/data-sources-and-file-formats/060-text-files-csv-tsv-psv.md b/_docs/data-sources-and-file-formats/060-text-files-csv-tsv-psv.md
index 0fdb165..ff675ab 100644
--- a/_docs/data-sources-and-file-formats/060-text-files-csv-tsv-psv.md
+++ b/_docs/data-sources-and-file-formats/060-text-files-csv-tsv-psv.md
@@ -1,5 +1,6 @@
---
title: "Text Files: CSV, TSV, PSV"
+date: 2015-12-28 21:37:18 UTC
parent: "Data Sources and File Formats"
---
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/data-sources-and-file-formats/070-sequencefile-format.md
----------------------------------------------------------------------
diff --git a/_docs/data-sources-and-file-formats/070-sequencefile-format.md b/_docs/data-sources-and-file-formats/070-sequencefile-format.md
index 2e15d17..cb92319 100644
--- a/_docs/data-sources-and-file-formats/070-sequencefile-format.md
+++ b/_docs/data-sources-and-file-formats/070-sequencefile-format.md
@@ -1,5 +1,6 @@
---
title: "Sequence Files"
+date: 2015-12-28 21:37:18 UTC
parent: "Data Sources and File Formats"
---
@@ -41,4 +42,4 @@ simple.seq contains byte serialized strings as keys and values, we can convert t
| EXPR$0 | EXPR$1 |
+-----------+-------------+
| key0 | value0 |
- +-----------+-------------+
\ No newline at end of file
+ +-----------+-------------+
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/develop-custom-functions/010-develop-custom-functions-introduction.md
----------------------------------------------------------------------
diff --git a/_docs/develop-custom-functions/010-develop-custom-functions-introduction.md b/_docs/develop-custom-functions/010-develop-custom-functions-introduction.md
index f8cd3b8..0a8a6ac 100644
--- a/_docs/develop-custom-functions/010-develop-custom-functions-introduction.md
+++ b/_docs/develop-custom-functions/010-develop-custom-functions-introduction.md
@@ -1,5 +1,6 @@
---
title: "Develop Custom Functions Introduction"
+date: 2015-12-28 21:37:18 UTC
parent: "Develop Custom Functions"
---
Drill provides a high performance Java API with interfaces that you can
@@ -36,4 +37,4 @@ complete the following tasks:
1. Create a Java program that implements Drill’s simple or aggregate interface, and compile a sources and a classes JAR file.
2. Add the sources and classes JAR files to Drill’s classpath.
- 3. Add the name of the package that contains the classes to Drill’s main configuration file, drill-override.conf.
\ No newline at end of file
+ 3. Add the name of the package that contains the classes to Drill’s main configuration file, drill-override.conf.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/develop-custom-functions/020-developing-a-simple-function.md
----------------------------------------------------------------------
diff --git a/_docs/develop-custom-functions/020-developing-a-simple-function.md b/_docs/develop-custom-functions/020-developing-a-simple-function.md
index 83fc3ad..d73ed6b 100644
--- a/_docs/develop-custom-functions/020-developing-a-simple-function.md
+++ b/_docs/develop-custom-functions/020-developing-a-simple-function.md
@@ -1,5 +1,6 @@
---
title: "Developing a Simple Function"
+date: 2015-12-28 21:37:18 UTC
parent: "Develop Custom Functions"
---
The section presents a brief overview of developing a simple function. The [tutorial]({{site.baseurl}}/docs/tutorial-develop-a-simple-function/) in the next section covers how to create a simple function in more depth.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/develop-custom-functions/025-tutorial-develop-a-simple-function.md
----------------------------------------------------------------------
diff --git a/_docs/develop-custom-functions/025-tutorial-develop-a-simple-function.md b/_docs/develop-custom-functions/025-tutorial-develop-a-simple-function.md
index 505a7bf..efac6c5 100644
--- a/_docs/develop-custom-functions/025-tutorial-develop-a-simple-function.md
+++ b/_docs/develop-custom-functions/025-tutorial-develop-a-simple-function.md
@@ -1,5 +1,6 @@
---
title: "Tutorial: Develop a Simple Function"
+date: 2015-12-28 21:37:18 UTC
parent: "Develop Custom Functions"
---
@@ -235,4 +236,4 @@ Restart drill and run the following query on the [`employee.json`]({{site.baseur
| ***a | #######ez |
| ***erta | ####### |
+----------+------------+
- 5 rows selected (2.259 seconds)
\ No newline at end of file
+ 5 rows selected (2.259 seconds)
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/develop-custom-functions/030-developing-an-aggregate-function.md
----------------------------------------------------------------------
diff --git a/_docs/develop-custom-functions/030-developing-an-aggregate-function.md b/_docs/develop-custom-functions/030-developing-an-aggregate-function.md
index c82a202..b20d5b1 100644
--- a/_docs/develop-custom-functions/030-developing-an-aggregate-function.md
+++ b/_docs/develop-custom-functions/030-developing-an-aggregate-function.md
@@ -1,5 +1,6 @@
---
title: "Developing an Aggregate Function"
+date: 2015-12-28 21:37:18 UTC
parent: "Develop Custom Functions"
---
The API for developing aggregate custom functions is at the alpha stage and intended for experimental use only. To experiment with this API, create a class within a Java package that implements Drill’s aggregate
@@ -54,4 +55,4 @@ Complete the following steps to create an aggregate function:
5. Use the maven-source-plugin to compile the sources and classes JAR files. Verify that an empty `drill-module.conf` is included in the resources folder of the JARs.
Drill searches this module during classpath scanning. If the file is not
included in the resources folder, you can add it to the JAR file or add it to
-`etc/drill/conf`.
\ No newline at end of file
+`etc/drill/conf`.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/develop-custom-functions/040-adding-custom-functions-to-drill.md
----------------------------------------------------------------------
diff --git a/_docs/develop-custom-functions/040-adding-custom-functions-to-drill.md b/_docs/develop-custom-functions/040-adding-custom-functions-to-drill.md
index 9ae2dbb..83fa71e 100644
--- a/_docs/develop-custom-functions/040-adding-custom-functions-to-drill.md
+++ b/_docs/develop-custom-functions/040-adding-custom-functions-to-drill.md
@@ -1,5 +1,6 @@
---
title: "Adding Custom Functions to Drill"
+date: 2015-12-28 21:37:18 UTC
parent: "Develop Custom Functions"
---
After you develop your custom function and generate the sources and classes
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/develop-custom-functions/050-use-custom-functions-in-queries.md
----------------------------------------------------------------------
diff --git a/_docs/develop-custom-functions/050-use-custom-functions-in-queries.md b/_docs/develop-custom-functions/050-use-custom-functions-in-queries.md
index d95f93d..287ce71 100644
--- a/_docs/develop-custom-functions/050-use-custom-functions-in-queries.md
+++ b/_docs/develop-custom-functions/050-use-custom-functions-in-queries.md
@@ -1,5 +1,6 @@
---
title: "Using Custom Functions in Queries"
+date: 2015-12-28 21:37:18 UTC
parent: "Develop Custom Functions"
---
When you issue a query with a custom function to Drill, Drill searches the
@@ -52,4 +53,4 @@ The query returns the following results:
| 28 |
| 36 |
+------------+
- …
\ No newline at end of file
+ …
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/develop-custom-functions/060-custom-function-interfaces.md
----------------------------------------------------------------------
diff --git a/_docs/develop-custom-functions/060-custom-function-interfaces.md b/_docs/develop-custom-functions/060-custom-function-interfaces.md
index 4183ac8..17919e0 100644
--- a/_docs/develop-custom-functions/060-custom-function-interfaces.md
+++ b/_docs/develop-custom-functions/060-custom-function-interfaces.md
@@ -1,5 +1,6 @@
---
title: "Custom Function Interfaces"
+date: 2015-12-28 21:37:18 UTC
parent: "Develop Custom Functions"
---
Implement the Drill interface appropriate for the type of function that you
@@ -152,4 +153,4 @@ The following example shows the program created for the `mysecondmin` function:
secondMin.value = 0;
}
- }
\ No newline at end of file
+ }
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/developer-information/009-rest-api.md
----------------------------------------------------------------------
diff --git a/_docs/developer-information/009-rest-api.md b/_docs/developer-information/009-rest-api.md
index 5900de5..afb5e28 100644
--- a/_docs/developer-information/009-rest-api.md
+++ b/_docs/developer-information/009-rest-api.md
@@ -1,5 +1,6 @@
---
title: "REST API"
+date: 2015-12-28 21:37:18 UTC
parent: "Developer Information"
---
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/developer-information/contribute-to-drill/010-apache-drill-contribution-guidelines.md
----------------------------------------------------------------------
diff --git a/_docs/developer-information/contribute-to-drill/010-apache-drill-contribution-guidelines.md b/_docs/developer-information/contribute-to-drill/010-apache-drill-contribution-guidelines.md
index d9812a5..7bd8584 100644
--- a/_docs/developer-information/contribute-to-drill/010-apache-drill-contribution-guidelines.md
+++ b/_docs/developer-information/contribute-to-drill/010-apache-drill-contribution-guidelines.md
@@ -1,5 +1,6 @@
---
title: "Apache Drill Contribution Guidelines"
+date: 2015-12-28 21:37:18 UTC
parent: "Contribute to Drill"
---
Disclaimer: These contribution guidelines are largely based on Apache Hive
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/developer-information/contribute-to-drill/020-apache-drill-contribution-ideas.md
----------------------------------------------------------------------
diff --git a/_docs/developer-information/contribute-to-drill/020-apache-drill-contribution-ideas.md b/_docs/developer-information/contribute-to-drill/020-apache-drill-contribution-ideas.md
index a4ef0b8..a19cb63 100644
--- a/_docs/developer-information/contribute-to-drill/020-apache-drill-contribution-ideas.md
+++ b/_docs/developer-information/contribute-to-drill/020-apache-drill-contribution-ideas.md
@@ -1,5 +1,6 @@
---
title: "Apache Drill Contribution Ideas"
+date: 2015-12-28 21:37:18 UTC
parent: "Contribute to Drill"
---
* Fixing JIRAs
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/developer-information/design-docs/010-drill-plan-syntax.md
----------------------------------------------------------------------
diff --git a/_docs/developer-information/design-docs/010-drill-plan-syntax.md b/_docs/developer-information/design-docs/010-drill-plan-syntax.md
index 67e2290..0e68163 100644
--- a/_docs/developer-information/design-docs/010-drill-plan-syntax.md
+++ b/_docs/developer-information/design-docs/010-drill-plan-syntax.md
@@ -1,5 +1,6 @@
---
title: "Drill Plan Syntax"
+date: 2015-12-28 21:37:18 UTC
parent: "Design Docs"
---
### Whats the plan?
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/developer-information/design-docs/020-rpc-overview.md
----------------------------------------------------------------------
diff --git a/_docs/developer-information/design-docs/020-rpc-overview.md b/_docs/developer-information/design-docs/020-rpc-overview.md
index 05cb1d6..1935577 100644
--- a/_docs/developer-information/design-docs/020-rpc-overview.md
+++ b/_docs/developer-information/design-docs/020-rpc-overview.md
@@ -1,5 +1,6 @@
---
title: "RPC Overview"
+date: 2015-12-28 21:37:18 UTC
parent: "Design Docs"
---
Drill leverages the Netty 4 project as an RPC underlayment. From there, we
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/developer-information/design-docs/030-query-stages.md
----------------------------------------------------------------------
diff --git a/_docs/developer-information/design-docs/030-query-stages.md b/_docs/developer-information/design-docs/030-query-stages.md
index 5c54249..5a7e5a5 100644
--- a/_docs/developer-information/design-docs/030-query-stages.md
+++ b/_docs/developer-information/design-docs/030-query-stages.md
@@ -1,5 +1,6 @@
---
title: "Query Stages"
+date: 2015-12-28 21:37:18 UTC
parent: "Design Docs"
---
## Overview
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/developer-information/design-docs/040-useful-research.md
----------------------------------------------------------------------
diff --git a/_docs/developer-information/design-docs/040-useful-research.md b/_docs/developer-information/design-docs/040-useful-research.md
index 03b104a..13c65eb 100644
--- a/_docs/developer-information/design-docs/040-useful-research.md
+++ b/_docs/developer-information/design-docs/040-useful-research.md
@@ -1,5 +1,6 @@
---
title: "Useful Research"
+date: 2015-12-28 21:37:19 UTC
parent: "Design Docs"
---
## Drill itself
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/developer-information/design-docs/050-value-vectors.md
----------------------------------------------------------------------
diff --git a/_docs/developer-information/design-docs/050-value-vectors.md b/_docs/developer-information/design-docs/050-value-vectors.md
index ebd1ea3..1564d00 100644
--- a/_docs/developer-information/design-docs/050-value-vectors.md
+++ b/_docs/developer-information/design-docs/050-value-vectors.md
@@ -1,5 +1,6 @@
---
title: "Value Vectors"
+date: 2015-12-28 21:37:19 UTC
parent: "Design Docs"
---
This document defines the data structures required for passing sequences of
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/developer-information/develop-drill/010-compiling-drill-from-source.md
----------------------------------------------------------------------
diff --git a/_docs/developer-information/develop-drill/010-compiling-drill-from-source.md b/_docs/developer-information/develop-drill/010-compiling-drill-from-source.md
index a10a842..f5240ca 100644
--- a/_docs/developer-information/develop-drill/010-compiling-drill-from-source.md
+++ b/_docs/developer-information/develop-drill/010-compiling-drill-from-source.md
@@ -1,5 +1,6 @@
---
title: "Compiling Drill from Source"
+date: 2015-12-28 21:37:19 UTC
parent: "Develop Drill"
---
To develop Drill, you compile Drill from source code and then set up a project
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/developer-information/develop-drill/020-drill-patch-review-tool.md
----------------------------------------------------------------------
diff --git a/_docs/developer-information/develop-drill/020-drill-patch-review-tool.md b/_docs/developer-information/develop-drill/020-drill-patch-review-tool.md
index e2302f7..9a0f8f0 100644
--- a/_docs/developer-information/develop-drill/020-drill-patch-review-tool.md
+++ b/_docs/developer-information/develop-drill/020-drill-patch-review-tool.md
@@ -1,5 +1,6 @@
---
title: "Drill Patch Review Tool"
+date: 2015-12-28 21:37:19 UTC
parent: "Develop Drill"
---
* Drill JIRA and Reviewboard script
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/getting-started/010-drill-introduction.md
----------------------------------------------------------------------
diff --git a/_docs/getting-started/010-drill-introduction.md b/_docs/getting-started/010-drill-introduction.md
index 4519b86..2dd980b 100644
--- a/_docs/getting-started/010-drill-introduction.md
+++ b/_docs/getting-started/010-drill-introduction.md
@@ -1,5 +1,6 @@
---
title: "Drill Introduction"
+date: 2015-12-28 21:37:19 UTC
parent: "Getting Started"
---
Drill is an Apache open-source SQL query engine for Big Data exploration.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/getting-started/020-why-drill.md
----------------------------------------------------------------------
diff --git a/_docs/getting-started/020-why-drill.md b/_docs/getting-started/020-why-drill.md
index f0dee66..4b06322 100644
--- a/_docs/getting-started/020-why-drill.md
+++ b/_docs/getting-started/020-why-drill.md
@@ -1,5 +1,6 @@
---
title: "Why Drill"
+date: 2015-12-28 21:37:19 UTC
parent: "Getting Started"
---
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/install/010-install-drill-introduction.md
----------------------------------------------------------------------
diff --git a/_docs/install/010-install-drill-introduction.md b/_docs/install/010-install-drill-introduction.md
index fe1b1fd..0d4b129 100644
--- a/_docs/install/010-install-drill-introduction.md
+++ b/_docs/install/010-install-drill-introduction.md
@@ -1,5 +1,6 @@
---
title: "Install Drill Introduction"
+date: 2015-12-28 21:37:19 UTC
parent: "Install Drill"
---
@@ -7,4 +8,4 @@ If you installed Drill 1.2 or earlier and generated Parquet files, you need to [
You can install Drill in either embedded mode or distributed mode. Installing
Drill in embedded mode does not require any configuration. To use Drill in a
-clustered Hadoop environment, install Drill in distributed mode. You need to perform some configuration after installing Drill in distributed mode. After you complete these tasks, connect Drill to your Hive, HBase, or distributed file system data sources, and run queries on them.
\ No newline at end of file
+clustered Hadoop environment, install Drill in distributed mode. You need to perform some configuration after installing Drill in distributed mode. After you complete these tasks, connect Drill to your Hive, HBase, or distributed file system data sources, and run queries on them.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/install/020-migrating-parquet-data.md
----------------------------------------------------------------------
diff --git a/_docs/install/020-migrating-parquet-data.md b/_docs/install/020-migrating-parquet-data.md
old mode 100755
new mode 100644
index c7baf17..5eb15e9
--- a/_docs/install/020-migrating-parquet-data.md
+++ b/_docs/install/020-migrating-parquet-data.md
@@ -1,5 +1,6 @@
---
title: "Migrating Parquet Data"
+date: 2015-12-28 21:37:19 UTC
parent: "Install Drill"
---
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/install/045-distributed-mode-prerequisites.md
----------------------------------------------------------------------
diff --git a/_docs/install/045-distributed-mode-prerequisites.md b/_docs/install/045-distributed-mode-prerequisites.md
index 8274389..74b703c 100644
--- a/_docs/install/045-distributed-mode-prerequisites.md
+++ b/_docs/install/045-distributed-mode-prerequisites.md
@@ -1,5 +1,6 @@
---
title: "Distributed Mode Prerequisites"
+date: 2015-12-28 21:37:19 UTC
parent: "Installing Drill in Distributed Mode"
---
You can install Apache Drill on one or more nodes to
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/install/047-installing-drill-on-the-cluster.md
----------------------------------------------------------------------
diff --git a/_docs/install/047-installing-drill-on-the-cluster.md b/_docs/install/047-installing-drill-on-the-cluster.md
index 3f02692..a7f398f 100644
--- a/_docs/install/047-installing-drill-on-the-cluster.md
+++ b/_docs/install/047-installing-drill-on-the-cluster.md
@@ -1,5 +1,6 @@
---
title: "Installing Drill on the Cluster"
+date: 2015-12-28 21:37:19 UTC
parent: "Installing Drill in Distributed Mode"
---
You install Drill on nodes in the cluster, and then configure a cluster ID and add Zookeeper information, as described in the following steps:
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/install/050-starting-drill-in-distributed-mode.md
----------------------------------------------------------------------
diff --git a/_docs/install/050-starting-drill-in-distributed-mode.md b/_docs/install/050-starting-drill-in-distributed-mode.md
index 9bdae82..dfca3ca 100644
--- a/_docs/install/050-starting-drill-in-distributed-mode.md
+++ b/_docs/install/050-starting-drill-in-distributed-mode.md
@@ -1,5 +1,6 @@
---
title: Starting Drill in Distributed Mode
+date: 2015-12-28 21:37:19 UTC
parent: "Installing Drill in Distributed Mode"
---
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/install/060-starting-the-web-ui.md
----------------------------------------------------------------------
diff --git a/_docs/install/060-starting-the-web-ui.md b/_docs/install/060-starting-the-web-ui.md
index 0da623a..1709984 100644
--- a/_docs/install/060-starting-the-web-ui.md
+++ b/_docs/install/060-starting-the-web-ui.md
@@ -1,5 +1,6 @@
---
title: Starting the Web Console
+date: 2015-12-28 21:37:19 UTC
parent: Install Drill
---
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/install/installing-drill-in-embedded-mode/010-embedded-mode-prerequisites.md
----------------------------------------------------------------------
diff --git a/_docs/install/installing-drill-in-embedded-mode/010-embedded-mode-prerequisites.md b/_docs/install/installing-drill-in-embedded-mode/010-embedded-mode-prerequisites.md
index 920dca3..6f0dbda 100644
--- a/_docs/install/installing-drill-in-embedded-mode/010-embedded-mode-prerequisites.md
+++ b/_docs/install/installing-drill-in-embedded-mode/010-embedded-mode-prerequisites.md
@@ -1,5 +1,6 @@
---
title: "Embedded Mode Prerequisites"
+date: 2015-12-28 21:37:19 UTC
parent: "Installing Drill in Embedded Mode"
---
Installing Drill in embedded mode installs Drill locally on your machine.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/install/installing-drill-in-embedded-mode/020-installing-drill-on-linux-and-mac-os-x.md
----------------------------------------------------------------------
diff --git a/_docs/install/installing-drill-in-embedded-mode/020-installing-drill-on-linux-and-mac-os-x.md b/_docs/install/installing-drill-in-embedded-mode/020-installing-drill-on-linux-and-mac-os-x.md
old mode 100755
new mode 100644
index 4a38a00..4b81b92
--- a/_docs/install/installing-drill-in-embedded-mode/020-installing-drill-on-linux-and-mac-os-x.md
+++ b/_docs/install/installing-drill-in-embedded-mode/020-installing-drill-on-linux-and-mac-os-x.md
@@ -1,5 +1,6 @@
---
title: "Installing Drill on Linux and Mac OS X"
+date: 2015-12-28 21:37:19 UTC
parent: "Installing Drill in Embedded Mode"
---
First, check that you [meet the prerequisites]({{site.baseurl}}/docs/embedded-mode-prerequisites), and then install Apache Drill on Linux or Mac OS X:
@@ -18,4 +19,4 @@ Complete the following steps to install Drill:
`tar -xvzf <.tar.gz file name>`
-The extraction process creates the installation directory containing the Drill software. You can now [start Drill]({{site.baseurl}}/docs/starting-drill-on-linux-and-mac-os-x).
\ No newline at end of file
+The extraction process creates the installation directory containing the Drill software. You can now [start Drill]({{site.baseurl}}/docs/starting-drill-on-linux-and-mac-os-x).
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/install/installing-drill-in-embedded-mode/030-starting-drill-on-linux-and-mac-os-x.md
----------------------------------------------------------------------
diff --git a/_docs/install/installing-drill-in-embedded-mode/030-starting-drill-on-linux-and-mac-os-x.md b/_docs/install/installing-drill-in-embedded-mode/030-starting-drill-on-linux-and-mac-os-x.md
index b69626c..c404eb7 100644
--- a/_docs/install/installing-drill-in-embedded-mode/030-starting-drill-on-linux-and-mac-os-x.md
+++ b/_docs/install/installing-drill-in-embedded-mode/030-starting-drill-on-linux-and-mac-os-x.md
@@ -1,5 +1,6 @@
---
title: "Starting Drill on Linux and Mac OS X"
+date: 2015-12-28 21:37:19 UTC
parent: "Installing Drill in Embedded Mode"
---
To start the Drill shell in embedded mode, use the `drill-embedded` command. Internally, the command uses a jdbc connection string and identifies the local node as the ZooKeeper node. Complete the following steps to start the Drill shell:
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/install/installing-drill-in-embedded-mode/040-installing-drill-on-windows.md
----------------------------------------------------------------------
diff --git a/_docs/install/installing-drill-in-embedded-mode/040-installing-drill-on-windows.md b/_docs/install/installing-drill-in-embedded-mode/040-installing-drill-on-windows.md
old mode 100755
new mode 100644
index d288038..443e749
--- a/_docs/install/installing-drill-in-embedded-mode/040-installing-drill-on-windows.md
+++ b/_docs/install/installing-drill-in-embedded-mode/040-installing-drill-on-windows.md
@@ -1,5 +1,6 @@
---
title: "Installing Drill on Windows"
+date: 2015-12-28 21:37:19 UTC
parent: "Installing Drill in Embedded Mode"
---
First, check that you [meet the prerequisites]({{site.baseurl}}/docs/embedded-mode-prerequisites), including setting the JAVA_HOME environment variable, and then install Drill. Complete the following steps to install Drill:
@@ -8,4 +9,4 @@ First, check that you [meet the prerequisites]({{site.baseurl}}/docs/embedded-mo
2. Move the downloaded file to a directory where you want to install Drill.
3. Unzip the GZ file using a third-party tool. If the tool you use does not unzip the underlying TAR file as well as the GZ file, perform a second unzip to extract the Drill software. The extraction process creates the installation directory containing the Drill software.
-At this point, you can [start Drill]({{site.baseurl}}/docs/starting-drill-on-windows).
\ No newline at end of file
+At this point, you can [start Drill]({{site.baseurl}}/docs/starting-drill-on-windows).
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/install/installing-drill-in-embedded-mode/050-starting-drill-on-windows.md
----------------------------------------------------------------------
diff --git a/_docs/install/installing-drill-in-embedded-mode/050-starting-drill-on-windows.md b/_docs/install/installing-drill-in-embedded-mode/050-starting-drill-on-windows.md
index 181c223..4197ee1 100644
--- a/_docs/install/installing-drill-in-embedded-mode/050-starting-drill-on-windows.md
+++ b/_docs/install/installing-drill-in-embedded-mode/050-starting-drill-on-windows.md
@@ -1,5 +1,6 @@
---
title: "Starting Drill on Windows"
+date: 2015-12-28 21:37:19 UTC
parent: "Installing Drill in Embedded Mode"
---
Start the Drill shell using the **sqlline command**. Complete the following steps to launch the Drill shell:
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/log-and-debug/001-log-and-debug-introduction.md
----------------------------------------------------------------------
diff --git a/_docs/log-and-debug/001-log-and-debug-introduction.md b/_docs/log-and-debug/001-log-and-debug-introduction.md
index 555ceab..cedabee 100644
--- a/_docs/log-and-debug/001-log-and-debug-introduction.md
+++ b/_docs/log-and-debug/001-log-and-debug-introduction.md
@@ -1,5 +1,6 @@
---
title: "Log and Debug Introduction"
+date: 2015-12-28 21:37:19 UTC
parent: "Log and Debug"
---
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/log-and-debug/002-error-messages.md
----------------------------------------------------------------------
diff --git a/_docs/log-and-debug/002-error-messages.md b/_docs/log-and-debug/002-error-messages.md
index 78a9d1e..59cd72b 100644
--- a/_docs/log-and-debug/002-error-messages.md
+++ b/_docs/log-and-debug/002-error-messages.md
@@ -1,5 +1,6 @@
---
title: "Error Messages"
+date: 2015-12-28 21:37:19 UTC
parent: "Log and Debug"
---
@@ -22,4 +23,4 @@ The following table provides descriptions for the IDs included in a thread:
|-----------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| QueryID | The identifier assigned to the query. You can locate a query in Drill Web Console by the QueryID and then cancel the query if needed. See [Query Profiles]({{ site.baseurl }}/docs/query-profiles/). |
| MajorFragmentID | The identifier assigned to a major fragment. Major fragments map to the physical plan. You can see major fragment activity for a query in the Drill Web Console. See [Query Profiles]({{ site.baseurl }}/docs/query-profiles) for more information. |
-| MinorFragmentID | The identifier assigned to the minor fragment. Minor fragments map to the parallelization of major fragments. See [Query Profiles]({{ site.baseurl }}/docs/query-profiles). |
\ No newline at end of file
+| MinorFragmentID | The identifier assigned to the minor fragment. Minor fragments map to the parallelization of major fragments. See [Query Profiles]({{ site.baseurl }}/docs/query-profiles). |
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/log-and-debug/003-modify-logback.xml.md
----------------------------------------------------------------------
diff --git a/_docs/log-and-debug/003-modify-logback.xml.md b/_docs/log-and-debug/003-modify-logback.xml.md
index ca506ad..b910409 100644
--- a/_docs/log-and-debug/003-modify-logback.xml.md
+++ b/_docs/log-and-debug/003-modify-logback.xml.md
@@ -1,5 +1,6 @@
---
title: "Modify logback.xml"
+date: 2015-12-28 21:37:19 UTC
parent: "Log and Debug"
---
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/log-and-debug/004-review-the-java-stack-trace.md
----------------------------------------------------------------------
diff --git a/_docs/log-and-debug/004-review-the-java-stack-trace.md b/_docs/log-and-debug/004-review-the-java-stack-trace.md
index 3b74397..0b21546 100644
--- a/_docs/log-and-debug/004-review-the-java-stack-trace.md
+++ b/_docs/log-and-debug/004-review-the-java-stack-trace.md
@@ -1,5 +1,6 @@
---
title: "Review the Java Stack Trace"
+date: 2015-12-28 21:37:19 UTC
parent: "Log and Debug"
---
@@ -38,4 +39,4 @@ Once you have the Drillbit process ID, you can use jstack to view the stack trac
"2ae226e1-f4c5-6253-e9ff-22ac1204935f:frag:3:2" daemon prio=10 tid=0x00007fa81167b800 nid=0x1431 waiting on condition [0x00007fa7aa3b3000]
"2ae226e1-f4c5-6253-e9ff-22ac1204935f:frag:2:2" daemon prio=10 tid=0x0000000004582000 nid=0x1430 waiting on condition [0x00007fa7a7bae000]
…
-
\ No newline at end of file
+
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/log-and-debug/005-query-audit-logging.md
----------------------------------------------------------------------
diff --git a/_docs/log-and-debug/005-query-audit-logging.md b/_docs/log-and-debug/005-query-audit-logging.md
index 884d52d..915db7e 100644
--- a/_docs/log-and-debug/005-query-audit-logging.md
+++ b/_docs/log-and-debug/005-query-audit-logging.md
@@ -1,5 +1,6 @@
---
title: "Query Audit Logging"
+date: 2015-12-28 21:37:19 UTC
parent: "Log and Debug"
---
The query log provides audit log functionality for the queries executed by various drillbits in the cluster. The log records important information about queries executed on the Drillbit where Drill runs. The log includes query text, start time, end time, user, status, schema, and the query id. You can query one of the following log files, depending on whether you run Drill in embedded or distributed mode, to get audit logging information:
@@ -53,4 +54,4 @@ To get the total number of successful and failed executions, run the following c
+------------+---------+
2 rows selected (0.219 seconds)
-Note the queryid column in the audit can be correlated with the profiles of the queries for troubleshooting/diagnostics purposes.
\ No newline at end of file
+Note the queryid column in the audit can be correlated with the profiles of the queries for troubleshooting/diagnostics purposes.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/odbc-jdbc-interfaces/010-interfaces-introduction.md
----------------------------------------------------------------------
diff --git a/_docs/odbc-jdbc-interfaces/010-interfaces-introduction.md b/_docs/odbc-jdbc-interfaces/010-interfaces-introduction.md
index 025490c..3fbc493 100644
--- a/_docs/odbc-jdbc-interfaces/010-interfaces-introduction.md
+++ b/_docs/odbc-jdbc-interfaces/010-interfaces-introduction.md
@@ -1,5 +1,6 @@
---
title: "Interfaces Introduction"
+date: 2015-12-28 21:37:19 UTC
parent: "ODBC/JDBC Interfaces"
---
You can connect to Apache Drill through the following interfaces:
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/odbc-jdbc-interfaces/015-using-jdbc-driver.md
----------------------------------------------------------------------
diff --git a/_docs/odbc-jdbc-interfaces/015-using-jdbc-driver.md b/_docs/odbc-jdbc-interfaces/015-using-jdbc-driver.md
old mode 100755
new mode 100644
index cabe485..270da0a
--- a/_docs/odbc-jdbc-interfaces/015-using-jdbc-driver.md
+++ b/_docs/odbc-jdbc-interfaces/015-using-jdbc-driver.md
@@ -1,5 +1,6 @@
---
title: "Using the JDBC Driver"
+date: 2015-12-28 21:37:19 UTC
parent: "ODBC/JDBC Interfaces"
---
This section explains how to install and use the JDBC driver for Apache Drill. To use the JDBC driver, you have to:
@@ -106,4 +107,4 @@ ResultSet rs = st.executeQuery("SELECT * from cp.`employee`");
while(rs.next()){
System.out.println(rs.getString(1));
}
-```
\ No newline at end of file
+```
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/odbc-jdbc-interfaces/020-using-jdbc-with-squirrel-on-windows.md
----------------------------------------------------------------------
diff --git a/_docs/odbc-jdbc-interfaces/020-using-jdbc-with-squirrel-on-windows.md b/_docs/odbc-jdbc-interfaces/020-using-jdbc-with-squirrel-on-windows.md
old mode 100755
new mode 100644
index f604dfe..3727421
--- a/_docs/odbc-jdbc-interfaces/020-using-jdbc-with-squirrel-on-windows.md
+++ b/_docs/odbc-jdbc-interfaces/020-using-jdbc-with-squirrel-on-windows.md
@@ -1,5 +1,6 @@
---
title: "Using JDBC with SQuirreL on Windows"
+date: 2015-12-28 21:37:19 UTC
parent: "ODBC/JDBC Interfaces"
---
To use the JDBC Driver to access Drill through SQuirreL, ensure that you meet the prerequisites and follow the steps in this section.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/odbc-jdbc-interfaces/configuring-odbc/010-odbc-configuration-reference.md
----------------------------------------------------------------------
diff --git a/_docs/odbc-jdbc-interfaces/configuring-odbc/010-odbc-configuration-reference.md b/_docs/odbc-jdbc-interfaces/configuring-odbc/010-odbc-configuration-reference.md
index 891d287..204f726 100644
--- a/_docs/odbc-jdbc-interfaces/configuring-odbc/010-odbc-configuration-reference.md
+++ b/_docs/odbc-jdbc-interfaces/configuring-odbc/010-odbc-configuration-reference.md
@@ -1,5 +1,6 @@
---
title: "ODBC Configuration Reference"
+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/020-configuring-odbc-on-linux.md
----------------------------------------------------------------------
diff --git a/_docs/odbc-jdbc-interfaces/configuring-odbc/020-configuring-odbc-on-linux.md b/_docs/odbc-jdbc-interfaces/configuring-odbc/020-configuring-odbc-on-linux.md
index ba1e88b..bbacf7f 100644
--- a/_docs/odbc-jdbc-interfaces/configuring-odbc/020-configuring-odbc-on-linux.md
+++ b/_docs/odbc-jdbc-interfaces/configuring-odbc/020-configuring-odbc-on-linux.md
@@ -1,5 +1,6 @@
---
title: "Configuring ODBC on Linux"
+date: 2015-12-28 21:37:19 UTC
parent: "Configuring ODBC"
---
ODBC driver managers use configuration files to define and configure ODBC data
[2/4] drill git commit: add date to front matter
Posted by kr...@apache.org.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sql-reference/sql-commands/087-union-set-operator.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-commands/087-union-set-operator.md b/_docs/sql-reference/sql-commands/087-union-set-operator.md
index b672957..2401f43 100644
--- a/_docs/sql-reference/sql-commands/087-union-set-operator.md
+++ b/_docs/sql-reference/sql-commands/087-union-set-operator.md
@@ -1,5 +1,6 @@
---
title: "UNION Set Operator"
+date: 2015-12-28 21:37:20 UTC
parent: "SQL Commands"
---
The UNION set operator combines the result sets of two separate query expressions. The result set of each query must have the same number of columns and compatible data types. UNION automatically removes duplicate records from the result set. UNION ALL returns all duplicate records.
@@ -41,4 +42,4 @@ The following example uses the UNION ALL set operator to combine click activity
| 37838 | 18737 |
+-------------+------------+
-This UNION ALL query returns rows that exist in two files (and includes any duplicate rows from those files): `clicks.campaign.json` and `clicks.json`
\ No newline at end of file
+This UNION ALL query returns rows that exist in two files (and includes any duplicate rows from those files): `clicks.campaign.json` and `clicks.json`
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sql-reference/sql-commands/088-where-clause.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-commands/088-where-clause.md b/_docs/sql-reference/sql-commands/088-where-clause.md
old mode 100755
new mode 100644
index 18a9c7d..20bb2cc
--- a/_docs/sql-reference/sql-commands/088-where-clause.md
+++ b/_docs/sql-reference/sql-commands/088-where-clause.md
@@ -1,5 +1,6 @@
---
title: "WHERE Clause"
+date: 2015-12-28 21:37:20 UTC
parent: "SQL Commands"
---
The WHERE clause selects rows based on a boolean expression. Only rows for which the expression evaluates to TRUE are returned in the result.
@@ -70,4 +71,4 @@ The following query uses a workspace named `dfw.views` and joins a view named
| "silver" | 708438 |
| "gold" | 2787682 |
+------------+------------+
- 3 rows selected
\ No newline at end of file
+ 3 rows selected
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sql-reference/sql-commands/089-with-clause.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-commands/089-with-clause.md b/_docs/sql-reference/sql-commands/089-with-clause.md
old mode 100755
new mode 100644
index 41c2cc7..1b36d8e
--- a/_docs/sql-reference/sql-commands/089-with-clause.md
+++ b/_docs/sql-reference/sql-commands/089-with-clause.md
@@ -1,5 +1,6 @@
---
title: "WITH Clause"
+date: 2015-12-28 21:37:20 UTC
parent: "SQL Commands"
---
The WITH clause is an optional clause used to contain one or more common table
@@ -90,4 +91,4 @@ duration of the query.
| Shauna Wyro | Store Manager | 15000.0 | 1994-12-01 00:00:00.0 |
| Roberta Damstra | VP Information Systems | 25000.0 | 1994-12-01 00:00:00.0 |
| Pedro Castillo | VP Country Manager | 35000.0 | 1994-12-01 00:00:00.0 |
- +------------+----------------+--------------+------------------------------------+
\ No newline at end of file
+ +------------+----------------+--------------+------------------------------------+
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sql-reference/sql-commands/090-show-databases-and-show-schemas.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-commands/090-show-databases-and-show-schemas.md b/_docs/sql-reference/sql-commands/090-show-databases-and-show-schemas.md
index 43d6c55..dd86b42 100644
--- a/_docs/sql-reference/sql-commands/090-show-databases-and-show-schemas.md
+++ b/_docs/sql-reference/sql-commands/090-show-databases-and-show-schemas.md
@@ -1,5 +1,6 @@
---
title: "SHOW DATABASES and SHOW SCHEMAS"
+date: 2015-12-28 21:37:20 UTC
parent: "SQL Commands"
---
The SHOW DATABASES and SHOW SCHEMAS commands generate a list of available Drill schemas that you can query.
@@ -57,4 +58,4 @@ The following example uses the SHOW DATABASES and SHOW SCHEMAS commands to gener
| sys |
| INFORMATION_SCHEMA |
+-------------+
- 9 rows selected (0.058 seconds)
\ No newline at end of file
+ 9 rows selected (0.058 seconds)
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sql-reference/sql-commands/100-show-files.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-commands/100-show-files.md b/_docs/sql-reference/sql-commands/100-show-files.md
index 1d7e0f9..95e01e6 100644
--- a/_docs/sql-reference/sql-commands/100-show-files.md
+++ b/_docs/sql-reference/sql-commands/100-show-files.md
@@ -1,5 +1,6 @@
---
title: "SHOW FILES"
+date: 2015-12-28 21:37:20 UTC
parent: "SQL Commands"
---
The SHOW FILES command provides a quick report of the file systems that are
@@ -62,4 +63,4 @@ file system:
| products.csv | false | true | 34972 | root | root | rw-r--r-- | 2014-08-01 06:39:34.0 | 2014-08-04 15:58:09.325 |
| products.csv.bad | false | true | 62307 | root | root | rw-r--r-- | 2014-08-04 15:58:02.0 | 2014-08-04 15:58:02.612 |
+------------+-------------+------------+------------+------------+------------+-------------+------------+------------------+
- 4 rows selected (0.165 seconds)
\ No newline at end of file
+ 4 rows selected (0.165 seconds)
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sql-reference/sql-commands/110-show-tables.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-commands/110-show-tables.md b/_docs/sql-reference/sql-commands/110-show-tables.md
index d7a8159..40ea4e1 100644
--- a/_docs/sql-reference/sql-commands/110-show-tables.md
+++ b/_docs/sql-reference/sql-commands/110-show-tables.md
@@ -1,5 +1,6 @@
---
title: "SHOW TABLES"
+date: 2015-12-28 21:37:20 UTC
parent: "SQL Commands"
---
The SHOW TABLES command returns a list of views created within a schema. It
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sql-reference/sql-commands/120-use.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-commands/120-use.md b/_docs/sql-reference/sql-commands/120-use.md
index 86464de..1394704 100644
--- a/_docs/sql-reference/sql-commands/120-use.md
+++ b/_docs/sql-reference/sql-commands/120-use.md
@@ -1,5 +1,6 @@
---
title: "USE"
+date: 2015-12-28 21:37:20 UTC
parent: "SQL Commands"
---
The USE command changes the schema context to the specified schema. When you
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sql-reference/sql-conditional-expressions/010-case-expression.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-conditional-expressions/010-case-expression.md b/_docs/sql-reference/sql-conditional-expressions/010-case-expression.md
index 9336b1c..a71bc4e 100644
--- a/_docs/sql-reference/sql-conditional-expressions/010-case-expression.md
+++ b/_docs/sql-reference/sql-conditional-expressions/010-case-expression.md
@@ -1,5 +1,6 @@
---
title: "CASE"
+date: 2015-12-28 21:37:20 UTC
parent: "SQL Conditional Expressions"
---
Executes statements based on one or more equality conditions.
@@ -46,4 +47,4 @@ The employee having an ID of 99 is Elizabeth Horne. The employee having a ID of
| 100 | Hunt |
| 101 | ID too high |
+-------------+------------+
- 3 rows selected (0.199 seconds)
\ No newline at end of file
+ 3 rows selected (0.199 seconds)
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sql-reference/sql-functions/005-about-sql-function-examples.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-functions/005-about-sql-function-examples.md b/_docs/sql-reference/sql-functions/005-about-sql-function-examples.md
index 5f60b47..85a0e0c 100644
--- a/_docs/sql-reference/sql-functions/005-about-sql-function-examples.md
+++ b/_docs/sql-reference/sql-functions/005-about-sql-function-examples.md
@@ -1,5 +1,6 @@
---
title: "About SQL Function Examples"
+date: 2015-12-28 21:37:20 UTC
parent: "SQL Functions"
---
-You need to use a FROM clause in Drill queries. You can use the VALUES clause in the FROM clause to define rows of data in a derived table. The derived table has statement level scope.
\ No newline at end of file
+You need to use a FROM clause in Drill queries. You can use the VALUES clause in the FROM clause to define rows of data in a derived table. The derived table has statement level scope.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sql-reference/sql-functions/010-math-and-trig.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-functions/010-math-and-trig.md b/_docs/sql-reference/sql-functions/010-math-and-trig.md
index bcec990..8944825 100644
--- a/_docs/sql-reference/sql-functions/010-math-and-trig.md
+++ b/_docs/sql-reference/sql-functions/010-math-and-trig.md
@@ -1,5 +1,6 @@
---
title: "Math and Trig"
+date: 2015-12-28 21:37:20 UTC
parent: "SQL Functions"
---
Drill supports the math functions shown in the following table of math functions plus trig functions listed at the end of this section. Most math functions and all trig functions take these input types:
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sql-reference/sql-functions/020-data-type-conversion.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-functions/020-data-type-conversion.md b/_docs/sql-reference/sql-functions/020-data-type-conversion.md
index 25dc37b..a601b28 100644
--- a/_docs/sql-reference/sql-functions/020-data-type-conversion.md
+++ b/_docs/sql-reference/sql-functions/020-data-type-conversion.md
@@ -1,5 +1,6 @@
---
title: "Data Type Conversion"
+date: 2015-12-28 21:37:20 UTC
parent: "SQL Functions"
---
Drill supports the following functions for casting and converting data types:
@@ -924,4 +925,4 @@ You can use the ‘z’ option to identify the time zone in TO_TIMESTAMP to make
Apache DrillDRILL-1141
ISNUMERIC should be implemented as a SQL function
SELECT count(columns[0]) as number FROM dfs.`bla` WHERE ISNUMERIC(columns[0])=1
- -->
\ No newline at end of file
+ -->
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sql-reference/sql-functions/030-date-time-functions-and-arithmetic.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-functions/030-date-time-functions-and-arithmetic.md b/_docs/sql-reference/sql-functions/030-date-time-functions-and-arithmetic.md
index 6269182..f355d6e 100644
--- a/_docs/sql-reference/sql-functions/030-date-time-functions-and-arithmetic.md
+++ b/_docs/sql-reference/sql-functions/030-date-time-functions-and-arithmetic.md
@@ -1,5 +1,6 @@
---
title: "Date/Time Functions and Arithmetic"
+date: 2015-12-28 21:37:20 UTC
parent: "SQL Functions"
---
@@ -560,4 +561,4 @@ SELECT UNIX_TIMESTAMP('2015-05-29 08:18:53.0', 'yyyy-MM-dd HH:mm:ss.SSS') FROM (
| 1432912733 |
+-------------+
1 row selected (0.171 seconds)
-```
\ No newline at end of file
+```
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sql-reference/sql-functions/040-string-manipulation.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-functions/040-string-manipulation.md b/_docs/sql-reference/sql-functions/040-string-manipulation.md
index 5540cc3..6105451 100644
--- a/_docs/sql-reference/sql-functions/040-string-manipulation.md
+++ b/_docs/sql-reference/sql-functions/040-string-manipulation.md
@@ -1,5 +1,6 @@
---
title: "String Manipulation"
+date: 2015-12-28 21:37:20 UTC
parent: "SQL Functions"
---
@@ -409,4 +410,4 @@ Converts characters in the string to uppercase.
+---------------+
| APACHE DRILL |
+---------------+
- 1 row selected (0.081 seconds)
\ No newline at end of file
+ 1 row selected (0.081 seconds)
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sql-reference/sql-functions/050-aggregate-and-aggregate-statistical.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-functions/050-aggregate-and-aggregate-statistical.md b/_docs/sql-reference/sql-functions/050-aggregate-and-aggregate-statistical.md
index 87c45ab..baa4efb 100644
--- a/_docs/sql-reference/sql-functions/050-aggregate-and-aggregate-statistical.md
+++ b/_docs/sql-reference/sql-functions/050-aggregate-and-aggregate-statistical.md
@@ -1,5 +1,6 @@
---
title: "Aggregate and Aggregate Statistical"
+date: 2015-12-28 21:37:20 UTC
parent: "SQL Functions"
---
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sql-reference/sql-functions/060-functions-for-handling-nulls.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-functions/060-functions-for-handling-nulls.md b/_docs/sql-reference/sql-functions/060-functions-for-handling-nulls.md
index 147b63c..2cf3fb9 100644
--- a/_docs/sql-reference/sql-functions/060-functions-for-handling-nulls.md
+++ b/_docs/sql-reference/sql-functions/060-functions-for-handling-nulls.md
@@ -1,5 +1,6 @@
---
title: "Functions for Handling Nulls"
+date: 2015-12-28 21:37:20 UTC
parent: "SQL Functions"
---
@@ -53,4 +54,4 @@ This function returns the same type as the first expression.
SELECT NULLIF(d9, d9) FROM alltypes limit 1;
+------------+
| EXPR$0 |
- +------------+
\ No newline at end of file
+ +------------+
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sql-reference/sql-window-functions/010-sql-window-functions-introduction.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-window-functions/010-sql-window-functions-introduction.md b/_docs/sql-reference/sql-window-functions/010-sql-window-functions-introduction.md
old mode 100755
new mode 100644
index 0c26954..4fbf704
--- a/_docs/sql-reference/sql-window-functions/010-sql-window-functions-introduction.md
+++ b/_docs/sql-reference/sql-window-functions/010-sql-window-functions-introduction.md
@@ -1,5 +1,6 @@
---
title: "SQL Window Functions Introduction"
+date: 2015-12-28 21:37:20 UTC
parent: "SQL Window Functions"
---
@@ -93,9 +94,9 @@ Currently, Drill supports the following value, aggregate, and ranking window fun
[Value]({{site.baseurl}}/docs/value-window-functions/)
-* [FIRST_VALUE()]({{site.baseurl}}/docs/value-window-functions/#first_value-|-last_value)
-* [LAG()]({{site.baseurl}}/docs/value-window-functions/#lag-|-lead)
-* [LAST_VALUE()]({{site.baseurl}}/docs/value-window-functions/#first_value-|-last_value)
+* [FIRST_VALUE()]({{site.baseurl}}/docs/value-window-functions/#first_value-|-last_value)
+* [LAG()]({{site.baseurl}}/docs/value-window-functions/#lag-|-lead)
+* [LAST_VALUE()]({{site.baseurl}}/docs/value-window-functions/#first_value-|-last_value)
* [LEAD()]({{site.baseurl}}/docs/value-window-functions/#lag-|-lead)
[Aggregate]({{site.baseurl}}/docs/aggregate-window-functions/)
@@ -109,7 +110,7 @@ Currently, Drill supports the following value, aggregate, and ranking window fun
[Ranking]({{site.baseurl}}/docs/ranking-window-functions/)
* [CUME_DIST()]({{site.baseurl}}/docs/ranking-window-functions/)
-* [DENSE_RANK()]({{site.baseurl}}/docs/ranking-window-functions/)
+* [DENSE_RANK()]({{site.baseurl}}/docs/ranking-window-functions/)
* [NTILE()]({{site.baseurl}}/docs/ranking-window-functions/)
* [PERCENT_RANK()]({{site.baseurl}}/docs/ranking-window-functions/)
* [RANK()]({{site.baseurl}}/docs/ranking-window-functions/)
@@ -146,17 +147,17 @@ Any of the following functions used with the OVER clause to provide a window spe
* AVG()
* COUNT()
-* CUME_DIST()
-* DENSE_RANK()
-* FIRST_VALUE()
+* CUME_DIST()
+* DENSE_RANK()
+* FIRST_VALUE()
* LAG()
-* LAST_VALUE()
-* LEAD()
+* LAST_VALUE()
+* LEAD()
* MAX()
-* MIN()
-* NTILE()
-* PERCENT_RANK()
-* RANK()
+* MIN()
+* NTILE()
+* PERCENT_RANK()
+* RANK()
* ROW_NUMBER()
* SUM()
@@ -207,5 +208,5 @@ The following delimiters define the frame:
* Window functions precede ORDER BY.
* Drill processes window functions after the WHERE, GROUP BY, and HAVING clauses.
* Including the OVER() clause after an aggregate set function turns the function into an aggregate window function.
-* You can use window functions to aggregate over any number of rows in the window frame.
-* If you want to run a window function on the result set returned by the FLATTEN clause, use FLATTEN in a subquery. For example: ``select x, y, a, sum(x) over() from ( select x , y, flatten(z) as a from `complex.json`); ``
\ No newline at end of file
+* You can use window functions to aggregate over any number of rows in the window frame.
+* If you want to run a window function on the result set returned by the FLATTEN clause, use FLATTEN in a subquery. For example: ``select x, y, a, sum(x) over() from ( select x , y, flatten(z) as a from `complex.json`); ``
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sql-reference/sql-window-functions/020-aggregate-window-functions.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-window-functions/020-aggregate-window-functions.md b/_docs/sql-reference/sql-window-functions/020-aggregate-window-functions.md
index de692c6..eb0f689 100644
--- a/_docs/sql-reference/sql-window-functions/020-aggregate-window-functions.md
+++ b/_docs/sql-reference/sql-window-functions/020-aggregate-window-functions.md
@@ -1,5 +1,6 @@
---
title: "Aggregate Window Functions"
+date: 2015-12-28 21:37:20 UTC
parent: "SQL Window Functions"
---
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sql-reference/sql-window-functions/030-ranking-window-functions.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-window-functions/030-ranking-window-functions.md b/_docs/sql-reference/sql-window-functions/030-ranking-window-functions.md
old mode 100755
new mode 100644
index 07d087f..2f0cdcd
--- a/_docs/sql-reference/sql-window-functions/030-ranking-window-functions.md
+++ b/_docs/sql-reference/sql-window-functions/030-ranking-window-functions.md
@@ -1,5 +1,6 @@
---
title: "Ranking Window Functions"
+date: 2015-12-28 21:37:20 UTC
parent: "SQL Window Functions"
---
@@ -191,4 +192,4 @@ The following query uses the ROW_NUMBER() window function to number the sales fo
-
\ No newline at end of file
+
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sql-reference/sql-window-functions/035-value-window-functions.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-window-functions/035-value-window-functions.md b/_docs/sql-reference/sql-window-functions/035-value-window-functions.md
old mode 100755
new mode 100644
index 1f64023..f6848e7
--- a/_docs/sql-reference/sql-window-functions/035-value-window-functions.md
+++ b/_docs/sql-reference/sql-window-functions/035-value-window-functions.md
@@ -1,11 +1,12 @@
----
-title: "Value Window Functions"
-parent: "SQL Window Functions"
----
-Window functions operate on a set of rows and return a single value for each row from the underlying query. The OVER() clause differentiates window functions from other analytical and reporting functions. See [SQL Window Functions Introduction]({{ site.baseurl }}/docs/sql-window-functions-introduction/).
-
-The following table lists the value window functions with supported data types and descriptions:
-
+---
+title: "Value Window Functions"
+date: 2015-12-28 21:37:20 UTC
+parent: "SQL Window Functions"
+---
+Window functions operate on a set of rows and return a single value for each row from the underlying query. The OVER() clause differentiates window functions from other analytical and reporting functions. See [SQL Window Functions Introduction]({{ site.baseurl }}/docs/sql-window-functions-introduction/).
+
+The following table lists the value window functions with supported data types and descriptions:
+
| Window Function | Argument Type | Return Type | Description |
|-----------------|--------------------------------|------------------------------|------------------------------------------------------------------------------------------------------------------------------------|
| LAG() | Any supported Drill data types | Same as the expression type | The LAG() window function returns the value for the row before the current row in a partition. If no row exists, null is returned. |
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/sql-reference/sql-window-functions/040-sql-window-functions-examples.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-window-functions/040-sql-window-functions-examples.md b/_docs/sql-reference/sql-window-functions/040-sql-window-functions-examples.md
index 570a6cc..9b5c714 100644
--- a/_docs/sql-reference/sql-window-functions/040-sql-window-functions-examples.md
+++ b/_docs/sql-reference/sql-window-functions/040-sql-window-functions-examples.md
@@ -1,5 +1,6 @@
---
title: "SQL Window Functions Examples"
+date: 2015-12-28 21:37:20 UTC
parent: "SQL Window Functions"
---
@@ -89,4 +90,4 @@ Now, you can run the window function example queries on your machine.
-
\ No newline at end of file
+
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/tutorials/010-tutorials-introduction.md
----------------------------------------------------------------------
diff --git a/_docs/tutorials/010-tutorials-introduction.md b/_docs/tutorials/010-tutorials-introduction.md
index 0771ec9..f7fead9 100644
--- a/_docs/tutorials/010-tutorials-introduction.md
+++ b/_docs/tutorials/010-tutorials-introduction.md
@@ -1,5 +1,6 @@
---
title: "Tutorials Introduction"
+date: 2015-12-28 21:37:20 UTC
parent: "Tutorials"
---
If you've never used Drill, use these tutorials to download, install, and start working with Drill. The tutorials include step-by-step procedures for the following tasks:
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/tutorials/020-drill-in-10-minutes.md
----------------------------------------------------------------------
diff --git a/_docs/tutorials/020-drill-in-10-minutes.md b/_docs/tutorials/020-drill-in-10-minutes.md
old mode 100755
new mode 100644
index 7151358..e737edb
--- a/_docs/tutorials/020-drill-in-10-minutes.md
+++ b/_docs/tutorials/020-drill-in-10-minutes.md
@@ -1,5 +1,6 @@
---
title: "Drill in 10 Minutes"
+date: 2015-12-28 21:37:20 UTC
parent: "Tutorials"
description: Get started with Drill in 10 minutes or less.
---
@@ -218,4 +219,4 @@ Now that you have an idea about what Drill can do, you might want to:
## More Information
-For more information about Apache Drill, explore the [Apache Drill web site](http://drill.apache.org).
\ No newline at end of file
+For more information about Apache Drill, explore the [Apache Drill web site](http://drill.apache.org).
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/tutorials/030-analyzing-the-yelp-academic-dataset.md
----------------------------------------------------------------------
diff --git a/_docs/tutorials/030-analyzing-the-yelp-academic-dataset.md b/_docs/tutorials/030-analyzing-the-yelp-academic-dataset.md
index 6139b9c..e24558c 100644
--- a/_docs/tutorials/030-analyzing-the-yelp-academic-dataset.md
+++ b/_docs/tutorials/030-analyzing-the-yelp-academic-dataset.md
@@ -1,5 +1,6 @@
---
title: "Analyzing the Yelp Academic Dataset"
+date: 2015-12-28 21:37:20 UTC
parent: "Tutorials"
---
Apache Drill is one of the fastest growing open source projects, with the community making rapid progress with monthly releases. The key difference is Drill’s agility and flexibility.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/tutorials/040-learn-drill-with-the-mapr-sandbox.md
----------------------------------------------------------------------
diff --git a/_docs/tutorials/040-learn-drill-with-the-mapr-sandbox.md b/_docs/tutorials/040-learn-drill-with-the-mapr-sandbox.md
index e64dc6f..d5b3d5a 100644
--- a/_docs/tutorials/040-learn-drill-with-the-mapr-sandbox.md
+++ b/_docs/tutorials/040-learn-drill-with-the-mapr-sandbox.md
@@ -1,5 +1,6 @@
---
title: "Learn Drill with the MapR Sandbox"
+date: 2015-12-28 21:37:20 UTC
parent: "Tutorials"
---
This tutorial uses the MapR Sandbox, which is a Hadoop environment pre-
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/tutorials/050-analyzing-highly-dynamic-datasets.md
----------------------------------------------------------------------
diff --git a/_docs/tutorials/050-analyzing-highly-dynamic-datasets.md b/_docs/tutorials/050-analyzing-highly-dynamic-datasets.md
index 69cf93d..41b03df 100644
--- a/_docs/tutorials/050-analyzing-highly-dynamic-datasets.md
+++ b/_docs/tutorials/050-analyzing-highly-dynamic-datasets.md
@@ -1,5 +1,6 @@
---
title: "Analyzing Highly Dynamic Datasets"
+date: 2015-12-28 21:37:20 UTC
parent: "Tutorials"
---
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/tutorials/060-analyzing-social-media.md
----------------------------------------------------------------------
diff --git a/_docs/tutorials/060-analyzing-social-media.md b/_docs/tutorials/060-analyzing-social-media.md
index 0be61ab..12d6b24 100644
--- a/_docs/tutorials/060-analyzing-social-media.md
+++ b/_docs/tutorials/060-analyzing-social-media.md
@@ -1,5 +1,6 @@
---
title: "Analyzing Social Media"
+date: 2015-12-28 21:37:20 UTC
parent: "Tutorials"
---
@@ -203,4 +204,4 @@ This report shows top Retweets for a date range with original Tweet date and cou
## Summary
-In this tutorial, you learned how to configure an environment to stream Twitter data using Apache Flume. You then learned how to analyze the data in native JSON format with SQL using Apache Drill, and how to run interactive reports and analysis using MicroStrategy.
\ No newline at end of file
+In this tutorial, you learned how to configure an environment to stream Twitter data using Apache Flume. You then learned how to analyze the data in native JSON format with SQL using Apache Drill, and how to run interactive reports and analysis using MicroStrategy.
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/tutorials/070-analyzing-data-using-window-functions.md
----------------------------------------------------------------------
diff --git a/_docs/tutorials/070-analyzing-data-using-window-functions.md b/_docs/tutorials/070-analyzing-data-using-window-functions.md
index 9c42dee..768d184 100644
--- a/_docs/tutorials/070-analyzing-data-using-window-functions.md
+++ b/_docs/tutorials/070-analyzing-data-using-window-functions.md
@@ -1,5 +1,6 @@
---
title: "Analyzing Data Using Window Functions"
+date: 2015-12-28 21:37:20 UTC
parent: "Tutorials"
---
@@ -239,4 +240,4 @@ This tutorial builds on previous tutorials, [Analyzing the Yelp Academic Dataset
| Anthem | 50 | Shanghai Club | 53 | 43 |
| Anthem | 43 | Two Brothers Kitchen | 50 | 32 |
+------------+---------------+----------------------------------------+------------------+------------------+
- 15 rows selected (0.518 seconds)
\ No newline at end of file
+ 15 rows selected (0.518 seconds)
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/tutorials/learn-drill-with-the-mapr-sandbox/005-about-the-mapr-sandbox.md
----------------------------------------------------------------------
diff --git a/_docs/tutorials/learn-drill-with-the-mapr-sandbox/005-about-the-mapr-sandbox.md b/_docs/tutorials/learn-drill-with-the-mapr-sandbox/005-about-the-mapr-sandbox.md
index 01bede8..045ab6f 100644
--- a/_docs/tutorials/learn-drill-with-the-mapr-sandbox/005-about-the-mapr-sandbox.md
+++ b/_docs/tutorials/learn-drill-with-the-mapr-sandbox/005-about-the-mapr-sandbox.md
@@ -1,5 +1,6 @@
---
title: "About the MapR Sandbox"
+date: 2015-12-28 21:37:20 UTC
parent: "Learn Drill with the MapR Sandbox"
---
This tutorial uses the MapR Sandbox, which is a Hadoop environment pre-configured with Drill. MapR includes Drill as part of the Hadoop distribution. The MapR
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/tutorials/learn-drill-with-the-mapr-sandbox/010-installing-the-apache-drill-sandbox.md
----------------------------------------------------------------------
diff --git a/_docs/tutorials/learn-drill-with-the-mapr-sandbox/010-installing-the-apache-drill-sandbox.md b/_docs/tutorials/learn-drill-with-the-mapr-sandbox/010-installing-the-apache-drill-sandbox.md
old mode 100755
new mode 100644
index d4ce23f..d5ceccf
--- a/_docs/tutorials/learn-drill-with-the-mapr-sandbox/010-installing-the-apache-drill-sandbox.md
+++ b/_docs/tutorials/learn-drill-with-the-mapr-sandbox/010-installing-the-apache-drill-sandbox.md
@@ -1,5 +1,6 @@
---
title: "Installing the Apache Drill Sandbox"
+date: 2015-12-28 21:37:20 UTC
parent: "Learn Drill with the MapR Sandbox"
---
## Prerequisites
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/tutorials/learn-drill-with-the-mapr-sandbox/020-getting-to-know-the-drill-sandbox.md
----------------------------------------------------------------------
diff --git a/_docs/tutorials/learn-drill-with-the-mapr-sandbox/020-getting-to-know-the-drill-sandbox.md b/_docs/tutorials/learn-drill-with-the-mapr-sandbox/020-getting-to-know-the-drill-sandbox.md
old mode 100755
new mode 100644
index 5949063..179d856
--- a/_docs/tutorials/learn-drill-with-the-mapr-sandbox/020-getting-to-know-the-drill-sandbox.md
+++ b/_docs/tutorials/learn-drill-with-the-mapr-sandbox/020-getting-to-know-the-drill-sandbox.md
@@ -1,5 +1,6 @@
---
title: "Getting to Know the Drill Sandbox"
+date: 2015-12-28 21:37:20 UTC
parent: "Learn Drill with the MapR Sandbox"
---
This section covers key information about the Apache Drill tutorial. After [installing the Drill sandbox]({{ site.baseurl }}/docs/installing-the-apache-drill-sandbox) and starting the sandbox, you can open another terminal window (Linux) or Command Prompt (Windows) and use the secure shell (ssh) to connect to the VM, assuming ssh is installed. Use the following login name and password: mapr/mapr. For
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/tutorials/learn-drill-with-the-mapr-sandbox/030-lesson-1-learn-about-the-data-set.md
----------------------------------------------------------------------
diff --git a/_docs/tutorials/learn-drill-with-the-mapr-sandbox/030-lesson-1-learn-about-the-data-set.md b/_docs/tutorials/learn-drill-with-the-mapr-sandbox/030-lesson-1-learn-about-the-data-set.md
index f6304f9..5655e3f 100644
--- a/_docs/tutorials/learn-drill-with-the-mapr-sandbox/030-lesson-1-learn-about-the-data-set.md
+++ b/_docs/tutorials/learn-drill-with-the-mapr-sandbox/030-lesson-1-learn-about-the-data-set.md
@@ -1,5 +1,6 @@
---
title: "Lesson 1: Learn about the Data Set"
+date: 2015-12-28 21:37:20 UTC
parent: "Learn Drill with the MapR Sandbox"
---
## Goal
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/tutorials/learn-drill-with-the-mapr-sandbox/040-lesson-2-run-queries-with-ansi-sql.md
----------------------------------------------------------------------
diff --git a/_docs/tutorials/learn-drill-with-the-mapr-sandbox/040-lesson-2-run-queries-with-ansi-sql.md b/_docs/tutorials/learn-drill-with-the-mapr-sandbox/040-lesson-2-run-queries-with-ansi-sql.md
index 3016e5a..a2860d5 100644
--- a/_docs/tutorials/learn-drill-with-the-mapr-sandbox/040-lesson-2-run-queries-with-ansi-sql.md
+++ b/_docs/tutorials/learn-drill-with-the-mapr-sandbox/040-lesson-2-run-queries-with-ansi-sql.md
@@ -1,5 +1,6 @@
---
title: "Lesson 2: Run Queries with ANSI SQL"
+date: 2015-12-28 21:37:20 UTC
parent: "Learn Drill with the MapR Sandbox"
---
## Goal
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/tutorials/learn-drill-with-the-mapr-sandbox/050-lesson-3-run-queries-on-complex-data-types.md
----------------------------------------------------------------------
diff --git a/_docs/tutorials/learn-drill-with-the-mapr-sandbox/050-lesson-3-run-queries-on-complex-data-types.md b/_docs/tutorials/learn-drill-with-the-mapr-sandbox/050-lesson-3-run-queries-on-complex-data-types.md
index 17b904b..8cd3545 100644
--- a/_docs/tutorials/learn-drill-with-the-mapr-sandbox/050-lesson-3-run-queries-on-complex-data-types.md
+++ b/_docs/tutorials/learn-drill-with-the-mapr-sandbox/050-lesson-3-run-queries-on-complex-data-types.md
@@ -1,5 +1,6 @@
---
title: "Lesson 3: Run Queries on Complex Data Types"
+date: 2015-12-28 21:37:20 UTC
parent: "Learn Drill with the MapR Sandbox"
---
## Goal
http://git-wip-us.apache.org/repos/asf/drill/blob/25920ab7/_docs/tutorials/learn-drill-with-the-mapr-sandbox/060-summary.md
----------------------------------------------------------------------
diff --git a/_docs/tutorials/learn-drill-with-the-mapr-sandbox/060-summary.md b/_docs/tutorials/learn-drill-with-the-mapr-sandbox/060-summary.md
index b806a63..87b5ecc 100644
--- a/_docs/tutorials/learn-drill-with-the-mapr-sandbox/060-summary.md
+++ b/_docs/tutorials/learn-drill-with-the-mapr-sandbox/060-summary.md
@@ -1,5 +1,6 @@
---
title: "Summary"
+date: 2015-12-28 21:37:20 UTC
parent: "Learn Drill with the MapR Sandbox"
---
This tutorial introduced Apache Drill and its ability to run ANSI SQL queries