Re: [ANNOUNCE] New Hive Committer - Yin Huai

2013-09-03 Thread Hari Subramaniyan
Congrats !! On Tue, Sep 3, 2013 at 11:43 PM, Vaibhav Gumashta wrote: > Congrats Yin! > > > On Tue, Sep 3, 2013 at 11:37 PM, Jarek Jarcec Cecho wrote: > >> Congratulations Yin! >> >> Jarcec >> >> On Tue, Sep 03, 2013 at 09:49:55PM -0700, Carl Steinbach wrote: >> > The Apache Hive PMC has voted t

Re: [ANNOUNCE] New Hive Committer - Yin Huai

2013-09-03 Thread Vaibhav Gumashta
Congrats Yin! On Tue, Sep 3, 2013 at 11:37 PM, Jarek Jarcec Cecho wrote: > Congratulations Yin! > > Jarcec > > On Tue, Sep 03, 2013 at 09:49:55PM -0700, Carl Steinbach wrote: > > The Apache Hive PMC has voted to make Yin Huai a committer on the Apache > > Hive project. > > > > Please join me in

Re: [ANNOUNCE] New Hive Committer - Yin Huai

2013-09-03 Thread Jarek Jarcec Cecho
Congratulations Yin! Jarcec On Tue, Sep 03, 2013 at 09:49:55PM -0700, Carl Steinbach wrote: > The Apache Hive PMC has voted to make Yin Huai a committer on the Apache > Hive project. > > Please join me in congratulating Yin! > > Thanks. > > Carl signature.asc Description: Digital signature

Re: [ANNOUNCE] New Hive Committer - Yin Huai

2013-09-03 Thread Prasanth Jayachandran
Congratulations yin!!! On Tuesday, September 3, 2013, Jov wrote: > congratulations! > > Jov > blog: http:amutu.com/blog > > > 2013/9/4 Carl Steinbach > >> The Apache Hive PMC has voted to make Yin Huai a committer on the Apache >> Hive project. >> >> Please join me in con

Re: [ANNOUNCE] New Hive Committer - Yin Huai

2013-09-03 Thread Jov
congratulations! Jov blog: http:amutu.com/blog 2013/9/4 Carl Steinbach > The Apache Hive PMC has voted to make Yin Huai a committer on the Apache > Hive project. > > Please join me in congratulating Yin! > > Thanks. > > Carl >

[ANNOUNCE] New Hive Committer - Yin Huai

2013-09-03 Thread Carl Steinbach
The Apache Hive PMC has voted to make Yin Huai a committer on the Apache Hive project. Please join me in congratulating Yin! Thanks. Carl

Re: Problems with 0.11, count(DISTINCT), and NPE

2013-09-03 Thread Yin Huai
Based on the log, it may be also related to https://issues.apache.org/jira/browse/HIVE-4927. To make it work (in a not very optimized way), can you try "set hive.auto.convert.join.noconditionaltask=false;" ? If you still get the error, give "set hive.auto.convert.join=false;" a try (it will turn of

Re: Problems with 0.11, count(DISTINCT), and NPE

2013-09-03 Thread Ashutosh Chauhan
Not sure about EMR. Your best bet is to ask on EMR forums. Thanks, Ashutosh On Tue, Sep 3, 2013 at 2:18 PM, Nathanial Thelen wrote: > Is there a way to run a patch on EMR? > > Thanks, > Nate > > On Sep 3, 2013, at 2:14 PM, Ashutosh Chauhan wrote: > > Fix in very related area has been checked i

Re: Problems with 0.11, count(DISTINCT), and NPE

2013-09-03 Thread Nathanial Thelen
Is there a way to run a patch on EMR? Thanks, Nate On Sep 3, 2013, at 2:14 PM, Ashutosh Chauhan wrote: > Fix in very related area has been checked in trunk today : > https://issues.apache.org/jira/browse/HIVE-5129 Likely that will fix your > issue. > Can you try latest trunk? > > Ashutosh >

Re: Problems with 0.11, count(DISTINCT), and NPE

2013-09-03 Thread Ashutosh Chauhan
Fix in very related area has been checked in trunk today : https://issues.apache.org/jira/browse/HIVE-5129 Likely that will fix your issue. Can you try latest trunk? Ashutosh On Tue, Sep 3, 2013 at 2:03 PM, Nathanial Thelen wrote: > I am running Hive in EMR and since upgrading to 0.11 from 0.8.

Problems with 0.11, count(DISTINCT), and NPE

