How to set dynamic parameter to .spec.configuration.files

[zouwenjie00]

HI:
I want to create custom macros ,like this:

   configuration:
    files:
      conf.d/customer_marco.xml: |
       <yandex>
         <macros>
           <installation2>{chi}</installation2>
           <cluster>demo</cluster>
           <shard>{shard}</shard>
           <replica>{replica}-{shard}</replica>
         </macros>
       </yandex>

and want get shardname 、replicaname、podname to set its，but it is not effect

[Slach]

what is the goal?

clickhouse-operator already generate some macros values during runtime, like {cluster} {shard} {replica}

why do you need to define other macros? which is your use case?

[zouwenjie00]

what is the goal?

clickhouse-operator already generate some macros values during runtime, like {cluster} {shard} {replica}

why do you need to define other macros? which is your use case?

I want to transfer the ck cluster on Independent deployment server to k8s ck cluster,this cluster have different macros , and different database table have different macros , i do not want change the sql

[Slach]

Is your indepentent deployment server just single instance of clickhouse-server?
Is this kubernetes cluster or single docker container or standalone systemd service?

[alex-zaitsev]

Hi @zouwenjie00 , have you checked system.macros table? By default, operator already generates macros similarly to what you want, populating it with proper values for every node.