You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Phabricator (Updated) (JIRA)" <ji...@apache.org> on 2012/04/17 07:49:37 UTC
[jira] [Updated] (HIVE-2955) Queries consists of
metadata-only-query returns always empty value
[ https://issues.apache.org/jira/browse/HIVE-2955?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Phabricator updated HIVE-2955:
------------------------------
Attachment: HIVE-2955.D2817.1.patch
navis requested code review of "HIVE-2955 [jira] Queries consists of metadata-only-query returns always empty value".
Reviewers: JIRA
DPAL-1108 Queries consists of metadata-only-query returns always empty value
For partitioned table, simple query on partition column returns always null or empty value, for example,
create table emppart(empno int, ename string) partitioned by (deptno int);
.. load partitions..
select distinct deptno from emppart; // empty
select min(deptno), max(deptno) from emppart; // NULL and NULL
TEST PLAN
EMPTY
REVISION DETAIL
https://reviews.facebook.net/D2817
AFFECTED FILES
ql/src/java/org/apache/hadoop/hive/ql/exec/ExecDriver.java
ql/src/java/org/apache/hadoop/hive/ql/optimizer/physical/MetadataOnlyOptimizer.java
ql/src/test/queries/clientpositive/metadataonly1.q
ql/src/test/results/clientpositive/metadataonly1.q.out
MANAGE HERALD DIFFERENTIAL RULES
https://reviews.facebook.net/herald/view/differential/
WHY DID I GET THIS EMAIL?
https://reviews.facebook.net/herald/transcript/6411/
Tip: use the X-Herald-Rules header to filter Herald messages in your client.
> Queries consists of metadata-only-query returns always empty value
> ------------------------------------------------------------------
>
> Key: HIVE-2955
> URL: https://issues.apache.org/jira/browse/HIVE-2955
> Project: Hive
> Issue Type: Bug
> Reporter: Navis
> Assignee: Navis
> Priority: Minor
> Attachments: HIVE-2955.D2817.1.patch
>
>
> For partitioned table, simple query on partition column returns always null or empty value, for example,
> {code}
> create table emppart(empno int, ename string) partitioned by (deptno int);
> .. load partitions..
> select distinct deptno from emppart; // empty
> select min(deptno), max(deptno) from emppart; // NULL and NULL
> {code}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira