Re: Cumulative sum with Hive

Hei, Thank you very much! Cool! I make it work like this: SELECT r.day, r.a, SUM(r.a) OVER part_month AS cumulative_a FROM ( SELECT day, month, COUNT (DISTINCT (a)) FROM table WHERE month='xx' GROUP BY day, month )r WINDOW part_month as (PARTITION BY r.month order by r.day) Greetings from F

Re: DDL wiki GRANT

Well done. Thanks very much. -- Lefty On Tue, Oct 14, 2014 at 11:48 PM, Suhas Gogate wrote: > Done! Thx. That where Brett's question originated :) > > On Tue, Oct 14, 2014 at 8:45 PM, Lefty Leverenz > wrote: > >> Looks good, except that you forgot to change the GRANT syntax >>

Re: DDL wiki GRANT

Done! Thx. That where Brett's question originated :) On Tue, Oct 14, 2014 at 8:45 PM, Lefty Leverenz wrote: > Looks good, except that you forgot to change the GRANT syntax >

Re: DDL wiki GRANT

Looks good, except that you forgot to change the GRANT syntax -- it still says object_type. -- Lefty On Tue, Oct 14, 2014 at 11:41 PM, Suhas Gogat

Re: Need write access to Hive Wiki

Lefty Thanks for the access! --Suhas On Tue, Oct 14, 2014 at 7:26 PM, Lefty Leverenz wrote: > Oh, Brett -- you gave an email address but I only used "javabrett" -- > woohoo! You've got edit privileges now. > > Whew, what a struggle. Now who wants first dibs on fixing the GRANT > syntax? > >

Re: DDL wiki GRANT

Lefty/Brett, I did change the wiki.. check if it looks okay. --Suhas On Tue, Oct 14, 2014 at 7:34 PM, Lefty Leverenz wrote: > One question remains: in object_specification, are the keywords TABLE and > DATABASE optional? > > At least for TABLE I've seen queries in the test suite that omitted

Re: DDL wiki GRANT

One question remains: in object_specification, are the keywords TABLE and DATABASE optional? At least for TABLE I've seen queries in the test suite that omitted it, but that was probably for SQL standards based authorization. So I guess we should assume TABLE and DATABASE are required unless som

Re: Need write access to Hive Wiki

Oh, Brett -- you gave an email address but I only used "javabrett" -- woohoo! You've got edit privileges now. Whew, what a struggle. Now who wants first dibs on fixing the GRANT syntax? -- Lefty On Tue, Oct 14, 2014 at 10:17 PM, Lefty Leverenz wrote: > Okay, Suhas, you've got edit privileges

Re: Need write access to Hive Wiki

Okay, Suhas, you've got edit privileges. Welcome to the wiki team! But it didn't work for Brett. Suspecting user error on my part, I entered javabrett despite the "No matches found" message and got a bright red error message. In exasperation I entered vitthal_gogate expecting the same error, bu

Re: Need write access to Hive Wiki

Also feel free to attempt to grant wiki write access to my account, javabrett at gmail dot com . Regards Brett On 15 October 2014 12:13, Lefty Leverenz wrote: > Still "No matches found" and one existing user has an underscore in his ID, > so that isn't the problem. > > Would someone else who can

error while running a hive view

Hello, I am getting the following error while running a view. However, the hive script that is used in the creation of hive view runs without error. It's only when I select * from hive_view I am getting the error saying *Caused by: java.lang.RuntimeException: Cannot serialize object* Could anyon

Re: Need write access to Hive Wiki

