N Campbell created HIVE-3193:
--------------------------------
Summary: cannot query views using qualified table references
Key: HIVE-3193
URL: https://issues.apache.org/jira/browse/HIVE-3193
Project: Hive
Issue Type: Bug
Affects Versions: 0.8.0
Reporter: N Campbell
hive server has databases. irrespective of specifying /db-name on the
connection or an explicit set the following scenario will fail
set database cert
drop view cert.vsint
create view CERT.VSINT as select * from CERT.TSINT
select * from CERT.VSINT
Error: Query returned non-zero code: 10, cause: FAILED: Error in semantic
analysis: Invalid table alias Referencing view from foreign databases is not
supported.
SQLState: 42000
ErrorCode: 10
and ditto
set database cert
drop view cert.vsint
create view CERT.VSINT as select * from TSINT
select * from CERT.VSINT
Error: Query returned non-zero code: 10, cause: FAILED: Error in semantic
analysis: Line 1:14 Table not found 'VSINT'
SQLState: 42000
ErrorCode: 10
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
