[
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)
