Clickhouse does not support SELECT TOP 2.

See the SQL Reference of Clickhouse here. I would suggest rewritting the query using LIMIT e.g.

select storage_name
from proxy_space
LIMIT 2;