Return-Path: 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 8115D45A0 for ; Mon, 23 May 2011 21:46:15 +0000 (UTC) Received: (qmail 28666 invoked by uid 500); 23 May 2011 21:46:14 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 28632 invoked by uid 500); 23 May 2011 21:46:14 -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 28623 invoked by uid 99); 23 May 2011 21:46:14 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 23 May 2011 21:46:14 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of swong@netflix.com designates 208.75.77.162 as permitted sender) Received: from [208.75.77.162] (HELO exout101.netflix.com) (208.75.77.162) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 23 May 2011 21:46:07 +0000 DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; s=s1024;d=netflix.com; h=from:to:date:subject:message-id:content-type:mime-version; bh=wu/pRFo9rdH2IUoI/gQqYdZtdbQ=; b=TCysh3pHLPIFQwhyKBCKu8Ey2kb+DOUzGOqcJtHdtcvrHhTX/eQ5qd8AEz3LlX3+WZbc+h5D zyvVD/uKnSe/eVJtD+BnyiUMqozp+ixRUwFrgk3b8YVnxfUmKAcSPOhH0XdUgb0Qwe3wR/L4 GLb2Ildi+pYTDDJ8MiQvsdyrqeA= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024;d=netflix.com; h=from:to:date:subject:message-id:content-type:mime-version; b=Z8n2mAVg6jETyN0W4FRFJH4bQEHQV42zg4iz3FOcb9ln74sL/UZRZRtl2Awf1GwymtPYf/Dl CHM64tO/QGeKO85sCYmXzxnG6X0tV3nCb+h5PLjg1nHFGghdh8HNpu4pK4a1B9aiuM4jSVs+ URq6DYt4O/UGhxY/pi7oTgy6Zoo= Received: from exchnmc101.netflix.com (10.64.32.131) by exout101.netflix.com (10.64.240.73) with Microsoft SMTP Server (TLS) id 8.3.137.0; Mon, 23 May 2011 14:46:08 -0700 Received: from ExchMBX104.netflix.com ([fe80::409a:eb58:3def:adb6]) by exchnmc101.netflix.com ([fe80::4894:38ba:ac0c:e4bc%13]) with mapi; Mon, 23 May 2011 14:45:45 -0700 From: Steven Wong To: "user@hive.apache.org" Date: Mon, 23 May 2011 14:45:44 -0700 Subject: Logging MySQL queries Thread-Topic: Logging MySQL queries Thread-Index: AcwZkn2/9ARah/l5QQ+HQobTMY9Cuw== Message-ID: <4F6B25AFFFCAFE44B6259A412D5F9B1032B8A095@ExchMBX104.netflix.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: acceptlanguage: en-US Content-Type: multipart/alternative; boundary="_000_4F6B25AFFFCAFE44B6259A412D5F9B1032B8A095ExchMBX104netfl_" MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org --_000_4F6B25AFFFCAFE44B6259A412D5F9B1032B8A095ExchMBX104netfl_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable My Hive metastore uses MySQL. I'd like to see Hive CLI log all SQL queries = that are issued to MySQL. What config/property should I set to accomplish t= his? Thanks. Steven --_000_4F6B25AFFFCAFE44B6259A412D5F9B1032B8A095ExchMBX104netfl_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

My Hive metastor= e uses MySQL. I’d like to see Hive CLI log all SQL queries that are i= ssued to MySQL. What config/property should I set to accomplish this?<= /o:p>

Tha= nks.

Steven

<= /html>= --_000_4F6B25AFFFCAFE44B6259A412D5F9B1032B8A095ExchMBX104netfl_--