hive> select * from field_goal;
OK
tynes44miss
tynes40miss
tynes33make
pete20make
pete21make
arnold56make
arnold22make
arnold45miss
Time taken: 0.04 seconds, Fetched: 8 row(s)
This makes sense:
hive> select name,avg(range) OVER (PARTI
Over the past few weeks I have taken several looks over documents in our
wiki.
The page that strikes me as alarmingly poor is the:
https://cwiki.apache.org/Hive/languagemanual.html
This page has several critical broken links such as
https://cwiki.apache.org/Hive/languagemanual-groupby.html
https:/
Will this allow BNF's for the DDL / DML to be provided and made up to date
more readily ?
2013/9/1 Edward Capriolo
> Over the past few weeks I have taken several looks over documents in our
> wiki.
> The page that strikes me as alarmingly poor is the:
> https://cwiki.apache.org/Hive/languagem
I am not sure about BNF. Hive uses antlr so the language itself is never
described as BNF. Maybe antlr has a tool or clever way to turn the .g file
into BNF. If it is possible that should be something we do during a
document generating step. Also if a new feature does change the language
the theory
In your 3rd query the OVER clause is being ignored because there is no
associated Aggregation Function.
This has been fixed in HIVE-4214. The query fails with the following error:
'cannot recognize input near 'range' 'OVER' '(' in select expression'
The Windowing behavior in Hive is documented in