2013-09-03 Thread Nathanial Thelen
I am running Hive in EMR and since upgrading to 0.11 from 0.8.1.8 I have been getting NullPointerExceptions (NPE) for certain queries in our staging environment. Only difference between stage and production is the amount of traffic we get so the data set is much smaller. We are not using any c

Re: how to config the job id in oozie

2013-09-03 Thread Sanjay Subramanian
Hi See here http://oozie.apache.org/docs/3.2.0-incubating/WorkflowFunctionalSpec.html#a4.2.1_Basic_EL_Constants String timestamp() It returns the UTC current date and time in W3C format down to the second (-MM-DDThh:mm:ss.sZ). I.e.: 1997-07-16T19:20:30.45Z I don’t like the fact that that

Re: Hive Query - Issue

2013-09-03 Thread Sanjay Subramanian
Hi When you do a SELECT * , the partition columns are returned as last N columns (if u have N partitions) In this case the 63rd column in SELECT * is the partition column Instead of SELECT * Do a SELECT col1, col2, col3, ….. Not to show the candle to t

Re: Hive Statistics information

2013-09-03 Thread Sanjay Subramanian
Thanks Ravi let me give this a shot Regards sanjay From: Ravi Kiran mailto:maghamraviki...@gmail.com>> Reply-To: "user@hive.apache.org" mailto:user@hive.apache.org>> Date: Friday, August 30, 2013 10:53 PM To: "user@hive.apache.org" mailto

Re: Hive with Kerberos and a Remote Metastore

2013-09-03 Thread Subroto
I am also facing the same problem…. Any idea?? Cheers, Subroto Sanyal On Sep 3, 2013, at 3:04 PM, Christopher Penney wrote: > I'm new to hive and trying to set it up in a relatively secure manner for a > test environment. I want to use a remote metastore so MR jobs can access the > DB. I seem

Re: Hive JDBC Server: java.lang.IllegalStateException: Shutdown in progress

2013-09-03 Thread Guy Doulberg
Hi Nitin, We are using Cdh4.2.1 for the Hadoop and for the hive, I think that I understand the problem, when the hive process is stopping the filesystem is closed before some of the threads. I still need to figure out why the hive-server is restarting On 09/02/2013 02:56 PM, Nitin Pawar w

how to config the job id in oozie

2013-09-03 Thread 李宏展
when i submit a workflow,oozie return a jobid like this 002-130903214537362-oozie-*. But in this page http://oozie.apache.org/docs/3.3.2/DG_Examples.html ,the job id is 14-20090525161321-oozie-tucu. The job id with a date is really useful for me,but How should I config oozie for this?

Re: Semantics of Rank.

2013-09-03 Thread Edward Capriolo
Beyond that answer please note: Udf names are always case insensitive. RaNk = RANK = rank For rank this is a special case that was fixed. On Tue, Sep 3, 2013 at 9:15 AM, j.barrett Strausser < j.barrett.straus...@gmail.com> wrote: > I filed HIVE-5038. My issue was that it seemed incorrect that r

Re: Semantics of Rank.

2013-09-03 Thread j.barrett Strausser
I filed HIVE-5038. My issue was that it seemed incorrect that rank took an arg. I haven't verified that the issue is fixed in trunk as claimed in the JIRA.However, between the reponse in JIRA and in this thread it seems resolved. On Tue, Sep 3, 2013 at 4:23 AM, Lefty Leverenz wrote: > Another em

Hive with Kerberos and a Remote Metastore

2013-09-03 Thread Christopher Penney
I'm new to hive and trying to set it up in a relatively secure manner for a test environment. I want to use a remote metastore so MR jobs can access the DB. I seem to have things almost working, but when a user with a credential tries to create a database I get: hive> show databases; OK

Re: Semantics of Rank.

2013-09-03 Thread Lefty Leverenz
Another email thread led me to HIVE-5038("rank operator is case-sensitive and has odd semantics") -- it's resolved as invalid, but is that only for the odd semantics? Perhaps this issue is clarified in more recent emails. I'm catching up on a huge

Re: Semantics of Rank.

2013-09-03 Thread Lefty Leverenz
What's the answer -- does the "rank" keyword have to be lowercase? If lowercase is obligatory we need to revise the wiki, which shows all uppercase ( https://cwiki.apache.org/confluence/display/Hive/LanguageManual+WindowingAndAnalytics ). In the test files it's lowercase (windowing_rank.q, ptf_ne