You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@zeppelin.apache.org by jo...@apache.org on 2018/08/17 02:24:24 UTC

zeppelin git commit: [ZEPPELIN-3710] Add to the SAP documentation limit and distinct description

Repository: zeppelin
Updated Branches:
  refs/heads/master b94d144ce -> b958d4c30


[ZEPPELIN-3710] Add to the SAP documentation limit and distinct description

### What is this PR for?
Add to the SAP documentation `limit` and `distinct` keywords description which have been added in [ZEPPELIN-3677](https://github.com/apache/zeppelin/pull/3106)

### What type of PR is it?
Improvement

### What is the Jira issue?
[ZEPPELIN-3710](https://issues.apache.org/jira/browse/ZEPPELIN-3710)

### Questions:
* Does the licenses files need update? No
* Is there breaking changes for older versions? No
* Does this needs documentation? Updated

Author: oxygen311 <al...@mail.ru>

Closes #3138 from oxygen311/ZEPPELIN-3710 and squashes the following commits:

77ffd47e3 [oxygen311] Add SAP Docs


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

Branch: refs/heads/master
Commit: b958d4c30da7590c98ffb04442d983bb36a8818c
Parents: b94d144
Author: oxygen311 <al...@mail.ru>
Authored: Tue Aug 14 12:03:50 2018 +0200
Committer: Jongyoul Lee <jo...@apache.org>
Committed: Fri Aug 17 11:24:20 2018 +0900

----------------------------------------------------------------------
 docs/interpreter/sap.md | 29 +++++++++++++++++++++++++++++
 1 file changed, 29 insertions(+)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/zeppelin/blob/b958d4c3/docs/interpreter/sap.md
----------------------------------------------------------------------
diff --git a/docs/interpreter/sap.md b/docs/interpreter/sap.md
index 2c4128c..bfb12e5 100644
--- a/docs/interpreter/sap.md
+++ b/docs/interpreter/sap.md
@@ -122,6 +122,35 @@ where
   and [Folder1].[Dimension5] in ('Value1', 'Value2');
 ```
 
+### `distinct` keyword
+You can write keyword `distinct` after keyword `select` to return only distinct (different) values.
+
+Example query
+```sql
+%sap
+universe [Universe Name];
+
+select distinct
+  [Folder1].[Dimension2], [Measure1]
+where
+  [Filter1];
+```
+
+### `limit` keyword
+You can write keyword `limit` and limit value in the end of query to limit the number of records returned based on a limit value.
+
+Example query
+```sql
+%sap
+universe [Universe Name];
+
+select
+  [Folder1].[Dimension2], [Measure1]
+where
+  [Filter1]
+limit 100;
+```
+
 ## Object Interpolation
 The SAP interpreter also supports interpolation of `ZeppelinContext` objects into the paragraph text.
 To enable this feature set `universe.interpolation` to `true`. The following example shows one use of this facility: