Return-Path: X-Original-To: apmail-hbase-issues-archive@www.apache.org Delivered-To: apmail-hbase-issues-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 37B4A91F6 for ; Tue, 6 Mar 2012 23:20:22 +0000 (UTC) Received: (qmail 1914 invoked by uid 500); 6 Mar 2012 23:20:22 -0000 Delivered-To: apmail-hbase-issues-archive@hbase.apache.org Received: (qmail 1854 invoked by uid 500); 6 Mar 2012 23:20:22 -0000 Mailing-List: contact issues-help@hbase.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Delivered-To: mailing list issues@hbase.apache.org Received: (qmail 1784 invoked by uid 99); 6 Mar 2012 23:20:21 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 06 Mar 2012 23:20:21 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=5.0 tests=ALL_TRUSTED,T_RP_MATCHES_RCVD X-Spam-Check-By: apache.org Received: from [140.211.11.116] (HELO hel.zones.apache.org) (140.211.11.116) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 06 Mar 2012 23:20:19 +0000 Received: from hel.zones.apache.org (hel.zones.apache.org [140.211.11.116]) by hel.zones.apache.org (Postfix) with ESMTP id 29234C2FB for ; Tue, 6 Mar 2012 23:19:58 +0000 (UTC) Date: Tue, 6 Mar 2012 23:19:58 +0000 (UTC) From: "Hadoop QA (Commented) (JIRA)" To: issues@hbase.apache.org Message-ID: <561714636.30330.1331075998169.JavaMail.tomcat@hel.zones.apache.org> In-Reply-To: <205348673.118.1317838470980.JavaMail.tomcat@hel.zones.apache.org> Subject: [jira] [Commented] (HBASE-4542) add filter info to slow query logging MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/HBASE-4542?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13223785#comment-13223785 ] Hadoop QA commented on HBASE-4542: ---------------------------------- -1 overall. Here are the results of testing the latest attachment http://issues.apache.org/jira/secure/attachment/12517322/Add-filter-info-to-slow-query-logging-2012-03-06_14_28_13.patch against trunk revision . +1 @author. The patch does not contain any @author tags. +1 tests included. The patch appears to include 4 new or modified tests. -1 javadoc. The javadoc tool appears to have generated -129 warning messages. +1 javac. The applied patch does not increase the total number of javac compiler warnings. -1 findbugs. The patch appears to introduce 154 new Findbugs (version 1.3.9) warnings. +1 release audit. The applied patch does not increase the total number of release audit warnings. -1 core tests. The patch failed these unit tests: org.apache.hadoop.hbase.mapreduce.TestHFileOutputFormat org.apache.hadoop.hbase.mapred.TestTableMapReduce org.apache.hadoop.hbase.mapreduce.TestImportTsv Test results: https://builds.apache.org/job/PreCommit-HBASE-Build/1121//testReport/ Findbugs warnings: https://builds.apache.org/job/PreCommit-HBASE-Build/1121//artifact/trunk/patchprocess/newPatchFindbugsWarnings.html Console output: https://builds.apache.org/job/PreCommit-HBASE-Build/1121//console This message is automatically generated. > add filter info to slow query logging > ------------------------------------- > > Key: HBASE-4542 > URL: https://issues.apache.org/jira/browse/HBASE-4542 > Project: HBase > Issue Type: Improvement > Affects Versions: 0.89.20100924 > Reporter: Kannan Muthukkaruppan > Assignee: Madhuwanti Vaidya > Attachments: 0001-jira-HBASE-4542-Add-filter-info-to-slow-query-loggin.patch, Add-filter-info-to-slow-query-logging-2012-03-06_14_28_13.patch, D1263.2.patch, D1539.1.patch > > > Slow query log doesn't report filters in effect. > For example: > {code} > (operationTooSlow): \ > {"processingtimems":3468,"client":"10.138.43.206:40035","timeRange": [0,9223372036854775807],\ > "starttimems":1317772005821,"responsesize":42411, \ > "class":"HRegionServer","table":"myTable","families":{"CF1":"ALL"]},\ > "row":"6c3b8efa132f0219b7621ed1e5c8c70b","queuetimems":0,\ > "method":"get","totalColumns":1,"maxVersions":1,"storeLimit":-1} > {code} > the above would suggest that all columns of myTable:CF1 are being requested for the given row. But in reality there could be filters in effect (such as ColumnPrefixFilter, ColumnRangeFilter, TimestampsFilter() etc.). We should enhance the slow query log to capture & report this information. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira