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 - Worldline Analytics Platform - Worldline (Villeurbanne, France) 2017-08-07 18:26 GMT+02:00 Loïc Chanel <loic.cha...@telecomnancy.net>: > Hi, > > As I tried to run some qu

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

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

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 - Worldline Analytics Platform - Worldline (Villeurbanne, France) 2017-07-07 16:51

Fail to load table via Tez

2017-07-07 Thread Loïc Chanel
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 System Big Data

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 - WASABI - Worldline (Villeurbanne, France) 2017-05-04 15:42 GMT+02:00 Markovich <amriv...@gmail.com>:

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 - WASABI - Worldline (Villeurbanne, France) 2016-10-18 4:40 GMT+02:00 Micro dong

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 - WASABI - Worldline (Villeurbanne, France) 2016-10

Re: Quota for rogue ad-hoc queries

2016-09-01 Thread Loïc Chanel
duce ...) 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 <sprag...@gmail.com>: > &

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 <zjf...@gmail.com>: > Congratulations, Wei ! > > On Thu, Mar 10, 2016 at 3:27 PM, Lefty Leverenz <leftylever

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+01:00 董亚军 &l

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 <satyaharish.app...@gm

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: HiveServer with LDAP

2015-09-21 Thread Loïc Chanel
is 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 <jornfra...@gmail.com>: > What do

HiveServer with LDAP

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

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 <tysa...@gmail.com>:

Re: HiveServer2 & Kerberos

2015-09-09 Thread Loïc Chanel
nate 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 <lars.fran...@gmail.com>: > That said, +1 to adding a check that we are using kerberos

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 <c...@apache.org>: > The Apache Hive PMC has voted to make Lars Francke a committer on the > Apache Hive Project. > &

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 understanding is that after using

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 ser...@hortonworks.com: Sure! From: Loïc Chanel loic.cha...@telecomnancy.net Reply-To: user

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 ser...@hortonworks.com: If that is the case it sounds like a bug… From: Jary Du jary...@gmail.com

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 jary...@gmail.com: Correct me if I am wrong, my

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 student

Re: HiveServer2 Kerberos

2015-08-19 Thread Loïc Chanel
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 12:01

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 Chanel

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 jary...@gmail.com: The Beeline client must have a valid Kerberos ticket in the ticket cache before attempting to connect. ( http

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 jary...@gmail.com: For Beeline connection string, it should be !connect

HiveServer2 Kerberos

2015-08-19 Thread Loïc Chanel
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: 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 sateesh.karutu...@gmail.com: I would like to create a table in hive

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 Engineering student

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 loic.cha...@telecomnancy.net

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 xzh...@cloudera.com: this works for me: In hive-site.xml: 1. hive.server2.session.check.interva=3000; 2

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 Engineering

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 15:27 GMT+02:00

Computation timeout

2015-07-29 Thread Loïc Chanel
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
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 TELECOM Nancy Trainee

Re: Computation timeout

2015-07-29 Thread Loïc Chanel
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 loic.cha...@telecomnancy.net: No, because I thought the idea of infinite operation was not very compatible with the idle word (as the operation