Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> BNF for Hive Views


Copy link to this message
-
Re: BNF for Hive Views
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 <[EMAIL PROTECTED]>

> 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 <[EMAIL PROTECTED]>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 <[EMAIL PROTECTED]>
>>
>>> 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
>>>>
>>>
>>>
>>>
>>
>
>