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

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

Hans Zeller created TRAFODION-1826:
--------------------------------------

             Summary: 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


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.4#6332)