DB for data saving without UPDATE and DELETE with selection on the indexed field?

Question

Database design

You need to select a database to which records of the following format will be written:

Time: DateTime
K: float16
TypeId: smallint (8 бит)
ExternalKeyId: long

Approximately 20 million records per day and more.
TypeId and ExternalKeyId are keys that are stored in another database.
It turns out that in a DB there will be quite a lot of records. The main requirement: data sampling by the ExternalKeyId field should work quickly. A query like
SELECT * FROM Table WHERE ExternalKeyId = ?
At a time returns from 15 to 1000 or more records, but there are many queries. Complex analytical queries are not planned.

Answer 1

Clickhouse
only sampling learn