Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 61DB2200C0F for ; Thu, 2 Feb 2017 10:50:25 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id 6068F160B57; Thu, 2 Feb 2017 09:50:25 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id E3556160B54 for ; Thu, 2 Feb 2017 10:50:22 +0100 (CET) Received: (qmail 7476 invoked by uid 500); 2 Feb 2017 09:50:20 -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 7466 invoked by uid 99); 2 Feb 2017 09:50:20 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 02 Feb 2017 09:50:20 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 507E318285E for ; Thu, 2 Feb 2017 09:50:20 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.379 X-Spam-Level: ** X-Spam-Status: No, score=2.379 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, RCVD_IN_SORBS_SPAM=0.5, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id a85F51E4rY8A for ; Thu, 2 Feb 2017 09:50:19 +0000 (UTC) Received: from mail-ot0-f177.google.com (mail-ot0-f177.google.com [74.125.82.177]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id F04435FB76 for ; Thu, 2 Feb 2017 09:50:18 +0000 (UTC) Received: by mail-ot0-f177.google.com with SMTP id 32so7900309oth.3 for ; Thu, 02 Feb 2017 01:50:18 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:in-reply-to:references:from:date:message-id:subject:to; bh=HYfgBhYfKZdP8u8WdhA/rQyW7VeU9WphAFrkhEqhrUk=; b=ZTfreyC5l8SHTwej4UOWtBQuSDxdsKDaOjoWLPTSo2C0D9Oya4YwRiPmBDQOZsa9OX emzIyuD1NEpR76fPcV5q5UuxDQyq+JcDrKrOXMqbYZ/e6pTsErTVpuhTfaolb75XEBKF XZ5h90RFkrGnf2EcfP+2QB2f0yQUEKvTi6wTD8isiTUw2EElxi/iB+w/89KC0f+SCYKo ggghrKb8Z/XwFAvsZD17yDmJbZcuCXDDHWwqDDzEH0xDSYZ3Og5JMNpMKndjE+kwNuOj 4I9ZSxa9XoUIv1P6SLyLhvV0xZGS7bDiHwZeoyIRS1nHK7TnBx8Qk3IY2OSq4jfHC6JU VgyQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to; bh=HYfgBhYfKZdP8u8WdhA/rQyW7VeU9WphAFrkhEqhrUk=; b=S9eR0lBReFzlQxUgDBEN634F+KJev+pBqOPqqyTGASa1fnto1LpGtANlTnF3A7mXA1 sMSR2OF7TiGPKichKdOLd+UWayBLXdFVt2CRjTQ055Wo9HmUpKHzQKDZ5/X4wgYL+Uj5 Vk0T4qGWnTHFl+WHDTCOd0zM4GDKkWBIlekV5M1a+j+ZI4wyN3tLnO8RCjWwE29V+taP aqEY6pUFGBvft6LNlIxEQHwELsTG/hVYwey9PeRxi8rIHPJBiJ2cd3lw7Cejbuj9PhoM 8gu2sxl/c2MXNIjdwlb/GJ9OGf7eiYecHt+ikxT3gWySs6CfNkSztSdo75TH0pLJxwv3 R4rQ== X-Gm-Message-State: AMke39mBK8ixTMAlHsc1V/+wMYn8N3Zc4X/Eci5i69sijKZwPvuMJHzxAVwZI7rNj8MJh8p5gEZGWghEzzLSHQ== X-Received: by 10.157.60.149 with SMTP id z21mr3369921otc.34.1486029014732; Thu, 02 Feb 2017 01:50:14 -0800 (PST) MIME-Version: 1.0 Received: by 10.182.39.39 with HTTP; Thu, 2 Feb 2017 01:50:14 -0800 (PST) In-Reply-To: <0323A879-AF9D-4FC2-B2C4-717A04B204B9@hortonworks.com> References: <0323A879-AF9D-4FC2-B2C4-717A04B204B9@hortonworks.com> From: =?UTF-8?B?0JzQsNC60YHQuNC8INCR0YPQudC70LjQvQ==?= Date: Thu, 2 Feb 2017 12:50:14 +0300 Message-ID: Subject: Re: Compactions doesn't launch on Hive 1.1.0 To: user@hive.apache.org Content-Type: multipart/alternative; boundary=94eb2c19018e8c961305478917e5 archived-at: Thu, 02 Feb 2017 09:50:25 -0000 --94eb2c19018e8c961305478917e5 Content-Type: text/plain; charset=UTF-8 Thanks! In logs i only see messages of DummyTxnManager, nothing about DbTxnManager. When i connected to hive i use "set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;". How else i can configure transaction manager? 2017-02-02 11:12 GMT+03:00 Gopal Vijayaraghavan : > > > > > > I try reduce check interval and launch it manuallty with command "Alter > > table tx_tbl compaction 'major';". Nothing helps. > > You can check the hive metastore log and confirm it also has the > DbTxnManager > set up & that it is triggering the compactions. > > Without a standalone metastore, the hive ACID compactor threads are not > triggered. > > Cheers, > Gopal > > > --94eb2c19018e8c961305478917e5 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Thanks!
In logs i only see messages of DummyTxnMan= ager, nothing about DbTxnManager.

When i connected to hive i = use "set hive.txn.manager=3Dorg.apache.hadoop.hive.ql.lockmgr.DbTxnMan= ager;".
How else i can configure transaction manager?=C2=A0
=

2017-02-02 11:12 = GMT+03:00 Gopal Vijayaraghavan <gopalv@apache.org>:




> I try reduce check interval and launch it manuallty with command "= ;Alter
> table tx_tbl compaction 'major';". Nothing helps.

You can check the hive metastore log and confirm it also has the DbTxnManag= er
set up & that it is triggering the compactions.

Without a standalone metastore, the hive ACID compactor threads are not tri= ggered.

Cheers,
Gopal



--94eb2c19018e8c961305478917e5--