Return-Path: Delivered-To: apmail-hadoop-hbase-dev-archive@locus.apache.org Received: (qmail 22089 invoked from network); 4 Mar 2008 03:11:13 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 4 Mar 2008 03:11:13 -0000 Received: (qmail 41654 invoked by uid 500); 4 Mar 2008 03:11:09 -0000 Delivered-To: apmail-hadoop-hbase-dev-archive@hadoop.apache.org Received: (qmail 41631 invoked by uid 500); 4 Mar 2008 03:11:09 -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 41622 invoked by uid 99); 4 Mar 2008 03:11:09 -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 19:11:09 -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.190] (HELO ti-out-0910.google.com) (209.85.142.190) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 04 Mar 2008 03:10:35 +0000 Received: by ti-out-0910.google.com with SMTP id b8so1133117tic.9 for ; Mon, 03 Mar 2008 19:10:42 -0800 (PST) Received: by 10.151.38.12 with SMTP id q12mr370179ybj.18.1204600239986; Mon, 03 Mar 2008 19:10:39 -0800 (PST) Received: by 10.151.109.10 with HTTP; Mon, 3 Mar 2008 19:10:39 -0800 (PST) Message-ID: Date: Tue, 4 Mar 2008 12:10:39 +0900 From: "edward yoon" To: hbase-dev@hadoop.apache.org Subject: Re: Renaming the table. In-Reply-To: <84E2AE771361E9419DD0EFBD31F09C4D4F47C88F47@EXVMBX015-1.exch015.msoutlookonline.net> 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 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.