Return-Path: 
 <user-return-19286-apmail-hive-user-archive=hive.apache.org@hive.apache.org>
X-Original-To: apmail-hive-user-archive@www.apache.org
Delivered-To: apmail-hive-user-archive@www.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id 7A7DF17D0B
	for <apmail-hive-user-archive@www.apache.org>;
 Mon,  6 Apr 2015 14:21:27 +0000 (UTC)
Received: (qmail 34953 invoked by uid 500); 6 Apr 2015 14:21:25 -0000
Delivered-To: apmail-hive-user-archive@hive.apache.org
Received: (qmail 34887 invoked by uid 500); 6 Apr 2015 14:21:25 -0000
Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-help@hive.apache.org>
List-Unsubscribe: <mailto:user-unsubscribe@hive.apache.org>
List-Post: <mailto:user@hive.apache.org>
List-Id: <user.hive.apache.org>
Reply-To: user@hive.apache.org
Delivered-To: mailing list user@hive.apache.org
Received: (qmail 34875 invoked by uid 99); 6 Apr 2015 14:21:25 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 06 Apr 2015 14:21:25 +0000
X-ASF-Spam-Status: No, hits=1.5 required=5.0
	tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: domain of sanjiv.is.on@gmail.com
 designates 209.85.212.175 as permitted sender)
Received: from [209.85.212.175] (HELO mail-wi0-f175.google.com)
 (209.85.212.175)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 06 Apr 2015 14:21:00 +0000
Received: by widdi4 with SMTP id di4so32157947wid.0
        for <user@hive.apache.org>; Mon, 06 Apr 2015 07:20:59 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20120113;
        h=mime-version:reply-to:in-reply-to:references:from:date:message-id
         :subject:to:content-type;
        bh=DkhzyqKVb/VmmW80sHWaZ8/n8rjGJIUJupdtH1cgKkc=;
        b=wCrlNzqO9bopePJo24K2Asyj8uww+NzzP/76I7Z8AoIQggMVDGcSqeCMja9l1P2nTP
         2zd6RZWsJwcQ3Zo+1XsoA9OcUbr4i8ZLKt4BpsAHvIfsrbdJ6zbbYDXhrrruYjrSsovL
         L/Sup2ZctCJNER1r7WOx+agYVPt4bWK0AGQTt0S36Mxo8/YpOp74mAUNFwZmE9ParoBx
         /r6p4ZYek30STrnMxrAu3NXisrLTgLXoHJVe6SZ8ocHmu5tYeh56HGweZNCvhF92qqGx
         XZ1gdPR5i+aBPSERNtdgsba/Eqj9RXW1Y2+/KRwnhDqwxxJhOKO+EZEyRh0ITgyI7uTT
         Gfng==
X-Received: by 10.195.12.97 with SMTP id ep1mr31676409wjd.134.1428330059401;
 Mon, 06 Apr 2015 07:20:59 -0700 (PDT)
MIME-Version: 1.0
Received: by 10.194.66.105 with HTTP; Mon, 6 Apr 2015 07:20:38 -0700 (PDT)
Reply-To: sanjiv.is.on@gmail.com
In-Reply-To: <004001d07070$cd2b7610$67826230$@co.uk>
References: <004001d07070$cd2b7610$67826230$@co.uk>
From: "@Sanjiv Singh" <sanjiv.is.on@gmail.com>
Date: Mon, 6 Apr 2015 19:50:38 +0530
Message-ID: 
 <CAAef+M6f0t38brpF1AfsbtXc8+BD3R=qXgscRSFMbenhAXY=dQ@mail.gmail.com>
Subject: Re: Concurrency issue,
 Setting hive.txn.manager to "org.apache.hadoop.hive.ql.lockmgr.DbTxnManager"
To: "user@hive.apache.org" <user@hive.apache.org>
Content-Type: multipart/alternative; boundary=047d7bfceb40d0103605130f01ac
X-Virus-Checked: Checked by ClamAV on apache.org

--047d7bfceb40d0103605130f01ac
Content-Type: text/plain; charset=UTF-8

Not sure ..It should work

Try adding below configuration and then check..

 <property>
  <name>hive.in.test</name>
  <value>true</value>
 </property>



