clickhouse_connect_table_creation_insert_and_row_query.py

1import clickhouse_connect
2
3# Create a client to a local ClickHouse instance
4client = clickhouse_connect.get_client(host='localhost', username='default', password='')
5
6# Create a table
7client.command('DROP TABLE IF EXISTS exercise_table')
8client.command('CREATE TABLE exercise_table (id UInt32, name String, timestamp DateTime) ENGINE = MergeTree() ORDER BY id')
9
10# Insert data using a list of lists (row-based)
11data = [[1, 'exercise 1', '2021-01-01 00:00:00'], [2, 'exercise 2', '2021-01-02 00:00:00']]
12client.insert('exercise_table', data, column_names=['id', 'name', 'timestamp'])
13
14# Query the data
15result = client.query('SELECT * FROM exercise_table')
16
17# Print the result rows
18for row in result.result_rows:
19    print(row)