You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hbase.apache.org by Kevin Pauli <ke...@thepaulis.com> on 2015/12/03 21:41:06 UTC
How to list the regions in an HBase table through the shell?
I would like to get the same information about the regions of a table that
appear in the web UI (i.e. region name, region server, start/end key,
locality), but through the hbase shell.
(The UI is flaky/slow, and furthermore I want to process this information as
part of a script.)
After much googling, I can't find out how, and this surprises me immensely.
version is 1.0.0.-cdh5.4.0
--
View this message in context: http://apache-hbase.679495.n3.nabble.com/How-to-list-the-regions-in-an-HBase-table-through-the-shell-tp4076402.html
Sent from the HBase User mailing list archive at Nabble.com.
Re: How to list the regions in an HBase table through the shell?
Posted by Ted Yu <yu...@gmail.com>.
Romil logged HBASE-14925 around the time I replied to Kevin.
Mind continuing discussion on HBASE-14925 ?
Cheers
On Thu, Dec 3, 2015 at 6:13 PM, Heng Chen <he...@gmail.com> wrote:
> @tedyu, should we add something like 'list server table' to list all
> regions in one table on some RS.
>
> I found in my practice, it is always needed.
>
> 2015-12-04 4:48 GMT+08:00 Ted Yu <yu...@gmail.com>:
>
> > There is get_splits command but it only shows the splits.
> >
> > status 'detailed' would show you enough information
> > e.g.
> >
> > "t1,30,1449175546660.da5f3853f6e59d1ada0a8554f12885ab."
> > numberOfStores=1, numberOfStorefiles=0,
> > storefileUncompressedSizeMB=0, lastMajorCompactionTimestamp=0,
> > storefileSizeMB=0, memstoreSizeMB=0, storefileIndexSizeMB=0,
> > readRequestsCount=0, writeRequestsCount=0, rootIndexSizeKB=0,
> > totalStaticIndexSizeKB=0, totalStaticBloomSizeKB=0, totalCompactingKVs=0,
> > currentCompactedKVs=0, compactionProgressPct=NaN, completeSequenceId=-1,
> > dataLocality=0.0
> >
> > However, you need to parse the regions of the table you're interested in
> >
> > FYI
> >
> > On Thu, Dec 3, 2015 at 12:41 PM, Kevin Pauli <ke...@thepaulis.com>
> wrote:
> >
> > > I would like to get the same information about the regions of a table
> > that
> > > appear in the web UI (i.e. region name, region server, start/end key,
> > > locality), but through the hbase shell.
> > >
> > > (The UI is flaky/slow, and furthermore I want to process this
> information
> > > as
> > > part of a script.)
> > >
> > > After much googling, I can't find out how, and this surprises me
> > immensely.
> > > version is 1.0.0.-cdh5.4.0
> > >
> > >
> > >
> > > --
> > > View this message in context:
> > >
> >
> http://apache-hbase.679495.n3.nabble.com/How-to-list-the-regions-in-an-HBase-table-through-the-shell-tp4076402.html
> > > Sent from the HBase User mailing list archive at Nabble.com.
> > >
> >
>
Re: How to list the regions in an HBase table through the shell?
Posted by Heng Chen <he...@gmail.com>.
@tedyu, should we add something like 'list server table' to list all
regions in one table on some RS.
I found in my practice, it is always needed.
2015-12-04 4:48 GMT+08:00 Ted Yu <yu...@gmail.com>:
> There is get_splits command but it only shows the splits.
>
> status 'detailed' would show you enough information
> e.g.
>
> "t1,30,1449175546660.da5f3853f6e59d1ada0a8554f12885ab."
> numberOfStores=1, numberOfStorefiles=0,
> storefileUncompressedSizeMB=0, lastMajorCompactionTimestamp=0,
> storefileSizeMB=0, memstoreSizeMB=0, storefileIndexSizeMB=0,
> readRequestsCount=0, writeRequestsCount=0, rootIndexSizeKB=0,
> totalStaticIndexSizeKB=0, totalStaticBloomSizeKB=0, totalCompactingKVs=0,
> currentCompactedKVs=0, compactionProgressPct=NaN, completeSequenceId=-1,
> dataLocality=0.0
>
> However, you need to parse the regions of the table you're interested in
>
> FYI
>
> On Thu, Dec 3, 2015 at 12:41 PM, Kevin Pauli <ke...@thepaulis.com> wrote:
>
> > I would like to get the same information about the regions of a table
> that
> > appear in the web UI (i.e. region name, region server, start/end key,
> > locality), but through the hbase shell.
> >
> > (The UI is flaky/slow, and furthermore I want to process this information
> > as
> > part of a script.)
> >
> > After much googling, I can't find out how, and this surprises me
> immensely.
> > version is 1.0.0.-cdh5.4.0
> >
> >
> >
> > --
> > View this message in context:
> >
> http://apache-hbase.679495.n3.nabble.com/How-to-list-the-regions-in-an-HBase-table-through-the-shell-tp4076402.html
> > Sent from the HBase User mailing list archive at Nabble.com.
> >
>
Re: How to list the regions in an HBase table through the shell?
Posted by Ted Yu <yu...@gmail.com>.
There is get_splits command but it only shows the splits.
status 'detailed' would show you enough information
e.g.
"t1,30,1449175546660.da5f3853f6e59d1ada0a8554f12885ab."
numberOfStores=1, numberOfStorefiles=0,
storefileUncompressedSizeMB=0, lastMajorCompactionTimestamp=0,
storefileSizeMB=0, memstoreSizeMB=0, storefileIndexSizeMB=0,
readRequestsCount=0, writeRequestsCount=0, rootIndexSizeKB=0,
totalStaticIndexSizeKB=0, totalStaticBloomSizeKB=0, totalCompactingKVs=0,
currentCompactedKVs=0, compactionProgressPct=NaN, completeSequenceId=-1,
dataLocality=0.0
However, you need to parse the regions of the table you're interested in
FYI
On Thu, Dec 3, 2015 at 12:41 PM, Kevin Pauli <ke...@thepaulis.com> wrote:
> I would like to get the same information about the regions of a table that
> appear in the web UI (i.e. region name, region server, start/end key,
> locality), but through the hbase shell.
>
> (The UI is flaky/slow, and furthermore I want to process this information
> as
> part of a script.)
>
> After much googling, I can't find out how, and this surprises me immensely.
> version is 1.0.0.-cdh5.4.0
>
>
>
> --
> View this message in context:
> http://apache-hbase.679495.n3.nabble.com/How-to-list-the-regions-in-an-HBase-table-through-the-shell-tp4076402.html
> Sent from the HBase User mailing list archive at Nabble.com.
>