Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
HBase >> mail # user >> schema help


Copy link to this message
-
schema help
Hello,

I am trying to solve a time related problem. I can certainly use opentsdb
for this but was wondering if anyone had a clever way to create this type of
schema.

I have an inventory table,

time (unix epoch), fieldA, fieldB, data
There are about 30 million of these entries.

95% of my queries will look like this:
show me where fieldA=zCORE from range [1314180693 to now]

for fieldA, there is a possibility of 4000 unique items.
for fieldB, there is a possibility of 2 unique items (bool).

So, I was thinking of creating 4000*2 tables and place the data like that so
I can easly scan.

Any thoughts about this? Will hbase freak out if i have 8000 tables?
--
--- Get your facts first, then you can distort them as you please.--
+
Rita 2011-08-25, 14:53
+
Ian Varley 2011-08-25, 15:03
+
Rita 2011-08-25, 15:12
+
Jimson K. James 2011-08-26, 03:34
+
Sonal Goyal 2011-08-26, 05:08
+
Jimson K. James 2011-08-26, 06:51
+
Sonal Goyal 2011-08-26, 06:58
+
Jimson K. James 2011-08-26, 07:17
+
Jimson K. James 2011-08-26, 07:26
+
Sheng Chen 2011-08-26, 06:08
+
Buttler, David 2011-08-26, 16:08
+
lars hofhansl 2011-08-26, 18:50
+
Doug Meil 2011-08-26, 19:09
+
Sheng Chen 2011-08-29, 02:45