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
/* this example would return TOP 10 of most huge tables */
WITH
(
SELECTsum(bytes)
FROMsystem.partsWHERE active
) AS total_disk_usage
SELECT
(sum(bytes) / total_disk_usage) *100AS table_disk_usage,
table
FROMsystem.partsGROUP BY table
ORDER BY table_disk_usage DESCLIMIT10;
The text was updated successfully, but these errors were encountered:
artvandaly
changed the title
Add support for with statement
Add support for with clause
Jan 22, 2023
Thank you for bringing this up.
Currently there is no WITH support indeed.
We are open for pull requests, so if you have some spare time, help is
appreciated.
Message ID: ***@***.***>
Could not find support for WITH clause
such as:
The text was updated successfully, but these errors were encountered: