You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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
The text was updated successfully, but these errors were encountered:
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 fieldsFrontend is reading
name
field, but query returntable
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:
to this:
if that okay I will submit a pull request
The text was updated successfully, but these errors were encountered: