[HIVE-3288] Hive does not support select distinct *

• Type: Task
• Status: Resolved
• Priority: Minor
• Resolution: Duplicate
• Affects Version/s: 0.9.0
• Component/s: Query Processor
• Assignee: Unassigned
• Reporter: Sambavi Muthukrishnan
• Created: 22/Jul/12 14:49
• Updated: 15/Jan/15 00:59
• Resolved: 02/Oct/12 04:14

Description

select distinct * returns the below error in Hive while mysql supports this syntax.

hive> select distinct * from src;
FAILED: Error in semantic analysis: Line 0:-1 Invalid function 'TOK_ALLCOLREF'

Issue Links

• relates to: HIVE-9194 Support select distinct *