Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-4196

Certain builtin functions throw symbol does not exist error when used inside aggregate function

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

Details

    Description

      Steps to reproduce this:

      [x.y.z.p:21000] > describe sample_07;
      Query: describe sample_07
      +-------------+--------+---------+
      | name        | type   | comment |
      +-------------+--------+---------+
      | code        | string |         |
      | description | string |         |
      | total_emp   | int    |         |
      | salary      | int    |         |
      +-------------+--------+---------+
      Fetched 4 row(s) in 0.02s
      
      [x.y.z.p:21000] > select count(bitand(total_emp,0)) from sample_07;
      Query: select count(bitand(total_emp,0)) from sample_07
      +-----------------------------+
      | count(bitand(total_emp, 0)) |
      +-----------------------------+
      | 823                         |
      +-----------------------------+
      Fetched 1 row(s) in 0.53s
      [x.y.z.p:21000] > select count(shiftleft(total_emp,0)) from sample_07;
      Query: select count(shiftleft(total_emp,0)) from sample_07
      WARNINGS: 
      Builtin 'shiftleft' with symbol '_ZN6impala16BitByteFunctions9ShiftLeftEPN10impala_udf15FunctionContextERKNS1_6IntValES6_' does not exist. Verify that all your impalads are the same version.
      
      [x.y.z.p:21000] > select count(shiftright(total_emp,0)) from sample_07;
      Query: select count(shiftright(total_emp,0)) from sample_07
      WARNINGS: 
      Builtin 'shiftright' with symbol '_ZN6impala16BitByteFunctions10ShiftRightEPN10impala_udf15FunctionContextERKNS1_6IntValES6_' does not exist. Verify that all your impalads are the same version.
      

      Attachments

        Issue Links

        Activity

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

          People

            bharathv Bharath Vissapragada
            mala_ck Mala Chikka Kempanna
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment