Return-Path: X-Original-To: apmail-hive-dev-archive@www.apache.org Delivered-To: apmail-hive-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id C61121040A for ; Thu, 5 Dec 2013 21:28:35 +0000 (UTC) Received: (qmail 64782 invoked by uid 500); 5 Dec 2013 21:28:35 -0000 Delivered-To: apmail-hive-dev-archive@hive.apache.org Received: (qmail 64739 invoked by uid 500); 5 Dec 2013 21:28:35 -0000 Mailing-List: contact dev-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@hive.apache.org Delivered-To: mailing list dev@hive.apache.org Received: (qmail 64731 invoked by uid 500); 5 Dec 2013 21:28:35 -0000 Delivered-To: apmail-hadoop-hive-dev@hadoop.apache.org Received: (qmail 64728 invoked by uid 99); 5 Dec 2013 21:28:35 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 05 Dec 2013 21:28:35 +0000 Date: Thu, 5 Dec 2013 21:28:35 +0000 (UTC) From: "Lenni Kuff (JIRA)" To: hive-dev@hadoop.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Created] (HIVE-5968) Assign (and expose to the client) unique object IDs for each metastore object MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 Lenni Kuff created HIVE-5968: -------------------------------- Summary: Assign (and expose to the client) unique object IDs for each metastore object Key: HIVE-5968 URL: https://issues.apache.org/jira/browse/HIVE-5968 Project: Hive Issue Type: New Feature Components: Database/Schema, Metastore Affects Versions: 0.12.0 Reporter: Lenni Kuff The Hive Metastore should assign a unique ID to every metastore object - Database, Table, Partition, etc. These IDs should also be exposed on each of the corresponding thrift structs. There are many cases where this would be useful, one simple case is the following: hive1> CREATE TABLE Foo; hive2> DROP TABLE Foo; hive3> CREATE Table Foo; Without object ID, there is no good way for the client to differentiate the table created in step1 versus the table created in step3. In general, working with object IDs is much more robust (especially with concurrent operations) than only the object names. With an ID the client can call get_table(object_id) and ensure the table they get back is exactly the one they expect. -- This message was sent by Atlassian JIRA (v6.1#6144)