Document Center
MaxCompute
Release Note
Announcements
Document updates
History
Product Introduction
What is MaxCompute?
Reading guidance
Definitions
MaxCompute glossary
Project
Table
Partition
Lifecycle
Resource
Function
Task
Instance
MaxCompute features in different zones
Pricing
Billing
View billing details
Billing method conversion
Outstanding payment warning and suspension policies
Renewal management
Prepare
Create an Alibaba Cloud account
Activate MaxCompute
Create a project
Install and configure a client
Users and Roles
Configure endpoints
Quick Start
Create and view a table
Import data
Run SQL statements and export data
(Optional) Use MapReduce
(Optional) Develop Java UDFs
(Optional) Submit Graph jobs
User Guide
Data types
Common commands
List of common commands
Project operations
Table operations
Instances operations
Resources operations
Functions operations
Set operations
Other operations
Data upload and download
Data upload and download overview
Connection to data tunnel service
Cloud data migration
Data upload and download tools
Tunnel commands
Tunnel SDK
Tunnel overview
TableTunnel
InstanceTunnel
UploadSession
DownloadSession
TunnelBufferedWriter
Bulk data channel SDK example
Example
Simple upload
Simple download
Example for multi-thread uploading
Example for multi-thread downloading
Example for BufferedWriter uploading
Example for BufferedWriter multi-thread uploading
Import or export data using the Data Integration
SQL
SQL summary
Operators
Type conversions
SQL limits
Insert Operation
INSERT OVERWRITE/INTO
MULTI INSERT
DYNAMIC PARTITION
DDL SQL
Table operations
Lifecycle of table
Column and Partition operation
View operations
Differences with other SQL syntax
Select Operation
SELECT syntax
SELECT Sequence
Subquery
UNION, INTERSECT, and EXCEPT
JOIN
SEMI JOIN
Lateral View
MAPJOIN HINT
HAVING clause
Grouping Sets
SELECT TRANSFORM
Script Mode SQL
Common table expression (CTE)
Explain
VALUES
Builtin functions
Compare built-in functions of MaxCompute with MySQL and Oracle
Date functions
Mathematical functions
Window functions
Aggregate functions
String functions
Other functions
UDF
UDF Summary
Java UDF
Python UDF
UDTF usage
UDT
UDJ
Appendix
Escape characters
LIKE usage
Regular expression
Reserved words and keywords
Hive data type mapping table
MapReduce
Summary
MapReduce
Extended MapReduce
Open-source MapReduce
Function Introduction
Basic concepts
Commands
Input and Output
Resources
Local run
Program Example
WordCount samples
MapOnly samples
Multi-input and Output
Multi-task samples
Secondary Sort samples
Resource samples
Counter samples
Grep samples
Join samples
Sleep samples
Unique samples
Sort samples
Partition samples
Pipeline samples
Java SDK
Java SDK
Overview of compatible versions of the SDK
Java Sandbox
MR limits
External table
Overview of External tables
OSS STS mode authorization
Access OSS unstructured data
Processing open source format data for OSS
Export unstructured data to OSS
Access Table Store data
Spark
Spark on MaxCompute overview
Set up a Spark on MaxCompute development environment
Develop a Spark on MaxCompute application
Develop a Spark on MaxCompute application by using Java or Scala
Develop a Spark on MaxCompute application by using PySpark
Spark on MaxCompute running modes
Diagnose a Spark on MaxCompute job
Spark on MaxCompute FAQ
Interactive SQL (Lightning)
Overview
Quick Start
Access domain name
Access services using JDBC interfaces
JDBC driver
Configure JDBC connections
Access services using common tools
SQL reference
View tasks
Constraints and limitations
FAQs
Graph
Summary
Aggregator
Function overview
SDK summary
Development and debugging
Limits
Examples
SSSP
PageRank
Kmeans
BiPartiteMatchiing
Strongly-connected component
Connected component
Topology Sorting
Linear Regression
Triangle Count
Vertex Input
Edge Input
View Job Running Information
Logview
Errors and warnings using the MaxCompute compiler
Management
Security management
Security model
MaxCompute permissions and DataWorks permissions
Manage users, roles, and permissions
Configure security functions
Configure security features
Target users
Quick Start
Use case: Add users and grant permissions
Use case: Add users and grant permissions using ACL
Use case: Project data protection
Manage users and permissions
User authentication
User management
Role management
Authorization
Permission check
Column-level access control
Resource share across project space
Resource sharing across projects based on package
Package usage method
Security configurations
Data protection of projects
Security command list
Security configuration of a project
Manage permissions
Package-based resource sharing
Security management use cases
Create a project
Grant packages
Check data security
Manage permissions by row
MaxCompute Manager
Tools and Downloads
Client
MaxCompute Studio
What is Studio
Project space connection management
Tools Installation and version history
Install IntelliJ IDEA
Installation procedure
View and upgrade the version
Manage data and resources
View tables and UDF
Import and export data
Visualization of operating the tables
Develop SQL procedure
Create MaxCompute Script module
Write SQL
Submit SQL scripts
Developing Java
Create MaxCompute Java Module
Develop and debug UDF
Develop MapReduce
Unstructured development
Develop Graph
Package、Upload and Register
Manage MaxCompute jobs
Job viewing
Job instance
Tool integration
Integrate with MaxCompute client
FAQ
How to develop UDF using Studio
How to manage MaxCompute metadata using Studio
Configure options
Configure MaxCompute Studio
Eclipse Plugins
Install
Create a MaxCompute project
MapReduce
UDF
Graph
Downloads
SDK Reference
Java SDK
Java SDK
Python SDK
Best Practices
SQL
Basic differences with standard SQL and solutions
Learn to write SQL statements quickly
Demo: Modify incompatible SQL
Export SQL operation result
Reasonableness evaluation of partition pruning
Group out the first n sections of each group of data
SQL implements multiple rows of data into one
Join on condition in MaxCompute(ODPS) SQL
Data migration
Migrate data from Hadoop to MaxCompute
Migrate data from RDS to MaxCompute to implement dynamic partitioning
Migrate JSON data from MongoDB to MaxCompute
Migrate JSON data from OSS to MaxCompute
Data development
Use Eclipse to develop a Java-based UDF
Use IntelliJ IDEA to develop a Java-based UDF
Use MaxCompute to analyze IP sources
Upload files exceeding 10 MB to DataWorks
Compute optimization
SQL optimization
Optimize long tail computing
Computing optimization program for long period indicators
Analyze MaxCompute bills
Error Code Appendix
Common Errors
SQL Common Errors
MapReduce Common Errors
Tunnel Common Errors
General Reference
Guidelines for the use of documentation
Alibaba Cloud documentation
Instructions for open source documentation
Open-Source Documentation Code of Conduct
Editing Open-Source Documentation
Alibaba Cloud console
Regions and zones
Service limits
Best practice of primary account security
Create an AccessKey
ICP Filing
Glossary
all-products-head
This Product
This Product
All Products
MaxCompute
MaxCompute
All Products
Release Note
Download PDF
Announcements
Document updates
History
Show more
Show less
Product Introduction
Download PDF
What is MaxCompute?
Reading guidance
Definitions
MaxCompute features in different zones
Show more
Show less
Pricing
Download PDF
Billing
View billing details
Billing method conversion
Outstanding payment warning and suspension policies
Renewal management
Show more
Show less
Prepare
Download PDF
Create an Alibaba Cloud account
Activate MaxCompute
Create a project
Install and configure a client
Users and Roles
Configure endpoints
Show more
Show less
Quick Start
Download PDF
Create and view a table
Import data
Run SQL statements and export data
(Optional) Use MapReduce
(Optional) Develop Java UDFs
(Optional) Submit Graph jobs
Show more
Show less
User Guide
Download PDF
Data types
Common commands
Data upload and download
SQL
MapReduce
External table
Spark
Interactive SQL (Lightning)
Graph
View Job Running Information
Show more
Show less
Management
Download PDF
Security management
Configure security features
Security management use cases
MaxCompute Manager
Show more
Show less
Tools and Downloads
Download PDF
Client
MaxCompute Studio
Eclipse Plugins
Downloads
Show more
Show less
SDK Reference
Download PDF
Java SDK
Python SDK
Show more
Show less
Best Practices
Download PDF
SQL
Data migration
Data development
Compute optimization
Show more
Show less
Error Code Appendix
Download PDF
Common Errors
SQL Common Errors
MapReduce Common Errors
Tunnel Common Errors
Show more
Show less
Free Trial
Free Trial