Home

(View project on GitHub)

Getting Started

The package can be installed with the Julia package manager. From the Julia REPL, type ] to enter the Pkg REPL mode and run:

pkg> registry add https://github.com/maxmouchet/JuliaRegistry.git
pkg> add ClickHouse

using ClickHouse
client = ClickHouseClient("http://localhost:8123")

table_sql = """
CREATE TABLE clickhouse_jl_test (
    a UInt32,
    b Float64)
ENGINE MergeTree()
ORDER BY a
"""

query(client, table_sql)
query(client, "INSERT INTO clickhouse_jl_test (a, b) VALUES (1, 3.14) (2, 1.61)")

query(client, "SELECT * FROM clickhouse_jl_test")
# df = 2×2 DataFrames.DataFrame
# │ Row │ a      │ b        │
# │     │ Int64⍰ │ Float64⍰ │
# ├─────┼────────┼──────────┤
# │ 1   │ 1      │ 3.14     │
# │ 2   │ 2      │ 1.61     │

query(client, "DROP TABLE clickhouse_jl_test")