From user-return-26063-archive-asf-public=cust-asf.ponee.io@hive.apache.org Wed May 16 15:59:59 2018 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id A3940180669 for ; Wed, 16 May 2018 15:59:58 +0200 (CEST) Received: (qmail 58052 invoked by uid 500); 16 May 2018 13:59:57 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 58042 invoked by uid 99); 16 May 2018 13:59:57 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 16 May 2018 13:59:57 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id A7AE8C00D7 for ; Wed, 16 May 2018 13:59:56 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.879 X-Spam-Level: * X-Spam-Status: No, score=1.879 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd4-us-west.apache.org (amavisd-new); dkim=pass (1024-bit key) header.d=agrible.com Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id JWy8o2Kzm8Cc for ; Wed, 16 May 2018 13:59:54 +0000 (UTC) Received: from mail-wm0-f67.google.com (mail-wm0-f67.google.com [74.125.82.67]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id C7AAA5F503 for ; Wed, 16 May 2018 13:59:53 +0000 (UTC) Received: by mail-wm0-f67.google.com with SMTP id j5-v6so1968112wme.5 for ; Wed, 16 May 2018 06:59:53 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=agrible.com; s=google; h=mime-version:from:date:message-id:subject:to; bh=21L6l/u7RWJJ0oJD/TbI8+CGY39nJdVgI0R9AiuIx4M=; b=NU3lluP09MlwXw/J7WABHuZaogs+0t7xebnYvITreZ02C10ocGE7uxIgu6jcm3GWTN +yfC7PwbygZn+Eo05ApXZcVzaTi6ISlVvikNDH7T/qDsC0mIar3oieQd/vNoUa4NTH4v pHYOo+VU22vZr905rRQ8Fs9ZctG27jE2lbLRY= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=21L6l/u7RWJJ0oJD/TbI8+CGY39nJdVgI0R9AiuIx4M=; b=HRv9e2PrjKyVYEpcpBWH6EQb+ZoiiLP4yLm/vSC1rqAKZinNOfwsmr92N3yX6cmsxf WtJBPF35ZyvH75AyusvBxyCaj5VkMRUC9r+TSc5lUl0ZQec76JNOeX+rtsAqx0EsxSqv YsJQVgbZwg+m6fB8jVgFGYpxa7RbRDB6vtOVDI5j4F5MRffERNZw09xHOw6PLQ2R9iF5 pi51wGKY+5xIVh3e0E4QsLjkCIsQDFKUSOzjpcXN7TDzSsoRQ9UwB1lPuGXpdpv3HhW/ Iz33dLzG6DXPpGsJBIqjpzAUu1agiYJE69rnXEg75VfKwudOgUGXFdKHn8sy+HWKLDfW 8YzA== X-Gm-Message-State: ALKqPwdPOEESNDWqV5HRb1rU3DnBO719LbsPtmOg4JGlVZfg6H8sIy41 rpMsObHf0s9J/WAbch3A4JRxdmFYIsHIJk634LIzY0dS X-Google-Smtp-Source: AB8JxZotnkmemmXLY6UO13/PKh5YYEuQcyJcm+68rIhei9+gCPzNmTKlvcyULwHfDkEf5OYtvsLzitTq2rYpzfmYwRg= X-Received: by 2002:a1c:8045:: with SMTP id b66-v6mr694039wmd.108.1526479193209; Wed, 16 May 2018 06:59:53 -0700 (PDT) MIME-Version: 1.0 Received: by 10.28.67.131 with HTTP; Wed, 16 May 2018 06:59:52 -0700 (PDT) From: Sowjanya Kakarala Date: Wed, 16 May 2018 08:59:52 -0500 Message-ID: Subject: passing configuration through connection string To: user@hive.apache.org Content-Type: multipart/alternative; boundary="000000000000119372056c532235" --000000000000119372056c532235 Content-Type: text/plain; charset="UTF-8" Hi all, I am trying to fetch the data from hive using python code, which works for normal tables. But, for bucketed tables with transactions set true, it is throwing error ` This command is not allowed on an ACID table dbname.tblname with a non-ACID transaction manager. ` I have set the folowing properties in the hive-site.xml, but still I see the same error. hive.txn.manager org.apache.hadoop.hive.ql.lockmgr.DbTxnManager set for error: not allowed on an ACID table with a non-ACID transaction manager hive.support.concurrency true set for error:FAILED: RuntimeException [Error 10264]: To use DbTxnManager Is there any way that I could pass this configuration from connection string? something like: conn = hive.Connection(host=HOST_NAME, port=PORT_NUMBER, username=HIVE_USERNAME,configuration=so and so) or is there any other way to send these configs? Thanks for any help. Thanks Sowjanya --000000000000119372056c532235 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi all,

I am trying to fetch the data f= rom hive using python code, which works for normal tables. But, for buckete= d tables with transactions set true, it is throwing error=C2=A0
`

This command is not allowed on an ACID table dbname.tblname with a non-ACI= D transaction manager.

`
I have set the folowing properties in the hive-site.xml, but st= ill I see the same error.=C2=A0

<property>

=C2=A0 <name>hive.txn.manager</name>

=C2=A0 <value>org.apache.hadoop.hive.ql.lockmgr.Db= TxnManager</value>

=C2=A0 <description>set for error: not allowed on = an ACID table with a non-ACID transaction manager</description>

</property>


<property>

=C2=A0 <name>hive.support.concurrency</name>

=C2=A0 <= /span><value>true</= value>

=C2=A0 <description>set for error:FAILED: RuntimeE= xception [Error 10264]: To use DbTxnManager= </description>

</property>


Is there any way that I could pass this configuration from c= onnection string?
something like:
conn =3D hive.Co= nnection(host=3DHOST_NAME, port=3DPORT_NUMBER, username=3DHIVE_USERNAME,configuration=3Dso and so)

or is there any other way to send these = configs?

Thanks for any help.

=
Thanks
Sowjanya
--000000000000119372056c532235--