Ever tried Presto for simpler , yet faster alternative option ? Might help if used in conjunction with hive (i repeat it is not a replacement, but a complement)
regards Dev On Thu, Sep 18, 2014 at 3:18 PM, Prakash Hosalli < prakash.hosa...@syncoms.com> wrote: > > > Hi, > > > > > > I am in dilemma to go ahead with Hive or phoenix. > > > > My requirement is achieving *“Low Latency”* for the > query. > > > > I went through both one with suitable records of data and > I got following output. > > > > 1. Hive ran all aggregation query with help of MR and took around 5 > Mins (approximately) with 1 Lakh of data.(With join, where clause, AND). > > 2. Same query with Phoenix it took less than 30 seconds. > > > > But, Phoenix is not support its own security layer, which is concern to > me. I need some clarification on following points > > > > 1. Is it possible to run MR as a pre-complied one rather than on > fly. If yes, then what are the step to take to fulfil this one. > > > > > > > > > > Thanks in advance, > > > > > > Regards, > > Prakash Hosalli > > > -- Devopam Mittra Life and Relations are not binary