You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@atlas.apache.org by dk...@apache.org on 2016/12/07 19:33:32 UTC
incubator-atlas-website git commit: Update Search.html with changes
applied to Search.twiki as part of ATLAS-737
Repository: incubator-atlas-website
Updated Branches:
refs/heads/asf-site 0de799f73 -> 9f32a5886
Update Search.html with changes applied to Search.twiki as part of ATLAS-737
Project: http://git-wip-us.apache.org/repos/asf/incubator-atlas-website/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-atlas-website/commit/9f32a588
Tree: http://git-wip-us.apache.org/repos/asf/incubator-atlas-website/tree/9f32a588
Diff: http://git-wip-us.apache.org/repos/asf/incubator-atlas-website/diff/9f32a588
Branch: refs/heads/asf-site
Commit: 9f32a5886b4c0b2c32bfc63b258653cf1d7df3b1
Parents: 0de799f
Author: Dave Kantor <dk...@us.ibm.com>
Authored: Wed Dec 7 14:27:22 2016 -0500
Committer: Dave Kantor <dk...@us.ibm.com>
Committed: Wed Dec 7 14:27:22 2016 -0500
----------------------------------------------------------------------
Search.html | 35 +++++++++++++++++++++++++----------
1 file changed, 25 insertions(+), 10 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-atlas-website/blob/9f32a588/Search.html
----------------------------------------------------------------------
diff --git a/Search.html b/Search.html
index 95fee64..662a307 100644
--- a/Search.html
+++ b/Search.html
@@ -1,13 +1,13 @@
<!DOCTYPE html>
<!--
- | Generated by Apache Maven Doxia at 2016-08-16
+ | Generated by Apache Maven Doxia at 2016-12-06
| Rendered using Apache Maven Fluido Skin 1.3.0
-->
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta charset="UTF-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0" />
- <meta name="Date-Revision-yyyymmdd" content="20160816" />
+ <meta name="Date-Revision-yyyymmdd" content="20161206" />
<meta http-equiv="Content-Language" content="en" />
<title>Apache Atlas – Search</title>
<link rel="stylesheet" href="./css/apache-maven-fluido-1.3.0.min.css" />
@@ -195,7 +195,7 @@
- <li id="publishDate" class="pull-right">Last Published: 2016-08-16</li> <li class="divider pull-right">|</li>
+ <li id="publishDate" class="pull-right">Last Published: 2016-12-06</li> <li class="divider pull-right">|</li>
<li id="projectVersion" class="pull-right">Version: 0.8-incubating-SNAPSHOT</li>
</ul>
@@ -218,7 +218,7 @@
<pre>
queryWithPath: query ~ opt(WITHPATH)
-query: querySrc ~ opt(loopExpression) ~ opt(selectClause) ~ opt(orderby) ~ opt(limitOffset)
+query: querySrc ~ opt(loopExpression) ~ opt(groupByExpr) ~ opt(selectClause) ~ opt(orderby) ~ opt(limitOffset)
querySrc: rep1sep(singleQrySrc, opt(COMMA))
@@ -229,18 +229,28 @@ singleQrySrc = FROM ~ fromSrc ~ opt(WHERE) ~ opt(expr ^? notIdExpression) |
fromSrc: identifier ~ AS ~ alias | identifier
+groupByExpr = GROUPBY ~ (LPAREN ~> rep1sep(selectExpression, COMMA) <~ RPAREN)
+
orderby: ORDERBY ~ expr ~ opt (sortOrder)
-
+
limitOffset: LIMIT ~ lmt ~ opt (offset)
-
-offset: OFFSET ~ offsetValue
-
+
+offset: OFFSET ~ offsetValue
+
sortOrder = ASC | DESC
-
+
loopExpression: LOOP ~ (LPAREN ~> query <~ RPAREN) ~ opt(intConstant <~ TIMES) ~ opt(AS ~> alias)
selectClause: SELECT ~ rep1sep(selectExpression, COMMA)
+countClause = COUNT ~ LPAREN ~ RPAREN
+
+maxClause = MAX ~ (LPAREN ~> expr <~ RPAREN)
+
+minClause = MIN ~ (LPAREN ~> expr <~ RPAREN)
+
+sumClause = SUM ~ (LPAREN ~> expr <~ RPAREN)
+
selectExpression: expr ~ opt(AS ~> alias)
expr: compE ~ opt(rep(exprRight))
@@ -251,7 +261,7 @@ compE:
arithE ~ (LT | LTE | EQ | NEQ | GT | GTE) ~ arithE |
arithE ~ (ISA | IS) ~ ident |
arithE ~ HAS ~ ident |
- arithE
+ arithE | countClause | maxClause | minClause | sumClause
arithE: multiE ~ opt(rep(arithERight))
@@ -287,6 +297,7 @@ literal: booleanConstant |
<ul>
<li>The <i>WithPath</i> clause can be used with transitive closure queries to retrieve the Path that</li></ul>connects the two related Entities. (We also provide a higher level interface for Closure Queries see scaladoc for 'org.apache.atlas.query.ClosureQuery')
<ul>
+<li>GROUPBY is optional. Group by can be specified with aggregate methods like max, min, sum and count. When group by is specified aggregated results are returned based on the method specified in select clause. Select expression is mandatory with group by expression.</li>
<li>ORDERBY is optional. When order by clause is specified, case insensitive sorting is done based on the column specified.</li></ul>For sorting in descending order specify 'DESC' after order by clause. If no order by is specified, then no default sorting is applied.
<ul>
<li>LIMIT is optional. It limits the maximum number of objects to be fetched starting from specified optional offset. If no offset is specified count starts from beginning.</li>
@@ -311,6 +322,10 @@ literal: booleanConstant |
<li>Column where Column isa PII</li>
<li>Table where name="sales_fact", columns</li>
<li>Table where name="sales_fact", columns as column select column.name, column.dataType, column.comment</li>
+<li>DB groupby(owner) select owner, count()</li>
+<li>DB groupby(owner) select owner, max(name)</li>
+<li>DB groupby(owner) select owner, min(name)</li>
+<li>from Person select count() as 'count', max(Person.age) as 'max', min(Person.age)</li>
<li>`Log Data`</li></ul></div>
<div class="section">
<h3><a name="Full-text_Search"></a>Full-text Search</h3>