ch_union_query: Build a ClickHouse 'UNION' query from several sub-queries
In TKCat: Tailored Knowledge Catalog
ch_union_query R Documentation
Build a ClickHouse UNION query from several sub-queries
Description
Wraps each input sub-query as a derived table and combines them with
UNION DISTINCT or UNION ALL. A single sub-query is returned wrapped but
without any UNION clause.
Usage
ch_union_query(queries, mode = c("DISTINCT", "ALL"))
Arguments
queries
a character vector of SELECT sub-queries to combine
mode
the union mode: "DISTINCT" (default) to deduplicate rows
across sub-queries, or "ALL" to keep every row
Value
A character string with the assembled UNION query.
See Also
ch_join_query()
TKCat documentation built on June 29, 2026, 9:06 a.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
| ch_union_query | R Documentation |
Build a ClickHouse UNION query from several sub-queries
Description
Wraps each input sub-query as a derived table and combines them with
UNION DISTINCT or UNION ALL. A single sub-query is returned wrapped but
without any UNION clause.
Usage
ch_union_query(queries, mode = c("DISTINCT", "ALL"))
Arguments
queries |
a character vector of |
mode |
the union mode: |
Value
A character string with the assembled UNION query.
See Also
ch_join_query()
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Embedding an R snippet on your website
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.