Community

Blog Events Webinars Tutorials Forum
  1. Blog
  2. Events
  3. Webinars
  4. Tutorials
  5. Forum
Create Account
×
SQL

ODPS SQL - Transpose Column to Row or Row to Column

This article describes how to use TRANS_ARRAY and LATERAL VIEW EXPLODE functions to transpose columns to rows in MaxCompute.

How to Optimize Slow SQL in PolarDB-X

This tutorial will guide you through optimizing slow SQL in PolarDB-X.

Introduction to Application Scenarios of PostgreSQL JSON and Optimization of Shared Detoast

This article introduces the application scenarios of PostgreSQL JSON and the optimization of Shared Detoast.

Accelerated Integration: Unveiling Flink Connector's API Design and Latest Advances

This article is compiled from the presentation by Ren Qingsheng, committer and PMC member of Apache Flink, at the Flink Forward Asia 2023 core technology session (Part 2).

Life of an SQL Task

This article outlines the SQL statement execution process, offering insights and guidance for newcomers to big data development.

Understand Flink SQL: Real-Time SQL Query Execution for Stream and Batch Data

Discover Flink SQL, the high-level API for executing SQL queries across streaming and batch data sets in Apache Flink.

Interpretation of Global Binlog and Backup and Restoration Capabilities of PolarDB-X 2.0

This article delves into PolarDB-X 2.0's Global Binlog feature and its backup and restoration functionalities, highlighting their role in preventing data silos and safeguarding database information.

PolarDB-X Optimizer Core Technology: Execution Plan Management

This article discusses the importance of SQL Plan Management in maintaining stable database performance by optimizing the execution plan and managing multiple plans for a single SQL query.

PolarDB-X Best Practice Series (2): How to Implement Efficient Paged Queries

This article introduces how to efficiently perform paging operations in a standalone database or distributed database.

PolarDB-X Best Practice Series (1): How to Design a User Table

This article describes how to desgine a user table efficiently.

MySQL Memory Allocation and Management (Part II)

This article introduces the structure and usage of InnoDB memory. The code is based on version 8.0.25.

MySQL Memory Allocation and Management (Part I)

This article introduces the memory allocation manager at the InnoDB layer and the SQL layer, including ut_allocator, mem_heap_allocator, and MEM_ROOT.

MySQL Memory Allocation and Management (Part III)

This article interprets the MySQL memory limit feature. The code is based on version 8.0.28.

MaxCompute Unleashed - Part 12: PIVOT/UNPIVOT

This article introduces the new syntax supported by MaxCompute - PIVOT/UNPIVOT.

MaxCompute Unleashed - Part 13: Global Zorder

This article introduces the support of Global Z-Order in MaxCompute.

MaxCompute Unleashed - Part 11: QUALIFY Clause

Part 11 of the "Unleash the Power of MaxCompute" series introduces the features and use of QUALIFY Clause.

MaxCompute Unleashed - Part 10: IF ELSE Branch Statement

Part 10 of the "Unleash the Power of MaxCompute" series introduces the script mode and parameterized views of MaxCompute.

MaxCompute Unleashed - Part 7: Grouping Set, Cube and Rollup

Part 7 of the "Unleash the Power of MaxCompute" series introduces MaxCompute's support for GROUPING SETS.

MaxCompute Unleashed - Part 3: Complex Type Functions

Part 3 of the “Unleash the Power of MaxCompute” series describes the complex type functions of MaxCompute.

MaxCompute Unleashed - Part 2: Basic Data Types and Built-in Functions

Part 2 of the “Unleash the Power of MaxCompute” series describes the basic data types and built-in functions of MaxCompute.

Related Tags
artificial intelligence big data cloud computing