mirror of
https://github.com/hanzo-ds/driver.git
synced 2026-10-30 20:32:40 +00:00
Kim Gustyr
11a09af20d
All numbers on one machine and environment, attributed in the docs: Apple M2 Pro, ClickHouse 25.12.11.4 in Docker, Python 3.11.11. Methodology change: scripts end their imports with 'import timing' (new perf/timing.py) which starts the clock and reports wall time and max RSS at exit. Interpreter startup and imports are excluded from timings; importing the numpy/pyarrow stack costs ~0.5 s and dominated sub-second cells under whole-process timing. New typed-projection PyArrow scripts (21-24) cover analytic extracts: int and string column subsets, clickhouse-driver vs clickhouse-connect. All perf scripts carry PEP 723 blocks with pinned versions. Scripts 15-17 updated to the current clickhouse-connect streaming API. beep boop
19 lines
501 B
Python
19 lines
501 B
Python
# /// script
|
|
# dependencies = [
|
|
# "clickhouse-connect==1.4.2",
|
|
# "pyarrow==25.0.0",
|
|
# ]
|
|
# ///
|
|
import sys
|
|
import clickhouse_connect
|
|
|
|
# Imported lazily at query time: preload before the clock starts.
|
|
import pyarrow
|
|
|
|
import timing
|
|
|
|
query = "SELECT * FROM perftest.ontime WHERE FlightDate < '{}'".format(sys.argv[1])
|
|
client = clickhouse_connect.get_client(host='localhost', query_limit=None, compress=False)
|
|
|
|
table = client.query_arrow(query, settings={'output_format_arrow_string_as_string': 1})
|