From user-return-482-apmail-phoenix-user-archive=phoenix.apache.org@phoenix.incubator.apache.org Sun Apr 6 16:09:18 2014 Return-Path: X-Original-To: apmail-phoenix-user-archive@minotaur.apache.org Delivered-To: apmail-phoenix-user-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 24C9E11152 for ; Sun, 6 Apr 2014 16:09:18 +0000 (UTC) Received: (qmail 12468 invoked by uid 500); 6 Apr 2014 16:09:17 -0000 Delivered-To: apmail-phoenix-user-archive@phoenix.apache.org Received: (qmail 12441 invoked by uid 500); 6 Apr 2014 16:09:17 -0000 Mailing-List: contact user-help@phoenix.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@phoenix.incubator.apache.org Delivered-To: mailing list user@phoenix.incubator.apache.org Received: (qmail 12425 invoked by uid 99); 6 Apr 2014 16:09:16 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 06 Apr 2014 16:09:16 +0000 X-ASF-Spam-Status: No, hits=-0.1 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_MED,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of amits@infolinks.com designates 207.126.144.125 as permitted sender) Received: from [207.126.144.125] (HELO mail-ie0-f170.google.com) (207.126.144.125) by apache.org (qpsmtpd/0.29) with SMTP; Sun, 06 Apr 2014 16:09:10 +0000 Received: from mail-ie0-f170.google.com ([209.85.223.170]) (using TLSv1) by eu1sys200aob108.postini.com ([207.126.147.11]) with SMTP ID DSNKU0F8EIAmi9uXnbEuBOh7HBv5N5eHA/Ur@postini.com; Sun, 06 Apr 2014 16:08:50 UTC Received: by mail-ie0-f170.google.com with SMTP id rd18so5295668iec.15 for ; Sun, 06 Apr 2014 09:08:47 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:date:message-id:subject:from:to :content-type; bh=XCQiXsXy9M0MzaEMkivS1lAAQ1+4Whsjyf/4dj4ZOGY=; b=R4CJn8ivI/OGDwpDS8RmxMu7VZG4JKM7D1XxgDgYoZvqY0Oi4nZKpki9LFGBNV2y5C wjVFBXDbMsrrfxtVKbexQwZQVKPjxe+a9SZT8n6pLg7M5tdBLvQd8h0SvpxAmIKyVI2q 6NPZtdBnXUEKtlI0aMmSB/ByskrPe1O+xpw0U3k20RDtnwULW/hJKjLypAa2ePtlUeCO QI41Hv6zTQpDp3WAJ+LMG31gm+exTQXB/TTtfEdpwBR8xJSPNI0hIm/UBDFq3s1AvgZC WNsOE+n1v7VlsYx4jcvCxtul//bIMoJ0aCix9em7AsfSbUjvEbLTkJ/oqdKbgegSuq2x UzeA== X-Gm-Message-State: ALoCoQkG+Jt1C0O4BDqfijWxwGEWDZ2VIfXC7OPgz1xGi8RK1ZeUOUJP7oNOhVyBoRsxnYvXNVj/m71Pgt9C/haQm0AnhnQz7ouUalZvdjVba6J34iHKmLsxohVmfxd6IDe/4gQNvYDNK3oDFLaSdtDC1ubAyIxJTg== X-Received: by 10.50.134.164 with SMTP id pl4mr15262409igb.21.1396800527788; Sun, 06 Apr 2014 09:08:47 -0700 (PDT) MIME-Version: 1.0 X-Received: by 10.50.134.164 with SMTP id pl4mr15262384igb.21.1396800527540; Sun, 06 Apr 2014 09:08:47 -0700 (PDT) Received: by 10.64.225.41 with HTTP; Sun, 6 Apr 2014 09:08:47 -0700 (PDT) Date: Sun, 6 Apr 2014 19:08:47 +0300 Message-ID: Subject: Best way to execute batch of queries From: Amit Sela To: user@phoenix.incubator.apache.org Content-Type: multipart/alternative; boundary=047d7b2e137144a44204f661f768 X-Virus-Checked: Checked by ClamAV on apache.org --047d7b2e137144a44204f661f768 Content-Type: text/plain; charset=ISO-8859-1 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. --047d7b2e137144a44204f661f768 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
Hi all,=A0
I'm running with Phoenix 2.2.2 which (A= FAIK) does not support batch queries.
I want to query some (not a= ll) of the columns in the table (all from the same family), for multiple ro= wkeys.
Normally I would execute a batch queries of:
se= lect c1,c2... from table where rowkey=3Drow1
select c1,c2.= .. from table where rowkey=3Drow2
...
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 fr= om the HBase API...

Is there a better way for me to use Phoenix in this cas= e ?

Thanks,
Amit.


--047d7b2e137144a44204f661f768--