[HIVE-4039] Hive compiler sometimes fails in semantic analysis / optimisation stage when boolean variable appears in WHERE clause.

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 0.11.0
• Component/s: Query Processor
• Hadoop Flags: Reviewed
• Release Note: I have changed the code, and added in a test file
• Assignee: Jean Xu
• Reporter: Jean Xu
• Created: 19/Feb/13 19:09
• Updated: 16/May/13 21:10
• Resolved: 20/Feb/13 12:53

Description

Hive compiler fails with a NullPointerException in semantic analysis / optimisation stage when a boolean variable appears in the WHERE clause in some cases. A minimal query to generate this error is here:
SELECT 1
FROM (
SELECT TRUE AS flag
FROM dim_one_row:measurementsystems
) a
WHERE flag;

On the other hand, the following query is perfectly fine:
SELECT 1
FROM (
SELECT TRUE AS flag
FROM dim_one_row:measurementsystems
) a
WHERE flag=TRUE;