Even more, why do you want to re-implement that and not simply use ESRI on top of your HDFS/HBase data? ESRI can even talk to Impala/Hive. I know it's not HBase anymore, but since I don't have the details of your usecase, don't know what's the best fit, so giving you options.
2014-04-03 12:10 GMT-04:00 Vladimir Rodionov <[email protected]>: > >> 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: [email protected] > > ________________________________________ > From: Prabhakar [[email protected]] > Sent: Thursday, April 03, 2014 12:50 AM > To: [email protected] > Subject: how Store and retrieve time series Gio Spacialdata in Hbase > > HI, > > 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. > > Thanks, > Prabhakar > > 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 [email protected] and > delete or destroy any copy of this message and its attachments. >
