yes i had read and re-read it. I do have a specific reason for wishing to view the bnf. thanks.
2013/8/25 Lefty Leverenz <leftylever...@gmail.com> > Have you tried the Views chapter in the O'Reilly book "Programming Hive" > by Rutherglen, Wampler, and Capriolo? > > -- Lefty > > > > On Mon, Aug 26, 2013 at 12:14 AM, Stephen Boesch <java...@gmail.com>wrote: > >> I was already well familiar with the content of the links you provided. >> I have a specific question about the BNF for views (and potentially other >> ddl/dml) that does not appear to be addressed . Thanks. >> >> >> >> 2013/8/25 Lefty Leverenz <leftylever...@gmail.com> >> >>> 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 <java...@gmail.com>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 >>>> >>> >>> >>> >> > >
