Last Updated: Jun 21, 2016

In order to improve the processing efficiency, you can specify the partition when creating a table. That is, several fields in the table are specified as partition columns. In most cases, user can consider the partition to be the directory under the file system. User can specify multiple partitions, that is, multiple fields of the table are considered as the partitions of the table, and the relationship among partitions is similar to that of multiple directories. If the partition columns to be accessed are specified when using data, then only corresponding partitions are read and full table scan is avoided, which can improve the processing efficiency and save costs. For detailed description, please see the description in Partition.

Thank you! We've received your feedback.