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 <alex39...@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 <alex39...@mail.ru> Authored: Tue Aug 14 12:03:50 2018 +0200 Committer: Jongyoul Lee <jongy...@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:
