Unnecessary columns should not be included in the partitioning key.
分区键中不应该包括不必要的列。
Choosing the right partitioning key is critical for two reasons.
选择正确的分区键之所以如此关键,有两方面的原因。
The partitioning key should include the most frequently joined columns.
分区键应该包括最常连接的列。
A partitioning key consists of one or more columns defined at table creation.
一个分区键由在表创建时定义的一个或多个列组成。
Have the corresponding columns of the partitioning key be partition compatible.
分区键的相应列是分区兼容的。
The following rules and recommendations apply to the partitioning key definition
如下的规则和建议适用于分区键定义
In a non-partitioned database, no partitioning key or partitioning map is required.
在一个非分区数据库中,不需要分区键或分区映射。
The columns used in this definition are referred to as the table partitioning key columns.
该定义中使用的列被称为表分区键列。
For each column in the partitioning key of the joined tables, an equijoin predicate must exist.
对于被合并的表的分区键内的每列,必须存在一个同等连接的谓语。
The partitioning key should be made up of columns that often participate in a GROUP BY clause.
分区键应该由常用于GROUP BY子句的列组成。
One of the recommendations shown for the LINEITEM table is to change the hash partitioning key.
关于lineitem表的一个建议是更改hash分区键。
In such cases, it is recommended that you choose a partitioning key based on even data balancing.
在这些情况下,建议您基于数据平衡选择分区键。
When you use the partitioning key in the join predicate, a final consideration needs to be mentioned.
如果在连接谓词中使用分区键(partitioning key),最后还有一点考虑需要顾及。
The resolution is to ensure that a partitioning key is defined for the table before a load takes place.
其解决方案就是确保在加载表之前,为该表定义一个分区键(partitioning key)。
This example tests the data skew in a scenario in which the partitioning key was changed to S_NATIONKEY.
这个示例测试的是分区键被更改为S_NATIONKEY的场景中的数据倾斜。
The primary key and any unique index of the table must be a superset of the associated partitioning key.
表的主键和所有惟一索引都必须是相关分区键的超集。
The cost of applying the partitioning hash algorithm is proportional to the size of the partitioning key.
应用分区散列算法的代价与分区键的规模成比例。
An integer partitioning key is more efficient than a character key, which is more efficient than a decimal key.
整型分区键要比字符键高效,而字符键又比小数键高效。
If there is no partitioning key provided explicitly in the CREATE TABLE command, the following defaults are used.
如果在CREATETABLE命令内没有显式地提供分区键,那么就会使用如下的这些默认值。
This example tests the data skew in a scenario in which the partitioning key was changed from S_NATIONKEY to S_ID.
这个示例测试的是分区键从 S_NATIONKEY 更改为 S_ID 的场景中的数据倾斜。
For TP, design decisions include selecting the column to use as the table partitioning key and number of partitions.
对于TP,设计决定包括选择用作表分区键的列和分区的数量。
Note that a new partitioning key is recommended (L_ORDERKEY) to replace the current one (L_PARTKEY), which is commented out.
注意,这里建议了一个新的分区键(L_ORDERKEY),用以替代当前的分区键(L_PARTKEY),后者被注释掉了。
The group of columns specified make up the partitioning key for the table —see sidebar, "Choosing a table partitioning key."
指定的列组成表的分区键 —参见边栏 “选择表分区键”。
The hashing algorithm is applied to the value of the partitioning key, and generates a partition number between zero and 4095.
散列算法应用于分区键的值,产生 0 到 4095之间的一个分区号。
In other words, all columns that are part of the partitioning key must be present in the primary key or unique index definition.
换句话说,作为分区键一部分的所有列都必须出现在主键或惟一索引定义中。
Tables that will be joined on the partitioning key should have the same number of partitions and should break on the same values.
需要按分区键进行连接的表应该有相同数量的分区,并且应该在相同的值上断开。
Based on your application's business processes, you need to identify which tables to partition with the correct partitioning key.
您需要根据应用程序的业务流程,确定用正确的分区键划分哪些表。
Columns with unevenly distributed data and columns with a small number of distinct values should not be chosen as a partitioning key.
具有分布不均匀的数据的列和具有少量distinct值的列都不应该被选作分区键。
A partitioning key is a column (or group of columns) that is used to determine the partition in which a particular row of data is stored.
分区键是用于确定特定一行数据存储在哪个分区的一个列(或一组列)。
应用推荐