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

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

    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

              People

              • Assignee:
                bharathv bharath v
                Reporter:
                mala_ck Mala Chikka Kempanna
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: