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

Max Size column incorrectly has NULLs in column stats via HS2 interface

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: Impala 2.9.0
    • Fix Version/s: Impala 2.9.0
    • Component/s: Backend
    • Labels:
      None

      Description

      If a query like

      show COLUMN STATS functional.alltypes

      is run through the HS2 interface, the "Max Size" column contains only NULLs. However, if the same query is run through Impala shell, the "Max Size" column has the same values as the "Avg Size" column (no NULLS).

        Issue Links

          Activity

          Hide
          tarasbob Taras Bobrovytsky added a comment -
          commit d07580c171a1ec2d86578237129faa5388be0272
          Author: Taras Bobrovytsky <tbobrovytsky@cloudera.com>
          Date:   Tue Feb 21 16:18:34 2017 -0800
          
              IMPALA-4962: Fix SHOW COLUMN STATS for HS2
              
              Impala incorrectly returned NULLs in the "Max Size" column of the SHOW
              COLUMN STATS result when executed through the HS2 interface. The issue
              was that the column was specified to be type INT in the result schema,
              but the actual type of the contents that we inserted into it was
              "long". The reason why this is not an issue in Impala shell is because
              we stringify the contents without inspecting the metadata for beeswax
              results.
              
              The issue was fixed by changing the type from INT to BIGINT.
              
              Change-Id: I419657744635dfdc2e1562fe60a597617fff446e
              Reviewed-on: http://gerrit.cloudera.org:8080/6109
              Reviewed-by: Alex Behm <alex.behm@cloudera.com>
              Tested-by: Impala Public Jenkins
          
          Show
          tarasbob Taras Bobrovytsky added a comment - commit d07580c171a1ec2d86578237129faa5388be0272 Author: Taras Bobrovytsky <tbobrovytsky@cloudera.com> Date: Tue Feb 21 16:18:34 2017 -0800 IMPALA-4962: Fix SHOW COLUMN STATS for HS2 Impala incorrectly returned NULLs in the "Max Size" column of the SHOW COLUMN STATS result when executed through the HS2 interface . The issue was that the column was specified to be type INT in the result schema, but the actual type of the contents that we inserted into it was " long " . The reason why this is not an issue in Impala shell is because we stringify the contents without inspecting the metadata for beeswax results. The issue was fixed by changing the type from INT to BIGINT. Change-Id: I419657744635dfdc2e1562fe60a597617fff446e Reviewed-on: http: //gerrit.cloudera.org:8080/6109 Reviewed-by: Alex Behm <alex.behm@cloudera.com> Tested-by: Impala Public Jenkins

            People

            • Assignee:
              tarasbob Taras Bobrovytsky
              Reporter:
              tarasbob Taras Bobrovytsky
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development