clickhouse-driver

clickhouse-driver copied to clipboard

Failed enum insert when types_check enabled

1

**Describe the bug** In the documentation it is written that supported types for enum inserts are: **Enum, int, long, str/basestring.** [https://clickhouse-driver.readthedocs.io/en/latest/types.html#enum8-16](https://clickhouse-driver.readthedocs.io/en/latest/types.html#enum8-16) Executing the example from the documentation works fine, except...

fonz-zz

- fixes #326 Checklist: - [x] Add tests that demonstrate the correct behavior of the change. Tests should fail without the change. - [x] Add or update relevant docs, in...

carlosfy

**Describe the bug** When inserting data into a table using the method Cient.execute(query, data), the data gets inserted into the table but the python code raises an exception: 'Unexpected packet...

carlosfy

Feature Request: Support for WATCH on live views

2

The title pretty much says it all, I would like to use WATCH on live views in aioch, and I think it would have to come through here first.

bdbernstein

clickhouse_driver.errors.UnknownTypeError: Code: 50. Unknown type Object('json')

5

driver doesn't support new `JSON` type added in 22.3 (I'm using 22.3.3.44 )

mike-luabase

Nanoseconds are not preserved on insert for DateTime64(8) columns

3

**Describe the bug** Nanoseconds are not preserved on insert for DateTime64(8) columns "2022-05-04 13:45:00.00000001" string value or parsed "2022-05-04 13:45:00.00000001" string value (tried more than one) **To Reproduce** Try inserting...

acmeguy

Select datetime accurate to millisecond

4

**Describe the bug** Selecting using datetime parameter doesn't consider milliseconds. Probably, can use `strftime` like this `%Y-%m-%d %H:%M:%S.%f` [here](https://github.com/mymarilyn/clickhouse-driver/blob/9a8b4a0706d78ee9952737a9b277f448acf3eaf0/clickhouse_driver/util/escape.py#L28). **To Reproduce** ```python client = make_client() client.execute('CREATE TABLE IF NOT EXISTS...

veotani

Include cityhash module

1

Hello and thanks for developing the library. Would you consider including the [cityhash](https://github.com/xzkostyan/clickhouse-cityhash) library in your codebase? It would greatly simplify packaging the library for Linux and reducing the dependency...

FedericoCeratto

query_dataframe returns empty dataframe with shape (0, 0) instead of returning shape (0, number of columns)

1

**Describe the bug** When the query returns 0 rows, function returns empty dataframe with the shape (0,0) without specifying any columns from query. IMHO, in that case it should return...

nariman9119

insert_dataframe() method sometimes failed for Decimal column because of numpy dtype mismatch

2

**Describe the bug** In class `DecimalColumn` method `before_write_items`, item is scaled and converted to `int`: ```python def before_write_items(self, items, nulls_map=None): null_value = self.null_value if self.scale >= 1: scale = 10...

zsmeijin