We can use more than one column as a partition key. In list partition, the partition is defined by a discrete list of values. List partition: This type of partition is completely different from the other two partitions.Hash partition is also used as an alternative to range partition. The mapping of rows is based on the hash value of the partition key. Hash Partition: it is used to evenly distribute data across all the partitions that are defined.It is one of the most common ways of doing partition. It maps data based on the ranges of values of the partitioning key and the range is already established for each partition and based on that the values are stored in each partition. Range Partition: This type of partition is used when data is distributed over a range of values.Let us now discuss each one of them below.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |