[jira] [Work started] (TRAFODION-2210) some operations on volatile and external tables return error is schema default is set to hive

["Anoop Sharma (JIRA)" <ji...@apache.org>]

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