Return-Path: 
 <user-return-9680-apmail-hive-user-archive=hive.apache.org@hive.apache.org>
X-Original-To: apmail-hive-user-archive@www.apache.org
Delivered-To: apmail-hive-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 93D5CD54D
	for <apmail-hive-user-archive@www.apache.org>;
 Wed, 25 Jul 2012 14:52:16 +0000 (UTC)
Received: (qmail 95870 invoked by uid 500); 25 Jul 2012 14:52:15 -0000
Delivered-To: apmail-hive-user-archive@hive.apache.org
Received: (qmail 95825 invoked by uid 500); 25 Jul 2012 14:52:15 -0000
Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-help@hive.apache.org>
List-Unsubscribe: <mailto:user-unsubscribe@hive.apache.org>
List-Post: <mailto:user@hive.apache.org>
List-Id: <user.hive.apache.org>
Reply-To: user@hive.apache.org
Delivered-To: mailing list user@hive.apache.org
Received: (qmail 95797 invoked by uid 99); 25 Jul 2012 14:52:14 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 25 Jul 2012 14:52:14 +0000
X-ASF-Spam-Status: No, hits=1.5 required=5.0
	tests=FSL_RCVD_USER,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: domain of prabhu.hive@gmail.com
 designates 209.85.217.176 as permitted sender)
Received: from [209.85.217.176] (HELO mail-lb0-f176.google.com)
 (209.85.217.176)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 25 Jul 2012 14:52:06 +0000
Received: by lboj14 with SMTP id j14so780538lbo.35
        for <user@hive.apache.org>; Wed, 25 Jul 2012 07:51:46 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20120113;
        h=mime-version:date:message-id:subject:from:to:content-type;
        bh=3+gz1ehRZnHn0aadj9qeIw9eBmIf/V+TLoW2KdDLUUg=;
        b=S+LtlnjKIU2dt6hR762N4chdkdZMxposbrpcrkyGSt3WvkrwnGzkSmf399FSIzBAXH
         bonz8BP0TizBUrWlKxPQOMEBlZINcbRQsLAhkRd0eh1tBjSsNPWqIOg16nTvwQcquBS+
         aQO2ruCdLxAqVJTT13L+QCG7gMZX4jYz+U4qBAysq5uYLrCVh12jyXMDABuKX8J8Vtim
         2EFM+Sa4kUv0+6ILdp5scC8lZn3oy67mBR0W52GKN86b3jf+feD96SdDR3f+hMXTBp0J
         J+70F0KvfmMZSxP16wwbvqZHXQ91p6tp9UBzA5ctkfR2+TF/eDMesFY2xOgxCRCkvVu0
         zBrA==
MIME-Version: 1.0
Received: by 10.112.54.37 with SMTP id g5mr11718150lbp.104.1343227906256; Wed,
 25 Jul 2012 07:51:46 -0700 (PDT)
Received: by 10.112.28.198 with HTTP; Wed, 25 Jul 2012 07:51:45 -0700 (PDT)
Date: Wed, 25 Jul 2012 20:21:45 +0530
Message-ID: 
 <CAJVJf7viVkAppB-h-SNcDhoF_LAkjNUqZ5h1OxKt9bZSiO6_ew@mail.gmail.com>
Subject: Hive Join-Query
From: prabhu k <prabhu.hive@gmail.com>
To: user@hive.apache.org
Content-Type: multipart/alternative; boundary=bcaec55401c6346e6c04c5a89e76

--bcaec55401c6346e6c04c5a89e76
Content-Type: text/plain; charset=ISO-8859-1

Hi Users,

I have 3 table's vender,supplier and date, by using these table Im trying
to generate a report like below

*Vendor Name,  Supplier Name, Year, Quarter, Sum ( quantity )*


I have executed the below query, after execute the query,I'm not getting
any result on my console

 hive>select v.vender,s.supplier_name,d.quarter,sum(v.quantity) from
vender1k v
    > JOIN dim_date d ON (v.order_date = d.ddate)
    > JOIN supplier s ON (s.supplierid=v.supplier)
    > group by v.quantity,d.quarter,v.vender,s.supplier_name;

vender
========

