[jira] [Closed] (TRAFODION-1826) Error 1389 when dropping external Hive table and Hive table has changed

["Hans Zeller (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/TRAFODION-1826?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Hans Zeller closed TRAFODION-1826.
----------------------------------

> Error 1389 when dropping external Hive table and Hive table has changed
> -----------------------------------------------------------------------
>
>                 Key: TRAFODION-1826
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-1826
>             Project: Apache Trafodion
>          Issue Type: Bug
>          Components: sql-cmp
>    Affects Versions: 1.1 (pre-incubation)
>         Environment: Any
>            Reporter: Hans Zeller
>            Assignee: Roberta Marton
>
> When Trafodion looks up the corresponding Trafodion external table for a Hive table, it compares the two column layouts and raises error 1389 when they don't match. It also does that in the DROP EXTERNAL TABLE command, and that shouldn't happen. We should be able to drop an external table even (and especially!) if it doesn't match the underlying table.
> Hive:
> {quote}create table t(a int);{quote}
> Trafodion:
> {quote}create external table t for hive.hive.t;{quote}
> Hive:
> {quote}drop table t;
> create table t(b int);{quote}
> Trafodion:
> {quote}drop external table t for hive.hive.t;
>   ERROR 1389: Object TRAFODION."_HV_HIVE_".T does not exist in Trafodion.{quote}



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)