Update search_over_cql.rst
@@ -172,6 +172,19 @@ In the following example, there are two top level aggregations named *sales_per_
ex : select * from twitter2.doc where es_query='{"size":0, "aggs":{{"sales":{"stats":{"field":"price"}}}}}' and es_options='indices=twitter2;json=true'
+.. note::
+
+ Elassandra only supports the following aggregation types over CQL:
+
+ * `Term aggregation <https://www.elastic.co/guide/en/elasticsearch/reference/6.8/search-aggregations-bucket-terms-aggregation.html>`_
+ * `Histogram aggregation <https://www.elastic.co/guide/en/elasticsearch/reference/6.8/search-aggregations-bucket-histogram-aggregation.html>`_
+ * `Date Histogram aggregation <https://www.elastic.co/guide/en/elasticsearch/reference/6.8/search-aggregations-bucket-datehistogram-aggregation.html>`_
+ * `Percentiles aggregation <https://www.elastic.co/guide/en/elasticsearch/reference/6.8/search-aggregations-metrics-percentile-aggregation.html>`_
+ * `Sum aggregation <https://www.elastic.co/guide/en/elasticsearch/reference/6.8/search-aggregations-metrics-sum-aggregation.html>`_
+ * `Avg aggregation <https://www.elastic.co/guide/en/elasticsearch/reference/6.8/search-aggregations-metrics-avg-aggregation.html>`_
+ * `Min aggregation <https://www.elastic.co/guide/en/elasticsearch/reference/6.8/search-aggregations-metrics-min-aggregation.html>`_
+ * `Max aggregation <https://www.elastic.co/guide/en/elasticsearch/reference/6.8/search-aggregations-metrics-max-aggregation.html>`_
+ * `Stats aggregation <https://www.elastic.co/guide/en/elasticsearch/reference/6.8/search-aggregations-metrics-stats-aggregation.html>`_
Distributed Elasticsearch aggregation with Apache Spark
.......................................................
