drill-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From krish...@apache.org
Subject [2/4] drill git commit: add date to front matter
Date Mon, 28 Dec 2015 21:57:30 GMT
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


Mime
View raw message