hbase-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vladimir Rodionov <vrodio...@carrieriq.com>
Subject RE: how Store and retrieve time series Gio Spacialdata in Hbase
Date Thu, 03 Apr 2014 16:10:54 GMT
>> suggest me the table design for this

Have you ever tried to google? You are asking people to do your own job, btw.
Have you ever heard about geohashing, space filling curves http://en.wikipedia.org/wiki/Hilbert_curve
or spatial indexes: http://en.wikipedia.org/wiki/R-tree

Best regards,
Vladimir Rodionov
Principal Platform Engineer
Carrier IQ, www.carrieriq.com
e-mail: vrodionov@carrieriq.com

From: Prabhakar [o.prabhakar@gmail.com]
Sent: Thursday, April 03, 2014 12:50 AM
To: dev@hbase.apache.org
Subject: how Store and retrieve time series Gio Spacialdata in Hbase


i have some data which got generated by vehicle GPS information. like
customer-id, vehicle-id,Latitude, longitude, address,time.. etc. I need to
store this data in Hbase for real time reads( writes can be batch, only
 concentrate on reads ). so while reading we are passing the parameters
like customerId,  time, address Point (Lat,Long) details with polygon( like
circle, rectangle,Square..etc) search. so the expected out put set of
vehicle address point within the polygon.
input is : one customer can search like find all his vehicles some
time-stamp with some address point within 1 KM or 2 KM Radius.
output is: retrieve all vehicle details within the given radius and given
address point on tha given time-stamp range.

please suggest me the proper GIO spacial API for this requirement and
suggest me the table design for this.


Confidentiality Notice:  The information contained in this message, including any attachments
hereto, may be confidential and is intended to be read only by the individual or entity to
whom this message is addressed. If the reader of this message is not the intended recipient
or an agent or designee of the intended recipient, please note that any review, use, disclosure
or distribution of this message or its attachments, in any form, is strictly prohibited. 
If you have received this message in error, please immediately notify the sender and/or Notifications@carrieriq.com
and delete or destroy any copy of this message and its attachments.

View raw message