The problem is if you follow our site from the main page you find the
broken docs, not the confluence ones.
On Mon, Sep 2, 2013 at 4:21 AM, Lefty Leverenz <leftylever...@gmail.com>wrote:
> Once again the /confluence/display version of the wiki is fine while the
> non-display version is glitchy. First the {code} tags gave invisible
> sample code, and now some of the doc links don't work -- but they're fine
> here: https://cwiki.apache.org/confluence/display/Hive/LanguageManual.
>
> Can anyone explain this, or better yet solve it? Until it's solved,
> should we include a link to the display version at the top of each wikidoc?
> (And I suppose that's the royal "we" unless someone else volunteers.)
>
> For the windowing
> doc<https://cwiki.apache.org/confluence/display/Hive/LanguageManual+WindowingAndAnalytics>,
> I've added a link to Harish's PDF file in the first paragraph:
>
> - See "Windowing Specifications in
> HQL<https://issues.apache.org/jira/secure/attachment/12575830/WindowingSpecification.pdf>"
> (attached to HIVE-4197<https://issues.apache.org/jira/browse/HIVE-4197>)
> for details.
>
> Happy Labor Day, everyone. -- Lefty
>
>
>
> On Sun, Sep 1, 2013 at 8:36 PM, Harish Butani <hbut...@hortonworks.com>wrote:
>
>> 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 HIVE-4197
>>
>> https://issues.apache.org/jira/secure/attachment/12575830/WindowingSpecification.pdf
>>
>> On Sep 1, 2013, at 2:04 PM, Edward Capriolo <edlinuxg...@gmail.com>
>> wrote:
>>
>> hive> select * from field_goal;
>> OK
>> tynes 44 miss
>> tynes 40 miss
>> tynes 33 make
>> pete 20 make
>> pete 21 make
>> arnold 56 make
>> arnold 22 make
>> arnold 45 miss
>> Time taken: 0.04 seconds, Fetched: 8 row(s)
>>
>> This makes sense:
>> hive> select name,avg(range) OVER (PARTITION by name ORDER by range) FROM
>> field_goal ;
>> arnold 22.0
>> arnold 33.5
>> arnold 41.0
>> pete 20.0
>> pete 20.5
>> tynes 33.0
>> tynes 36.5
>> tynes 39.0
>> Time taken: 4.14 seconds, Fetched: 8 row(s)
>>
>> but what is this?
>> hive> select name,range OVER (PARTITION by name ORDER by range) FROM
>> field_goal ;
>> tynes 44
>> tynes 40
>> tynes 33
>> pete 20
>> pete 21
>> arnold 56
>> arnold 22
>> arnold 45
>> Time taken: 3.709 seconds, Fetched: 8 row(s)
>>
>> It would be great if the
>> https://cwiki.apache.org/Hive/languagemanual-windowingandanalytics.html#LanguageManualWindowingAndAnalytics-PARTITIONBYwithpartitioning%252CORDERBY%252Candwindowspecification
>>
>>
>> Most of the links here:
>> https://cwiki.apache.org/Hive/languagemanual.html
>>
>> are broken...
>> What gives?
>> The language manual used to be fairly useful, now it is in major
>> dis-array.
>>
>>
>>
>>
>>
>>
>> CONFIDENTIALITY NOTICE
>> NOTICE: This message is intended for the use of the individual or entity
>> to which it is addressed and may contain information that is confidential,
>> privileged and exempt from disclosure under applicable law. If the reader
>> of this message is not the intended recipient, you are hereby notified that
>> any printing, copying, dissemination, distribution, disclosure or
>> forwarding of this communication is strictly prohibited. If you have
>> received this communication in error, please contact the sender immediately
>> and delete it from your system. Thank You.
>
>
>
>
