https://community.databricks.com/t5/data-engineering/question-of-changing-cluster-key-in-liquid-cluster/m-p/72077#M34488 <P>If i already have a cluster key1 for existing table, i want to change cluster key to key2 using&nbsp;</P><DIV><SPAN>ALTER</SPAN> <SPAN>TABLE</SPAN><SPAN>&nbsp;table CLUSTER </SPAN><SPAN>BY</SPAN><SPAN>&nbsp;(key2), then run&nbsp;</SPAN><SPAN>OPTIMIZE table</SPAN><SPAN>, based on databrick document , existing files will not be rewritten (verified by my test as well), cluster Key2 will only be applied incrementally.&nbsp; If my existing files are huge (saying having long history), using Key2 will not improve performance when i search the table (e.g. select * from table where key2='xxxx'). is liquid cluster supposed to work this way or i am missing anything?</SPAN></DIV> Fri, 07 Jun 2024 16:30:48 GMT yj940525 2024-06-07T16:30:48Z https://community.databricks.com/t5/data-engineering/question-of-changing-cluster-key-in-liquid-cluster/m-p/72077#M34488 <P>If i already have a cluster key1 for existing table, i want to change cluster key to key2 using&nbsp;</P><DIV><SPAN>ALTER</SPAN> <SPAN>TABLE</SPAN><SPAN>&nbsp;table CLUSTER </SPAN><SPAN>BY</SPAN><SPAN>&nbsp;(key2), then run&nbsp;</SPAN><SPAN>OPTIMIZE table</SPAN><SPAN>, based on databrick document , existing files will not be rewritten (verified by my test as well), cluster Key2 will only be applied incrementally.&nbsp; If my existing files are huge (saying having long history), using Key2 will not improve performance when i search the table (e.g. select * from table where key2='xxxx'). is liquid cluster supposed to work this way or i am missing anything?</SPAN></DIV> Fri, 07 Jun 2024 16:30:48 GMT https://community.databricks.com/t5/data-engineering/question-of-changing-cluster-key-in-liquid-cluster/m-p/72077#M34488 yj940525 2024-06-07T16:30:48Z