You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@pinot.apache.org by jl...@apache.org on 2019/02/05 22:51:38 UTC

[incubator-pinot.wiki] branch master updated: Updated Pinot Query Language (markdown)

This is an automated email from the ASF dual-hosted git repository.

jlli pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/incubator-pinot.wiki.git


The following commit(s) were added to refs/heads/master by this push:
     new 7139952  Updated Pinot Query Language (markdown)
7139952 is described below

commit 7139952e669085348d864d56ab5666b0775c0953
Author: Jialiang Li <jl...@linkedin.com>
AuthorDate: Tue Feb 5 14:51:37 2019 -0800

    Updated Pinot Query Language (markdown)
---
 Pinot-Query-Language.md | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

diff --git a/Pinot-Query-Language.md b/Pinot-Query-Language.md
index d8daeea..276a1ba 100644
--- a/Pinot-Query-Language.md
+++ b/Pinot-Query-Language.md
@@ -85,7 +85,7 @@ where we don't put the results for the same group together.
 # PQL Specification
 
 ## SELECT
-The select statement is as follows
+The select statement is as follows:
 ```sql
 SELECT <outputColumn> (, outputColumn)*
   FROM <tableName>
@@ -126,11 +126,11 @@ The `ORDER BY` clause orders selection results by a list of columns. PQL support
 The `TOP n` clause causes the _n_ largest group results to be returned. If not specified, the top 10 groups are returned.
 ### LIMIT
 The `LIMIT n` clause causes the selection results to contain at most _n_ results.
-The `LIMIT a, b` clause paginate the selection results from the _a_ th results and return at most _b_ results.
+The `LIMIT a, b` clause paginates the selection results from the _a_ th results and return at most _b_ results.
 
 ## Transform Function in Aggregation and Grouping
 In aggregation and grouping, each column can be transformed from one or multiple columns.
-For example, the following query will calculate the maximum value of column `foo` divided by column `bar` grouping on the column `time` converted form time unit `MILLISECONDS` to `SECONDS`:
+For example, the following query will calculate the maximum value of column `foo` divided by column `bar` grouping on the column `time` converted from time unit `MILLISECONDS` to `SECONDS`:
 ```sql
 SELECT MAX(DIV(foo, bar) FROM myTable
   GROUP BY TIMECONVERT(time, 'MILLISECONDS', 'SECONDS')


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org