Search: "partition key"
Can the primary key function as the partition key? - HybridDB for MySQL Documentation
Yes. In HybridDB for MySQL, a column can function as both the primary key and the partition key. ...
What are primary keys, data partitions, and partition keys - Table Store Documentation
divides a table into data partitions. Data is partitioned by the first column of the primary key, which is called data partition key. Rows that have the same data partition key must belong to the same data partition. This makes sure that Table Store can make ...
Partition samples - MaxCompute Documentation
The following example takes Partition as input and output. Example 1: public static void main logic that determines whether the Partition can be used as the input of MapReduce job. ...
DYNAMIC PARTITION - MaxCompute Documentation
: create table parttable(a int, b double) partitioned by (p string); insert into parttable partition(p) select key, value To ‘insert overwrite’ into a partition table, specify the partition value in the statement. It can ...
Partition - MaxCompute Documentation
-level partition table with the date as the level one partition and the region as the level two partition create table src (key To improve MaxCompute’s processing efficiency, you can specify a partition when creating a table ...
Reasonableness evaluation of partition pruning - MaxCompute Documentation
Background and purposes Partition tables of MaxCompute refer to the partition spaces specified during table creation. This refers certain fields in the table as partition columns. When using data, if you mention the name of the ...
Which data types can be used as the partition keys of tables? - HybridDB for MySQL Documentation
HybridDB for MySQL currently allows only one column to function as the partition key of a table partition key that is composed of multiple columns. For more information, see DDL statements. ...
Partition and format data disk more than 2 TiB - Elastic Compute Service Documentation
This article describes how to partition and format a large data disk in different operating systems using the GPT data disk. Note If you want to partition and format a data disk less than 2 TiB, please see ...
Column/Partition operation - MaxCompute Documentation
Add partition Statement format: ALTER TABLE TABLE_NAME ADD [IF NOT EXISTS] PARTITION partition_spec partition_spec:(partition_col1 = partition_col_value1, partition_col2 = partiton_col_value2 ...
Why partition keys are required in creating tables? - HybridDB for MySQL Documentation
Currently, HybridDB for MySQL supports only partition tables. After you specify a partition key, HybridDB for MySQL automatically distributes data based on this key. If no partition key is specified, HybridDB for MySQL cannot decide how to distribute the data optimally. ...