# Hash Partitioned Table

__*Hash Partition*__

```10
CREATE TABLE test.t1 (x INT)
    PARTITION BY HASH(x)
    PARTITIONS 4;
...

tidb> explain select * from test.t1 where x=7;
+-------------------------+----------+-----------+------------------------+--------------------------------+
| id                      | estRows  | task      | access object          | operator info                  |
+-------------------------+----------+-----------+------------------------+--------------------------------+
| TableReader_9           | 10.00    | root      |                        | data:Selection_8               |
| └─Selection_8           | 10.00    | cop[tikv] |                        | eq(test.t1.x, 7)               |
|   └─TableFullScan_7     | 10000.00 | cop[tikv] | table:t1, ~!@partition:p3@!~ | keep order:false, stats:pseudo |
+-------------------------+----------+-----------+------------------------+--------------------------------+
3 rows in set (0.00 sec)
```

------------------------------------------------------------

Class demo scripts:

https://github.com/pingcap/tidb-course-201-lab/blob/master/scripts/07-demo-partition-hash-01-show.sql

```
CREATE TABLE test.t1 (x INT)
    PARTITION BY HASH(x)
    PARTITIONS 4;
```