click_house

click_house copied to clipboard

I'd like to use [`Lowcardinality`](https://clickhouse.com/docs/en/sql-reference/data-types/lowcardinality/), but as far as I can tell that isn't currently implemented in this library. I can contribute a patch to help implement this feature, but...

benschwarz

Clickhouse 22.6 introduced `X-ClickHouse-Exception-Code` which you can check for any errors. This is especially useful when we use the `send_progress_in_http_headers` parameter, as in this case, the ClickHouse server doesn't really...

madejejej

``` create table dt_type_test ( a DateTime , b Nullable(DateTime) , c DateTime64(3) , d Nullable(DateTime64(3)) , e DateTime64(3, 'UTC') , f Nullable(DateTime64(3, 'UTC')) , g Decimal(18,2) ) engine=Log ;...

slotrans

Hi @shlima There is one question. When a query is made via (select_all, select_value or select_one) method, get method is called: ``` def select_all(sql) response = get(body: Util::Statement.format(sql, 'JSON')) Response::Factory[response]...

lireirelico

`.select_all` and `.select_one` methods return inconsistent data when # of rows is above a certain threshold

8

Hey @shlima! During local testing, I'm noticing inconsistent data returned by the [`.select_all`](https://github.com/shlima/click_house/blob/360d8870c198f3172d69592e78ef63a2eec90d5e/lib/click_house/extend/connection_selective.rb#L7) and [`.select_one`](https://github.com/shlima/click_house/blob/360d8870c198f3172d69592e78ef63a2eec90d5e/lib/click_house/extend/connection_selective.rb#L17) methods. Specifically, when there is X amount of data inserted into the table (in my...

jlholm

We sometimes fetch a lot of data from Clickhouse and the default Faraday JSON parser is quite slow. Patching the JSON library with the Oj gem would help, but I...

madejejej

TypeError - String does not have #dig method

1

Always i get this error on my requests, does anyone know what it could be? 

lucaspontarolo

I am using Ruby on Rails 7 with multiple databases. I got this error. 1. I tried with:adapter: net_http but it isn't recognized. 2. Removing this line it doesn't raise...

leoplct

Problem: Creating a column with a codec type throws an error. Migration Repro: ``` ClickHouse.connection.create_table('visits', engine: 'MergeTree ORDER BY date') do |t| t.Date :date, compression_codec: 'CODEC(DoubleDelta, ZSTD(1))' end ``` Error:...

encodedrose

Put RaiseError middleware at the end of the middleware chain

1

Faraday middlewares are being called in [reverse order](https://lostisland.github.io/faraday/#/middleware/index?id=how-it-works). With the current ordering, you might get a successful (200) response from Clickhouse with an expected content type (application/json), but the response...

madejejej