Document Center
MaxCompute
Product Introduction
What is MaxCompute?
Reading guidance
Announcements
History
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 Endpoint
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
Definitions
MaxCompute glossary
Project
Table
Partition
Data types
Lifecycle
Resource
Function
Task
Instance
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
Connection to data tunnel service
Cloud data migration
Data upload and download tools
Tunnel commands
Tunnel SDK
Summary
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
Differences with other SQL syntax
DDL SQL
Table operations
Lifecycle of table
Column and Partition operation
View operations
Insert Operation
INSERT OVERWRITE/INTO
MULTI INSERT
DYNAMIC PARTITION
Select Operation
SELECT syntax
SELECT Sequence
Subquery
UNION, INTERSECT, and EXCEPT
JOIN
SEMI JOIN
MAPJOIN HINT
Lateral View
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
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
Unstructured data exported to OSS
Access Table Store data
Spark
Spark overview
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
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
Authorization
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
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
Package、Upload and Register
Develop Graph
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 project
MapReduce
UDF
Graph
Downloads
SDK Reference
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
Write your first MapReduce
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
Product Introduction
Download PDF
What is MaxCompute?
Reading guidance
Announcements
History
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 Endpoint
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
Definitions
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
Configure security features
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