github.com/whtcorpsinc/MilevaDB-Prod@v0.0.0-20211104133533-f57f4be3b597/interlock/aggfuncs/func_sum.go (about)

     1  // Copyright 2020 WHTCORPS INC, Inc.
     2  //
     3  // Licensed under the Apache License, Version 2.0 (the "License");
     4  // you may not use this file except in compliance with the License.
     5  // You may obtain a copy of the License at
     6  //
     7  //     http://www.apache.org/licenses/LICENSE-2.0
     8  //
     9  // Unless required by applicable law or agreed to in writing, software
    10  // distributed under the License is distributed on an "AS IS" BASIS,
    11  // See the License for the specific language governing permissions and
    12  // limitations under the License.
    13  
    14  package aggfuncs
    15  
    16  import (
    17  	"unsafe"
    18  
    19  	"github.com/whtcorpsinc/milevadb/stochastikctx"
    20  	"github.com/whtcorpsinc/milevadb/types"
    21  	"github.com/whtcorpsinc/milevadb/soliton/chunk"
    22  	"github.com/whtcorpsinc/milevadb/soliton/replog"
    23  	"github.com/whtcorpsinc/milevadb/soliton/set"
    24  )
    25  
    26  const (
    27  	// DefPartialResult4SumFloat64Size is the size of partialResult4SumFloat64
    28  	DefPartialResult4SumFloat64Size = int64(unsafe.Sizeof(partialResult4SumFloat64{}))
    29  	// DefPartialResult4SumDecimalSize is the size of partialResult4SumDecimal
    30  	DefPartialResult4SumDecimalSize = int64(unsafe.Sizeof(partialResult4SumDecimal{}))
    31  	// DefPartialResult4SumDistinctFloat64Size is the size of partialResult4SumDistinctFloat64
    32  	DefPartialResult4SumDistinctFloat64Size = int64(unsafe.Sizeof(partialResult4SumDistinctFloat64{}))
    33  	// DefPartialResult4SumDistinctDecimalSize is the size of partialResult4SumDistinctDecimal
    34  	DefPartialResult4SumDistinctDecimalSize = int64(unsafe.Sizeof(partialResult4SumDistinctDecimal{}))
    35  )
    36  
    37  type partialResult4SumFloat64 struct {
    38  	val             float64
    39  	notNullEventCount int64
    40  }
    41  
    42  type partialResult4SumDecimal struct {
    43  	val             types.MyDecimal
    44  	notNullEventCount int64
    45  }
    46  
    47  type partialResult4SumDistinctFloat64 struct {
    48  	val    float64
    49  	isNull bool
    50  	valSet set.Float64Set
    51  }
    52  
    53  type partialResult4SumDistinctDecimal struct {
    54  	val    types.MyDecimal
    55  	isNull bool
    56  	valSet set.StringSet
    57  }
    58  
    59  type baseSumAggFunc struct {
    60  	baseAggFunc
    61  }
    62  
    63  type baseSum4Float64 struct {
    64  	baseSumAggFunc
    65  }
    66  
    67  func (e *baseSum4Float64) AllocPartialResult() (pr PartialResult, memDelta int64) {
    68  	p := new(partialResult4SumFloat64)
    69  	return PartialResult(p), DefPartialResult4SumFloat64Size
    70  }
    71  
    72  func (e *baseSum4Float64) ResetPartialResult(pr PartialResult) {
    73  	p := (*partialResult4SumFloat64)(pr)
    74  	p.val = 0
    75  	p.notNullEventCount = 0
    76  }
    77  
    78  func (e *baseSum4Float64) AppendFinalResult2Chunk(sctx stochastikctx.Context, pr PartialResult, chk *chunk.Chunk) error {
    79  	p := (*partialResult4SumFloat64)(pr)
    80  	if p.notNullEventCount == 0 {
    81  		chk.AppendNull(e.ordinal)
    82  		return nil
    83  	}
    84  	chk.AppendFloat64(e.ordinal, p.val)
    85  	return nil
    86  }
    87  
    88  func (e *baseSum4Float64) UFIDelatePartialResult(sctx stochastikctx.Context, rowsInGroup []chunk.Event, pr PartialResult) (memDelta int64, err error) {
    89  	p := (*partialResult4SumFloat64)(pr)
    90  	for _, event := range rowsInGroup {
    91  		input, isNull, err := e.args[0].EvalReal(sctx, event)
    92  		if err != nil {
    93  			return 0, err
    94  		}
    95  		if isNull {
    96  			continue
    97  		}
    98  		p.val += input
    99  		p.notNullEventCount++
   100  	}
   101  	return 0, nil
   102  }
   103  
   104  func (e *baseSum4Float64) MergePartialResult(sctx stochastikctx.Context, src, dst PartialResult) (memDelta int64, err error) {
   105  	p1, p2 := (*partialResult4SumFloat64)(src), (*partialResult4SumFloat64)(dst)
   106  	if p1.notNullEventCount == 0 {
   107  		return 0, nil
   108  	}
   109  	p2.val += p1.val
   110  	p2.notNullEventCount += p1.notNullEventCount
   111  	return 0, nil
   112  }
   113  
   114  type sum4Float64 struct {
   115  	baseSum4Float64
   116  }
   117  
   118  func (e *sum4Float64) Slide(sctx stochastikctx.Context, rows []chunk.Event, lastStart, lastEnd uint64, shiftStart, shiftEnd uint64, pr PartialResult) error {
   119  	p := (*partialResult4SumFloat64)(pr)
   120  	for i := uint64(0); i < shiftEnd; i++ {
   121  		input, isNull, err := e.args[0].EvalReal(sctx, rows[lastEnd+i])
   122  		if err != nil {
   123  			return err
   124  		}
   125  		if isNull {
   126  			continue
   127  		}
   128  		p.val += input
   129  		p.notNullEventCount++
   130  	}
   131  	for i := uint64(0); i < shiftStart; i++ {
   132  		input, isNull, err := e.args[0].EvalReal(sctx, rows[lastStart+i])
   133  		if err != nil {
   134  			return err
   135  		}
   136  		if isNull {
   137  			continue
   138  		}
   139  		p.val -= input
   140  		p.notNullEventCount--
   141  	}
   142  	return nil
   143  }
   144  
   145  type sum4Float64HighPrecision struct {
   146  	baseSum4Float64
   147  }
   148  
   149  type sum4Decimal struct {
   150  	baseSumAggFunc
   151  }
   152  
   153  func (e *sum4Decimal) AllocPartialResult() (pr PartialResult, memDelta int64) {
   154  	p := new(partialResult4SumDecimal)
   155  	return PartialResult(p), DefPartialResult4SumDecimalSize
   156  }
   157  
   158  func (e *sum4Decimal) ResetPartialResult(pr PartialResult) {
   159  	p := (*partialResult4SumDecimal)(pr)
   160  	p.notNullEventCount = 0
   161  }
   162  
   163  func (e *sum4Decimal) AppendFinalResult2Chunk(sctx stochastikctx.Context, pr PartialResult, chk *chunk.Chunk) error {
   164  	p := (*partialResult4SumDecimal)(pr)
   165  	if p.notNullEventCount == 0 {
   166  		chk.AppendNull(e.ordinal)
   167  		return nil
   168  	}
   169  	chk.AppendMyDecimal(e.ordinal, &p.val)
   170  	return nil
   171  }
   172  
   173  func (e *sum4Decimal) UFIDelatePartialResult(sctx stochastikctx.Context, rowsInGroup []chunk.Event, pr PartialResult) (memDelta int64, err error) {
   174  	p := (*partialResult4SumDecimal)(pr)
   175  	for _, event := range rowsInGroup {
   176  		input, isNull, err := e.args[0].EvalDecimal(sctx, event)
   177  		if err != nil {
   178  			return 0, err
   179  		}
   180  		if isNull {
   181  			continue
   182  		}
   183  		if p.notNullEventCount == 0 {
   184  			p.val = *input
   185  			p.notNullEventCount = 1
   186  			continue
   187  		}
   188  
   189  		newSum := new(types.MyDecimal)
   190  		err = types.DecimalAdd(&p.val, input, newSum)
   191  		if err != nil {
   192  			return 0, err
   193  		}
   194  		p.val = *newSum
   195  		p.notNullEventCount++
   196  	}
   197  	return 0, nil
   198  }
   199  
   200  func (e *sum4Decimal) Slide(sctx stochastikctx.Context, rows []chunk.Event, lastStart, lastEnd uint64, shiftStart, shiftEnd uint64, pr PartialResult) error {
   201  	p := (*partialResult4SumDecimal)(pr)
   202  	for i := uint64(0); i < shiftEnd; i++ {
   203  		input, isNull, err := e.args[0].EvalDecimal(sctx, rows[lastEnd+i])
   204  		if err != nil {
   205  			return err
   206  		}
   207  		if isNull {
   208  			continue
   209  		}
   210  		if p.notNullEventCount == 0 {
   211  			p.val = *input
   212  			p.notNullEventCount = 1
   213  			continue
   214  		}
   215  		newSum := new(types.MyDecimal)
   216  		err = types.DecimalAdd(&p.val, input, newSum)
   217  		if err != nil {
   218  			return err
   219  		}
   220  		p.val = *newSum
   221  		p.notNullEventCount++
   222  	}
   223  	for i := uint64(0); i < shiftStart; i++ {
   224  		input, isNull, err := e.args[0].EvalDecimal(sctx, rows[lastStart+i])
   225  		if err != nil {
   226  			return err
   227  		}
   228  		if isNull {
   229  			continue
   230  		}
   231  		newSum := new(types.MyDecimal)
   232  		err = types.DecimalSub(&p.val, input, newSum)
   233  		if err != nil {
   234  			return err
   235  		}
   236  		p.val = *newSum
   237  		p.notNullEventCount--
   238  	}
   239  	return nil
   240  }
   241  
   242  func (e *sum4Decimal) MergePartialResult(sctx stochastikctx.Context, src, dst PartialResult) (memDelta int64, err error) {
   243  	p1, p2 := (*partialResult4SumDecimal)(src), (*partialResult4SumDecimal)(dst)
   244  	if p1.notNullEventCount == 0 {
   245  		return 0, nil
   246  	}
   247  	newSum := new(types.MyDecimal)
   248  	err = types.DecimalAdd(&p1.val, &p2.val, newSum)
   249  	if err != nil {
   250  		return 0, err
   251  	}
   252  	p2.val = *newSum
   253  	p2.notNullEventCount += p1.notNullEventCount
   254  	return 0, nil
   255  }
   256  
   257  type sum4DistinctFloat64 struct {
   258  	baseSumAggFunc
   259  }
   260  
   261  func (e *sum4DistinctFloat64) AllocPartialResult() (pr PartialResult, memDelta int64) {
   262  	p := new(partialResult4SumDistinctFloat64)
   263  	p.isNull = true
   264  	p.valSet = set.NewFloat64Set()
   265  	return PartialResult(p), DefPartialResult4SumDistinctFloat64Size
   266  }
   267  
   268  func (e *sum4DistinctFloat64) ResetPartialResult(pr PartialResult) {
   269  	p := (*partialResult4SumDistinctFloat64)(pr)
   270  	p.isNull = true
   271  	p.valSet = set.NewFloat64Set()
   272  }
   273  
   274  func (e *sum4DistinctFloat64) UFIDelatePartialResult(sctx stochastikctx.Context, rowsInGroup []chunk.Event, pr PartialResult) (memDelta int64, err error) {
   275  	p := (*partialResult4SumDistinctFloat64)(pr)
   276  	for _, event := range rowsInGroup {
   277  		input, isNull, err := e.args[0].EvalReal(sctx, event)
   278  		if err != nil {
   279  			return memDelta, err
   280  		}
   281  		if isNull || p.valSet.Exist(input) {
   282  			continue
   283  		}
   284  		p.valSet.Insert(input)
   285  		memDelta += DefFloat64Size
   286  		if p.isNull {
   287  			p.val = input
   288  			p.isNull = false
   289  			continue
   290  		}
   291  		p.val += input
   292  	}
   293  	return memDelta, nil
   294  }
   295  
   296  func (e *sum4DistinctFloat64) AppendFinalResult2Chunk(sctx stochastikctx.Context, pr PartialResult, chk *chunk.Chunk) error {
   297  	p := (*partialResult4SumDistinctFloat64)(pr)
   298  	if p.isNull {
   299  		chk.AppendNull(e.ordinal)
   300  		return nil
   301  	}
   302  	chk.AppendFloat64(e.ordinal, p.val)
   303  	return nil
   304  }
   305  
   306  type sum4DistinctDecimal struct {
   307  	baseSumAggFunc
   308  }
   309  
   310  func (e *sum4DistinctDecimal) AllocPartialResult() (pr PartialResult, memDelta int64) {
   311  	p := new(partialResult4SumDistinctDecimal)
   312  	p.isNull = true
   313  	p.valSet = set.NewStringSet()
   314  	return PartialResult(p), DefPartialResult4SumDistinctDecimalSize
   315  }
   316  
   317  func (e *sum4DistinctDecimal) ResetPartialResult(pr PartialResult) {
   318  	p := (*partialResult4SumDistinctDecimal)(pr)
   319  	p.isNull = true
   320  	p.valSet = set.NewStringSet()
   321  }
   322  
   323  func (e *sum4DistinctDecimal) UFIDelatePartialResult(sctx stochastikctx.Context, rowsInGroup []chunk.Event, pr PartialResult) (memDelta int64, err error) {
   324  	p := (*partialResult4SumDistinctDecimal)(pr)
   325  	for _, event := range rowsInGroup {
   326  		input, isNull, err := e.args[0].EvalDecimal(sctx, event)
   327  		if err != nil {
   328  			return memDelta, err
   329  		}
   330  		if isNull {
   331  			continue
   332  		}
   333  		hash, err := input.ToHashKey()
   334  		if err != nil {
   335  			return memDelta, err
   336  		}
   337  		decStr := string(replog.String(hash))
   338  		if p.valSet.Exist(decStr) {
   339  			continue
   340  		}
   341  		p.valSet.Insert(decStr)
   342  		memDelta += int64(len(decStr))
   343  		if p.isNull {
   344  			p.val = *input
   345  			p.isNull = false
   346  			continue
   347  		}
   348  		newSum := new(types.MyDecimal)
   349  		if err = types.DecimalAdd(&p.val, input, newSum); err != nil {
   350  			return memDelta, err
   351  		}
   352  		p.val = *newSum
   353  	}
   354  	return memDelta, nil
   355  }
   356  
   357  func (e *sum4DistinctDecimal) AppendFinalResult2Chunk(sctx stochastikctx.Context, pr PartialResult, chk *chunk.Chunk) error {
   358  	p := (*partialResult4SumDistinctDecimal)(pr)
   359  	if p.isNull {
   360  		chk.AppendNull(e.ordinal)
   361  		return nil
   362  	}
   363  	chk.AppendMyDecimal(e.ordinal, &p.val)
   364  	return nil
   365  }