Repository: cassandra Updated Branches: refs/heads/trunk a2b1b8abc -> 52a10696a
Fix HELP SELECT_EXPR output in cqlsh Patch by pthompson; reviewed by stefania for CASSANDRA-10074 Project: http://git-wip-us.apache.org/repos/asf/cassandra/repo Commit: http://git-wip-us.apache.org/repos/asf/cassandra/commit/2e87c433 Tree: http://git-wip-us.apache.org/repos/asf/cassandra/tree/2e87c433 Diff: http://git-wip-us.apache.org/repos/asf/cassandra/diff/2e87c433 Branch: refs/heads/trunk Commit: 2e87c433a957bebe8e9578bca81ee7db6b50c87b Parents: aa60cde Author: Philip Thompson <ptnapol...@gmail.com> Authored: Thu Sep 24 09:43:29 2015 -0700 Committer: Joshua McKenzie <jmcken...@apache.org> Committed: Thu Sep 24 09:43:29 2015 -0700 ---------------------------------------------------------------------- pylib/cqlshlib/helptopics.py | 10 +++++++++- 1 file changed, 9 insertions(+), 1 deletion(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/cassandra/blob/2e87c433/pylib/cqlshlib/helptopics.py ---------------------------------------------------------------------- diff --git a/pylib/cqlshlib/helptopics.py b/pylib/cqlshlib/helptopics.py index 8e296e1..b5cf09a 100644 --- a/pylib/cqlshlib/helptopics.py +++ b/pylib/cqlshlib/helptopics.py @@ -797,6 +797,7 @@ class CQL3HelpTopics(CQLHelpTopics): SELECT name1, name2, name3 FROM ... SELECT COUNT(*) FROM ... + SELECT MIN(name1), MAX(name2), SUM(name3), AVG(name4) FROM ... The SELECT expression determines which columns will appear in the results and takes the form of a comma separated list of names. @@ -810,7 +811,14 @@ class CQL3HelpTopics(CQLHelpTopics): single row will be returned, with a single column named "count" whose value is the number of rows from the pre-aggregation resultset. - Currently, COUNT is the only function supported by CQL. + The MAX and MIN functions can be used to compute the maximum and the + minimum value returned by a query for a given column. + + The SUM function can be used to sum up all the values returned by + a query for a given column. + + The AVG function can be used to compute the average of all the + values returned by a query for a given column. """ def help_alter_drop(self):