|
|
Hello,
Is it possible to export table schema only versus exporting the entire table? I need this so I can create a separate table for QA purposes. -- --- Get your facts first, then you can distort them as you please.--
On Mon, Mar 12, 2012 at 5:28 PM, Rita <[EMAIL PROTECTED]> wrote: > Hello, > > Is it possible to export table schema only versus exporting the entire > table? I need this so I can create a separate table for QA purposes. >
In shell, if you do 'describe TABLENAME', the output can be used create the table IIRC.
Let us know if it doesn't work.
St.Ack
+
Stack 2012-03-13, 03:23
Rita,
I guess you are looking for something similar to RBDMS (say, oracle) is providing.
If that is the case, Exporting table structure alone doesnt make much sense in HBase case as HBase table can contain unstructured data. I mean, number of column qualifiers (Equivalent with Oracle columns) is not fixed.
Otherwise, as Stack mentioned, you can use describe command output to recreate a table (manually).
-- Regards, Laxman > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of > Stack > Sent: Tuesday, March 13, 2012 8:53 AM > To: [EMAIL PROTECTED] > Subject: Re: export schema only > > On Mon, Mar 12, 2012 at 5:28 PM, Rita <[EMAIL PROTECTED]> wrote: > > Hello, > > > > Is it possible to export table schema only versus exporting the > entire > > table? I need this so I can create a separate table for QA purposes. > > > > In shell, if you do 'describe TABLENAME', the output can be used > create the table IIRC. > > Let us know if it doesn't work. > > St.Ack
+
Laxman 2012-03-13, 06:58
thanks. I will give it a try On Tue, Mar 13, 2012 at 2:58 AM, Laxman <[EMAIL PROTECTED]> wrote:
> Rita, > > I guess you are looking for something similar to RBDMS (say, oracle) is > providing. > > If that is the case, Exporting table structure alone doesn’t make much > sense > in HBase case as HBase table can contain unstructured data. > I mean, number of column qualifiers (Equivalent with Oracle columns) is not > fixed. > > Otherwise, as Stack mentioned, you can use describe command output to > recreate a table (manually). > > -- > Regards, > Laxman > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of > > Stack > > Sent: Tuesday, March 13, 2012 8:53 AM > > To: [EMAIL PROTECTED] > > Subject: Re: export schema only > > > > On Mon, Mar 12, 2012 at 5:28 PM, Rita <[EMAIL PROTECTED]> wrote: > > > Hello, > > > > > > Is it possible to export table schema only versus exporting the > > entire > > > table? I need this so I can create a separate table for QA purposes. > > > > > > > In shell, if you do 'describe TABLENAME', the output can be used > > create the table IIRC. > > > > Let us know if it doesn't work. > > > > St.Ack > > -- --- Get your facts first, then you can distort them as you please.--
|
|