v.21.1Improvements

Include Dynamic Columns for Wildcard Queries with Configurable Settings

Official CH changelog text
Include dynamic columns like MATERIALIZED / ALIAS for wildcard query when settings asterisk_include_materialized_columns and asterisk_include_alias_columns are turned on. #17462 (Ken Chen).
Add support for including dynamic columns such as MATERIALIZED and ALIAS columns in wildcard queries when specific settings are enabled.

Why it matters

This feature allows users to include MATERIALIZED and ALIAS columns in the result set when using wildcard selectors (like SELECT *), enhancing query flexibility and completeness by exposing computed or derived columns that were previously omitted by default.

How to use it

To enable this feature, set the following settings to 1 (true) before running your query:

SET asterisk_include_materialized_columns = 1;
SET asterisk_include_alias_columns = 1;


Then, wildcard queries such as SELECT * will include MATERIALIZED and ALIAS columns in the output.

Related resources

PreviousNext