Tim Gattone created HIVE-10751:
----------------------------------
Summary: 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.13.1, 0.13.0, 0.12.0, 0.11.0, 0.10.0
Reporter: Tim Gattone
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)
