[HIVE-2955] Queries consists of metadata-only-query returns always empty value

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 0.10.0
• Component/s: Query Processor
• Hadoop Flags: Reviewed
• Assignee: Navis Ryu
• Reporter: Navis Ryu
• Created: 17/Apr/12 05:31
• Updated: 05/Jan/14 13:01
• Resolved: 22/Jun/12 04:27

Description

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

Issue Links

• duplicates: HIVE-4386 max() and min() return NULL on partition column; distinct() returns nothing
• is duplicated by: HIVE-3108 SELECT count(DISTINCT col) ... returns 0 if "col" is a partition column
• is duplicated by: HIVE-4386 max() and min() return NULL on partition column; distinct() returns nothing