Use case

ClickHouse should be able to serve large amount of short queries on prepared datasets.

For example, you can prepare a dataset for user personalization or antifraud and serve it directly by clickhouse-server in realtime in ad-network, RTB, for DDoS prevention, e-commerce apps, games, etc...

Describe the solution you'd like

1. clickhouse-server should have TCPHandler that will implement Redis or Memcached protocol.
2. Add get method to IStorage interface and supportsGetRequests. The method takes array of Fields and returns array of Fields.
3. Implement this method for StorageDictionary, EmbeddedRocksDB, Join, Set and (when it will be ready), AggregatingMemory. Then implement it for Distributed tables.