search

timeplus-io / proton-python-driver

Python driver for Proton which support Proton native wire protocol
Other
10 stars 3 forks source link

low_cardinality has issue #17

Closed jhao0117 closed 9 months ago

jhao0117 commented 1 year ago 

>>> from clickhouse_driver import Client
>>> client = Client('localhost', port = 18463)
>>> res = client.execute("select * from system.asynchronous_metric_log where metric='AsynchronousMetricsCalculationTimeSpent' limit 1")
Traceback (most recent call last):
  File "/Users/jameshao/venvs/gluon/lib/python3.9/site-packages/clickhouse_driver/columns/service.py", line 106, in get_column_by_spec
    cls = column_by_type[spec]
KeyError: '(string'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/Users/jameshao/venvs/gluon/lib/python3.9/site-packages/clickhouse_driver/client.py", line 296, in execute
    rv = self.process_ordinary_query(
  File "/Users/jameshao/venvs/gluon/lib/python3.9/site-packages/clickhouse_driver/client.py", line 482, in process_ordinary_query
    return self.receive_result(with_column_types=with_column_types,
  File "/Users/jameshao/venvs/gluon/lib/python3.9/site-packages/clickhouse_driver/client.py", line 143, in receive_result
    return result.get_result()
  File "/Users/jameshao/venvs/gluon/lib/python3.9/site-packages/clickhouse_driver/result.py", line 50, in get_result
    for packet in self.packet_generator:
  File "/Users/jameshao/venvs/gluon/lib/python3.9/site-packages/clickhouse_driver/client.py", line 159, in packet_generator
    packet = self.receive_packet()
  File "/Users/jameshao/venvs/gluon/lib/python3.9/site-packages/clickhouse_driver/client.py", line 173, in receive_packet
    packet = self.connection.receive_packet()
  File "/Users/jameshao/venvs/gluon/lib/python3.9/site-packages/clickhouse_driver/connection.py", line 485, in receive_packet
    packet.block = self.receive_data()
  File "/Users/jameshao/venvs/gluon/lib/python3.9/site-packages/clickhouse_driver/connection.py", line 558, in receive_data
    return (self.block_in_raw if raw else self.block_in).read()
  File "/Users/jameshao/venvs/gluon/lib/python3.9/site-packages/clickhouse_driver/streams/native.py", line 74, in read
    column = read_column(self.context, column_type, n_rows,
  File "/Users/jameshao/venvs/gluon/lib/python3.9/site-packages/clickhouse_driver/columns/service.py", line 115, in read_column
    column = get_column_by_spec(column_spec, column_options)
  File "/Users/jameshao/venvs/gluon/lib/python3.9/site-packages/clickhouse_driver/columns/service.py", line 95, in get_column_by_spec
    return create_low_cardinality_column(spec, create_column_with_options)
  File "/Users/jameshao/venvs/gluon/lib/python3.9/site-packages/clickhouse_driver/columns/lowcardinalitycolumn.py", line 11, in create_low_cardinality_column
    nested = column_by_spec_getter(inner)
  File "/Users/jameshao/venvs/gluon/lib/python3.9/site-packages/clickhouse_driver/columns/service.py", line 68, in create_column_with_options
    return get_column_by_spec(x, column_options, use_numpy=use_numpy)
  File "/Users/jameshao/venvs/gluon/lib/python3.9/site-packages/clickhouse_driver/columns/service.py", line 110, in get_column_by_spec
    raise errors.UnknownTypeError('Unknown type {}'.format(spec))
clickhouse_driver.errors.UnknownTypeError: Code: 50. Unknown type (string
>>>
jovezhong commented 9 months ago

(Jove Github Bot) added it to the current sprint.