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

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


+
Hamza Asad 2013-06-03, 05:50
+
Nitin Pawar 2013-06-03, 06:19
+
Hamza Asad 2013-06-03, 07:06
Copy link to this message
-
Re: How to delete Specific date data using hive QL?
Nitin Pawar 2013-06-03, 08:27
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
+
Hamza Asad 2013-06-03, 09:19
+
Stephen Sprague 2013-06-03, 19:09
+
Hamza Asad 2013-06-04, 06:07
+
Nitin Pawar 2013-06-04, 06:40
+
Hamza Asad 2013-06-04, 07:11
+
Nitin Pawar 2013-06-04, 07:18
+
Hamza Asad 2013-06-04, 07:52
+
bejoy_ks@... 2013-06-04, 15:33