search

sanchezzzhak / kak-clickhouse

Yii2 ext. ClickHouse
69 stars 43 forks source link

Implement PREWHERE clause #12

Closed sleptor closed 7 years ago

sleptor commented 7 years ago

This clause has the same meaning as the WHERE clause. The difference is in which data is read from the table. When using PREWHERE, first only the columns necessary for executing PREWHERE are read. Then the other columns are read that are needed for running the query, but only those blocks where the PREWHERE expression is true.

https://clickhouse.yandex/reference_en.html#PREWHERE+clause

sanchezzzhak commented 7 years ago

in the new branch querySpecialSection some implementation.

sleptor commented 7 years ago

works! thank you so much!