Document Center
Search
Search by Current Product
remote login
data migration
reset password
MySQL
server
Document Center
MaxCompute
MaxCompute
Product Introduction
What is MaxCompute?
Announcements
Reading guidance
History
Pricing
Billing
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
UploadSession
DownloadSession
TunnelBufferedWriter
Bulk data channel SDK example
Example
Example for uploading
简单下载示例
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
Real-time data tunnel of DataHub
SQL
SQL summary
Operators
Type conversion
DDL SQL
Table Operations
Lifecycle of table
Column and Partition operation
View operations
Insert Operation
INSERT OVERWRITE/INTO
MULTI INSERT
DYNAMIC PARTITION
VALUES
Select Operation
Introduction to the SELECT Syntax
SELECT Sequence
Subquery
UNION, INTERSECT, and EXCEPT
JOIN
Lateral View
SEMI JOIN
MAPJOIN HINT
HAVING clause
Explain
Common table expression (CTE)
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
UDT
UDJ
Differences with other SQL syntax
SQL limits
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
Java SDK
Java SDK
Overview of compatible versions of the SDK
MR limits
Java Sandbox
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
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
View Job Running Information
Logview
Errors and warnings using the MaxCompute compiler
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
Interactive SQL (Lightning)
Overview
Quick Start
Guide description
Prerequisites
Prepare client tools for connection
Access services and perform analysis
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
MaxCompute Manager
Security
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
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
Detailed introduction
Downloads
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
SDK Reference
Java SDK
Python SDK
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
MaxCompute
Product Introduction
Download PDF
What is MaxCompute?
Announcements
Reading guidance
History
Show more
Show less
Pricing
Download PDF
Billing
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
View Job Running Information
Graph
Interactive SQL (Lightning)
MaxCompute Manager
Show more
Show less
Security
Download PDF
Configure security features
Show more
Show less
Tools and Downloads
Download PDF
Client
MaxCompute Studio
Eclipse Plugins
Downloads
Show more
Show less
Best Practices
Download PDF
SQL
Data migration
Data development
Compute optimization
Show more
Show less
SDK Reference
Download PDF
Java SDK
Python SDK
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