Uploaded image for project: 'Kylin'
  1. Kylin
  2. KYLIN-682

Got "No aggregator for func 'MIN' and return type 'decimal(19,4)'" error when build cube

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • v0.7.1
    • v0.7.1
    • Job Engine
    • None

    Description

      Problem from community user Sun:

      Try to build our own test cube according to the offical tutorial. When
      doing the step of Build Base Cuboid Data, error occurs.

      I checked the mapreduce task log and found the following error stacktrace
      :
      Note that with defining measure step, I choose measure of GMV_MIN and
      GMV_MAX both and these two measures are automatically defined as
      decimal(19,4) and there is no way to modify that.

      Super weird for this kind of exception info. Hope any experts can shed a
      light on this.

      Best regards,
      Sun.

      2015-04-14 10:49:06,327 INFO [AsyncDispatcher event handler]
      org.apache.hadoop.mapreduce.v2.app.job.impl.TaskAttemptImpl: Diagnostics
      report from attempt_1428978814353_0003_m_000000_3: Error:
      java.lang.IllegalArgumentException: No aggregator for func 'MIN' and
      return type 'decimal(19,4)'
      at
      org.apache.kylin.metadata.measure.MeasureAggregator.create(MeasureAggregat
      or.java:58)
      at
      org.apache.kylin.metadata.measure.MeasureAggregators.<init>(MeasureAggrega
      tors.java:49)
      at
      org.apache.kylin.metadata.measure.MeasureAggregators.<init>(MeasureAggrega
      tors.java:39)
      at
      org.apache.kylin.job.hadoop.cube.CuboidReducer.setup(CuboidReducer.java:73
      )
      at org.apache.hadoop.mapreduce.Reducer.run(Reducer.java:168)
      at org.apache.hadoop.mapred.Task$NewCombinerRunner.combine(Task.java:1651)
      at
      org.apache.hadoop.mapred.MapTask$MapOutputBuffer.sortAndSpill(MapTask.java
      :1630)
      at
      org.apache.hadoop.mapred.MapTask$MapOutputBuffer.flush(MapTask.java:1482)
      at
      org.apache.hadoop.mapred.MapTask$NewOutputCollector.close(MapTask.java:720
      )
      at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:790)
      at org.apache.hadoop.mapred.MapTask.run(MapTask.java:341)
      at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:168)
      at java.security.AccessController.doPrivileged(Native Method)
      at javax.security.auth.Subject.doAs(Subject.java:415)
      at
      org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.
      java:1642)
      at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:163)

      Attachments

        Activity

          People

            shaofengshi Shao Feng Shi
            shaofengshi Shao Feng Shi
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: