Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive, mail # user - How to delete Specific date data using hive QL?


Copy link to this message
-
Re: How to delete Specific date data using hive QL?
Hamza Asad 2013-06-03, 09:19
Thanx for your response nitin. Anybody else have any better solution?
On Mon, Jun 3, 2013 at 1:27 PM, Nitin Pawar <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]>wrote:
>
>> no, its not partitioned by date.
>>
>>
>> On Mon, Jun 3, 2013 at 11:19 AM, Nitin Pawar <[EMAIL PROTECTED]>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 <[EMAIL PROTECTED]>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*