Re: hive concurrency not working

2016-08-03 Thread Divakar Reddy
Reg " hive concurrency not working" in HDP. yes, it's known issue in HDP and with Hue 2.6 I have below information on this issue and hope it will help you. When you are running Hive queries through Hue (Beeswax), users are unable to run multiple queries concurrent

Re: hive concurrency not working

2016-08-03 Thread Jörn Franke
You need to configure the yarn scheduler (fair or capacity depending on your needs) > On 03 Aug 2016, at 15:14, Raj hadoop wrote: > > Dear All, > > In need or your help, > > we have horton works 4 node cluster,and the problem is hive is allowing only > one user at a time, > > if any second

RE: hive concurrency not working

2016-08-03 Thread Amit Bajpai
You need to increase the value for the below hive property value in Ambari hive.server2.tez.sessions.per.default.queue If this does not fix the issue then you need to update the capacity scheduler property values. From: Raj hadoop [mailto:raj.had...@gmail.com] Sent: Wednesday, August 03, 2016 8

Re: hive concurrency not working

2016-08-03 Thread Sergey Shelukhin
Can you elaborate on not working? Is it giving an error, or hanging (and if so, does it queue and eventually execute); are you using HS2; what commands/actions do the users perform? Also, what version of Hive is this? From: Raj hadoop mailto:raj.had...@gmail.com>> Reply-To: "user@hive.apache.org

Re: Create table from orc file

2016-08-03 Thread Marcin Tustin
Correct you need to specify the columns. If you created the file I assume you have a record of them. Someone more familiar with the hive code will have to comment on the exceptions. On Wednesday, August 3, 2016, Johannes Stamminger < johannes.stammin...@airbus.com> wrote: > But doing so I assume

Re: Create table from orc file

2016-08-03 Thread Johannes Stamminger
But doing so I assume it does not detect the columns on it's own, I have to specify such manually - or am I wrong? The orc file I finally want to work with contains ~28000 columns (513MB size, ~50 rows, 3 structs with 2 of them containing ~14000 fields each) ... The hive documentation for the

hive concurrency not working

2016-08-03 Thread Raj hadoop
Dear All, In need or your help, we have horton works 4 node cluster,and the problem is hive is allowing only one user at a time, if any second resource need to login hive is not working, could someone please help me in this Thanks, Rajesh

Malformed orc file

2016-08-03 Thread Igor Kuzmenko
Hello, I've got a malformed ORC file in my Hive table. File was created by Hive Streaming API and I have no idea under what circumstances it became corrupted. File on google drive: link Exception message when trying t

Re: Create table from orc file

2016-08-03 Thread Marcin Tustin
Yes. Create an external table whose location contains only the orc file(s) you want to include in the table. On Wed, Aug 3, 2016 at 7:53 AM, Johannes Stamminger < johannes.stammin...@airbus.com> wrote: > Hi, > > > is it possible to write data to an orc file(s) using the hive-orc api and > to > us

Create table from orc file

2016-08-03 Thread Johannes Stamminger
Hi, is it possible to write data to an orc file(s) using the hive-orc api and to use such by hive (create a table from it)? Regards This email (including any attachments) may contain confidential and/or privileged information or information otherwise protected from disclosure. If you are not

Re: unsubscribe

2016-08-03 Thread Lefty Leverenz
To unsubscribe please send a message to user-unsubscr...@hive.apache.org as described here: Mailing Lists . Thanks. -- Lefty On Mon, Aug 1, 2016 at 11:13 PM, zhang jp wrote: > unsubscribe >