[ 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