Return-Path: X-Original-To: apmail-hbase-user-archive@www.apache.org Delivered-To: apmail-hbase-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 078F5FA9A for ; Thu, 11 Apr 2013 02:12:13 +0000 (UTC) Received: (qmail 15312 invoked by uid 500); 11 Apr 2013 02:12:10 -0000 Delivered-To: apmail-hbase-user-archive@hbase.apache.org Received: (qmail 15244 invoked by uid 500); 11 Apr 2013 02:12:10 -0000 Mailing-List: contact user-help@hbase.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hbase.apache.org Delivered-To: mailing list user@hbase.apache.org Received: (qmail 15236 invoked by uid 99); 11 Apr 2013 02:12:10 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 11 Apr 2013 02:12:10 +0000 X-ASF-Spam-Status: No, hits=-0.5 required=5.0 tests=FREEMAIL_ENVFROM_END_DIGIT,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of urlop007@gmail.com designates 74.125.82.49 as permitted sender) Received: from [74.125.82.49] (HELO mail-wg0-f49.google.com) (74.125.82.49) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 11 Apr 2013 02:12:06 +0000 Received: by mail-wg0-f49.google.com with SMTP id e12so1105920wgh.4 for ; Wed, 10 Apr 2013 19:11:45 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:x-received:in-reply-to:references:date:message-id :subject:from:to:content-type; bh=+ca8wqJZxsRtqXHlXmsyT6y18tnLfj+gRKc63pLOqYw=; b=GEmJOqPECh9UAJpnIzB80fO4rLOKVzRHCLjSOek7AaY69FpYIrWFbia/3yF051G1cg 8TIlZdp7P+KOse5jPR5l1pg7IfVj6vOyerW3eL98uIaCE0T/5KIyTkmIqs+KAaWCniOL O9V1JobL2ujp3uktfHLT3zCDDLQBdPKj+H9LDXwD5Z8c8SmhYBTkFHDydVI4/azM1nYU 33cQ/pM7ECLLBh0hLjoEyob2fq+LoukcaoGQAutCh0QrYVWii38BAQiOPXFy4cKzUHT6 ElfTBCghQ1dmG6qci7shlBUUkPORAC3fiVInah6iXyDXIjRxo2MsKsVEhlae4/0Uoloe K2sQ== MIME-Version: 1.0 X-Received: by 10.194.222.3 with SMTP id qi3mr1111626wjc.28.1365646305021; Wed, 10 Apr 2013 19:11:45 -0700 (PDT) Received: by 10.194.43.164 with HTTP; Wed, 10 Apr 2013 19:11:44 -0700 (PDT) In-Reply-To: <391D65D0EBFC9B4B95E117F72A360F1A1F731E@SHSMSX101.ccr.corp.intel.com> References: <391D65D0EBFC9B4B95E117F72A360F1A1F731E@SHSMSX101.ccr.corp.intel.com> Date: Wed, 10 Apr 2013 19:11:44 -0700 Message-ID: Subject: Re: composite query on hbase and rcfile From: ur lops To: user@hbase.apache.org Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Checked: Checked by ClamAV on apache.org Hi Raymond and Azuryy, I appreciate the response. Raymond answered my question and this is what I was looking for. Best Rob On Wed, Apr 10, 2013 at 7:08 PM, Liu, Raymond wrote: > I guess rob mean that use one query to query rcfile and HBASE table at the same time. > If your query is on two table, one upon rcfile, another upon HBASE through hbase storage handler, I think that should be ok. > > Best Regards, > Raymond Liu > >> >> what's mean a composite query? Hive's query doesn't depends on file format, it >> can be ran on text file, sequence file, rcfile etc. >> >> >> On Thu, Apr 11, 2013 at 6:14 AM, ur lops wrote: >> >> > Hi, >> > Does anyone know, if hive can run a composite query over RCFILE >> > and HBASE in the same query? >> > >> > >> > Quick anwer will be highly appreciated Thanks in advance. >> > Rob >> >