MaxCompute is an enterprise-level SaaS-based cloud data warehouse that is used for data analytics. MaxCompute allows you to use multiple methods to run big data computing and analytics jobs. If you want to run a data analytics job, such as a simple query job, you can use one of the methods that are described in this topic to query and analyze data in an efficient manner. This topic describes the methods that you can use to query and analyze data and the precautions for using the methods.
SQL query feature of DataAnalysis of DataWorks
You can use the SQL query feature of DataAnalysis of DataWorks in query mode to execute SQL statements and run authorization commands. The SQL statements or authorization commands return the same results as the MaxCompute client (odpscmd). You can also switch SQL query from the query mode to the analysis mode and use the powerful analysis features of Web Excel to analyze query results.
Ad hoc query feature of DataWorks
To debug, analyze, and query data that is developed by using DataStudio of DataWorks, you can use the ad hoc query feature of DataWorks. For more information about how to use the ad hoc query feature of DataWorks, see Create an ad hoc query.