hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ted Yu <yuzhih...@gmail.com>
Subject Re: Delete multiple records column family for particular rowkey of hbase table
Date Wed, 11 Feb 2015 18:22:47 GMT
Related JIRA:
https://issues.apache.org/jira/browse/HBASE-12462

On Wed, Feb 11, 2015 at 9:55 AM, ramkrishna vasudevan <
ramkrishna.s.vasudevan@gmail.com> wrote:

> So you want to just delete all the rows in a column family and you don't
> want to specify the rowkeys.
> You can try BulkDeleteEndPoint. It allows the user to specify a scan based
> on which the delete can be executed.
>
> Regards
> Ram
>
> On Wed, Feb 11, 2015 at 10:18 PM, shobhitpal48amity@gmail.com <
> shobhitpal48amity@gmail.com> wrote:
>
> > Hi All,
> >
> > I have started learning Hbase, and came across a situation, where i have
> to
> > delete all records of column family. Is there is any way in Hbase shell
> to
> > delete records from column family for a particular rowkey?
> >
> > I have tried delete and deleteall commands of hbase shell as follows,
> >
> > deleteall : By using deleteall, i am able to delete entire row ,including
> > all column families for that row. So it doesn't serve my purpose
> >
> > hbase(main) > deleteall 'name_of_table','row-key'
> >
> > This will delete the entire "row-key" with all its column family.
> >
> > delete : With delete I am able to delete records one by one as I am
> passing
> > them as parameter in delete query.
> >
> > hbase(main) > delete
> > 'name_of_table','row-key','testcf:record-from-column-family'
> >
> > This will delete the "record-from-column-family" record of testcf column
> > family . This one serves my purpose of deleting records from column
> family
> > but only if the records count is very small, provided i have to pass that
> > record in query.
> >
> > If I have 10000 records in "testcf", to be deleted then, i can't execute
> > the
> > delete query 10000 times , with different records as query parameter.
> >
> > Is there is any way to achieve this, either by using wildcard of
> something
> > similar to that in delete query,so that it will delete all 10000 records
> in
> > one shot.
> >
> > Thanks for your valuable suggestions.
> >
> >
> > Regards,
> > Shobhit Pal
> >
> >
> >
> > --
> > View this message in context:
> >
> http://apache-hbase.679495.n3.nabble.com/Delete-multiple-records-column-family-for-particular-rowkey-of-hbase-table-tp4068224.html
> > Sent from the HBase User mailing list archive at Nabble.com.
> >
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message