python-а. Но похоже там есть ошибка для типов DateTime
>>> data = clickhouse_client.execute("select toDateTime('2019-10-10 10:00:00')", columnar=True)
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "/Users/artur/.virtualenvs/studio/lib/python2.7/site-packages/clickhouse_driver/client.py", line 219, in execute
columnar=columnar
File "/Users/artur/.virtualenvs/studio/lib/python2.7/site-packages/clickhouse_driver/client.py", line 349, in process_ordinary_query
columnar=columnar)
File "/Users/artur/.virtualenvs/studio/lib/python2.7/site-packages/clickhouse_driver/client.py", line 88, in receive_result
return result.get_result()
File "/Users/artur/.virtualenvs/studio/lib/python2.7/site-packages/clickhouse_driver/result.py", line 45, in get_result
for packet in self.packet_generator:
File "/Users/artur/.virtualenvs/studio/lib/python2.7/site-packages/clickhouse_driver/client.py", line 100, in packet_generator
packet = self.receive_packet()
File "/Users/artur/.virtualenvs/studio/lib/python2.7/site-packages/clickhouse_driver/client.py", line 114, in receive_packet
packet = self.connection.receive_packet()
File "/Users/artur/.virtualenvs/studio/lib/python2.7/site-packages/clickhouse_driver/connection.py", line 391, in receive_packet
packet.block = self.receive_data()
File "/Users/artur/.virtualenvs/studio/lib/python2.7/site-packages/clickhouse_driver/connection.py", line 454, in receive_data
block = self.block_in.read()
File "/Users/artur/.virtualenvs/studio/lib/python2.7/site-packages/clickhouse_driver/streams/native.py", line 80, in read
self.fin)
File "/Users/artur/.virtualenvs/studio/lib/python2.7/site-packages/clickhouse_driver/columns/service.py", line 101, in read_column
column = get_column_by_spec(column_spec, column_options=column_options)
File "/Users/artur/.virtualenvs/studio/lib/python2.7/site-packages/clickhouse_driver/columns/service.py", line 67, in get_column_by_spec
return create_numpy_dt_column(spec, column_options)
File "/Users/artur/.virtualenvs/studio/lib/python2.7/site-packages/clickhouse_driver/columns/numpycolumns.py", line 153, in create_numpy_dt_column
return NumpyDateTimeColumn(tz_name)
File "/Users/artur/.virtualenvs/studio/lib/python2.7/site-packages/clickhouse_driver/columns/numpycolumns.py", line 26, in init
super().__init__(**kwargs)
TypeError: super() takes at least 1 argument (0 given)
не подскажите чем вы пользуетесь для выгрузки данных?
я тиспользую clickhouse-driver. Если у вас модификация драйвера от Суилина, то попробуйте сделать переменную Columnar=False, или используйте сразу загрузку в dataframe с помощью функции client.query_dataframe()
Обсуждают сегодня