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

Query return empty result if it contains NullLiteral in inlineview

    Details

      Description

      Here is a simplified query.

      create table sc (
      coll_def_id string,
      seg_def_id string,
      customer_id string
      );

      insert into sc values
      ('001', 'aaa', 'jack'),
      ('002', 'bbb', 'jack'),
      ('001', 'aaa', 'jim'),
      ('001', 'ccc', 'jack'),
      ('002', 'aaa', 'jim');

      select ad1.coll_def_id from (
      select coll_def_id, count(distinct(customer_id)), NULL as dept, NULL as cat
      from sc group by coll_def_id, dept) ad1;

        Attachments

          Activity

            People

            • Assignee:
              alex.behm Alexander Behm
              Reporter:
              jyu@cloudera.com Juan Yu
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: