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

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

    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

            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: