Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
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
>>>>>
>>>>
>>>>
>>>>
>>>
>>
>>
>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB