hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "N Campbell (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-3193) cannot query views using qualified table references
Date Sun, 24 Jun 2012 18:12:42 GMT
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

        

Mime
View raw message