Document Center

    MaxCompute

    • Release Note
      • Announcements
      • Document updates
      • History
    • Product Introduction
      • What is MaxCompute?
      • What you must know
      • Definitions
        • Terms
        • Project
        • Table
        • Partition
        • Lifecycle
        • Resource
        • Function
        • Task
        • Instance
        • ACID semantics
      • Limits
      • Storage performance
      • MaxCompute features in different regions
    • Pricing
      • Billing
      • Storage pricing (pay-as-you-go)
      • Computing pricing
      • Download pricing(Pay-As-You-Go)
      • View billing details
      • Switch billing methods
      • Upgrade or downgrade configurations
      • Outstanding payment warning and suspension policies
      • Renewal management
    • Type
      • Subscription
      • Pay-as-you-go
    • Prepare
      • Create an Alibaba Cloud account
      • Create RAM users
      • 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
    • Tutorials
      • Build an online operation analysis platform
        • Business scenarios and development process
        • Prepare the environment
        • Prepare data
        • Build data models and analyze data
          • Create tables
          • Design workflows
          • Configure nodes
          • Commit and test nodes
        • Display data on dashboards
    • Development
      • Data types
        • Data type editions
        • MaxCompute V1.0 data type edition
        • MaxCompute V2.0 data type edition
        • Hive-compatible data type edition
        • Compatibility between components and data types
      • Common commands
        • List of common commands
        • Project operations
        • Table-level operations
        • Instance operations
        • Resource operations
        • Functions operations
        • SET operations
        • Time zone configuration operations
        • Other operations
      • Data upload and download
        • Overview
        • Connection to data tunnel service
        • Select tools to migrate data to MaxCompute
        • Introduction to the tools
        • Run Tunnel commands to upload and download data
          • Tunnel command usage
          • Tunnel commands
        • Tunnel SDK
          • MaxCompute Tunnel overview
          • TableTunnel
          • InstanceTunnel
          • UploadSession
          • DownloadSession
          • TunnelBufferedWriter
        • Bulk data channel SDK example
          • Example
          • Simple upload
          • Simple download example
          • Example for multi-thread uploading
          • Multi-threaded download
          • Data upload by using BufferedWriter
          • Data upload by using BufferedWriter in multi-threaded mode
          • Examples of uploading and downloading complex data
        • Import or export data by using Data Integration
      • SQL
        • MaxCompute SQL overview
        • MaxCompute SQL limits
        • Differences with other SQL statements
        • Operators
        • Data type conversion
        • DDL SQL
          • Table operations
          • Lifecycle management operations
          • Partition and column operations
          • View-related operations
        • Insert Operation
          • INSERT OVERWRITE and INSERT INTO
          • MULTI INSERT
          • Insert data in dynamic partition mode (DYNAMIC PARTITION)
          • VALUES
        • Select Operation
          • SELECT syntax
          • Sequence of clauses in a SELECT statement
          • Subquery
          • UNION, INTERSECT, and EXCEPT
          • JOIN
          • SEMI JOIN
          • MAPJOIN HINT
          • Lateral View
          • HAVING clause
          • Grouping Sets
          • SELECT TRANSFORM
        • Script Mode SQL
        • Common table expressions
        • CLONE TABLE
        • Explain
        • LOAD
        • 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
          • Overview
          • Java UDF
          • Python 2 UDFs
          • Python 3 UDFs
          • Code-embedded UDFs
          • Open source geospatial UDFs
          • UDTF usage
          • SQL functions
          • Dynamic parameters
        • UDF examples
          • Obtain a JSON string
          • Check the value of a JSON string
          • Convert data types to JSON STRING
          • Add key-value pairs to a JSON string
          • Obtain the values of strings that have delimiters
          • Obtain the character at a specific position in a URL
          • Obtain a remainder
          • Replace strings by using regular expressions
          • Obtain the values of strings that have no delimiters
          • Obtain time in a specific format
        • UDT
          • Usage examples
          • UDT
        • UDJ
        • Appendix
          • Escape character
          • LIKE usage
          • Regular expression
          • Reserved words and keywords
          • Mapping of data types
      • MapReduce
        • Summary
          • MapReduce
          • Extended MapReduce model
          • Open source MapReduce
        • Limits
        • Function Introduction
          • Basic concepts
          • Job submission
          • Input and output
          • Resources
          • Local run
        • Program Example
          • WordCount
          • MapOnly samples
          • MultipleInOut
          • Multi-task samples
          • SecondarySort
          • Resource samples
          • UserDefinedCounters
          • Grep
          • JOIN
          • Sleep samples
          • Unique samples
          • Sort samples
          • Partition samples
          • Pipeline samples
        • Java SDK
          • Java SDK
          • Overview of compatible versions of the SDK
          • Java Sandbox
      • Mars
        • Overview
        • Preparations
        • Instructions
      • External table
        • Overview of External tables
        • STS authorization
        • Access OSS data by using the built-in extractor
        • Access unstructured data in OSS by using a custom extractor
        • Partition data by using foreign tables
        • Process OSS data stored in open source formats
        • Export unstructured data to OSS
        • Access Table Store data
      • PyODPS
        • Quick start
        • Installation guide and limits
        • Platform instructions
          • Overview
          • Migrate PyODPS nodes from a data development platform to a local PyODPS environment
          • Use PyODPS in DataWorks
          • Create a PyODPS 3 node
        • Basic operations
          • Overview
          • Projects
          • Tables
          • SQL
          • Task instances
          • Resources
          • Functions
        • Configurations
        • DataFrame
          • Overview
          • Quick start
          • Create a DataFrame object
          • Sequence
          • Collection
          • Execution
          • Column operations
          • Aggregation
          • Sort, deduplicate, sample, and transform data
          • Use UDFs and the third-party Python libraries
          • MapReduce API
          • Data merging
          • Window functions
          • Plotting
          • Debugging
        • User experience enhancement
          • Command line
          • IPython
          • Jupyter Notebook
        • API overview
        • Examples
          • Reference a third-party package in a PyODPS node
          • Use a PyODPS node to query data based on specific criteria
          • Use a PyODPS node to pass parameters
          • Use a PyODPS node to read data from a partitioned table
          • Use a PyODPS node to read data from the level-1 partition of the specified table
          • Use a PyODPS node to perform sequence operations
          • Use a PyODPS node to aggregate data
          • Use a PyODPS node to perform column operations
          • Use a PyODPS node to sort data
          • Use a PyODPS node to de-duplicate data
          • Use a PyODPS node to sample data
          • Use a PyODPS node to scale data
          • Use a PyODPS node to process NULL values
      • Spark
        • Spark on MaxCompute overview
        • Set up a Spark on MaxCompute development environment
        • Running modes
        • Java and Scala development examples
          • Develop a demo project on Spark on MaxCompute by using Java or Scala
          • Spark-1.x examples
          • Spark-2.x examples
        • Develop a Spark on MaxCompute application by using PySpark
        • Check jobs
        • Access instances in a VPC from Spark on MaxCompute
        • Configure Spark on MaxCompute to access OSS resources
      • Interactive SQL (Lightning)
        • Overview
        • Constraints and limitations
        • Quick Start
        • Access domain name
        • Access services using JDBC interfaces
          • JDBC driver
          • Configure a JDBC connection
          • Access services using common tools
        • Query syntax and built-in functions
        • View tasks
        • 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
        • Use Logview V2.0 to view job running information
        • Errors and warnings using the MaxCompute compiler
      • Open-source features of MaxCompute
    • Management
      • Security management
        • Security models
        • Manage roles
          • Management role permissions
          • Assign management roles to a RAM user
        • Permission relationships between MaxCompute and DataWorks
        • Management of users and permissions
        • Enable security features
      • Configure security features
        • Target users
        • Quick Start
          • Use case: Add users and grant permissions
          • Add a role and grant permissions to the role by using ACL
          • Use case: Project data protection
          • Configure IP address whitelists
        • Manage users and permissions
          • User authentication
          • Manage users
          • Authorize users
          • Manage roles
          • Check permissions
        • Column-level access control
        • Policy-based access control and download control
        • Resource share across project space
          • Package-based resource sharing across projects
          • Package usage method
        • Project security configurations
        • Project data protection
        • Security command list
          • Statements for project security configurations
          • Statements for project permission management
          • Statements for package-based resource sharing
      • Security management use cases
        • Create a project
        • Grant packages
        • Check data security
        • Manage permissions by using a RAM user
        • Manage permissions by row
      • Security white paper
        • MaxCompute security white paper
      • Resource and job management
        • MaxCompute Management
      • Information schema
        • Overview
        • Metadata views
      • Audit logs
      • Data encryption
    • Tools and Downloads
      • Client
      • MaxCompute Studio
        • What is Studio
        • Tools Installation and version history
          • Install IntelliJ IDEA
          • Installation procedure
          • View and upgrade the version
        • Configure MaxCompute Studio
        • Manage project connections
        • 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
          • Overview
          • Create MaxCompute Java Module
          • Develop and debug UDF
          • Develop MapReduce
          • Develop Graph
          • Unstructured development
          • Package、Upload and Register
        • Develop a Python program
          • Configure a Python development environment
          • Develop a Python UDF
          • Develop a PyODPS script
        • 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
      • Downloads
    • SDK Reference
      • Java SDK
        • Java SDK
        • Java SDK examples
          • Run security-related commands
          • Instance Logview
          • Return error logs
          • Set the SQL flag
          • Use SQLTask and Tunnel to export a large amount of data
      • Python SDK
        • Overview
        • SDK for Python
    • JDBC Reference
      • Overview
      • Usage notes
      • Third-party tools integrated with JDBC
        • Configure MaxCompute JDBC on Tableau
        • Configure MaxCompute JDBC on SQL Workbench/J
    • Best Practices
      • SQL
        • 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
        • Overview
        • Migrate data across DataWorks workspaces
        • Best practices of migrating data from Hadoop to MaxCompute
        • Migrate data from an Oracle database to MaxCompute
        • Migrate data from a Kafka cluster to MaxCompute
        • Migrate data from an Elasticsearch cluster 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
        • Migrate data from MaxCompute to Tablestore
        • Migrate data from MaxCompute to OSS
        • Migrate data from a user-created MySQL database on an ECS instance to MaxCompute
        • Migrate data from Amazon Redshift to MaxCompute
        • Migrate data from BigQuery to MaxCompute
        • Migrate log data to MaxCompute
          • Overview
          • Use Tunnel to upload log data to MaxCompute
          • Use DataHub to migrate log data to MaxCompute
          • Use DataWorks Data Integration to migrate log data to MaxCompute
      • Data development
        • Use IntelliJ IDEA to develop a Java-based UDF
        • Use MaxCompute to analyze IP sources
        • Upload files exceeding 10 MB to DataWorks
        • Grant access to a specific UDF to a specified user
        • Use a PyODPS node to segment Chinese text based on Jieba
        • Use a PyODPS node to download data to a local directory for processing or to process data online
      • Compute optimization
        • SQL optimization
        • Optimize JOIN long tails
        • Optimize long tail computing
        • Computing optimization program for long period indicators
        • Analyze MaxCompute bills
      • Cost optimization
        • Overview
        • Select a billing method
        • Optimize computing costs
        • Optimize storage costs
        • Optimize the costs of data uploads and downloads
        • Manage costs
        • Command reference
      • Security management
        • Set a RAM user as the super administrator for a MaxCompute project
    • Error Code Appendix
      • Common errors
      • Common SQL errors
      • Common MapReduce errors
      • Common Tunnel errors
    • Service Agreements
      • Service Level Agreement of MaxCompute
    • 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 pair
      • ICP Filing
      • Glossary
 
All Products
Search
  • Document Center
  • MaxCompute
  • Product Introduction
  • Limits

This Product

  • This Product
  • All Products

    Limits

    Document Center
    Download PDF

    Limits

    Last Updated: Feb 17, 2020

    This topic provides limits of MaxCompute product modules.

    The limits include:
    • Limits of SQL
    • Limits of data upload and download
    • Limits of using common commands
    • Limits
    • Limits of MaxCompute Graph
    • Limits of security configuration
    • Limits of MaxCompute Lightning
    Previous: ACID semantics Next: Storage performance

    How helpful was this page?

    What might be the problems?

      More suggestions?

      Thank you! We've received your feedback.
      Free Trial Free Trial