Label archiving of oceanbase

 OceanBase subquery

OceanBase subquery

In data, sub queries can be divided into dependent sub queries and non dependent sub queries. A dependent subquery means that the execution of the subquery depends on the 'variable' of the external query, so the subquery is usually calculated multiple times. A subquery without dependency means that the execution of the subquery does not depend on the 'variable' of the external query
 Oceanbase distributed aggregation push down

Oceanbase distributed aggregation push down

Aggregation operators in the database, such as sum, avg, group by, sort, etc., consume a lot of CPU and IO resources for computing, reading and writing. Through parallel execution, the corresponding operators are pushed down to each computing node, making full use of the computing resources of the cluster, and improving the execution efficiency. On the whole, the convergence
 General Syntax Summary (Below)

General Syntax Summary (Below)

Constant INT_VALUE: matches integer type constants, such as 123. DECIMAL_VALUE: matches fixed point type constants, such as 123.456. STR_VALUE: matches string constants, such as abc. NULL: matches a NULL constant. STORAGE_SIZE: Match Store