> The problem is if you follow our site from the main page you find the broken docs, not the confluence ones.
Let's take this to a separate thread, since it isn't about the windowing query. -- Lefty On Mon, Sep 2, 2013 at 11:44 AM, Edward Capriolo <edlinuxg...@gmail.com>wrote: > 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. >> >> >> >> >