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
+
Nitin Pawar 2013-06-03, 08:27
Copy link to this message
-
Re: How to delete Specific date data using hive QL?
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*
+
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