thats far more better :) .. Please tell me few more things. Do i have to change my query if i create table with partition on date? rest of the columns would be same as it is? Also if i export that partitioned table to mysql, does schema of that table would same as it was before partition?
On Tue, Jun 4, 2013 at 12:09 AM, Stephen Sprague <sprag...@gmail.com> wrote: > there is no delete semantic. > > you either partition on the data you want to drop and use drop partition > (or drop table for the whole shebang) or you can do as Nitin suggests by > selecting the inverse of the data you want to delete and store it back into > the table itself. Not ideal but maybe it could work for your situation. > > Now here's another idea. This was just _recently_ discussed on this group > as coincidence would have it. if you were to have scanned just a little of > the groups messages you would have seen that and could then have added to > the discussion! :) > > > On Mon, Jun 3, 2013 at 2:19 AM, Hamza Asad <hamza.asa...@gmail.com> wrote: > >> Thanx for your response nitin. Anybody else have any better solution? >> >> >> On Mon, Jun 3, 2013 at 1:27 PM, Nitin Pawar <nitinpawar...@gmail.com>wrote: >> >>> hive does not give you a record level deletion as of now. >>> >>> so unless you have partitioned, other option is you overwrite the table >>> with data which you want >>> please wait for others to suggest you more options. this one is just >>> mine and can be costly too >>> >>> >>> On Mon, Jun 3, 2013 at 12:36 PM, Hamza Asad <hamza.asa...@gmail.com>wrote: >>> >>>> no, its not partitioned by date. >>>> >>>> >>>> On Mon, Jun 3, 2013 at 11:19 AM, Nitin Pawar >>>> <nitinpawar...@gmail.com>wrote: >>>> >>>>> how is the data laid out? >>>>> is it partitioned data by the date? >>>>> >>>>> >>>>> On Mon, Jun 3, 2013 at 11:20 AM, Hamza Asad <hamza.asa...@gmail.com>wrote: >>>>> >>>>>> Dear all, >>>>>> How can i remove data of specific dates from HDFS using >>>>>> hive query language? >>>>>> >>>>>> -- >>>>>> *Muhammad Hamza Asad* >>>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> Nitin Pawar >>>>> >>>> >>>> >>>> >>>> -- >>>> *Muhammad Hamza Asad* >>>> >>> >>> >>> >>> -- >>> Nitin Pawar >>> >> >> >> >> -- >> *Muhammad Hamza Asad* >> > > -- *Muhammad Hamza Asad*
