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
- How Do I Merge Small Files?
- How Do I Use DLI to Access Data in an OBS Bucket?
- How Do I Specify an OBS Path When Creating an OBS Table?
- How Do I Create a Table Using JSON Data in an OBS Bucket?
- How Can I Use the count Function to Perform Aggregation?
- How Do I Synchronize DLI Table Data from One Region to Another?
- How Do I Insert Table Data into Specific Fields of a Table Using a SQL Job?
- How Do I Delete Table Data?
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
more