Querying Data

Hydrolix provides a number of query interfaces that can be used to interact with the system.

Query HTTP API

An HTTP interface is available for querying data. This is accessible by querying via HTTP using GET or POST to https://your-host.domain/query

$ curl -XPOST https://try.hydrolix.net/query -d 'Select count() from sample_project.sample_table'
2010

$ curl 'https://try.hydrolix.net/query?query=SELECT%20count()%20FROM%20sample_project.sample_table'
2010

Native Clickhouse

The Native interface is available for access for connectivity using such things as the clickhouse-client. For example to connect you would use.

clickhouse-client -h myhostname --port 9440 -s

Portal Query

The portal uses the HTTP API to make queries. This environment is good for cursory tests however we'd recommend using alternative clients or 3rd Party Integrations for result sets anticipated to be larger than 10,000 rows.