vender    supplier   order_date quantiry
ven_1     supp_1    2010-03-03 5000
ven_2     supp_2    2010-03-03 6000
ven_3     supp_1   2010-03-03 6000

supplier
==========
supplier_id supplier_name

supp_1          Nokia
supp_2          HLL
supp_1          NOKIA

DIM_DATE
========
ddate                  year          quarter
2010-03-03          2010            2
2010-03-03          2010            2
2010-03-03          2010            2


Please suggest and help me on this query.

Thanks,
Prabhu.

--bcaec55401c6346e6c04c5a89e76
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div>Hi Users,</div>
<div>=A0</div>
<div>I have 3 table&#39;s vender,supplier and date, by using these table Im=
 trying to generate a report like below</div>
<div>=A0</div>
<div><strong><font style=3D"BACKGROUND-COLOR:#ff0000">Vendor Name,=A0 Suppl=
ier Name, Year, Quarter, Sum (=A0quantity )</font></strong></div>
<div>=A0</div>
<div>=A0</div>
<div>I have executed the below query, after execute the query,I&#39;m not g=
etting any result on my console</div>
<div>=A0</div>
<div>
<div><span style=3D"FONT-FAMILY:&#39;Segoe UI&#39;;DIRECTION:ltr;WORD-WRAP:=
break-word;COLOR:#000000;FONT-SIZE:10pt"><font face=3D"Arial">hive&gt;</fon=
t>select v.vender,s.supplier_name,d.quarter,sum(v.quantity) from vender1k v=
<br>
=A0=A0=A0=A0&gt; JOIN dim_date d ON (v.order_date =3D d.ddate)<br>=A0=A0=A0=
=A0&gt; JOIN supplier s ON (s.supplierid=3Dv.supplier)<br>=A0=A0=A0=A0&gt; =
group by v.quantity,d.quarter,v.vender,s.supplier_name;<br></span><span sty=
le=3D"FONT-FAMILY:&#39;Segoe UI&#39;;DIRECTION:ltr;WORD-WRAP:break-word;COL=
OR:#000000;FONT-SIZE:10pt"></span></div>
</div>
<div><br>vender<br>=3D=3D=3D=3D=3D=3D=3D=3D</div>
<div>=A0</div>
<div>vender=A0=A0=A0 supplier=A0=A0 order_date=A0quantiry</div>
<div>ven_1=A0=A0=A0=A0 supp_1=A0=A0=A0 2010-03-03=A05000<br>ven_2=A0=A0=A0=
=A0 supp_2=A0=A0=A0 2010-03-03=A06000=A0<br>ven_3=A0=A0=A0=A0 supp_1=A0=A0 =
2010-03-03=A06000</div>
<div>=A0</div>
<div>supplier<br>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D<br>supplier_id=A0supplier_n=
ame</div>
<div>=A0</div>
<div>supp_1=A0=A0=A0=A0=A0=A0=A0=A0 =A0Nokia<br>supp_2=A0=A0=A0=A0=A0=A0=A0=
=A0=A0 HLL=A0<br>supp_1=A0=A0=A0=A0=A0=A0=A0=A0 =A0NOKIA</div>
<div>=A0</div>
<div>DIM_DATE<br>=3D=3D=3D=3D=3D=3D=3D=3D</div>
<div>ddate=A0=A0=A0=A0 =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 =A0year=A0=A0=A0=
=A0=A0=A0=A0=A0 =A0quarter=A0=A0</div>
<div>2010-03-03=A0=A0=A0=A0=A0=A0=A0=A0=A0 2010=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0=A0 2=A0<br>2010-03-03=A0=A0=A0=A0=A0=A0=A0=A0=A0 2010=A0=A0=A0=A0=A0=A0=
=A0=A0=A0=A0=A0 2<br>2010-03-03=A0=A0=A0=A0=A0=A0=A0=A0=A0 2010=A0=A0=A0=A0=
=A0=A0=A0=A0=A0=A0=A0 2</div>
<div>=A0</div>
<div>=A0</div>
<div>Please suggest and help me on this query.</div>
<div>=A0</div>
<div>Thanks,</div>
<div>Prabhu.<br></div>

--bcaec55401c6346e6c04c5a89e76--