clickhouse
clickhouse copied to clipboard
archan937
A Ruby database driver for Clickhouse
```` Clickhouse.connection.create_table("events") do |t| t.fixed_string :id, 16 t.array :array_data, 'String' t.date :date t.engine "MergeTree(date, (date), 8192)" end ```` ```` Clickhouse.connection.insert_rows("events", :names => %w(id array_data date)) do |rows| rows
Can be used as: `` con = Clickhouse::Connection.new { session_id: true, ... } con.execute "CREATE TEMPORARY TABLE ..." ``
There is error in this code example ```ruby Clickhouse.connection.insert_rows(events, :names => %w(id year date time event user_id revenue)) do |rows| ... end ``` `events` changed to `"events"`
When I run this command `Clickhouse.connection.databases` it gives an error Clickhouse::QueryError: Got status 401 (expected 200): Code: 194, e.displayText() = DB::Exception: Password required for user default (version 19.17.6.36 (official build))...
Does this gem support defining default value as what is descried in clickhouse documentation metioned bellow? ``` CREATE [TEMPORARY] TABLE [IF NOT EXISTS] [db.]name [ON CLUSTER cluster] ( name1 [type1]...
While in clickhouse console: ``` SELECT count() FROM tracks WHERE date = '2019-07-09' ┌─count()─┐ │ 4162001 │ └─────────┘ ``` And Rails log shows ``` DEBUG -- : SELECT count() FROM...
For your review... This addresses the insertion of rows with NULLs, related to https://github.com/archan937/clickhouse/issues/5 There are extra changes in this too to deal with ability to pass in a self-signed...
Recently Yandex added support for **Nullable** types. But this gem does not support them. Nullable fields are not documented yet. Some info can be found [here](https://github.com/yandex/ClickHouse/blob/933313aea3d4fa1c217e4191b005055cf6caad0a/doc/example_datasets/nyc_taxi.md) I forked gem and...
session_id parameter for the connection can be used to setup a session with Clickhouse One application is using TEMPORARY TABLE
If I have a table with two columns, “foo” and “bar”, I cannot use `insert_rows` to insert a record with only “foo”, because `insert_rows` doesn't actually use the “rows” parameter....
