Mailing-List: contact issues-help@spark.apache.org; run by ezmlm
Precedence: bulk
Date: Mon, 4 Aug 2014 21:28:12 +0000 (UTC)
From: "Michael Armbrust (JIRA)" <jira@apache.org>
To: issues@spark.apache.org
Message-ID: <JIRA.12731681.1407136661869.10800.1407187692581@arcas>
In-Reply-To: <JIRA.12731681.1407136661869@arcas>
References: <JIRA.12731681.1407136661869@arcas>
Subject: [jira] [Commented] (SPARK-2825) Allow creating external tables in
 metastore
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ https://issues.apache.org/jira/browse/SPARK-2825?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14085311#comment-14085311 ] 

Michael Armbrust commented on SPARK-2825:
-----------------------------------------

CREATE EXTERNAL TABLE already works as far as I know and should have the same semantics as Hive.

The only operation that is not supported is CREATE EXTERNAL TABLE tablename AS SELECT ... This operation is heavier weight than just creating a pointer, since the query needs to be executed to calculate the data.  I'd assume that this is for a case when you want to create a new table, but want the data to exist outside of warehouse.

> Allow creating external tables in metastore
> -------------------------------------------
>
>                 Key: SPARK-2825
>                 URL: https://issues.apache.org/jira/browse/SPARK-2825
>             Project: Spark
>          Issue Type: Bug
>          Components: SQL
>            Reporter: Aaron Davidson
>
> External tables are useful for creating a metastore entry that points at pre-existing data. There is an easy workaround to use registerAsTable within SparkSQL itself, but this is only transient, and has to be re-run for every Spark session.


--
This message was sent by Atlassian JIRA
(v6.2#6252)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org