Hi, We have designed an metric_table, for ex:
metric_type, timestamp, metricId in HBase using Apache Phoenix. And there is no indexing available on this table yet. Our access patterns are usually select * from metric_table where metric_type='x' and timestamp > 'start_date' and timestamp < 'end_date'. MetricId is not used in select statement. So, how does HBase scanning work in this scenario. I read that each region would hold the start and end rowkey for efficient scanning. In this case, since the rowkey is combined with metricId, will the select statement do a full scan of HBase table? Appreciate any inputs on this. Thanks Kanagha
