[
https://issues.apache.org/jira/browse/TRAFODION-2210?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Work on TRAFODION-2210 started by Anoop Sharma.
-----------------------------------------------
> some operations on volatile and external tables return error is schema
> default is set to hive
> ---------------------------------------------------------------------------------------------
>
> Key: TRAFODION-2210
> URL: https://issues.apache.org/jira/browse/TRAFODION-2210
> Project: Apache Trafodion
> Issue Type: Bug
> Reporter: Anoop Sharma
> Assignee: Anoop Sharma
>
> In the following example, session schema default is set to hive.hive
> (hive catalog and hive schema).
> That causes some operations on volatile and external table to
> return errors.
> Since fully qualifying a volatile or external table is not supported,
> the proposed fix it to treat volatile and external tables in trafodion
> catalog and not return errors.
> Some examples (there are other examples with indexes, etc):
> >>set schema hive.hive;
> --- SQL operation complete.
> >>create volatile table t (a int);
> *** ERROR[3242] This statement is not supported. Reason: DDL operations can
> only be done on trafodion or external tables.
> *** ERROR[8822] The statement was not prepared.
> >>
> >>create external table th for th;
> --- SQL operation complete.
> >>drop external table th for th;
> *** ERROR[3242] This statement is not supported. Reason: DDL operations can
> only be done on trafodion or external tables.
> *** ERROR[8822] The statement was not prepared.
> >>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
