Return-Path: X-Original-To: apmail-hbase-user-archive@www.apache.org Delivered-To: apmail-hbase-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id F0487189BE for ; Thu, 11 Jun 2015 18:47:35 +0000 (UTC) Received: (qmail 90337 invoked by uid 500); 11 Jun 2015 18:47:33 -0000 Delivered-To: apmail-hbase-user-archive@hbase.apache.org Received: (qmail 90260 invoked by uid 500); 11 Jun 2015 18:47:33 -0000 Mailing-List: contact user-help@hbase.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hbase.apache.org Delivered-To: mailing list user@hbase.apache.org Received: (qmail 90248 invoked by uid 99); 11 Jun 2015 18:47:33 -0000 Received: from Unknown (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 11 Jun 2015 18:47:33 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id E74AC1A546B for ; Thu, 11 Jun 2015 18:47:32 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.041 X-Spam-Level: ** X-Spam-Status: No, score=2.041 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, FREEMAIL_ENVFROM_END_DIGIT=0.25, HTML_MESSAGE=3, RCVD_IN_MSPIKE_H2=-1.108, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd2-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-us-west.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id G8oZQN2Yq4SS for ; Thu, 11 Jun 2015 18:47:32 +0000 (UTC) Received: from mail-ie0-f194.google.com (mail-ie0-f194.google.com [209.85.223.194]) by mx1-us-west.apache.org (ASF Mail Server at mx1-us-west.apache.org) with ESMTPS id F36A626536 for ; Thu, 11 Jun 2015 18:47:31 +0000 (UTC) Received: by ierx19 with SMTP id x19so4222488ier.3 for ; Thu, 11 Jun 2015 11:47:31 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:date:message-id:subject:from:to:content-type; bh=3PBOWivxfJEuT3aU/MH3LFAetj90k5qZm+ANtZIU51k=; b=G38lzdFMXxlhvTB3NCQB3uBuYGQsfBCA0LbzSuFn8OB+JgRcrptRDavoQvUcwbGsWg cVxk/qDPurY6T90cgPo+U+dsOePbIcnhPPcdy3Ob8f04HY+EuO2raFT7c0bYrRYgNbax UJVpZnqpf52Pwnc/4Z1pZNIKFNDQaI1BMXrHw7dRcBLwTisqaOHfXibSZt/3IhuxCPWR MDqmuymrZL+BfAtktpXc748m9LYlnMeHDMZKGqTW6ZozY1zqtAA3Gsb/ryHn0Oez+m+0 ZJebkalyCNVA0F+B7CC3JIg0r4kxM4ZddF83XGzu5NPsrS5+W75TDS7tYWgio8Gxx5UW oUWQ== MIME-Version: 1.0 X-Received: by 10.50.132.33 with SMTP id or1mr32303815igb.31.1434048451462; Thu, 11 Jun 2015 11:47:31 -0700 (PDT) Received: by 10.36.76.69 with HTTP; Thu, 11 Jun 2015 11:47:31 -0700 (PDT) Date: Thu, 11 Jun 2015 13:47:31 -0500 Message-ID: Subject: Table Delete in Apache Hbase From: Arun Kumaran Sabtharishi To: user@hbase.apache.org Content-Type: multipart/alternative; boundary=047d7b1636e18a7f180518426cfb --047d7b1636e18a7f180518426cfb Content-Type: text/plain; charset=UTF-8 Hello Hbase users and developers, I have a few questions regarding how table table delete works in hbase. *What I know:* If a hbase table is deleted(after disabling), the SYSTEM.CATALOG entries related to that table will be deleted. If a view is created using phoenix (assuming there are other views which are not related to each other) and the view that has been created is deleted, the SYSTEM.CATALOG entries related to the view will be deleted. Okay. Sounds good! *What I want to know:* Does the 'delete view' checks whether the other views(which were already existing) are going to be affected(doing a scan)? If table T1 and views V1, V2 and V3 already exists. Create a view Vx which is not dependent/related to any of V1, V2 and V3. Delete Vx. Does the delete Vx checks SYSTEM.CATALOG for V1, V2 and V3? In other words, does it do a scan to check whether the V1, V2 and V3 are dependent/related to Vx? Thanks, Arun --047d7b1636e18a7f180518426cfb--