ClickHouse.jl

Installation

In order to enter pkg> mode, enter a REPL and press ], then:

pkg> add ClickHouse

Usage examples

Usage examples can be found on the usage page.

Supported data types

• String, FixedString(N)
• Float32, Float64
• Int8, Int16, Int32, Int64
• UInt8, UInt16, UInt32, UInt64
• Date, DateTime, DateTime64
• Enum
• UUID
• Tuple
• LowCardinality(T)
• Nullable(T)
• Array(T)
• Nothing
• SimpleAggregateFunction
• IPv4, IPv6
• Decimals

Limitations

• Transfer compression is currently not implemented
• Timezone conversion of DateTime / DateTime64 for columns that have a timezone assigned in ClickHouse doesn't happen automatically. All DateTime objects are naive, meaning they aren't timezone aware. For reasoning, see this post and this post.

Index

• ClickHouse.ClickHouseServerException
• ClickHouse.ClickHouseSock
• ClickHouse.connect
• ClickHouse.execute
• ClickHouse.insert
• ClickHouse.ping
• ClickHouse.select
• ClickHouse.select_callback
• ClickHouse.select_channel
• ClickHouse.select_df

Contents

• API
• Types
• Functions
• ClickHouse.jl
• Installation
• Usage examples
• Supported data types
• Limitations
• Index
• Contents
• Usage
• Executing DDL
• Inserting data
• Selecting data