Skip to content

[bitnami/clickhouse] Missing some window functions from clickhouse images #82791

Open
@talfridmen

Description

@talfridmen

Name and Version

bitnami/clickhouse:25.5.2-debian-12-r1

What steps will reproduce the bug?

  1. docker run --detach --name clickhouse --env ALLOW_EMPTY_PASSWORD=yes docker.io/bitnami/clickhouse:25.5.2-debian-12-r1
  2. docker exec -it clickhouse clickhouse-client
  3. select * from system.functions where name ILIKE 'lag'; - this returns an empty query
  4. or select lag <tab> - will autocomplete to 'lagInFrame' - which is not what we want.

What is the expected behavior?

Since version ~23 the lag and lead window functions have become stable and standard.
for some reason they do not exist in these images.
When using the official clickhouse image - they of course do exist.

What do you see instead?

the lag and lead functions are not recognized by clickhouse.

Additional information

BTW - this is also true for 25.4.5 image - I stopped checking after that.

Metadata

Metadata

Assignees

Labels

clickhouseon-holdIssues or Pull Requests with this label will never be considered staletech-issuesThe user has a technical issue about an application

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions