hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Owen O'Malley (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (HIVE-3193) cannot query views using qualified table references
Date Tue, 20 Aug 2013 23:01:52 GMT

     [ https://issues.apache.org/jira/browse/HIVE-3193?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Owen O'Malley resolved HIVE-3193.
---------------------------------

    Resolution: Cannot Reproduce
    
> 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
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message