Search: "mapjoin"
MAPJOIN HINT - MaxCompute Documentation
This topic describes how to use a MAPJOIN statement to join a large table with one or more small tables. It is ...
MaxCompute SQL performance tuning Forums
convenient queries and optimize SQL efficiency. Some existing tuning settings that used to require manual operations such as MapJoin ...
Demo: Modify incompatible SQL - MaxCompute Documentation
The earlier version of MaxCompute still keeps the physical execution plan when MapJoin Hints are added, and gives priority ...
SQL limits - MaxCompute Documentation
performed on a maximum of 256 tables. MAPJOIN   Eight small tables Quantity limit ...
SQL Common Errors - MaxCompute Documentation
examples in Data types or introduction on date functions in Built-in functions. ODPS-0123121:Mapjoin ...
Learn to write SQL statements quickly - MaxCompute Documentation
Cartesian projects and usage of MapJoin. Union all must use the format of subqueries. The In/Not in statements can ...
Basic differences with standard SQL and solutions - MaxCompute Documentation
set to 10,000. If the number of data records to be queried is large. MAPJOIN The Join clause does not ...
SQL optimization - MaxCompute Documentation
exceed 512 MB, you can optimize the preceding statement into mapjoin statement.select /*+ MAPJOIN(B) */ * from A join B on A.value ...
Optimize long tail computing - MaxCompute Documentation
use the mapjoin statement to cache the small table. For the syntax and relevant description, see Introduction to the SELECT ...
On Kafka Stream: A lightweight stream computing mode Forums
be of a certain value, because it does not offer MapJoin. In the previous version, EventTime and other Meta fields are also not provided. ...