Still "No matches found" and one existing user has an underscore in his ID, so that isn't the problem. Would someone else who can grant wiki edit privileges please try? -- Lefty On Tue, Oct 14, 2014 at 5:54 PM, Lefty Leverenz wrote: > Still no joy. I'll give it a few hours. (Or someone else

Re: ALTER TABLE T1 PARTITION(P1) CONCATENATE bug?

Could you tell the version number of hive? Thanks, Navis 2014-10-15 2:00 GMT+09:00 Time Less : > I have found a work-around for this bug. After you issue the ALTER > TABLE...CONCATENATE command, issue: > > ALTER TABLE T1 PARTITION (P1) SET LOCATION > ".../apps/hive/warehouse/DB1/T1/P1"; > > This

Re: Java api for connecting to hiveserver2

That's an older version of the HCatalog javadocs. You can find current javadocs here: http://hive.apache.org/javadocs/r0.13.1/api/index.html. -- Lefty On Sun, Oct 12, 2014 at 3:05 PM, Suhas Gogate wrote: > Edward/Hanish, this is a reasonable use case to justify Java API. I > initially thought

Re: Need write access to Hive Wiki

Still no joy. I'll give it a few hours. (Or someone else can try.) -- Lefty On Tue, Oct 14, 2014 at 5:12 PM, Lefty Leverenz wrote: > Hm, still "No matches found" (using cut-&-paste) -- I'll keep trying in > case it's a sync issue. Thanks. > > -- Lefty > > On Tue, Oct 14, 2014 at 5:04 PM, Suh

Re: subscribe

How can I stop th JIRA emails? Should I send an email to u...@apache.hive.org or develo...@apache.hive.org On Sat, Oct 11, 2014 at 8:39 PM, Lefty Leverenz wrote: > Arthur, there's a separate email address for subscribing to > u...@apache.hive.org -- see http://hive.apache.org/mailing_lists.html

Re: Need write access to Hive Wiki

Hm, still "No matches found" (using cut-&-paste) -- I'll keep trying in case it's a sync issue. Thanks. -- Lefty On Tue, Oct 14, 2014 at 5:04 PM, Suhas Gogate wrote: > Thanks Lefty, I can actually login using this id to confluence wiki ( > https://cwiki.apache.org/confluence/dashboard.action).

Re: Need write access to Hive Wiki

Thanks Lefty, I can actually login using this id to confluence wiki ( https://cwiki.apache.org/confluence/dashboard.action). I created this id just half hour back before sending over to this mailing list, so could be sync issue? It is underscore (_) between my first and last name. id: vitthal_

Re: Need write access to Hive Wiki

Confluence didn't recognize that user id. Might it have a typo? -- Lefty On Tue, Oct 14, 2014 at 4:30 PM, Suhas Gogate wrote: > My confluence user id is vitthal_gogate > > Thanks > --Suhas >

Re: DDL wiki GRANT

+1 -- Lefty On Tue, Oct 14, 2014 at 4:37 PM, Brett Randall wrote: > +1 > > On 15 October 2014 07:23, Suhas Gogate wrote: > > Agree w/ Brett.. so may be instead of "object_type", we can use > > "object_specification" (similar to principal specification)? > > > > GRANT > > priv_type [(column

Re: DDL wiki GRANT

+1 On 15 October 2014 07:23, Suhas Gogate wrote: > Agree w/ Brett.. so may be instead of "object_type", we can use > "object_specification" (similar to principal specification)? > > GRANT > priv_type [(column_list)] > [, priv_type [(column_list)]] ... > [ON object_specification] >

Need write access to Hive Wiki

My confluence user id is vitthal_gogate Thanks --Suhas

Re: DDL wiki GRANT

Agree w/ Brett.. so may be instead of "object_type", we can use "object_specification" (similar to principal specification)? GRANT priv_type [(column_list)] [, priv_type [(column_list)]] ... [ON object_specification] TO principal_specification [, principal_specification] ...

Re: DDL wiki GRANT

I'll correct it as soon as we reach consensus. (Perhaps Thejas will chime in.) If you want to do it yourself, you can get wiki edit privilege quite easily. -- Lefty On Tue, Oct 14, 2014 at 7:

Re: ALTER TABLE T1 PARTITION(P1) CONCATENATE bug?

I have found a work-around for this bug. After you issue the ALTER TABLE...CONCATENATE command, issue: ALTER TABLE T1 PARTITION (P1) SET LOCATION ".../apps/hive/warehouse/DB1/T1/P1"; This will fix the metadata that CONCATENATE breaks. –– *Tim Ellis:* 510-761-6610 On Mon, Oct 13, 2014 at 10:37

Re: Cumulative sum with Hive

Hey, You could try something like SELECT sum(a) OVER (PARTITION BY dummy ROWS UNBOUNDED PRECEDING) FROM (SELECT a, “dummy” AS dummy FROM table) AS aux; The smaller solution of : SELECT sum(A) OVER (PARTITION BY “dummy” ROWS UNBOUNDED PRECEDING) FROM table; For me gets stuck without presenting

Cumulative sum with Hive

Hi, Could you please help me how to calculate cumulative sum with Hive? Like RSUM in Oracle? Thanks. -- Best Regards, *Meri-Tuulia Rautavuori* *Business Analyst* SongHi Entertainment Ltd *Särkiniementie 5 C 7* *00210 Helsinki* +358 45 271 2171 *merituulia.rautavu...@songhi.com * http://www.

Re: DDL wiki GRANT

I agree that the use of priv_level is confusing when it is actually referring to object_name (of type TABLE or DATABASE). I don't mind the rolling-up of tbl_name or db_name into object_type, although it then makes object_type: somewhat misleading. "[ON object_type object_name]" reads well for me.

Re: Question re: Concurrency

conf/hive-default.xml.template: hive.support.concurrency conf/hive-default.xml.template- false Hive does not support this feature as default. But you can enable it thru some settings. 2014-10-14 10:38 GMT+08:00 Time Less : > I am looking at this page: > https://cwiki.apache.org/confluence/di