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

MV datamap doesn't affect using avg expression and count expression

    XMLWordPrintableJSON

    Details

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

      Description

      test case:
      create table test_table(name string, age int, height int,weight int) stored by 'carbondata'
      create datamap test_table_mv using 'mv' as select sum(height),count(age),avg(age),name from test_table group by name
      explain select avg(age),name from test_table group by name

      [== Physical Plan ==
      *HashAggregate(keys=name#33, functions=count(age#34), avg(cast(age#34 as bigint)))
      +- Exchange hashpartitioning(name#33, 200)
      +- *HashAggregate(keys=name#33, functions=partial_count(age#34), partial_avg(cast(age#34 as bigint)))
      +- *FileScan carbondata default.test_tablename#33,age#34]

        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 - 3h 20m
                  3h 20m