I have the following table:

CREATE TABLE IF NOT EXISTS "uptime" (
  "nvr_id" STRING NULL INVERTED INDEX,
  "value" BIGINT NULL,
  "greptime_timestamp" TIMESTAMP(9) NOT NULL,
  TIME INDEX ("greptime_timestamp"),
  PRIMARY KEY ("nvr_id")
)

And I want to run this query:

SELECT DISTINCT nvr_id FROM lrm_nvr.uptime;

This query takes ~16s to run (~99,194,924 rows). Is there a way to make this query faster? Or is there another query I can make?

Do you mean that there are ~99,194,924 distinct nvr_ids? Currently, you can consider using a flow task to compute the distinct set of nvr_id in a new table.