hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lefty Leverenz <leftylever...@gmail.com>
Subject Re: BNF for Hive Views
Date Mon, 26 Aug 2013 04:02:19 GMT
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 <javadba@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
>

Mime
View raw message