Hi Everyone,

Currently we are facing issue with OPTIMIZE table_name FULL operation. The dataset consists of 150 billion rows of data and it takes 8 hours to optimize the reloaded clustered table. The table is refreshed every month and it needs clustering because we need faster query performance. 

Q1) Can we insert data in parallel to clustered table? if so how to reduce the write times?

Q2) Is it good idea to use liquid clustering on table that refreshes 150 Billion rows every month? please suggest any alternatives.

Thank you in advance for your valuable time.