shell.rb

shell.rb

scan 'patient-2-nvp', COLUMNS => ['d:subtype', 'd:ehrSystemIdQualifier'], LIMIT => 10 }

import org.apache.hadoop.hbase.filter.CompareFilter
import org.apache.hadoop.hbase.filter.SingleColumnValueFilter
import org.apache.hadoop.hbase.filter.SubstringComparator
import org.apache.hadoop.hbase.util.Bytes

scan 'patient-2-nvp', { COLUMNS => ['d:ehrSystemIdQualifier'], LIMIT => 2000, FILTER => SingleColumnValueFilter.new(Bytes.toBytes('d'), Bytes.toBytes('ehrSystemIdQualifier'), CompareFilter::CompareOp.valueOf('EQUAL'), SubstringComparator.new('MEDS_HX_REVIEW')) }

scan 'patient-2-nvp', { COLUMNS => ['d:ehrSystemIdQualifier'], LIMIT => 20, FILTER => SingleColumnValueFilter.new(Bytes.toBytes('d'), Bytes.toBytes('provIds'), CompareFilter::CompareOp.valueOf('NOT_EQUAL'), BinaryComparator.new(Bytes.toBytes(''))) }

scan 'patient-2-nvp', { COLUMNS => ['d:subtype'], LIMIT => 100 }