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

MV datamap doesn't take effect when query SQL has coalesce with all projections and no filter condition

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Blocker
    • Resolution: Unresolved
    • Affects Version/s: 1.5.1
    • Fix Version/s: None
    • Component/s: core
    • Labels:
      None

      Description

      MV datamap doesn't take effect when query SQL has coalesce with all projections and no filter condition

      test case :

      create table test_main(id int,name string,height int,weight int) using carbondata
      create datamap test_main_mv using 'mv' as select sum(id) as sum_id, sum(height) as sum_height,name as myname from test_main group by name
      select coalesce(sum(id),12) as sumid, sum(height) as sum_height from test_main group by name

        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:

                  Time Tracking

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