hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Wei Zheng (JIRA)" <j...@apache.org>
Subject [jira] [Assigned] (HIVE-10751) Hive View Specification Needs Update
Date Tue, 02 Jun 2015 17:42:49 GMT

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

Wei Zheng reassigned HIVE-10751:
--------------------------------

    Assignee: Wei Zheng

> Hive View Specification Needs Update
> ------------------------------------
>
>                 Key: HIVE-10751
>                 URL: https://issues.apache.org/jira/browse/HIVE-10751
>             Project: Hive
>          Issue Type: Task
>          Components: Documentation
>    Affects Versions: 0.10.0, 0.11.0, 0.12.0, 0.13.0, 0.13.1
>            Reporter: Tim Gattone
>            Assignee: Wei Zheng
>            Priority: Trivial
>
> On this page: https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-Create/Drop/AlterView
>  
> There is no mention in the spec of the optional [db_name] to qualify the View with, but
it is mentioned with CREATE TABLE.
>  
> Isn’t this an oversight?  My understanding is that we can qualify the CREATE VIEW statement
with the database such as CREATE VIEW jrnl.sbb_base_v
>  
> The reason I ask is another vendor is questioning this syntax.
>  
> CREATE VIEW [IF NOT EXISTS] view_name [(column_name [COMMENT column_comment], ...) ]
>   [COMMENT view_comment]
>   [TBLPROPERTIES (property_name = property_value, ...)]
>   AS SELECT ...;
> =================================================
> Email response from Hortonworks:
> Subject: Hive - Question
>  
> Good morning Tim, 
>  
> I have received this email thread from Doug. I have looked into it below are my findings.

>  
> Yes. We can qualify the CREATE VIEW statement with the database. 
>  
> hive> create view db1.vw3 as select * from default.x1;
> OK
> Time taken: 0.084 seconds
> hive>
>  
> This could be a possible documentation issue or improvement, which can be addressed by
raising an Apache JIRA. This documentation is maintained by apache and HWX contributes to
it. Anyone can register and raise Apache JIRA.  
>  
> Please let me know if you have any questions or concerns.                       
>  
> Thank you,
> Sai



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message