Computation timeout

2015-07-29 Thread Loïc Chanel
ow if Hive provides with the same property someway. Did anyone heard about such a thing ? Thanks in advance for your help, Loïc Loïc CHANEL Engineering student at TELECOM Nancy Trainee at Worldline - Villeurbanne

Re: Computation timeout

2015-07-29 Thread Loïc Chanel
No, because I thought the idea of infinite operation was not very compatible with the "idle" word (as the operation will not stop running), but I'll try :-) Thanks for the idea, Loïc Loïc CHANEL Engineering student at TELECOM Nancy Trainee at Worldline - Villeurbanne 2015-07-29

Re: Computation timeout

2015-07-29 Thread Loïc Chanel
else have another idea ? Thanks, Loïc Loïc CHANEL Engineering student at TELECOM Nancy Trainee at Worldline - Villeurbanne 2015-07-29 15:34 GMT+02:00 Loïc Chanel : > No, because I thought the idea of infinite operation was not very > compatible with the "idle" word (as the opera

Re: Computation timeout

2015-07-29 Thread Loïc Chanel
Yes, I set it to negative 60. It's not a problem if the session is killed. That's actually what I try to do, because I can't allow to a user to try to end an infinite request. Therefore I'll try your solution :) Thanks, Loïc Loïc CHANEL Engineering student at TELE

Re: Computation timeout

2015-07-29 Thread Loïc Chanel
I don't think your solution works, as after more than 4 minutes I could still see logs of my job showing that it was running. Do you have a way to check that even if the job was running, it was not being killed by Hive ? Or another solution ? Thanks for your help, Loïc Loïc CHANEL Engine

Re: Computation timeout

2015-07-30 Thread Loïc Chanel
name of the properties ? I'll try again and keep you informed Loïc CHANEL Engineering student at TELECOM Nancy Trainee at Worldline - Villeurbanne 2015-07-29 20:15 GMT+02:00 Xuefu Zhang : > this works for me: > In hive-site.xml: > 1. hive.server2.session.check.interva=3000; >

Re: Computation timeout

2015-07-30 Thread Loïc Chanel
My bad, I think I just mixed up the properties. At the end of the day, everything seems to work as you described. Thanks a lot ! Loïc Loïc CHANEL Engineering student at TELECOM Nancy Trainee at Worldline - Villeurbanne 2015-07-30 9:31 GMT+02:00 Loïc Chanel : > Rats, I think I just figu

Re: Computation timeout

2015-07-30 Thread Loïc Chanel
Indeed, I was checking this out on the exact same page, but I'm almost convinced that I saw on a documentation that the default value was 3000 for the check.interval. As I can't find it again, let's say I was tired and my eyes betrayed me. Thanks a lot, Loïc Loïc CHANEL Enginee

Re: Getting error in creating a hive table via java

2015-07-31 Thread Loïc Chanel
The type String doesn't exist in SQL. I think you want to use VARCHAR instead ;-) Regards, Loïc Loïc CHANEL Engineering student at TELECOM Nancy Trainee at Worldline - Villeurbanne 2015-07-31 13:56 GMT+02:00 Sateesh Karuturi : > I would like to create a table in hive using Java. U

HiveServer2 & Kerberos

2015-08-19 Thread Loïc Chanel
sport with JDBC Uri: jdbc:hive2:// 192.168.6.210:1: Peer indicated failure: Unsupported mechanism type PLAIN (state=08S01,code=0) Does anyone had the same problem ? Or know how to solve it ? Thanks in advance, Loïc Loïc CHANEL Engineering student at TELECOM Nancy Trainee at Worldline - Villeurbanne

Re: HiveServer2 & Kerberos

2015-08-19 Thread Loïc Chanel
erate Kerberos keytabs, and to ensure that Hive has the path to access to its keytab, but nothing changed. Does anyone has an idea about how to solve this issue ? Thanks in advance for your help :) Loïc Loïc CHANEL Engineering student at TELECOM Nancy Trainee at Worldline - Villeurbanne 2015-08-19

Re: HiveServer2 & Kerberos

2015-08-19 Thread Loïc Chanel
response though. Do you have another idea ? Loïc CHANEL Engineering student at TELECOM Nancy Trainee at Worldline - Villeurbanne 2015-08-19 17:42 GMT+02:00 Jary Du : > "The Beeline client must have a valid Kerberos ticket in the ticket cache > before attempting to connect

Re: HiveServer2 & Kerberos

2015-08-19 Thread Loïc Chanel
All right, but then, what is the password hive asks for ? Hive's one ? How do I know its value ? Loïc CHANEL Engineering student at TELECOM Nancy Trainee at Worldline - Villeurbanne 2015-08-19 17:51 GMT+02:00 Jary Du : > For Beeline connection string, it should be "!connect

