[
https://issues.apache.org/jira/browse/TRAFODION-3153?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16549933#comment-16549933
]
ASF GitHub Bot commented on TRAFODION-3153:
-------------------------------------------
Github user asfgit closed the pull request at:
https://github.com/apache/trafodion/pull/1652
> CREATE EXTERNAL TABLE doesn't report error if Hive table already exists
> -----------------------------------------------------------------------
>
> Key: TRAFODION-3153
> URL: https://issues.apache.org/jira/browse/TRAFODION-3153
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmp
> Affects Versions: 2.3
> Reporter: David Wayne Birdsall
> Assignee: David Wayne Birdsall
> Priority: Major
>
> The following session demonstrates the problem. The second CREATE EXTERNAL
> TABLE statement should fail and report that the object already exists, but
> instead it reports success.
> {quote}
> >>drop external table if exists hive.hive.test1;
> --- SQL operation complete.
> >>
> >>create external table hive.hive.test1
> +>( a date, b char(20) )
> +>row format delimited fields terminated by '|'
> +>location '/user/trafodion/hive/exttables/test1';
> --- SQL operation complete.
> >>
> >>select count(*) from hive.hive.test1;
> (EXPR)
> --------------------
> 0
> --- 1 row(s) selected.
> >>
> >>-- should fail with error 1387, but reports success
> >>create external table hive.hive.test1
> +>( a date, b char(20) )
> +>row format delimited fields terminated by '|'
> +>location '/user/trafodion/hive/exttables/test1';
> --- SQL operation complete.
> >>exit;
> End of MXCI Session
> {quote}
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
