Return-Path: Delivered-To: apmail-hadoop-hbase-dev-archive@locus.apache.org Received: (qmail 38965 invoked from network); 4 Mar 2008 06:05:27 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 4 Mar 2008 06:05:27 -0000 Received: (qmail 57687 invoked by uid 500); 4 Mar 2008 06:05:23 -0000 Delivered-To: apmail-hadoop-hbase-dev-archive@hadoop.apache.org Received: (qmail 57665 invoked by uid 500); 4 Mar 2008 06:05:23 -0000 Mailing-List: contact hbase-dev-help@hadoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: hbase-dev@hadoop.apache.org Delivered-To: mailing list hbase-dev@hadoop.apache.org Received: (qmail 57655 invoked by uid 99); 4 Mar 2008 06:05:23 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 03 Mar 2008 22:05:23 -0800 X-ASF-Spam-Status: No, hits=1.2 required=10.0 tests=SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: local policy) Received: from [209.85.142.186] (HELO ti-out-0910.google.com) (209.85.142.186) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 04 Mar 2008 06:04:48 +0000 Received: by ti-out-0910.google.com with SMTP id b8so1313102tic.9 for ; Mon, 03 Mar 2008 22:04:56 -0800 (PST) Received: by 10.150.192.7 with SMTP id p7mr349753ybf.159.1204610694153; Mon, 03 Mar 2008 22:04:54 -0800 (PST) Received: by 10.151.109.10 with HTTP; Mon, 3 Mar 2008 22:04:54 -0800 (PST) Message-ID: Date: Tue, 4 Mar 2008 15:04:54 +0900 From: "edward yoon" To: hbase-dev@hadoop.apache.org Subject: Re: Renaming the table. In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <84E2AE771361E9419DD0EFBD31F09C4D4F47C88F47@EXVMBX015-1.exch015.msoutlookonline.net> X-Virus-Checked: Checked by ClamAV on apache.org Is there a renaming tool of columnfamily(-ies) ? On 3/4/08, edward yoon wrote: > >> I would expect you to add a renameTable method to HBaseAdmin and > create a RenameTable subclass of TableOperation in the master. > > Yes. good. > > On 3/4/08, Bryan Duxbury wrote: > > Yes, it's good functionality. Just making sure you understand all the > > pieces you'll need. > > > > I would expect you to add a renameTable method to HBaseAdmin and > > create a RenameTable subclass of TableOperation in the master. > > > > -Bryan > > > > On Mar 3, 2008, at 7:10 PM, edward yoon wrote: > > > > > Anyway guys, Is addition of table rename function ok? > > > > > > On 3/4/08, Jim Kellerman wrote: > > >> +1 Bryan. In the future, we need to be able to recover HBase > > >> entirely from the file system > > >> without either the META or ROOT region's help since they may be > > >> corrupted. > > >> > > >> --- > > >> Jim Kellerman, Senior Engineer; Powerset > > >> > > >> > > >>> -----Original Message----- > > >>> From: Bryan Duxbury [mailto:bryan@rapleaf.com] > > >>> Sent: Monday, March 03, 2008 4:22 PM > > >>> To: hbase-dev@hadoop.apache.org > > >>> Subject: Re: Renaming the table. > > >>> > > >>> I'm not sure I understand. Do you mean you'd maintain a > > >>> mapping between the old, actual table name and the new, > > >>> logical table name? I don't really like that idea. It sounds > > >>> like it would add a ton of failure cases and complexity to > > >>> the system. We need tables to stay in a really consistent > > >>> state so that we can have as much data reliability as possible. > > >>> > > >>> -Bryan > > >>> > > >>> On Mar 3, 2008, at 3:58 PM, edward yoon wrote: > > >>> > > >>>>> We'd need to add a new table operation for renaming a table > > >>>>> internally. The ugly part is that we'd have to rewrite > > >>> every row for > > >>>>> the table in META to do this. > > >>>> > > >>>> In fact, i thought a physical/logical table name management for > > >>>> high-performance without no changing the meta data. > > >>>> > > >>>> On 3/4/08, Bryan Duxbury wrote: > > >>>>> We'd need to add a new table operation for renaming a table > > >>>>> internally. The ugly part is that we'd have to rewrite > > >>> every row for > > >>>>> the table in META to do this. > > >>>>> > > >>>>> The SQL way to do this would be "ALTER TABLE table RENAME > > >>> new name". > > >>>>> However, that's a bit verbose, so I think "RENAME table TO > > >>>>> new_table" > > >>>>> would be fine. > > >>>>> > > >>>>> > > >>>>> -Bryan > > >>>>> > > >>>>> > > >>>>> On Mar 2, 2008, at 9:56 PM, edward yoon wrote: > > >>>>> > > >>>>>> A renaming function of table alteration is needed. > > >>>>>> Is there a tool for renaming the table? > > >>>>>> > > >>>>>> Any ideas please post back. > > >>>>>> Also, i'd like to add renaming syntax to hql as describe below. > > >>>>>> > > >>>>>> hql > RENAMING table_name TO new_table_name; > > >>>>>> > > >>>>>> What do you think? > > >>>>>> -- > > >>>>>> B. Regards, > > >>>>>> Edward yoon @ NHN, corp. > > >>>>> > > >>>>> > > >>>> > > >>>> > > >>>> -- > > >>>> B. Regards, > > >>>> Edward yoon @ NHN, corp. > > >>> > > >>> > > >>> No virus found in this incoming message. > > >>> Checked by AVG Free Edition. > > >>> Version: 7.5.516 / Virus Database: 269.21.3/1308 - Release > > >>> Date: 3/3/2008 10:01 AM > > >>> > > >>> > > >> > > >> No virus found in this outgoing message. > > >> Checked by AVG Free Edition. > > >> Version: 7.5.516 / Virus Database: 269.21.3/1308 - Release Date: > > >> 3/3/2008 10:01 AM > > >> > > >> > > > > > > > > > -- > > > B. Regards, > > > Edward yoon @ NHN, corp. > > > > > > > -- > B. Regards, > Edward yoon @ NHN, corp. > -- B. Regards, Edward yoon @ NHN, corp.