We are using ClickHouse server 23.12.2, maybe there was an update in field names of system.tables leading to frontend code getting wrong fields
Frontend is reading name field, but query return table field instead:
I recommend to add new fields on query in housewatch/clickhouse/queries/sql.py, it won't break previous HouseWatch versions
from this:
AVAILABLE_TABLES_SQL = """
SELECT database, table
FROM system.tables
WHERE database NOT ILIKE 'information_schema'
"""
to this:
AVAILABLE_TABLES_SQL = """
SELECT database, table, table as name, total_bytes, total_bytes as readable_bytes, total_rows, engine, partition_key
FROM system.tables
WHERE database NOT ILIKE 'information_schema'
"""
if that okay I will submit a pull request
We are using ClickHouse server 23.12.2, maybe there was an update in field names of
system.tablesleading to frontend code getting wrong fieldsFrontend is reading
namefield, but query returntablefield instead:I recommend to add new fields on query in housewatch/clickhouse/queries/sql.py, it won't break previous HouseWatch versions
from this:
to this:
if that okay I will submit a pull request