Uploaded image for project: 'HBase'
  1. HBase
  2. HBASE-19292

Numerical comparison support for column value - cell

    XMLWordPrintableJSON

    Details

    • Type: Wish
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.3.1
    • Fix Version/s: None
    • Component/s: Filters
    • Environment:

      may not be related

    • External issue ID:
      198964

      Description

      I've gotten the following data set:

      rowkey1 test:duration =43425
      rowkey2 test:duration = 5000
      rowkey3 test:duration = 90
      rowkey4 test:duration =8882

      According to your filter languages, if i want the data in a specific duration range,e.g. 2000<duration<10000. I should compose the scanner specifications like this:

      {FILTER => "SingleColumnValueFilter('test', 'duration', <=, 'binary:10000') AND SingleColumnValueFilter('test', 'duration', >=, 'binary:2000')"}

      Finally got nothing, since i foud out that the comparator i used is BinaryComparator which compares by bits i.e, `90` is greater than `800`, a little incredible.

      Currently i am unable to follow your spectacular project. I have read your source code of the BinaryComparator, it's really vague for newbie in java.
      Could you please add support for numerical comparison or give me some advice to conform my needs.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              afisher Kayla Fisher
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:

                Time Tracking

                Estimated:
                Original Estimate - 336h
                336h
                Remaining:
                Remaining Estimate - 336h
                336h
                Logged:
                Time Spent - Not Specified
                Not Specified