Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
+
Hamza Asad 2013-06-03, 09:19
Copy link to this message
-
Re: How to delete Specific date data using hive QL?
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 <[EMAIL PROTECTED]> wrote:

> 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*
>
+
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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB