Hi Amit, Would it be possible to post your CREATE TABLE statement, the EXPLAIN on the query, and the query itself so we can better diagnose any issues?
>From your description above, you're executing the right query - it's always better to query for multiple rows versus executing a single query for each row (this is typically the case for any query engine). Batching is implemented in 2.2.3 and above, but not for performance reasons. Some products for which we have integration rely on a JDBC driver to support batching, so that's why it was added. Batching does not buy you anything in Phoenix, because it's an embedded JDBC driver. Thanks, James On Sun, Apr 6, 2014 at 9:08 AM, Amit Sela <[email protected]> wrote: > Hi all, > I'm running with Phoenix 2.2.2 which (AFAIK) does not support batch > queries. > I want to query some (not all) of the columns in the table (all from the > same family), for multiple rowkeys. > Normally I would execute a batch queries of: > *select c1,c2... from table where rowkey=row1* > *select c1,c2... from table where rowkey=row2* > *...* > Since batch is not supported, I do the following: > *select c1,c2... from table where rowkey in (row1,row2...)* > > This ends up being slower than executing a batch of gets from the HBase > API... > > Is there a better way for me to use Phoenix in this case ? > > Thanks, > Amit. > > >
