Support of the block of totals

[nicktrandafil]

With the SQL:

SELECT name
FROM workflow_jobs        
GROUP BY name
    WITH TOTALS
LIMIT 5, 5

clickhosue-cpp responds with exception unimplemented 7. Would be nice to have this feature.

[nicktrandafil]

Is there a different way to obtain row count in a SQL which contains "LIMIT" before the limit is applied? I mean without employing two separate queries. This would be useful in implementing pagination on the data.

[Enmk]

Hello @nicktrandafil could you please share a simple SQL example to test this feature? That would help with development.

[nicktrandafil]

Hello @Enmk. You could use the SQL which I provided in my first comment. I tested the feature on the official playground of Clickhouse

clickhouse client --secure --host play.clickhouse.com --user explorer

then

SELECT name               
FROM workflow_jobs
GROUP BY name                          
    WITH TOTALS   
LIMIT 5, 5                             
FORMAT JSON  

In the results there is the desired statistic rows_before_limit_at_least:

{
        ...
        "rows": 5,
        "rows_before_limit_at_least": 906,
        ...
}

Notice FORMAT JSON. In default format of response representation you wouldn't see this statistic.