Document Center

    MaxCompute

    • Release Note
      • Announcements
      • Feature updates
      • History
    • Product Introduction
      • What is MaxCompute?
      • What you must know
      • Definitions
        • Terms
        • Project
        • Table
        • Partition
        • Lifecycle
        • Resource
        • Function
        • Task
        • Instance
        • ACID semantics
      • 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
      • Switch billing methods
      • 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
    • Tutorials
      • Build an online operation analysis platform
        • Business scenario 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
      • Common commands
        • List of common commands
        • Project operations
        • Table 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
        • Selection of tools to migrate data to the cloud
        • 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 for multi-thread uploading
          • Example for multi-thread downloading
          • Example for BufferedWriter uploading
          • Example for BufferedWriter multi-thread uploading
        • Import or export data by using Data Integration
      • SQL
        • 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
          • 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 expressions
        • CLONE TABLE
        • 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
          • Overview
          • Java UDF
          • Python UDFs
          • Open source geospatial UDFs
          • UDTF usage
          • Dynamic parameters
        • UDF examples
          • 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
          • UDT
        • UDJ
        • Appendix
          • Escape characters
          • 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 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
      • External table
        • Overview of External tables
        • STS authorization
        • Access OSS unstructured data
        • Process OSS data stored in open-source formats
        • Export unstructured data to OSS
        • Access Table Store data
      • Spark
        • Spark on MaxCompute overview
        • Set up a Spark on MaxCompute development environment
        • Running modes
        • Java and Scala development examples
          • Develop a Spark on MaxCompute application by Java or Scala
          • Spark-1.x examples
          • Spark-2.x examples
        • Develop a Spark on MaxCompute application by using PySpark
        • Check jobs
        • Spark on MaxCompute accesses VPC-type instances
      • Interactive SQL (Lightning)
        • Overview
        • Constraints and limitations
        • Quick Start
        • Access domain name
        • Access services using JDBC interfaces
          • JDBC driver
          • Configure JDBC connections
          • 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
        • Errors and warnings using the MaxCompute compiler
    • Management
      • Security management
        • Security model
        • Manage roles
          • Management roles
          • Assign management roles to a RAM user
        • Permission relationship 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 an IP address whitelist
        • Manage users and permissions
          • Authenticate users
          • Manage users
          • Authorize users
          • Manage roles
          • Check permissions
        • Column-level access control
        • Policy-based access control and download 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 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
    • 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
          • Overview
          • Create MaxCompute Java Module
          • Develop and debug UDF
          • Develop MapReduce
          • Develop Graph
          • Unstructured development
          • 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
      • 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
        • Python SDK
    • 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
        • Migrate data across DataWorks workspaces
        • Best practices of migrating data from Hadoop to MaxCompute
        • Migrate data from Oracle 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 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
      • 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
      • MapReduce Common Errors
      • Tunnel Common 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
      • 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: MaxCompute features in different regions

    How helpful was this page?

    What might be the problems?

      More suggestions?

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