[DRILL-3272] HIve : Using 'if' function in hive results in an ExpressionParsingException

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Fix Version/s: Future
• Component/s: Functions - Hive
• Assignee: Unassigned
• Reporter: Rahul Kumar Challapalli
• Created: 10/Jun/15 20:53
• Updated: 16/Jun/16 16:43

Description

git.commit.id.abbrev=5f26b8b

The below query fails. It works properly from hive however

select if(1999 > 2000, 'latest', 'old') from lineitem limit 1;
Error: SYSTEM ERROR: org.apache.drill.common.exceptions.ExpressionParsingException: Expression has syntax error! line 1:28:mismatched input ',' expecting CParen

Fragment 1:1

[Error Id: 007e7d7d-62dc-42fd-b526-07762c33719c on qa-node190.qa.lab:31010] (state=,code=0)

I attached the error log. Let me know if you need anything else.