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

count(distinct NULL) fails on a view

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: Impala 2.7.0
    • Fix Version/s: Impala 2.8.0
    • Component/s: Frontend
    • Labels:

      Description

      [localhost:21000] > create view test_view as SELECT id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, float_col, double_col, date_string_col, string_col, timestamp_col, year, month, day FROM functional.alltypesagg;
      Query: create view test_view as SELECT id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, float_col, double_col, date_string_col, string_col, timestamp_col, year, month, day FROM functional.alltypesagg
      ++
      ||
      ++
      ++
      Fetched 0 row(s) in 0.06s
      [localhost:21000] > select count(distinct null) from test_view;
      Query: select count(distinct null) from test_view
      Query submitted at: 2016-08-29 17:07:44 (Coordinator: http://mj-desktop.ca.cloudera.com:25000)
      ERROR: IllegalStateException: Grouping expr NULL returns type NULL_TYPE but its output tuple slot has type BOOLEAN
      

        Attachments

          Activity

            People

            • Assignee:
              yonghyun_impala_8905 Yonghyun Hwang
              Reporter:
              mjacobs Matthew Jacobs
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: