Yugabyte DB automatically splits tables into multiple shards, called tablets, using either hash or range-based strategy. Sharding is a process of breaking up large tables into smaller shards that are spread across multiple servers. A shard is essentially a horizontal data partition that contains a subset of the total data set.
You can display the shards (tablets) in YCQL by querying the SYSTEM.PARTITIONS table.
SELECT id, replica_addresses FROM system.partitions WHERE keyspace_name = 'keyspace name' and table_name = 'table name';
Example:
cassandra@ycqlsh> CREATE KEYSPACE test;
cassandra@ycqlsh> USE test;
cassandra@ycqlsh:test> CREATE TABLE test (c1 INT, c2 VARCHAR, c3 VARCHAR, PRIMARY KEY((c1), c2));
cassandra@ycqlsh:test> SELECT id, replica_addresses FROM system.partitions WHERE keyspace_name = 'test' and table_name = 'test';
id | replica_addresses
--------------------------------------+----------------------------------------------------------------------------------------
9a75898f-a2fe-68af-a54f-250b46d1357f | {'172.161.25.249': 'FOLLOWER', '172.161.46.42': 'FOLLOWER', '172.161.55.44': 'LEADER'}
1aca3973-32e6-38af-da48-7517b27adcc2 | {'172.161.25.249': 'FOLLOWER', '172.161.46.42': 'LEADER', '172.161.55.44': 'FOLLOWER'}
2bc3001a-1a65-1daa-7845-264fd18a3005 | {'172.161.25.249': 'LEADER', '172.161.46.42': 'FOLLOWER', '172.161.55.44': 'FOLLOWER'}
(3 rows)
In the example above the TEST table has three shards (tablets).
Have Fun!