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 <[email protected]> Authored: Wed Dec 7 14:27:22 2016 -0500 Committer: Dave Kantor <[email protected]> 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>