Regards
Sanjiv Singh
Mob :  +091 9990-447-339

On Mon, Apr 6, 2015 at 7:21 PM, Mich Talebzadeh <mich@peridale.co.uk> wrote:

> Hi,
>
>
>
> I turned on concurrency for hive for DML with settings in hive-site.xml as
> follows:
>
>
>
> hive.support.concurrency=true
>
> hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager
>
> hive.compactor.initiator.on=true
>
> hive.compactor.worker.threads=2
>
> hive.support.concurrency=true
>
> hive.enforce.bucketing=true
>
> hive.exec.dynamic.partition.mode=nonstrict
>
>
>
> Recycled connection to metastore and started hive server. Tried to query
> hive as follows:
>
>
>
> hive> use asehadoop;
>
> FAILED: LockException [Error 10280]: Error communicating with the metastore
>
>
>
> Went back and set hive.txn.manager to default
>
> hive.txn.manager= org.apache.hadoop.hive.ql.lockmgr.DummyTxnManager
>
>
>
> and recycled again and all worked!
>
>
>
> Sounds like concurrency does not work or something extra I need to do?
>
>
>
> Thanks
>
>
>
> Mich Talebzadeh
>
>
>
> http://talebzadehmich.wordpress.com
>
>
>
> Publications due shortly:
>
> Creating in-memory Data Grid for Trading Systems with Oracle TimesTen and
> Coherence Cache
>
>
>
> NOTE: The information in this email is proprietary and confidential. This
> message is for the designated recipient only, if you are not the intended
> recipient, you should destroy it immediately. Any information in this
> message shall not be understood as given or endorsed by Peridale 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 accept
> any responsibility.
>
>
>
>
>

--047d7bfceb40d0103605130f01ac
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Not sure ..It should work=C2=A0 <br><br></div>Try add=
ing below configuration and then check..<br><div><pre><span style=3D"line-h=
eight:16.25px"><pre style=3D"line-height:125%;margin:0px"> <span style=3D"c=
olor:rgb(0,119,0)">&lt;property&gt;</span>
  <span style=3D"color:rgb(0,119,0)">&lt;name&gt;</span>hive.in.test<span s=
tyle=3D"color:rgb(0,119,0)">&lt;/name&gt;</span>
  <span style=3D"color:rgb(0,119,0)">&lt;value&gt;</span>true<span style=3D=
"color:rgb(0,119,0)">&lt;/value&gt;</span>
 <span style=3D"color:rgb(0,119,0)">&lt;/property&gt;</span></pre></span></=
