Re: LDAPS (Secure LDAP) Hive configuration

2016-06-16 Thread Jose Rozanec
Hi, Yes, that is correct. We have LDAPS configured on 636, and certificate available only at that port. 443 is not enabled in our case, and should not bother, since communication is performed just on 636. 2016-06-15 23:20 GMT-03:00 Anurag Tangri : > > Hey Joze, > Ldaps is a different port like

Re: LDAPS (Secure LDAP) Hive configuration

2016-06-15 Thread Anurag Tangri
Hey Joze, Ldaps is a different port like 636 or something. Default port does not work as far as I remember. Could you check if something on these lines ? Thanks, Anurag Tangri Sent from my iPhone > On Jun 15, 2016, at 3:01 PM, Jose Rozanec > wrote: > > Hi, > > We upgraded to 2.1.0, but

Re: LDAPS (Secure LDAP) Hive configuration

2016-06-15 Thread Jose Rozanec
Hi, We upgraded to 2.1.0, but we still cannot get it working: we get "LDAP: error code 34 - invalid DN". We double-checked the DN configuration, and the ldap team agrees is ok. We then configured SSL parameters as well (hive.server2.use.SSL, hive.server2.keystore.path, hive.server2.keystore.passwo

Re: LDAPS (Secure LDAP) Hive configuration

2016-06-13 Thread Jose Rozanec
Thank you for the quick response. Will try upgrading to version 2.1.0 Thanks! 2016-06-13 4:34 GMT-03:00 Oleksiy S : > Hello, >> >> We are working on a Hive 2.0.0 cluster, to configure LDAPS >> authentication, but I get some errors preventing a successful >> authentication. >> Does anyone have so

Re: LDAPS (Secure LDAP) Hive configuration

2016-06-13 Thread Oleksiy S
> > Hello, > > We are working on a Hive 2.0.0 cluster, to configure LDAPS authentication, > but I get some errors preventing a successful authentication. > Does anyone have some insight on how to solve this? > > *The problem* > The errors we get are (first is most frequent): > - sun.security.provid

LDAPS (Secure LDAP) Hive configuration

2016-06-10 Thread Jose Rozanec
Hello, We are working on a Hive 2.0.0 cluster, to configure LDAPS authentication, but I get some errors preventing a successful authentication. Does anyone have some insight on how to solve this? *The problem* The errors we get are (first is most frequent): - sun.security.provider.certpath.SunCer

Re: Hive configuration parameter hive.enforce.bucketing does not exist in Hive 2

2016-04-29 Thread Mich Talebzadeh
Lefty Leverenz wrote: > FYI, the removal of hive.enforce.bucketing is documented in the wiki ( > hive.enforce.bucketing > <https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties#ConfigurationProperties-hive.enforce.bucketing>) > and the JIRA issue that removed i

Re: Hive configuration parameter hive.enforce.bucketing does not exist in Hive 2

2016-04-29 Thread Lefty Leverenz
FYI, the removal of hive.enforce.bucketing is documented in the wiki ( hive.enforce.bucketing <https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties#ConfigurationProperties-hive.enforce.bucketing>) and the JIRA issue that removed it is HIVE-12331 <https://issues.apache

Re: Hive configuration parameter hive.enforce.bucketing does not exist in Hive 2

2016-04-29 Thread Mich Talebzadeh
il 29, 2016 at 11:16 > To: user > Subject: Re: Hive configuration parameter hive.enforce.bucketing does not > exist in Hive 2 > > Well having it in the old code causes the query to crash as well! > > Dr Mich Talebzadeh > > > > LinkedIn * > https://www.linkedin.c

Re: Hive configuration parameter hive.enforce.bucketing does not exist in Hive 2

2016-04-29 Thread Sergey Shelukhin
er@hive.apache.org>> Subject: Re: Hive configuration parameter hive.enforce.bucketing does not exist in Hive 2 Well having it in the old code causes the query to crash as well! Dr Mich Talebzadeh LinkedIn https://www.linkedin.com/profile/view?id=AAEWh2gBx

Re: Hive configuration parameter hive.enforce.bucketing does not exist in Hive 2

2016-04-29 Thread Mich Talebzadeh
Date: Friday, April 29, 2016 at 02:51 > To: user > Subject: Hive configuration parameter hive.enforce.bucketing does not > exist in Hive 2 > > Is the parameter > > --set hive.enforce.bucketing = true; > > depreciated in Hive 2 as it causes hql code not to work? > >

Re: Hive configuration parameter hive.enforce.bucketing does not exist in Hive 2

2016-04-29 Thread Sergey Shelukhin
hive.apache.org>> Date: Friday, April 29, 2016 at 02:51 To: user mailto:user@hive.apache.org>> Subject: Hive configuration parameter hive.enforce.bucketing does not exist in Hive 2 Is the parameter --set hive.enforce.bucketing = true; depreciated in Hive 2 as it causes hql code not to work?

Hive configuration parameter hive.enforce.bucketing does not exist in Hive 2

2016-04-29 Thread Mich Talebzadeh
Is the parameter --set hive.enforce.bucketing = true; depreciated in Hive 2 as it causes hql code not to work? hive> set hive.enforce.bucketing = true; Query returned non-zero code: 1, cause: hive configuration hive.enforce.bucketing does not exists. Dr Mich Talebzadeh LinkedIn * ht

Re: Add multiple users in admin role while running in hive configuration-reg

2016-02-22 Thread mathes waran
HI Thanks for the ideas..I checked out and its very useful link. Thanks, Matheswaran On Mon, Feb 22, 2016 at 11:57 PM, Takahiko Saito wrote: > Hi Matheswaran, > > I believe existing admin can create a new role(admin) for other users via > beeline: > > https://cwiki.apache.org/confluence/displ

Re: Add multiple users in admin role while running in hive configuration-reg

2016-02-22 Thread Takahiko Saito
Hi Matheswaran, I believe existing admin can create a new role(admin) for other users via beeline: https://cwiki.apache.org/confluence/display/Hive/SQL+Standard+Based+Hive+Authorization#SQLStandardBasedHiveAuthorization-RoleManagementCommands On Mon, Feb 22, 2016 at 3:12 AM, mathes waran wrote:

Add multiple users in admin role while running in hive configuration-reg

2016-02-22 Thread mathes waran
Hi, I had set the property of set.users.admin.role as hive.users.in.admin.role user1,user2 Comma separated list of users who are in admin role for bootstrapping. More users can be added in ADMIN role later. in hive-site.xml. If i want to add another users,stop the pro

Re: Hive configuration property

2012-09-26 Thread Abhishek
ail.com] > Sent: 26 September 2012 22:27 > To: user@hive.apache.org > Cc: ; > Subject: Re: Hive configuration property > > Hi Ashok, > > Thanks for the reply, can you please tell me how many reducers should be > considered using for 1 GB of intermediate data. >

RE: Hive configuration property

2012-09-26 Thread ashok.samal
omatically determine number of reducers. Thanks Ashok S. From: Abhishek [mailto:abhishek.dod...@gmail.com] Sent: 26 September 2012 22:27 To: user@hive.apache.org Cc: ; Subject: Re: Hive configuration property Hi Ashok, Thanks for the reply, can you please tell me how many reducers should be consid

Re: Hive configuration property

2012-09-26 Thread Abhishek
epends on ur > data size. > > Regards > Ashok S. > > From: Bejoy KS [mailto:bejoy...@yahoo.com] > Sent: 26 September 2012 21:04 > To: user@hive.apache.org > Subject: Re: Hive configuration property > > Hi Abshiek > > Based on my experience you

RE: Hive configuration property

2012-09-26 Thread ashok.samal
Yes Abshiek, By setting below prop. You ll get better result. The no should depends on ur data size. Regards Ashok S. From: Bejoy KS [mailto:bejoy...@yahoo.com] Sent: 26 September 2012 21:04 To: user@hive.apache.org Subject: Re: Hive configuration property Hi Abshiek Based on my experience

Re: Hive configuration property

2012-09-26 Thread Abhishek
> yield you better performance numbers. > > Regards, > Bejoy KS > > From: Abhishek > To: "user@hive.apache.org" > Cc: "user@hive.apache.org" > Sent: Wednesday, September 26, 2012 7:04 PM > Subject: Re: Hive configuration prop

Re: Hive configuration property

2012-09-26 Thread Bejoy KS
e.org" Cc: "user@hive.apache.org" Sent: Wednesday, September 26, 2012 7:04 PM Subject: Re: Hive configuration property Thanks Bharath, Your points make sense.I'll try thisĀ "hive.exec.reducers.max" property. Regards Abhi Sent from my iPhone On Sep 26, 201

Re: Hive configuration property

2012-09-26 Thread Abhishek
Thanks Bharath, Your points make sense.I'll try this "hive.exec.reducers.max" property. Regards Abhi Sent from my iPhone On Sep 26, 2012, at 9:23 AM, bharath vissapragada wrote: > > I'm no expert in hive, but here are my 2 cents. > > By default hive schedules a reducer per every 1 GB of

Re: Hive configuration property

2012-09-26 Thread bharath vissapragada
I'm no expert in hive, but here are my 2 cents. By default hive schedules a reducer per every 1 GB of data ( change that value by modifying *hive.exec.reducers.bytes.per.reducer ) *. If your input data is huge, there will be large number of reducers, which might be unnecessary.( Sometimes large nu

Hive configuration property

2012-09-26 Thread Abhishek
Hi all, I have doubt regarding below properties, is it a good practice to override below properties in hive. If yes, what is the optimal values for the following properties? set hive.exec.reducers.bytes.per.reducer= In order to limit the maximum number of reducers: set hive.exec.reducers.m

RE: Passing date as hive configuration variable

2012-05-10 Thread Saurabh S
.ge...@memorylane.com > To: user@hive.apache.org > Subject: Re: Passing date as hive configuration variable > Date: Thu, 10 May 2012 18:39:10 + > > Another option is to do it all in the shell: > > #/bin/sh > somedate=$(date -d '2 day ago' +"%Y-%m-%d") > ec

Re: Passing date as hive configuration variable

2012-05-10 Thread Gesli, Nicole
nalyst >Walt Disney Parks and Resorts Online >Ph: 407-566-2545 >Tie: 8-296-2545 > >CONFIDENTIAL > >-Original Message- >From: Saurabh S [mailto:saurab...@live.com] >Sent: Thursday, May 10, 2012 2:06 PM >To: user@hive.apache.org >Subject: Passing date as hive co

RE: Passing date as hive configuration variable

2012-05-10 Thread Tucker, Matt
NFIDENTIAL -Original Message- From: Saurabh S [mailto:saurab...@live.com] Sent: Thursday, May 10, 2012 2:06 PM To: user@hive.apache.org Subject: Passing date as hive configuration variable I'm having a hard time passing a date as a hive environment variable. The setting is t

Re: Passing date as hive configuration variable

2012-05-10 Thread Ashish Thusoo
I think you have to put quotes around the variable to tell give that you are comparing against a string... Ashish On May 10, 2012 2:06 PM, "Saurabh S" wrote: > > I'm having a hard time passing a date as a hive environment variable. > > The setting is this: The table I'm querying is partitioned o

Passing date as hive configuration variable

2012-05-10 Thread Saurabh S
I'm having a hard time passing a date as a hive environment variable. The setting is this: The table I'm querying is partitioned on a date column, say, local_dt. I wish to query on last two days' worth of data. Unfortunately there seems to be no way of getting the current date without either sc

Hive configuration

2011-05-13 Thread Raghunath, Ranjith
Is there any advantage to changing the value of the 'hive.exec.submitviachild' parameter? Thank you, Ranjith