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: locks are held on tables even when no job running

2015-10-23 Thread Divakar Reddy
might be your issue related to https://issues.apache.org/jira/browse/HIVE-10500 Can you please add this in the custom hive-site.xml and try? Name: datanucleus.connectionPoolingType Value: dbcp On Fri, Oct 23, 2015 at 2:37 PM, Mich Talebzadeh wrote: > Hi Eugene, > > > > The code drops the table

Re: downloading RDBMS table data to Hive with Sqoop import

2015-05-05 Thread Divakar Reddy
As per my knowledge Sqoop doesn't support updates and deletes. We are handling like: 1) drop particular data from *partitioned* (form partitioned Column) table and load it again with conditions in sqoop like --query "select * form xyz where date = '2015-04-02' Thanks, Divakar On Tue, May 5, 201

Re: Row exception in Hive while using join

2015-03-05 Thread Divakar Reddy
Can you try this script? create table table_llv_N_C as select a.chromosome_number, a.position, b.id from (select * from table_line_n_passed where chromosome_number is not null) a join table_line_c_passed b on a.chromosome_number=b.chromosome_number; On Thu, Mar 5, 2015 at 1:41 PM, Vikram Dixit

Re: error on show databases

2014-08-06 Thread Divakar Reddy
It seems your hive metastore is down. restart it and try again. Thanks, Divakar On Wed, Aug 6, 2014 at 9:13 PM, Rahul Channe wrote: > Hi All, > > I am getting following error > > hive> show databases; > FAILED: Execution Error, return code 1 from > org.apache.hadoop.hive.ql.exec.DDLTask. java.

Re: Joins Failing

2014-03-24 Thread Divakar Reddy
I hope, this property will fix your issue. set mapred.reduce.child.java.opts=-Xmx4096m; On Mon, Mar 24, 2014 at 3:59 PM, Clay McDonald < stuart.mcdon...@bateswhite.com> wrote: > I believe I found my issue. > > 2014-03-24 15:49:38,775 FATAL [main] org.apache.hadoop.mapred.YarnChild: > Error r