pre><br></div></div><div class=3D"gmail_extra"><br clear=3D"all"><div><div =
class=3D"gmail_signature"><div dir=3D"ltr">Regards<br>Sanjiv Singh<br>Mob :=
=C2=A0 +091 9990-447-339<br></div></div></div>
<br><div class=3D"gmail_quote">On Mon, Apr 6, 2015 at 7:21 PM, Mich Talebza=
deh <span dir=3D"ltr">&lt;<a href=3D"mailto:mich@peridale.co.uk" target=3D"=
_blank">mich@peridale.co.uk</a>&gt;</span> wrote:<br><blockquote class=3D"g=
mail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-l=
eft:1ex"><div link=3D"blue" vlink=3D"purple" lang=3D"EN-GB"><div><p>Hi,<u><=
/u><u></u></p><p><u></u>=C2=A0<u></u></p><p>I turned on concurrency for hiv=
e for DML with settings in hive-site.xml as follows:<u></u><u></u></p><p><u=
></u>=C2=A0<u></u></p><p><span style=3D"font-family:&quot;Courier New&quot;=
;color:blue">hive.support.concurrency=3Dtrue<u></u><u></u></span></p><p><sp=
an style=3D"font-family:&quot;Courier New&quot;;color:red">hive.txn.manager=
=3Dorg.apache.hadoop.hive.ql.lockmgr.DbTxnManager<u></u><u></u></span></p><=
p><span style=3D"font-family:&quot;Courier New&quot;;color:blue">hive.compa=
ctor.initiator.on=3Dtrue<u></u><u></u></span></p><p><span style=3D"font-fam=
ily:&quot;Courier New&quot;;color:blue">hive.compactor.worker.threads=3D2<u=
></u><u></u></span></p><p><span style=3D"font-family:&quot;Courier New&quot=
;;color:blue">hive.support.concurrency=3Dtrue<u></u><u></u></span></p><p><s=
pan style=3D"font-family:&quot;Courier New&quot;;color:blue">hive.enforce.b=
ucketing=3Dtrue<u></u><u></u></span></p><p><span style=3D"font-family:&quot=
;Courier New&quot;;color:blue">hive.exec.dynamic.partition.mode=3Dnonstrict=
<u></u><u></u></span></p><p><u></u>=C2=A0<u></u></p><p>Recycled connection =
to metastore and started hive server. Tried to query hive as follows:<u></u=
><u></u></p><p><u></u>=C2=A0<u></u></p><p><span style=3D"font-family:&quot;=
Courier New&quot;;color:red">hive&gt; use asehadoop;<u></u><u></u></span></=
p><p><span style=3D"font-family:&quot;Courier New&quot;;color:red">FAILED: =
LockException [Error 10280]: Error communicating with the metastore<u></u><=
u></u></span></p><p><u></u>=C2=A0<u></u></p><p>Went back and set <span styl=
e=3D"color:black">hive.txn.manager</span><span style=3D"font-family:&quot;C=
ourier New&quot;;color:blue"> </span><span style=3D"color:black">to default=
<u></u><u></u></span></p><p><span style=3D"font-family:&quot;Courier New&qu=
ot;;color:red">hive.txn.manager=3D </span><code><span style=3D"color:red">o=
rg.apache.hadoop.hive.ql.lockmgr.DummyTxnManager <u></u><u></u></span></cod=
e></p><p><code><span style=3D"color:red"><u></u>=C2=A0<u></u></span></code>=
</p><p><code><span style=3D"font-family:&quot;Arial&quot;,&quot;sans-serif&=
quot;;color:#333333">and recycled again and all worked!<u></u><u></u></span=
></code></p><p><code><span style=3D"font-family:&quot;Arial&quot;,&quot;san=
s-serif&quot;;color:#333333"><u></u>=C2=A0<u></u></span></code></p><p><code=
><span style=3D"font-family:&quot;Arial&quot;,&quot;sans-serif&quot;;color:=
#333333">Sounds like concurrency does not work or something extra I need to=
 do?<u></u><u></u></span></code></p><p><code><span style=3D"font-family:&qu=
ot;Arial&quot;,&quot;sans-serif&quot;;color:#333333"><u></u>=C2=A0<u></u></=
span></code></p><p><code><span style=3D"font-family:&quot;Arial&quot;,&quot=
;sans-serif&quot;;color:#333333">Thanks</span></code><u></u><u></u></p><p><=
u></u>=C2=A0<u></u></p><p>Mich Talebzadeh<u></u><u></u></p><p><u></u>=C2=A0=
<u></u></p><p><a href=3D"http://talebzadehmich.wordpress.com" target=3D"_bl=
ank">http://talebzadehmich.wordpress.com</a><u></u><u></u></p><p><u></u>=C2=
=A0<u></u></p><p>Publications due shortly:<u></u><u></u></p><p>Creating in-=
memory Data Grid for Trading Systems with Oracle TimesTen and Coherence Cac=
he<u></u><u></u></p><p><u></u>=C2=A0<u></u></p><p>NOTE: The information in =
this email is proprietary and confidential. This message is for the designa=
ted recipient only, if you are not the intended recipient, you should destr=
oy it immediately. Any information in this message shall not be understood =
as given or endorsed by Peridale Ltd, its subsidiaries or their employees, =
unless expressly so stated. It is the responsibility of the recipient to en=
sure that this email is virus free, therefore neither Peridale Ltd, its sub=
sidiaries nor their employees accept any responsibility.<u></u><u></u></p><=
p><u></u>=C2=A0<u></u></p><p><u></u>=C2=A0<u></u></p></div></div></blockquo=
te></div><br></div>

--047d7bfceb40d0103605130f01ac--