hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ted Dunning <tdunn...@maprtech.com>
Subject Re: Schema design question
Date Sat, 16 Apr 2011 21:51:02 GMT
TsDB has more columns than it appears at first glance.  They store all of
the observations for a relatively long time interval in a single row.

You may have spotted that right off (I didn't).

On Sat, Apr 16, 2011 at 1:27 AM, Yves Langisch <yves@langisch.ch> wrote:

> As I'm about to plan a similar app I have studied the HBase schema of the
> opentsb project:
>
> http://opentsdb.net/schema.html
>
> The opentsb approach seems to have many rows instead of many columns. What
> is the better schema design in terms of query performance? My experience so
> far is that a width schema with many columns but less rows performs better.
> A 'horizontal' table scan seems to be better suited for fast queries.
>
> Yves

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