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.