Re: HiveServer2 & Kerberos

2015-08-19 Thread Loïc Chanel
By the way, thanks a lot for your help, because your solution works, but I'm still interested in knowing what is the password I did not enter. Thanks again, Loïc Loïc CHANEL Engineering student at TELECOM Nancy Trainee at Worldline - Villeurbanne 2015-08-19 18:07 GMT+02:00 Loïc C

Re: HiveServer2 & Kerberos

2015-08-20 Thread Loïc Chanel
Indeed, I don't need the password, but why is Beeline asking me for one ? To what does it correspond ? Thanks again, Loïc Loïc CHANEL Engineering student at TELECOM Nancy Trainee at Worldline - Villeurbanne 2015-08-19 18:22 GMT+02:00 Jary Du : > Correct me if I am wrong, my understa

Re: HiveServer2 & Kerberos

2015-08-20 Thread Loïc Chanel
=hive/hiveh...@westeros.wl: And if I press enter everything works perfectly, because I am using Kerberos authentication, that's actually why I was asking what is Hive asking for, because in my case, it seems that I shouldn't be asked for a password when connecting. Loïc CHANEL Engineering

Re: HiveServer2 & Kerberos

2015-08-25 Thread Loïc Chanel
It is the case. Would you like me to fill a JIRA about it ? Loïc CHANEL Engineering student at TELECOM Nancy Trainee at Worldline - Villeurbanne 2015-08-24 19:24 GMT+02:00 Sergey Shelukhin : > If that is the case it sounds like a bug… > > From: Jary Du > Reply-To: "use

Re: HiveServer2 & Kerberos

2015-08-26 Thread Loïc Chanel
Here it is : https://issues.apache.org/jira/browse/HIVE-11653 Loïc CHANEL Engineering student at TELECOM Nancy Trainee at Worldline - Villeurbanne 2015-08-25 23:10 GMT+02:00 Sergey Shelukhin : > Sure! > > From: Loïc Chanel > Reply-To: "user@hive.apache.org" > Date: Tu

Re: HiveServer2 & Kerberos

2015-08-26 Thread Loïc Chanel
I understand the behavior, but when Kerberos is enabled, isn't that a bit redundant ? Loïc CHANEL Engineering student at TELECOM Nancy Trainee at Worldline - Villeurbanne 2015-08-26 17:53 GMT+02:00 kulkarni.swar...@gmail.com < kulkarni.swar...@gmail.com>: > > my understand

Re: [ANNOUNCE] New Hive Committer - Lars Francke

2015-09-07 Thread Loïc Chanel
Congrats Lars ! :) Loïc CHANEL Engineering student at TELECOM Nancy Trainee at Worldline - Villeurbanne 2015-09-07 10:54 GMT+02:00 Carl Steinbach : > The Apache Hive PMC has voted to make Lars Francke a committer on the > Apache Hive Project. > > Please join me in congrat

Re: HiveServer2 & Kerberos

2015-09-09 Thread Loïc Chanel
owed to impersonate testUser Do any of you have an idea about where this could come from ? Loïc CHANEL Engineering student at TELECOM Nancy Trainee at Worldline - Villeurbanne 2015-08-31 13:51 GMT+02:00 Lars Francke : > That said, +1 to adding a check that we are using kerberos and skipping >

Re: HiveServer2 & Kerberos

2015-09-10 Thread Loïc Chanel
You were right ! Thanks a lot, I didn't checked this property as I thought Ambari set it to true when enabling Kerberos. Thanks again, Loïc Loïc CHANEL Engineering student at TELECOM Nancy Trainee at Worldline - Villeurbanne 2015-09-09 19:53 GMT+02:00 Takahiko Saito : > Hi Loic,

HiveServer with LDAP

2015-09-18 Thread Loïc Chanel
s for that function ? Thanks in advance for your help, Loïc Loïc CHANEL Engineering student at TELECOM Nancy Trainee at Worldline - Villeurbanne

Re: HiveServer with LDAP

2015-09-21 Thread Loïc Chanel
s not the case), I should not be able to connect to Hive, but I am. Do you see what I mean ? Maybe I'm not very clear. Regards, Loïc Loïc CHANEL Engineering student at TELECOM Nancy Trainee at Worldline - Villeurbanne 2015-09-19 11:12 GMT+02:00 Jörn Franke : > What do you mean by it i

Re: beeline and kerberos

2016-01-11 Thread Loïc Chanel
As I had the same problem a few months ago, I think your solution is in this thread : http://mail-archives.apache.org/mod_mbox/hive-user/201509.mbox/%3CCAPsi++Zsgvro4JTJPRXNyjzCTtSv7=4zjsipml51kvbforo...@mail.gmail.com%3E Regards, Loïc Loïc CHANEL System & virtualization engineer TO - XaaS

