Anoop Sharma created TRAFODION-2210:
---------------------------------------
Summary: 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)
