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
Stephen Boesch 2013-08-26, 04:29
The antlr file  (Hive.g ) is providing the info I need for this specific
case, but if BNF exists a pointer would still be helpful . Thx
2013/8/25 Stephen Boesch <[EMAIL PROTECTED]>

> 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
>>>>>
>>>>
>>>>
>>>>
>>>
>>
>>
>