Let me introduce you to the Hive wiki. - Hive wiki home page: https://cwiki.apache.org/confluence/display/Hive/Home - Language manual: https://cwiki.apache.org/confluence/display/Hive/LanguageManual - DDL: https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL - Views: https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-Create%2FDropView - Excerpt: "A view's schema is frozen at the time the view is created; subsequent changes to underlying tables (e.g. adding a column) will not be reflected in the view's schema. If an underlying table is dropped or changed in an incompatible fashion, subsequent attempts to query the invalid view will fail." - New in Hive 0.11: https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-AlterViewAsSelect - SELECT: https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Select
The wiki is still a work in progress, but you'll find more DDL information than in the old Hive xdocs that Cloudera provides. Everything in the xdocs is in the wiki now (except for some nifty headings in the CREATE TABLE section, which ought to be added to the wiki). -- Lefty On Sun, Aug 25, 2013 at 4:38 PM, Stephen Boesch <[email protected]> wrote: > > It appears a bit challenging to find the BNF's for the hive DDL's. After > a few google's the following popped up for cdh3 and only for a subset of > table creation's. > > > > http://archive.cloudera.com/cdh/3/hive/language_manual/data-manipulation-statements.html > > Is there an updated and more complete DDL BNF reference? Although my > present need is for views (and specifically how to impose a schema on a > view), the BNF for other statements would also be helpful. > > Thanks, > > stephenb >
