Thx Nitin. I just wanted to confirm before I give up. I'll probably do a daily partition and see how it goes.
Thanks. On Thursday, September 18, 2014 12:30 PM, Nitin Pawar <nitinpawar...@gmail.com> wrote: 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
