---
title: clickhouse.query() function
description: clickhouse.query() queries data from ClickHouse using specified parameters.
url: https://docs.influxdata.com/flux/v0/stdlib/contrib/qxip/clickhouse/query/
estimated_tokens: 1073
product: Flux
version: v0
---

# clickhouse.query() function

-   Flux 0.192.0+
-   View InfluxDB support

`clickhouse.query()` is a user-contributed function maintained by the [package author](#package-author-and-maintainer).

`clickhouse.query()` queries data from ClickHouse using specified parameters.

##### Function type signature

```js
(
    query: string,
    ?cors: string,
    ?format: string,
    ?limit: A,
    ?max_bytes: B,
    ?url: string,
) => stream[C] where A: Stringable, B: Stringable, C: Record
```

For more information, see [Function type signatures](/flux/v0/function-type-signatures/).

## Parameters

### url

ClickHouse HTTP API URL. Default is `http://127.0.0.1:8123`.

### query

(Required) ClickHouse query to execute.

### limit

Query rows limit. Defaults is `100`.

### cors

Request remote CORS headers. Defaults is `1`.

### max\_bytes

Query bytes limit. Default is `10000000`.

### format

Query format. Default is `CSVWithNames`.

*For information about available formats, see [ClickHouse formats](https://clickhouse.com/docs/en/interfaces/formats/).*

## Examples

### Query ClickHouse

```js
import "contrib/qxip/clickhouse"

option clickhouse.defaultURL = "https://play@play.clickhouse.com"

clickhouse.query(query: "SELECT version()")
```

[inputs](/flux/v0/tags/inputs/)