Never mind, after going over my code it appears that IntelliJ's 'auto-complete' got me. ;-)
Thanks -Pete -----Original Message----- From: Peter Haidinyak [mailto:[email protected]] Sent: Friday, December 10, 2010 4:32 PM To: [email protected] Subject: Result different between remote Client and HBase Shell Hi all, I've run across an interesting problem. I have imported a few thousand rows into HBase and when I do a 'scan' from the shell tool I get back a different 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=>'pg_nhp1 2010-12-08 0000000', ENDROW=>'pg_nhp1 2010-12-10 9999999', COLUMNS=>['Data:BotCode'], VERSIONS=>1} This query returns 399 rows Java client code... Scan scan = new Scan(); scan.setCaching(10000); scan.setMaxVersions(1); scan.setCaching(1000); scan.addFamily(TRAFFIC_FAMILY_BYTES); scan.addColumn(TRAFFIC_FAMILY_BYTES, TrafficFilterArray.BOT_CODE.getColumnAsBytes()); final String affiliate = m_affiliateList.get(0); final String startingRow = (affiliate + SPACE_CHARACTER + m_startDate + STARTING_INDEX + STARTING_INDEX); scan.setStartRow(startingRow.getBytes()); final String endingRow = (affiliate + SPACE_CHARACTER + m_endDate + ENDING_INDEX); scan.setStopRow(endingRow.getBytes()); try { final ResultScanner scanner = m_trafficTable.getScanner(scan); int rowCount = 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 it. I just hacked this together.
