+1
On Mon, Apr 25, 2016 at 2:40 PM Lars Francke wrote:
> Thanks for the further votes. If I'm not mistaken three more would be
> missing for a successful vote.
>
> @Carl, thanks for your vote. I'd behappy to hear any concerns you might
> have.
>
> @Ashutosh: Sounds like a very sensible idea. I'v
r gap of 5-6 months. It shows tremendous growth in hive
> community activity!
>
> hive 0.13 - 1081
> hive 0.12 - 439
> hive 0.11 - 374
>
> -Thejas
>
> On Mon, Apr 21, 2014 at 3:17 PM, Harish Butani
> wrote:
> > The Apache Hive team is proud to announce the the relea
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
Can you try this:
select search_terms, productid, clicks_to_product from npath ( on clicks
distributed by sessionid sort by timestamp
arg1('SEARCH.NOTPRODUCT*.PRODUCT'),
arg2('SEARCH'), arg3(page = 'SEARCH'),
arg4('PRODUCT'), arg5(p
Can you provide details on what you want to do.
You maybe able to express this by stacking queries: execute npath in a SubQuery
in the from clause and then do windowing in an outer select.
Also you get the 'path' object back from npath, so you can apply array indexing
on it.
regards,
Harish.
On
Regarding the issue posted with rank and dense_rank. The example posted was:
CREATE TABLE test (a INT);
EXPLAIN
SELECT
DENSE_RANK() OVER (PARTITION BY a),
a
FROM test;
Some comments on this:
1. The underlying issue is the bug that ranking functions had to be lowercase.
This was fixed in Ji