Re: Maximum number of concurrent hive connections

2016-01-11 Thread Kashif Hussain
ot be understood as given or endorsed by Peridale Technology > Ltd, its subsidiaries or their employees, unless expressly so stated. It is > the responsibility of the recipient to ensure that this email is virus > free, therefore neither Peridale Ltd, its subsidiaries nor their employees >

Maximum number of concurrent hive connections

2016-01-11 Thread Kashif Hussain
Hi, I need 3000-4000 concurrent connections to hive.The hive metastore is running on a 256 GB Ram machine. Can anyone tell me what's the maximum number of connections a hive metstaore can support ? Regards, Kashif

Re: Hive Insert taking a lot of time

2015-11-02 Thread Kashif Hussain
ly the where statement in > your queries on the orc table. > > > On 02 Nov 2015, at 13:36, Kashif Hussain wrote: > > > > Hi, > > I am trying to insert data into orc table from a text table.The query is > as follows : > > > > insert into table test_orc(x,y)

Hive Insert taking a lot of time

2015-11-02 Thread Kashif Hussain
Hi, I am trying to insert data into orc table from a text table.The query is as follows : insert into table test_orc(x,y) select * from test where x=4 and y=5 ; The MR is taking a lot of time and all but one reducer got completed quickly.But the last reducer is taking a lot of time. The total dat

Maximum Size of String data type in hive

2015-10-27 Thread Kashif Hussain
Hi, Is there any limit on the size of value in a column of string data type ? Also, is there any performance impact of large values in string columns while querying ? Regards, Kashif