hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Phabricator (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-4342) NPE for query involving UNION ALL with nested JOIN and UNION ALL
Date Sun, 21 Apr 2013 04:23:16 GMT

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

Phabricator updated HIVE-4342:
------------------------------

    Attachment: HIVE-4342.D10407.1.patch

navis requested code review of "HIVE-4342 [jira] NPE for query involving UNION ALL with nested
JOIN and UNION ALL".

Reviewers: JIRA

HIVE-4342 temp

UNION ALL query with JOIN in first part and another UNION ALL in second part gives NPE.

JOIN
UNION ALL
UNION ALL

Attachments:
1. HiveCommands.txt : command script to setup schema for query under consideration.
2. sourceData1.txt and sourceData2.txt : required for above command script.
3. Query.txt : Exact query which produces NPE.

NOTE: you will need to update path to sourceData1.txt and sourceData2.txt in the HiveCommands.txt
to suit your environment.

Attached files contain the schema and exact query which fails on Hive 0.9.
It is worthwhile to note that the same query executes successfully on Hive 0.7.

TEST PLAN
  EMPTY

REVISION DETAIL
  https://reviews.facebook.net/D10407

AFFECTED FILES
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/GenMRUnion1.java
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/unionproc/UnionProcContext.java
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/unionproc/UnionProcFactory.java
  ql/src/test/queries/clientpositive/union34.q
  ql/src/test/results/clientpositive/union34.q.out

MANAGE HERALD RULES
  https://reviews.facebook.net/herald/view/differential/

WHY DID I GET THIS EMAIL?
  https://reviews.facebook.net/herald/transcript/24921/

To: JIRA, navis

                
> NPE for query involving UNION ALL with nested JOIN and UNION ALL
> ----------------------------------------------------------------
>
>                 Key: HIVE-4342
>                 URL: https://issues.apache.org/jira/browse/HIVE-4342
>             Project: Hive
>          Issue Type: Bug
>          Components: Logging, Metastore, Query Processor
>    Affects Versions: 0.9.0
>         Environment: Red Hat Linux VM with Hive 0.9 and Hadoop 2.0
>            Reporter: Mihir Kulkarni
>            Assignee: Navis
>            Priority: Critical
>         Attachments: HIVE-4342.D10407.1.patch, HiveCommands.txt, Query.txt, sourceData1.txt,
sourceData2.txt
>
>
> UNION ALL query with JOIN in first part and another UNION ALL in second part gives NPE.
> bq. JOIN
> UNION ALL
> bq. UNION ALL
> Attachments:
> 1. HiveCommands.txt : command script to setup schema for query under consideration.
> 2. sourceData1.txt and sourceData2.txt : required for above command script.
> 3. Query.txt : Exact query which produces NPE.
> NOTE: you will need to update path to sourceData1.txt and sourceData2.txt in the HiveCommands.txt
to suit your environment.
> Attached files contain the schema and exact query which fails on Hive 0.9.
> It is worthwhile to note that the same query executes successfully on Hive 0.7.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message