When you bucket the data in a partition, there will be a file created for each of your bucketing key.
Now if you add more data to the same bucket that means that file would need to rebuild I would prefer a partition on day level under month level where I write the data once a day and bucket the data there I am not sure hive supports append to bucketed files yet. please wait for others to answer as well On Thu, Sep 18, 2014 at 9:27 PM, Kumar V <kumarbuyonl...@yahoo.com> wrote: > 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. > > -- Nitin Pawar
