Nodetool getendpoints¶

getendpoints - <keyspace> <table> <key>- Print the end-points IP or name of the nodes that own the partition key. getendpoints - <keyspace> <table> <key-components> - Print the end-points IP or name of the nodes that own the partition key.

Use this command to know which node holds the specific partition key.

For example:

nodetool getendpoints nba player_name Russell

In a case of a composite partition key, use : between columns in the key. All columns in the partition key are required. Alternatively, you can use the --key-components option to specify each component of the partition key separately, instead of combining them into a single colon-separated string. This approach avoids ambiguity when key values contain colons. All partition key columns must be specified, and they must be provided in the correct order as defined in the table schema. You must specify either the --key or the --key-components option, but not both.

ScyllaDB does not support getendpoints for a partition key with a frozen UDT.

Example 1: Single partition key

CREATE TABLE superheroes (
   firstname text,
   lastname text,
   age int,
   PRIMARY KEY (firstname)
);

nodetool getendpoints "superheroes" "peter"

This retrieves the nodes responsible for the partition key peter in the superheroes table.

Example 2: Composite partition key (specified as colon-separated string)

CREATE TABLE superheroes (
   firstname text,
   lastname text,
   age int,
   PRIMARY KEY ((firstname, lastname))
);

nodetool getendpoints "mykeyspace" "superheroes" "peter:parker"

When using a composite partition key, separate the components with a colon (:) in the order defined in the schema.

Example 3: Composite partition key (specified by individual components)

CREATE TABLE superheroes (
   firstname text,
   lastname text,
   age int,
   PRIMARY KEY ((firstname, lastname))
);

nodetool getendpoints "mykeyspace" "superheroes" --key-components "peter" --key-components "parker"

Example 4: Composite partition key with colon

CREATE TABLE superheroes (
   firstname text,
   lastname text,
   age int,
   PRIMARY KEY ((firstname, lastname))
);

nodetool getendpoints "mykeyspace" "superheroes" --key-components "peter:the-great" --key-components "parker"

In this example, the first key component includes a colon, which would cause parsing issues in the string format. Using --key-components ensures it’s interpreted correctly.

Nodetool Reference