Document Center
MaxCompute
Release Note
Announcements
Document updates
History
Product Introduction
What is MaxCompute?
What you must know
Definitions
MaxCompute glossary
Project
Table
Partition
Lifecycle
Resource
Function
Task
Instance
Limits
MaxCompute features in different regions
Pricing
Billing method
Storage pricing(Pay-As-You-Go)
Computing pricing
Download pricing(Pay-As-You-Go)
View billing details
Billing method conversion
Configuration upgrade and downgrade
Outstanding payment warning and suspension policies
Renewal management
Prepare
Create an Alibaba Cloud account
Activate MaxCompute
Create a project
Install and configure the odpscmd client
Configure endpoints
Users and Roles
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
(Optional) Use an ad-hoc query to run SQL statements
Development
Data types
Common commands
List of common commands
Project operations
Table operations
Instances operations
Resources operations
Functions operations
Set operations
Time zone configuration 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
Run Tunnel commands to upload and download data
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
SQL limits
Differences with other SQL syntax
Operators
Type conversions
DDL SQL
Table operations
Lifecycle of table
Partition and column operations
View operations
Insert Operation
INSERT OVERWRITE/INTO
MULTI INSERT
DYNAMIC PARTITION
VALUES
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
Parameterized view
Builtin functions
Comparison of functions built in MaxCompute, MySQL, and Oracle
Date functions
Mathematical functions
Window functions
Aggregate functions
String functions
Other functions
UDF
UDF Summary
Java UDF
Python UDF
Open source geospatial UDFs
UDTF usage
UDT
UDT
UDJ
Appendix
Escape characters
LIKE usage
Regular expression
Reserved words and keywords
Mapping of data types
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
Java and Scala development examples
Develop a Spark on MaxCompute application by using Java or Scala
Develop a Spark on MaxCompute application
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
Limits
Function overview
SDK summary
Development and debugging
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
Authenticate users
Manage users
Manage roles
Authorize users
Check permissions
Column-level access control
Resource share across project space
Resource sharing across projects based on package
Package usage method
Security configurations
Project data protection
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
Security white paper
MaxCompute security white paper
MaxCompute Manager
Information schema
Overview
List of metadata views
Tools and Downloads
Client
MaxCompute Studio
What is Studio
Tools Installation and version history
Install IntelliJ IDEA
Installation procedure
View and upgrade the version
Project space connection management
Configure MaxCompute Studio
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
Eclipse Plugins
Install
Create a MaxCompute project
MapReduce
UDF
Graph
Downloads
SDK Reference
Java SDK
Java SDK
Java SDK examples
Run security-related commands
Generate an instance Logview URL
Return error logs
Set the SQL flag
Use SQLTask and Tunnel to export a large amount of data
Python SDK
JDBC Reference
JDBC overview
Third-party tools integrated with JDBC
Configure MaxCompute JDBC on Tableau
Configure MaxCompute JDBC on SQL Workbench/J
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 JOIN long tails
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
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?
What you must know
Definitions
Limits
MaxCompute features in different regions
Show more
Show less
Pricing
Download PDF
Billing method
Storage pricing(Pay-As-You-Go)
Computing pricing
Download pricing(Pay-As-You-Go)
View billing details
Billing method conversion
Configuration upgrade and downgrade
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 the odpscmd client
Configure endpoints
Users and Roles
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
(Optional) Use an ad-hoc query to run SQL statements
Show more
Show less
Development
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
Security white paper
MaxCompute Manager
Information schema
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
JDBC Reference
JDBC overview
Third-party tools integrated with JDBC
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