hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kanagha <er.kana...@gmail.com>
Subject Question regarding designing row keys
Date Mon, 03 Oct 2016 20:31:50 GMT
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

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message