Hi, I would like to know how to handle frequent updates to bucketed tables. Is there a way to update without a rebuild ? I have a monthly partition for a table with buckets. But I have to update the table every day. Is there a way to achieve this without a rebuild of this partition every day ? Or, is this a wrong use case for a bucketed table ? This table is joined with another table. So, I thought bucketing will speed up the queries. What are my options ?
Please let me know. Regards, Murali.