[
https://issues.apache.org/jira/browse/HIVE-2310?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13071404#comment-13071404
]
Carl Steinbach commented on HIVE-2310:
--------------------------------------
CREATE EXTERNAL TABLE does not require the user to specify a LOCATION clause:
{code}
hive> CREATE EXTERNAL TABLE ext(a INT);
OK
hive> DESCRIBE FORMATTED ext;
...
Location: file:/user/hive/warehouse/ext <--- NOT GOOD
Table Type: EXTERNAL_TABLE
hive>
{code}
We should make the following changes:
* Require the user to specify a valid LOCATION clause for CREATE EXTERNAL TABLE
statements.
* Throw an error if the user specifies a LOCATION that is a subdirectory of
hive.metastore.warehouse.dir
> CREATE EXTERNAL TABLE should require a valid LOCATION clause
> ------------------------------------------------------------
>
> Key: HIVE-2310
> URL: https://issues.apache.org/jira/browse/HIVE-2310
> Project: Hive
> Issue Type: Bug
> Components: SQL
> Reporter: Carl Steinbach
>
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
