You might want to consider something like Impala or Phoenix, I presume you are trying to do some report query for dashboard or UI? MapReduce is certainly not adequate as there is too much latency on startup. If you want to give this a try, cdh4 and Impala are a good start.
Mouradk On 29 Nov 2013, at 10:33, Ramon Wang <ra...@appannie.com> wrote: > The general performance requirement for each query is less than 100 ms, > that's the average level. Sounds crazy, but yes we need to find a way for > it. > > Thanks > Ramon > > > On Fri, Nov 29, 2013 at 5:01 PM, yonghu <yongyong...@gmail.com> wrote: > >> The question is what you mean of "real-time". What is your performance >> request? In my opinion, I don't think the MapReduce is suitable for the >> real time data processing. >> >> >> On Fri, Nov 29, 2013 at 9:55 AM, Azuryy Yu <azury...@gmail.com> wrote: >> >>> you can try phoniex. >>> On 2013-11-29 3:44 PM, "Ramon Wang" <ra...@appannie.com> wrote: >>> >>>> Hi Folks >>>> >>>> It seems to be impossible, but I still want to check if there is a way >> we >>>> can do "complex" query on HBase with "Order By", "JOIN".. etc like we >>> have >>>> with normal RDBMS, we are asked to provided such a solution for it, any >>>> ideas? Thanks for your help. >>>> >>>> BTW, i think maybe impala from CDH would be a way to go, but haven't >> got >>>> time to check it yet. >>>> >>>> Thanks >>>> Ramon >>