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
Parent topic: Job Development
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.See the reply and handling status in My Cloud VOC.
The system is busy. Please try again later.
For any further questions, feel free to contact us through the chatbot.
Chatbotmore