Re: Hive Query Timeout in hive-jdbc

2016-02-02 Thread Loïc Chanel
Actually, Hive doesn't support timeout, but Tez and MapReduce does. Therefore, you can set a timeout on these tools to kill failed queries. Hope this helps, Loïc Loïc CHANEL System & virtualization engineer TO - XaaS Ind - Worldline (Villeurbanne, France) 2016-02-02 11:10 GMT+

Re: Hive Query Timeout in hive-jdbc

2016-02-02 Thread Loïc Chanel
Then indeed Tez and MR timeout won't be any help, sorry. I would be very interested in your solution though. Regards, Loïc Loïc CHANEL System & virtualization engineer TO - XaaS Ind - Worldline (Villeurbanne, France) 2016-02-02 11:27 GMT+01:00 Satya Harish Appana : > Queries I am

Re: [ANNOUNCE] New Hive Committer - Wei Zheng

2016-03-10 Thread Loïc Chanel
Congratulations ! Loïc CHANEL System & virtualization engineer TO - XaaS Ind - Worldline (Villeurbanne, France) 2016-03-10 11:44 GMT+01:00 Jeff Zhang : > Congratulations, Wei ! > > On Thu, Mar 10, 2016 at 3:27 PM, Lefty Leverenz > wrote: > >> Congratulations! >>

Re: Quota for rogue ad-hoc queries

2016-09-01 Thread Loïc Chanel
MapReduce ...) parameters, but not directly into YARN. At least it was the case when I tried this (one year ago). Regards, Loïc CHANEL System & virtualization engineer TO - XaaS Ind - Worldline (Villeurbanne, France) 2016-09-01 16:52 GMT+02:00 Stephen Sprague : > > rogue queries >

Re: Permission denied: user=root, access=WRITE, inode="/user/root":hdfs:hdfs:drwxr-xr-x

2016-10-05 Thread Loïc Chanel
What are you trying to do when you get that trace ? The problem seems to be that you're trying to read from directory /user/root owned by hdfs with user root, that has no right to do so. Regards, Loïc Loïc CHANEL System Big Data engineer MS&T - WASABI - Worldline (Villeurbanne, Fran

Re: Start HiveServer2 with Kerberos meet FATAL error

2016-10-18 Thread Loïc Chanel
Hi, What is it you're executing when you get that error ? It seems you're trying to log into HiveServer with unix username instead of your Kerberos keytab. Regards, Loïc Loïc CHANEL System Big Data engineer MS&T - WASABI - Worldline (Villeurbanne, France) 2016-10-18 4:40 GMT+02

Re: User is not allowed to impersonate

2017-05-09 Thread Loïc Chanel
Hello Andrey, Can you check the keytabs are properly generated and handled on Hive host ? Using maybe klist with -t option. Regards, Loïc Loïc CHANEL System Big Data engineer MS&T - WASABI - Worldline (Villeurbanne, France) 2017-05-04 15:42 GMT+02:00 Markovich : > i'm sti

Fail to load table via Tez

2017-07-07 Thread Loïc Chanel
size is set to 2560 MB and tez.grouping.max-size is set to 1073741824. If you need more information feel free to ask. I am currently running out of ideas on how to debug this as I have a limited access to Tez container logs, so any inputs will be highly appreciated. Thanks ! Loïc Loïc CHANEL

Re: Fail to load table via Tez

2017-07-07 Thread Loïc Chanel
physical memory limits. Current usage: 2.5 GB of 2.5 GB physical memory used; 4.4 GB of 5.3 GB virtual memory used. Killing container. Do you have another idea ? Regards, Loïc Loïc CHANEL System Big Data engineer MS&T - Worldline Analytics Platform - Worldline (Villeurbanne, France) 2017-07-0

Cannot validate serde: org.apache.hive.hcatalog.data.JsonSerDe

2017-08-07 Thread Loïc Chanel
roblem ? Any inputs about where it could come from ? Thanks in advance for your help ! Regards, Loïc Loïc CHANEL System Big Data engineer MS&T - Worldline Analytics Platform - Worldline (Villeurbanne, France)

Re: Cannot validate serde: org.apache.hive.hcatalog.data.JsonSerDe

2017-08-09 Thread Loïc Chanel
Still any inputs on that one ? Nobody met it ? Regards, Loïc Loïc CHANEL System Big Data engineer MS&T - Worldline Analytics Platform - Worldline (Villeurbanne, France) 2017-08-07 18:26 GMT+02:00 Loïc Chanel : > Hi, > > As I tried to run some queries with JSON SerDe from Spark