...
*=fields that may be hoisted (if lower level fields are unambiguous or the rollup contains only 1 bet)
Rollup level: | BET | SIDE | MARKET | EVENT | EVENT_TYPE | EXCHANGE |
|---|---|---|---|---|---|---|
Settled As | Y | Y | Y | Y | Y | Y |
Settled Date | Y | MAX | MAX | MAX | MAX | MAX |
Bet Count | Y | Y | Y | Y | Y | Y |
Profit | Y | SUM | SUM | SUM | SUM | SUM |
Exchange Id | Y | Y | Y | Y | Y | Y |
Event Type Id | Y | Y | Y | Y | Y | N |
Event Id | Y | Y | Y | Y | N | N |
Market Id | Y | Y | Y | N | N | N |
Selection Id | Y | Y | N* | N | N | N |
Handicap | Y | Y | N* | N | N | N |
Side | Y | Y | N* | N | N | N |
Price Requested | Y | AVG | N*(AVG) | N | N | N |
Price Matched | Y | AVG | N*(AVG) | N | N | N |
Size Settled | Y | SUM | N*(SUM) | N | N | N |
Price Reduced | Y | Y | Y | N | N | N |
Commission | N | N | Y | SUM | SUM | SUM |
Bet Id | Y | N* | N* | N | N | N |
Placed Date | Y | MAX | MAX | N | N | N |
Persistence Type | Y | Y | Y | N | N | N |
Order Type | Y | Y | Y | N | N | N |
Regulator Code | Y | Y | Y | N | N | N |
Regulator Auth Code | Y | Y | Y | N | N | N |
Voided Date(where applicable) | Y | MAX | MAX | N | N | N |
BetOutcome | Y | N | N | N | N | N |