Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Mon, 7 Nov 2011 07:23:52 +0000 (UTC)
From: "binlijin (Updated) (JIRA)" <jira@apache.org>
To: hive-dev@hadoop.apache.org
Message-ID: 
 <1167327865.5955.1320650632878.JavaMail.tomcat@hel.zones.apache.org>
In-Reply-To: 
 <2114162440.7106.1316796026251.JavaMail.tomcat@hel.zones.apache.org>
Subject: [jira] [Updated] (HIVE-2466) mapjoin_subquery  dump small table
 (mapjoin table) to the same file
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable


     [ https://issues.apache.org/jira/browse/HIVE-2466?page=3Dcom.atlassian=
.jira.plugin.system.issuetabpanels:all-tabpanel ]

binlijin updated HIVE-2466:
---------------------------

    Priority: Critical  (was: Blocker)
   =20
> mapjoin_subquery  dump small table (mapjoin table) to the same file
> -------------------------------------------------------------------
>
>                 Key: HIVE-2466
>                 URL: https://issues.apache.org/jira/browse/HIVE-2466
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Processor
>    Affects Versions: 0.7.1
>            Reporter: binlijin
>            Assignee: binlijin
>            Priority: Critical
>         Attachments: D285.1.patch, hive-2466.1.patch, hive-2466.2.patch, =
hive-2466.3.patch, hive-2466.4.patch
>
>
> in mapjoin_subquery.q  there is a query=EF=BC=9A
> SELECT /*+ MAPJOIN(z) */ subq.key1, z.value
> FROM
> (SELECT /*+ MAPJOIN(x) */ x.key as key1, x.value as value1, y.key as key2=
, y.value as value2=20
>  FROM src1 x JOIN src y ON (x.key =3D y.key)) subq
>  JOIN srcpart z ON (subq.key1 =3D z.key and z.ds=3D'2008-04-08' and z.hr=
=3D11);
> when dump x and z to a local file,there all dump to the same file, so we =
lost the data of x

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrato=
rs: https://issues.apache.org/jira/secure/ContactAdministrators!default.jsp=
a
For more information on JIRA, see: http://www.atlassian.com/software/jira