Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-3272

HIve : Using 'if' function in hive results in an ExpressionParsingException

Attach filesAttach ScreenshotAdd voteVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • Future
    • Functions - Hive
    • None

    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.

      Attachments

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            Unassigned Unassigned
            rkins Rahul Kumar Challapalli

            Dates

              Created:
              Updated:

              Slack

                Issue deployment