Re: DISCUSS: Hive language manual to be source control managed

2013-09-04 Thread Lefty Leverenz
> > I believe I converted a majority of the wiki before you did > https://github.com/mislam77/hive-li/blob/master/docs/xdocs/language_manual/cli.xml, > but that is splitting hairs :) Go ahead and split hairs, Edward, because you deserve plenty of credit. And last year you warned me that the comm

Re: Sentry Meetup

2013-09-04 Thread Sanjay Subramanian
Thanks I will see it in the CDH users group Regards sanjay From: Shreepadma Venugopalan mailto:shreepa...@cloudera.com>> Reply-To: "user@hive.apache.org" mailto:user@hive.apache.org>> Date: Wednesday, September 4, 2013 5:33 PM To: "user@hive.apache.org

Re: Sentry Meetup

2013-09-04 Thread Shreepadma Venugopalan
Hi Sanjay, The problems you are encountering with Sentry are due to misconfiguration. These are not bugs. We have responded to you questions on cdh-user@. Shreepadma On Wed, Sep 4, 2013 at 3:49 PM, Sanjay Subramanian < sanjay.subraman...@wizecommerce.com> wrote: > Ahh…..why not SFO :-) >

Re: how to config the job id in oozie

2013-09-04 Thread Sanjay Subramanian
Wow that’s a great idea Artem From: Artem Ervits mailto:are9...@nyp.org>> Reply-To: "user@hive.apache.org" mailto:user@hive.apache.org>> Date: Wednesday, September 4, 2013 5:07 AM To: "'user@hive.apache.org'" mailto:user@hive.apache.org>> Subject: Re: how to config t

Re: DISCUSS: Hive language manual to be source control managed

2013-09-04 Thread Alan Gates
I'm definitely +1 on moving the language doc to source control. Being able to have versions of the language manual that match versions of Hive would be very valuable. Alan. On Sep 1, 2013, at 2:39 PM, Edward Capriolo wrote: > Over the past few weeks I have taken several looks over documents

Re: Access

2013-09-04 Thread Ellen Evans
Thanks, Ashutosh. Ellen On Wed, Sep 4, 2013 at 3:39 PM, Ashutosh Chauhan wrote: > Added. Thanks, Ellen for helping in improving hive documentation. > > Ashutosh > > > On Wed, Sep 4, 2013 at 3:13 PM, Ellen Evans wrote: > >> >> >> -- Forwarded message -- >> From: Ellen Evans >>

Re: Sentry Meetup

2013-09-04 Thread Sanjay Subramanian
Ahh…..why not SFO :-) I am struggling to implement Sentry and would love some inputs Shreepadma, thanks for all your clarifications but I am only partially done with my implementation I have a workaround whereby I can blank out tables from "default" db of hive to all hiveserver2 JDBC users…

Sentry Meetup

2013-09-04 Thread Shreepadma Venugopalan
Sentry is a fine-grained role-based authorization system for Hive among others. We're planning to have a Sentry meetup in NYC coinciding with Hadoop World and Strata 2013. Please RSVP hereif you wish to attend the meetup and hear more abou

Re: Access

2013-09-04 Thread Ashutosh Chauhan
Added. Thanks, Ellen for helping in improving hive documentation. Ashutosh On Wed, Sep 4, 2013 at 3:13 PM, Ellen Evans wrote: > > > -- Forwarded message -- > From: Ellen Evans > Date: Wed, Sep 4, 2013 at 3:11 PM > Subject: Access > To: user@hive.apache.org > > > Hi - > > My na

Fwd: Access

2013-09-04 Thread Ellen Evans
-- Forwarded message -- From: Ellen Evans Date: Wed, Sep 4, 2013 at 3:11 PM Subject: Access To: user@hive.apache.org Hi - My name is Ellen Evans and I am a tech writer at Hortonworks. I've been asked to do some work on the Hive wiki. Currently I am supposed to update the Date d

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

2013-09-04 Thread Nathanial Thelen
Doing: > set hive.auto.convert.join.noconditionaltask=false; makes it work (though it does way more map reduce jobs than it should). When I get some time I will test against the latest trunk. Thanks, Nate On Sep 3, 2013, at 6:09 PM, Yin Huai wrote: > Based on the log, it may be also relate

Re: Issue in BINARY datatype

2013-09-04 Thread Sushanth Sowmyan
I tried recreating your exact dump with a more recent(built as of about 3 weeks back) hive. And in addition to the base64-decoded version of the binary data, I get some extraneous characters in every line of the select *. (consistently the same extra characters) For eg, an od -c of the first line

Re: How to use HCatalog with Hive?

2013-09-04 Thread Ash G
Thank you. I installed hive on mac using Homebrew. May that is the reason I do not see hcat. I will re-install using binary tarball. On Wed, Sep 4, 2013 at 2:27 PM, Sushanth Sowmyan wrote: > Hi, > > The hcat commandline should be available to you in the hcatalog/bin > directory if you used the

Re: How to use HCatalog with Hive?

2013-09-04 Thread Sushanth Sowmyan
Hi, The hcat commandline should be available to you in the hcatalog/bin directory if you used the hive-0.11 binary tarball. That said, the hcat commandline is a simplified stripped down hive commandline, and except for switches like -g, you should be able to use the hive cli for everything you us

How to use HCatalog with Hive?

2013-09-04 Thread Ash G
I installed Hive 0.11. I believe hcatalog is now part of of it. I do not see a separate HCAT command. How does one use Command line hcat with hive now? Or do I need to install hcat separately?

Re: Hive unit test errors

2013-09-04 Thread Sushanth Sowmyan
This seems to work for me on trunk. This should work in 0.11 as well, given that the feature it is complaining about was introduced in HIVE-4139, which was committed in hive-0.11. Could you please check your /hive/build/shims/hive-shims-0.11.0.jar (should be the same as /Users/echu/.ivy2/local/org

Re: how to config the job id in oozie

2013-09-04 Thread Artem Ervits
You can also use shell action to generate timestamp in format you want and pass to the next action as parameter. I do agree it should be easier. Artem Ervits Data Analyst New York Presbyterian Hospital From: Sanjay Subramanian [mailto:sanjay.subraman...@wizecommerce.com] Sent: Tuesday, Septembe

Issue in BINARY datatype

2013-09-04 Thread Arun Vasu
Hi, I am using Hive 10. When I create an external table with column type as Binary, the query result on the table is showing some junk values for the column with binary datatype. Please find below the query I have used to create the table: CREATE EXTERNAL TABLE BOOL1(NB BOOLEAN,email STRING, bitf

Re: [ANNOUNCE] New Hive Committer - Yin Huai

2013-09-04 Thread Alexander Alten-Lorenz
Amazing news, congratz Yin! Well deserved! On Sep 4, 2013, at 6:49 AM, 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 -- Alexander Alten-Lorenz http://mapredit.blo

Re: Hive with Kerberos and a Remote Metastore

2013-09-04 Thread Subroto
Hi Christopher, I am running hive metastore as user "hive" (hive/ip-10-151-109-165.ec2.internal@EC2.INTERNAL) and then I configure hadoop.proxyuser.hive.hosts and hadoop.proxyuser.hive.groups to '*'. This works. On Sep 3, 2013, at 6:39 PM, Subroto wrote: > I am also facing the same problem…. A

Re: [ANNOUNCE] New Hive Committer - Yin Huai

2013-09-04 Thread Thejas Nair
Congrats Yin! Well deserved! Looking forward to many more contributions from you! On Tue, Sep 3, 2013 at 11:45 PM, Hari Subramaniyan wrote: > 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