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

Switch to Threaded View
HBase >> mail # user >> How to get Metadata information in Hbase


Copy link to this message
-
Re: How to get Metadata information in Hbase
One other tool option for you is to use Phoenix. You use SQL to create a
table and define the columns through standard DDL. Your columns make up the
allowed KeyValues for your table and the metadata is surfaced through the
standard JDBC metadata APIs (with column family mapping to table catalog).

Thanks,
James
On Mon, Nov 25, 2013 at 10:51 AM, Jean-Marc Spaggiari <
[EMAIL PROTECTED]> wrote:

> >1.get the information about tables like how many tables and name of
> tables.
> You can use HBaseAdmin from the API. admin.getTableNames()
>
> > 2.get the columnfamilies name in each table.
> From the table you can get the descriptor to get the families:
> table.getTableDescriptor();
>
> >3.get the columns names and their data types in each columnfamily.
> to get the ALL the column names, 2 options. 1) You keep track of them in
> your application using constans... 2) you run a full scan map reduce job.
>
> JM
>
>
> 2013/11/25 Ted Yu <[EMAIL PROTECTED]>
>
> > bq. 3.get the columns names and their data types in each columnfamily.
> >
> > Each columnfamily can have arbitrarily many columns. There is no tool
> which
> > returns the above information.
> >
> >
> > On Tue, Nov 26, 2013 at 12:26 AM, Asaf Mesika <[EMAIL PROTECTED]>
> > wrote:
> >
> > > bin/hbase shell
> > > In there:
> > > Type help and you'll get along
> > >
> > > On Monday, November 25, 2013, ashishkshukladb wrote:
> > >
> > > > I want to get the metadata information in Hbase. My basic purpose is
> > to -
> > > >
> > > > 1.get the information about tables like how many tables and name of
> > > tables.
> > > >
> > > > 2.get the columnfamilies name in each table.
> > > >
> > > > 3.get the columns names and their data types in each columnfamily.
> > > >
> > > > Is there any tool or command by using which we can get the above
> > > > information
> > > > ??
> > > >
> > > >
> > > >
> > > >
> > > > --
> > > > View this message in context:
> > > >
> > >
> >
> http://apache-hbase.679495.n3.nabble.com/How-to-get-Metadata-information-in-Hbase-tp4053044.html
> > > > Sent from the HBase User mailing list archive at Nabble.com.
> > > >
> > >
> >
>