Skip to content

ClickHouse: REPLACE and APPLY dynamic column selection are not implemented #14

@stergiotis

Description

@stergiotis

REPLACE and APPLY clauses in dynamic column selections are not implemented

FROM trips 
SELECT 
  COLUMNS('.*_amount|fee|tax')
  REPLACE(
    total_amount*2 AS total_amount,
    mta_tax/1.1 AS mta_tax
  ) 
  APPLY(avg)
  APPLY(col -> round(col, 2))
FORMAT Vertical;

Example from https://clickhouse.com/blog/sql-dynamic-column-selection-clickhouse

Metadata

Metadata

Assignees

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions