drill-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bridg...@apache.org
Subject drill git commit: add support for multiple window functions in query, edits for 1.2
Date Tue, 06 Oct 2015 23:44:25 GMT
Repository: drill
Updated Branches:
  refs/heads/gh-pages 492ed5a29 -> b7965f0a9


add support for multiple window functions in query, edits for 1.2


Project: http://git-wip-us.apache.org/repos/asf/drill/repo
Commit: http://git-wip-us.apache.org/repos/asf/drill/commit/b7965f0a
Tree: http://git-wip-us.apache.org/repos/asf/drill/tree/b7965f0a
Diff: http://git-wip-us.apache.org/repos/asf/drill/diff/b7965f0a

Branch: refs/heads/gh-pages
Commit: b7965f0a947ba2dc7cf4ee51f3c84bc016108406
Parents: 492ed5a
Author: Bridget Bevens <bbevens@maprtech.com>
Authored: Tue Oct 6 16:40:55 2015 -0700
Committer: Bridget Bevens <bbevens@maprtech.com>
Committed: Tue Oct 6 16:40:55 2015 -0700

----------------------------------------------------------------------
 .../050-configuring-multitenant-resources.md    |  2 -
 .../010-sql-window-functions-introduction.md    | 40 ++++++++++----------
 .../040-lesson-2-run-queries-with-ansi-sql.md   |  6 +--
 3 files changed, 21 insertions(+), 27 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/drill/blob/b7965f0a/_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 bc5d517..63898f3 100644
--- a/_docs/configure-drill/050-configuring-multitenant-resources.md
+++ b/_docs/configure-drill/050-configuring-multitenant-resources.md
@@ -17,8 +17,6 @@ OS = 8G
 
 If Yarn does most of the work, give Drill 20G, for example, and give Yarn 60G. If you expect
a heavy query load, give Drill 60G and Yarn 20G.
 
-{% include startnote.html %}Drill will execute queries within Yarn soon.{% include endnote.html
%} [DRILL-142](https://issues.apache.org/jira/browse/DRILL-142)
-
 YARN consists of two main services:
 
 * ResourceManager  

http://git-wip-us.apache.org/repos/asf/drill/blob/b7965f0a/_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
index 1fc2586..6d70901 100755
--- 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
@@ -3,9 +3,9 @@ title: "SQL Window Functions Introduction"
 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 term window describes the set of rows on which the function operates.
A window function uses values from the rows in a window to calculate the returned values.

+Window functions operate on a set of rows and return a single value for each row from the
underlying query. The term window describes the set of rows on which the function operates.
A window function uses values from the rows in a window to calculate the returned values.
 
 
-When you use a window function in a query, you specify a window using the OVER() clause.
The OVER() clause differentiates window functions from other analytical and reporting functions.

+When you use a window function in a query, define the window using the OVER() clause. The
OVER() clause (window definition) differentiates window functions from other analytical and
reporting functions. A query can include multiple window functions with the same or different
window definitions. 
 
 The OVER() clause has the following capabilities:  
 
@@ -74,29 +74,29 @@ The following query uses the AVG() window function with the PARTITION
BY clause
 
 Currently, Drill supports the following value, aggregate, and ranking window functions: 

 
-Value
+[Value]({{site.baseurl}}/docs/value-window-functions/)
 
-* FIRST_VALUE()
-* LAG()
-* LAST_VALUE()
-* LEAD() 
+* [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   
+[Aggregate]({{site.baseurl}}/docs/aggregate-window-functions/)   
 
-* AVG()
-* COUNT()
-* MAX()
-* MIN()
-* SUM()
+* [AVG()]({{site.baseurl}}/docs/aggregate-window-functions/)
+* [COUNT()]({{site.baseurl}}/docs/aggregate-window-functions/)
+* [MAX()]({{site.baseurl}}/docs/aggregate-window-functions/)
+* [MIN()]({{site.baseurl}}/docs/aggregate-window-functions/)
+* [SUM()]({{site.baseurl}}/docs/aggregate-window-functions/)
 
-Ranking  
+[Ranking]({{site.baseurl}}/docs/ranking-window-functions/)  
 
-* CUME_DIST()
-* DENSE_RANK()
-* NTILE()
-* PERCENT_RANK()
-* RANK()
-* ROW_NUMBER()
+* [CUME_DIST()]({{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/)
+* [ROW_NUMBER()]({{site.baseurl}}/docs/ranking-window-functions/)
 
 All of the ranking functions depend on the sort ordering specified by the ORDER BY clause
of the associated window definition. Rows that are not distinct in the ordering are called
peers. The ranking functions are defined so that they give the same answer for any two peer
rows.  
 

http://git-wip-us.apache.org/repos/asf/drill/blob/b7965f0a/_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 e2aa8c3..3016e5a 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
@@ -311,11 +311,7 @@ supports the creation of metadata in the file system.
     +----------+-------------------+-----------+----------+--------+----------+-------------+
     1 row selected
 
-Once the users get an idea on what data is available by exploring it directly
-from file system , views can be used as a way to take the data in downstream
-tools like Tableau, Microstrategy etc for downstream analysis and
-visualization. For these tools, a view appears simply as a “table” with
-selectable “columns” in it.
+Once the users know what data is available by exploring it directly from the file system,
views can be used as a way to read the data into downstream tools such as Tableau and MicroStrategy
for analysis and visualization. For these tools, a view appears simply as a “table” with
selectable “columns” in it.
 
 ## Query Across Data Sources
 


Mime
View raw message