hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Hamza Asad <hamza.asa...@gmail.com>
Subject Re: How to delete Specific date data using hive QL?
Date Tue, 04 Jun 2013 06:07:51 GMT
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 <spragues@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.asad13@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 <nitinpawar432@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.asad13@gmail.com>wrote:
>>>
>>>> no, its not partitioned by date.
>>>>
>>>>
>>>> On Mon, Jun 3, 2013 at 11:19 AM, Nitin Pawar <nitinpawar432@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.asad13@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*

Mime
View raw message