Traceback (most recent call last):
File "./SMA_test_alter.py", line 128, in <module>
main()
File "./SMA_test_alter.py", line 125, in main
ch_client.execute('INSERT into data.sma VALUES', dfs.to_dict('records'))
File "/home/1/.local/lib/python3.8/site-packages/clickhouse_driver/client.py", line 261, in execute
rv = self.process_insert_query(
File "/home/1/.local/lib/python3.8/site-packages/clickhouse_driver/client.py", line 478, in process_insert_query
rv = self.send_data(sample_block, data,
File "/home/1/.local/lib/python3.8/site-packages/clickhouse_driver/client.py", line 529, in send_data
block = block_cls(sample_block.columns_with_types, chunk,
File "/home/1/.local/lib/python3.8/site-packages/clickhouse_driver/block.py", line 39, in __init__
self.data = self.normalize(data or [])
File "/home/1/.local/lib/python3.8/site-packages/clickhouse_driver/block.py", line 127, in normalize
self._mutate_dicts_to_rows(data)
File "/home/1/.local/lib/python3.8/site-packages/clickhouse_driver/block.py", line 161, in _mutate_dicts_to_rows
data[i] = [row[name] for name in column_names]
File "/home/1/.local/lib/python3.8/site-packages/clickhouse_driver/block.py", line 161, in <listcomp>
data[i] = [row[name] for name in column_names]
KeyError: '0'
Describe the bug I try to create table with pandahouse:
and got as a result:
To Reproduce
Expected behavior created table(b/c I just copied create_table string and it works if I manually push it using ch client.
Versions
Version of package with the problem. pandahouse==0.2.7
Python version. python -V
Python 3.8.10