Uploaded image for project: 'CarbonData'
  1. CarbonData
  2. CARBONDATA-3303

MV datamap return wrong results when using coalesce and less groupby columns

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.6.0
    • Component/s: None
    • Labels:
      None

      Description

      SQL:

      create table coalesce_test_main(id int,name string,height int,weight int using carbondata

      insert into coalesce_test_main select 1,'tom',170,130

      insert into coalesce_test_main select 2,'tom',170,120

      insert into coalesce_test_main select 3,'lily',160,100

      create datamap coalesce_test_main_mv using 'mv' as select coalesce(sum(id),0) as sum_id,name as myname,weight from coalesce_test_main group by name,weight

      select coalesce(sum(id),0) as sumid,name from coalesce_test_main group by name

      Result:

      1 tom

      2 tom

      3 lily

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                qiuchenjian Chenjian Qiu
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 5.5h
                  5.5h