Help Center> Data Lake Insight> FAQs> Problems Related to SQL Jobs> Job Development> How Can I Use the count Function to Perform Aggregation?
Updated on 2022-11-09 GMT+08:00

How Can I Use the count Function to Perform Aggregation?

The correct method for using the count function to perform aggregation is as follows:

SELECT
  http_method,
  count(http_method)
FROM
  apigateway
WHERE
  service_id = 'ecs' Group BY http_method

Or

SELECT
  http_method
FROM
  apigateway
WHERE
  service_id = 'ecs' DISTRIBUTE BY http_method

If an incorrect method is used, an error will be reported.

SELECT
  http_method,
  count(http_method)
FROM
  apigateway
WHERE
  service_id = 'ecs' DISTRIBUTE BY http_method

Job Development FAQs

more