From user-return-14453-apmail-hbase-user-archive=hbase.apache.org@hbase.apache.org Sat Dec 11 00:32:21 2010 Return-Path: Delivered-To: apmail-hbase-user-archive@www.apache.org Received: (qmail 35739 invoked from network); 11 Dec 2010 00:32:21 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 11 Dec 2010 00:32:21 -0000 Received: (qmail 6466 invoked by uid 500); 11 Dec 2010 00:32:19 -0000 Delivered-To: apmail-hbase-user-archive@hbase.apache.org Received: (qmail 6438 invoked by uid 500); 11 Dec 2010 00:32:19 -0000 Mailing-List: contact user-help@hbase.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hbase.apache.org Delivered-To: mailing list user@hbase.apache.org Received: (qmail 6430 invoked by uid 99); 11 Dec 2010 00:32:19 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 11 Dec 2010 00:32:19 +0000 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of phaidinyak@local.com designates 70.183.28.5 as permitted sender) Received: from [70.183.28.5] (HELO mail11.local.com) (70.183.28.5) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 11 Dec 2010 00:32:11 +0000 Received: from IRV1HUBCAS01.eLiberation.com (10.1.190.40) by mail11.local.com (10.1.230.41) with Microsoft SMTP Server (TLS) id 8.3.83.0; Fri, 10 Dec 2010 16:32:04 -0800 Received: from IRV1EXMB01.eLiberation.com ([fe80::895:3aed:8948:77ab]) by IRV1HUBCAS01.eLiberation.com ([fe80::7853:3c40:9449:94df%13]) with mapi; Fri, 10 Dec 2010 16:31:49 -0800 From: Peter Haidinyak To: "user@hbase.apache.org" Date: Fri, 10 Dec 2010 16:31:47 -0800 Subject: Result different between remote Client and HBase Shell Thread-Topic: Result different between remote Client and HBase Shell Thread-Index: AcuYysugazMP9a/SQ42mGgXsAlIQhw== Message-ID: <321C2E54215EEB41A581FDD9DAECBC5DFCC73DDB@IRV1EXMB01.eLiberation.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_321C2E54215EEB41A581FDD9DAECBC5DFCC73DDBIRV1EXMB01eLibe_" MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org --_000_321C2E54215EEB41A581FDD9DAECBC5DFCC73DDBIRV1EXMB01eLibe_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi all, I've run across an interesting problem. I have imported a few thousand ro= ws into HBase and when I do a 'scan' from the shell tool I get back a diffe= rent amount of rows than if I do the same query with a remote Java Client. scan tool command... hbase(main):030:0> scan 'TrafficLog', {STARTROW=3D>'pg_nhp1 2010-12-08 0000= 000', ENDROW=3D>'pg_nhp1 2010-12-10 9999999', COLUMNS=3D>['Data:BotCode'], = VERSIONS=3D>1} This query returns 399 rows Java client code... Scan scan =3D new Scan(); scan.setCaching(10000); scan.setMaxVersions(1); scan.setCaching(1000); scan.addFamily(TRAFFIC_FAMILY_BYTES); scan.addColumn(TRAFFIC_FAMILY_BYTES, TrafficFilterArray.BOT_CODE.getCol= umnAsBytes()); final String affiliate =3D m_affiliateList.get(0); final String startingRow =3D (affiliate + SPACE_CHARACTER + m_startDate= + STARTING_INDEX + STARTING_INDEX); scan.setStartRow(startingRow.getBytes()); final String endingRow =3D (affiliate + SPACE_CHARACTER + m_endDate + E= NDING_INDEX); scan.setStopRow(endingRow.getBytes()); try { final ResultScanner scanner =3D m_trafficTable.getScanner(scan); int rowCount =3D 0; for (final Result result : scanner) { rowCount++; } m_logger.error("<><><> RowCount: " + rowCount); } catch (IOException p_ioException) { m_logger.error("IOException during scan.", p_ioException); } This query returns 195 results. I'm at a loss on this one. Thanks -Pete PS If there is a better way to query from the Client I would love to know i= t. I just hacked this together. --_000_321C2E54215EEB41A581FDD9DAECBC5DFCC73DDBIRV1EXMB01eLibe_--