hbase-user mailing list archives

Never mind, after going over my code it appears that IntelliJ's 'auto-complete' got me. ;-)

Thanks

-Pete

-----Original Message-----
From: Peter Haidinyak [mailto:phaidinyak@local.com] 
Sent: Friday, December 10, 2010 4:32 PM
To: user@hbase.apache.org
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.