This article introduces the new syntax supported by MaxCompute - PIVOT/UNPIVOT.
This article introduces the support of Global Z-Order in MaxCompute.
Part 11 of the "Unleash the Power of MaxCompute" series introduces the features and use of QUALIFY Clause.
Part 10 of the "Unleash the Power of MaxCompute" series introduces the script mode and parameterized views of MaxCompute.
Part 7 of the "Unleash the Power of MaxCompute" series introduces MaxCompute's support for GROUPING SETS.
Part 3 of the “Unleash the Power of MaxCompute” series describes the complex type functions of MaxCompute.
Part 2 of the “Unleash the Power of MaxCompute” series describes the basic data types and built-in functions of MaxCompute.
Part 5 of the "Unleash the Power of MaxCompute" series introduces the support of MaxCompute for other scripting languages - SELECT TRANSFORM.
Part 4 of the "Unleash the Power of MaxCompute" series describes the improvements of MaxCompute in the SQL DML.
Part 6 of the "Unleash the Power of MaxCompute" series describes a new feature called User Defined Type (UDT).
Part 1 of the “Unleash the Power of MaxCompute” series describes the improvements of MaxCompute in usability.
The focus of this article is maximizing SQL capabilities. It explores a unique approach, using basic syntax to solve complex data scenarios through flexible and divergent data processing thinking.
This article describes an overview of the newly released features in SQL Server 2022 and the authors’s personal understanding of each function as a user.
In a bypass attack, the attacker's primary goal is to acquire information and inject a file or web shell code into the targeted system.
This article explains how to use PostgreSQL Recursive SQL and the PL/pgSQL function to draw fractal graphs (with examples).
All well-known open-source products (such as MySQL, Spark, and Presto) have optimizers. This article explains the principle of SQL optimizers with an easy-to-understand approach.
Part 20 of this series discusses another important SQL optimization method: rule-based optimization (RBO).
Part 19 of this series discusses SQL performance optimization.
This short article uses a demo to explain how to use OpenAI to convert natural language instructions into SQL queries.
This article is compiled from Xiaolin He’s presentation at the 2022 Flink Forward Asia (FFA) Conference, discussing Flink SQL insight, best practices, and future works.