Skip to content

Instantly share code, notes, and snippets.

@prateeka

prateeka/GraphPlanner.scala

Last active July 30, 2021 23:16
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save prateeka/51ad79f9c8f3ccf625393bc46807864c to your computer and use it in GitHub Desktop.
Save prateeka/51ad79f9c8f3ccf625393bc46807864c to your computer and use it in GitHub Desktop.
Download ZIP
AggLogical-lastchild.lastchild-fail
Raw
GraphPlanner.scala
AggregateLogical(
SelectedData(
ColumnData(SelectColumn(Some(c0),DimensionallyModifiedValue(AggregatedValue(AttributeValue(FlatAttribute(ef1dd654-da9a-42bc-77ef-ea4431bdeb4e: "salesamount1")),Sum),List(Child(Child(CurrentMember(FlatHierarchy(d525ca44-1aa7-4c19-bfa7-ed6e69040b00+1298889108: "Order Date Month Hierarchy")),false),false))),NoAggregation), NoAggregation, Some(c0))
),
AuxiliaryData(),
AggregateLogical(
SelectedData(
DimensionallyModifiedData(ValueData(AggregatedValue(AttributeValue(FlatAttribute(ef1dd654-da9a-42bc-77ef-ea4431bdeb4e: "salesamount1")),Sum),NoAggregation,Set(RawAttribute(FlatAttribute(ef1dd654-da9a-42bc-77ef-ea4431bdeb4e: "salesamount1"),Sum,Some(c_36))),Some(c_37)),List(Child(Child(CurrentMember(FlatHierarchy(d525ca44-1aa7-4c19-bfa7-ed6e69040b00+1298889108: "Order Date Month Hierarchy")),false),false)),Min,Some(c_37))
),
AuxiliaryData(),
JoinCubes(
AggregateLogical(
SelectedData(
DerivedData(RawKey(FlatKey(05952e75-0b33-4da9-b69c-cd95cf9a8ef7+4d6b7994),1,AggregateGrouped(true),Some(c_56)),com.atscale.engine.core.plan.cube.JoinLeft$@2fd8d02,Some(AggregateGrouped(true)),None),
DerivedData(RawKey(FlatKey(c8b9198d-301f-4a13-9247-78edf51daec3+4d6b7994),1,AggregateGrouped(true),Some(c_57)),com.atscale.engine.core.plan.cube.JoinLeft$@2fd8d02,Some(AggregateGrouped(true)),None),
DerivedData(ModifiedData(RawKey(FlatKey(43ccba78-f55d-4e86-af6c-e5ac7c6cb626+4d6b7994),1,AggregateGrouped(true),Some(c_50)),Child(Child(CurrentMember(FlatHierarchy(d525ca44-1aa7-4c19-bfa7-ed6e69040b00+1298889108: "Order Date Month Hierarchy")),false),false),ModifiedData(RawKey(FlatKey(43ccba78-f55d-4e86-af6c-e5ac7c6cb626+4d6b7994),1,AggregateGrouped(true),Some(c_50)),Child(CurrentMember(FlatHierarchy(d525ca44-1aa7-4c19-bfa7-ed6e69040b00+1298889108: "Order Date Month Hierarchy")),false),RawKey(FlatKey(43ccba78-f55d-4e86-af6c-e5ac7c6cb626+4d6b7994),1,AggregateGrouped(true),Some(c_50)),Some(c_51)),Some(c_54)),com.atscale.engine.core.plan.cube.JoinRight$@6c00a96f,Some(AggregateGrouped(true)),None)
),
AuxiliaryData(),
JoinCubes(
JoinCubes(
AggregatePlanned(
SelectedData(
RawKey(FlatKey(05952e75-0b33-4da9-b69c-cd95cf9a8ef7+4d6b7994),1,AggregateGrouped(true),Some(c_56))
),
AuxiliaryData(),
RawCube(Cube(b89a2fb7-74f4-4828-706e-70f7186e10a0: "Internet Sales Cube"))
),
AggregatePlanned(
SelectedData(
ModifiedData(RawKey(FlatKey(05952e75-0b33-4da9-b69c-cd95cf9a8ef7+4d6b7994),1,AggregateGrouped(true),Some(c_60)),CurrentMember(FlatHierarchy(d525ca44-1aa7-4c19-bfa7-ed6e69040b00+1298889108: "Order Date Month Hierarchy")),RawKey(FlatKey(05952e75-0b33-4da9-b69c-cd95cf9a8ef7+4d6b7994),1,AggregateGrouped(true),Some(c_60)),Some(c_61)),
ValueData(WindowFunctionApplication(RowNumberWindowFunction,List(),List(),List((KeyValue(FlatKey(c8b9198d-301f-4a13-9247-78edf51daec3+4d6b7994)),FlatDescending)),None),NoAggregation,Set(RawKey(FlatKey(c8b9198d-301f-4a13-9247-78edf51daec3+4d6b7994),1,AggregateGrouped(true),Some(c_58))),Some(rn_c59)),
RawKey(FlatKey(c8b9198d-301f-4a13-9247-78edf51daec3+4d6b7994),1,AggregateGrouped(true),Some(c_57))
),
AuxiliaryData(),
RawCube(Cube(b89a2fb7-74f4-4828-706e-70f7186e10a0: "Internet Sales Cube"))
),
JoinSelectedData(
DerivedData(RawKey(FlatKey(05952e75-0b33-4da9-b69c-cd95cf9a8ef7+4d6b7994),1,AggregateGrouped(true),Some(c_56)),com.atscale.engine.core.plan.cube.JoinLeft$@2fd8d02,Some(AggregateGrouped(true)),None),
DerivedData(RawKey(FlatKey(c8b9198d-301f-4a13-9247-78edf51daec3+4d6b7994),1,AggregateGrouped(true),Some(c_57)),com.atscale.engine.core.plan.cube.JoinRight$@6c00a96f,Some(AggregateGrouped(true)),None)
),
JoinConstraints(
CubeDataConstraint(DerivedData(RawKey(FlatKey(05952e75-0b33-4da9-b69c-cd95cf9a8ef7+4d6b7994),1,AggregateGrouped(true),Some(c_56)),com.atscale.engine.core.plan.cube.JoinLeft$@2fd8d02,None,None),None,DerivedData(ModifiedData(RawKey(FlatKey(05952e75-0b33-4da9-b69c-cd95cf9a8ef7+4d6b7994),1,AggregateGrouped(true),Some(c_60)),CurrentMember(FlatHierarchy(d525ca44-1aa7-4c19-bfa7-ed6e69040b00+1298889108: "Order Date Month Hierarchy")),RawKey(FlatKey(05952e75-0b33-4da9-b69c-cd95cf9a8ef7+4d6b7994),1,AggregateGrouped(true),Some(c_60)),Some(c_61)),com.atscale.engine.core.plan.cube.JoinRight$@6c00a96f,None,None),None,EqualsComparison),
CubeValueConstraint(ConstantValue[IntType](1),DerivedData(ValueData(WindowFunctionApplication(RowNumberWindowFunction,List(),List(),List((KeyValue(FlatKey(c8b9198d-301f-4a13-9247-78edf51daec3+4d6b7994)),FlatDescending)),None),NoAggregation,Set(RawKey(FlatKey(c8b9198d-301f-4a13-9247-78edf51daec3+4d6b7994),1,AggregateGrouped(true),Some(c_58))),Some(rn_c59)),com.atscale.engine.core.plan.cube.JoinRight$@6c00a96f,None,None),com.atscale.engine.core.plan.cube.JoinRight$@6c00a96f,EqualsComparison)
),
InnerJoin
),
JoinCubes(
AggregatePlanned(
SelectedData(
RawKey(FlatKey(05952e75-0b33-4da9-b69c-cd95cf9a8ef7+4d6b7994),1,AggregateGrouped(true),Some(c_44)),
RawKey(FlatKey(43ccba78-f55d-4e86-af6c-e5ac7c6cb626+4d6b7994),1,AggregateGrouped(true),Some(c_45)),
ValueData(WindowFunctionApplication(RankWindowFunction,List(),List(),List((KeyValue(FlatKey(c8b9198d-301f-4a13-9247-78edf51daec3+4d6b7994)),FlatAscending)),None),NoAggregation,Set(RawKey(FlatKey(c8b9198d-301f-4a13-9247-78edf51daec3+4d6b7994),1,AggregateGrouped(true),Some(c_42))),Some(rk_c43)),
RawKey(FlatKey(c8b9198d-301f-4a13-9247-78edf51daec3+4d6b7994),1,AggregateGrouped(true),Some(c_46))
),
AuxiliaryData(),
RawCube(Cube(b89a2fb7-74f4-4828-706e-70f7186e10a0: "Internet Sales Cube"))
),
AggregatePlanned(
SelectedData(
ModifiedData(RawKey(FlatKey(43ccba78-f55d-4e86-af6c-e5ac7c6cb626+4d6b7994),1,AggregateGrouped(true),Some(c_50)),Child(CurrentMember(FlatHierarchy(d525ca44-1aa7-4c19-bfa7-ed6e69040b00+1298889108: "Order Date Month Hierarchy")),false),RawKey(FlatKey(43ccba78-f55d-4e86-af6c-e5ac7c6cb626+4d6b7994),1,AggregateGrouped(true),Some(c_50)),Some(c_51)),
ValueData(WindowFunctionApplication(RowNumberWindowFunction,List(),List(),List((KeyValue(FlatKey(c8b9198d-301f-4a13-9247-78edf51daec3+4d6b7994)),FlatAscending), (KeyValue(FlatKey(ae85a7d0-5c98-40c5-bcd5-26a94570ed5f+4d6b7994)),FlatDescending)),None),NoAggregation,Set(RawKey(FlatKey(c8b9198d-301f-4a13-9247-78edf51daec3+4d6b7994),1,AggregateGrouped(true),Some(c_47)), RawKey(FlatKey(ae85a7d0-5c98-40c5-bcd5-26a94570ed5f+4d6b7994),1,AggregateGrouped(true),Some(c_48))),Some(rn_c49)),
RawKey(FlatKey(c8b9198d-301f-4a13-9247-78edf51daec3+4d6b7994),1,AggregateGrouped(true),Some(c_52)),
RawKey(FlatKey(ae85a7d0-5c98-40c5-bcd5-26a94570ed5f+4d6b7994),1,AggregateGrouped(true),Some(c_53))
),
AuxiliaryData(),
RawCube(Cube(b89a2fb7-74f4-4828-706e-70f7186e10a0: "Internet Sales Cube"))
),
JoinSelectedData(
DerivedData(RawKey(FlatKey(05952e75-0b33-4da9-b69c-cd95cf9a8ef7+4d6b7994),1,AggregateGrouped(true),Some(c_44)),com.atscale.engine.core.plan.cube.JoinLeft$@2fd8d02,Some(AggregateGrouped(true)),None),
DerivedData(ModifiedData(RawKey(FlatKey(43ccba78-f55d-4e86-af6c-e5ac7c6cb626+4d6b7994),1,AggregateGrouped(true),Some(c_50)),Child(Child(CurrentMember(FlatHierarchy(d525ca44-1aa7-4c19-bfa7-ed6e69040b00+1298889108: "Order Date Month Hierarchy")),false),false),ModifiedData(RawKey(FlatKey(43ccba78-f55d-4e86-af6c-e5ac7c6cb626+4d6b7994),1,AggregateGrouped(true),Some(c_50)),Child(CurrentMember(FlatHierarchy(d525ca44-1aa7-4c19-bfa7-ed6e69040b00+1298889108: "Order Date Month Hierarchy")),false),RawKey(FlatKey(43ccba78-f55d-4e86-af6c-e5ac7c6cb626+4d6b7994),1,AggregateGrouped(true),Some(c_50)),Some(c_51)),Some(c_54)),com.atscale.engine.core.plan.cube.JoinRight$@6c00a96f,Some(AggregateGrouped(true)),None)
),
JoinConstraints(
CubeDataConstraint(DerivedData(ValueData(WindowFunctionApplication(RankWindowFunction,List(),List(),List((KeyValue(FlatKey(c8b9198d-301f-4a13-9247-78edf51daec3+4d6b7994)),FlatAscending)),None),NoAggregation,Set(RawKey(FlatKey(c8b9198d-301f-4a13-9247-78edf51daec3+4d6b7994),1,AggregateGrouped(true),Some(c_42))),Some(rk_c43)),com.atscale.engine.core.plan.cube.JoinLeft$@2fd8d02,None,None),None,DerivedData(ValueData(WindowFunctionApplication(RowNumberWindowFunction,List(),List(),List((KeyValue(FlatKey(c8b9198d-301f-4a13-9247-78edf51daec3+4d6b7994)),FlatAscending), (KeyValue(FlatKey(ae85a7d0-5c98-40c5-bcd5-26a94570ed5f+4d6b7994)),FlatDescending)),None),NoAggregation,Set(RawKey(FlatKey(c8b9198d-301f-4a13-9247-78edf51daec3+4d6b7994),1,AggregateGrouped(true),Some(c_47)), RawKey(FlatKey(ae85a7d0-5c98-40c5-bcd5-26a94570ed5f+4d6b7994),1,AggregateGrouped(true),Some(c_48))),Some(rn_c49)),com.atscale.engine.core.plan.cube.JoinRight$@6c00a96f,None,None),None,EqualsComparison)
),
InnerJoin
),
JoinSelectedData(
DerivedData(RawKey(FlatKey(05952e75-0b33-4da9-b69c-cd95cf9a8ef7+4d6b7994),1,AggregateGrouped(true),Some(c_56)),com.atscale.engine.core.plan.cube.JoinLeft$@2fd8d02,Some(AggregateGrouped(true)),None),
DerivedData(RawKey(FlatKey(c8b9198d-301f-4a13-9247-78edf51daec3+4d6b7994),1,AggregateGrouped(true),Some(c_57)),com.atscale.engine.core.plan.cube.JoinLeft$@2fd8d02,Some(AggregateGrouped(true)),None),
DerivedData(ModifiedData(RawKey(FlatKey(43ccba78-f55d-4e86-af6c-e5ac7c6cb626+4d6b7994),1,AggregateGrouped(true),Some(c_50)),Child(Child(CurrentMember(FlatHierarchy(d525ca44-1aa7-4c19-bfa7-ed6e69040b00+1298889108: "Order Date Month Hierarchy")),false),false),ModifiedData(RawKey(FlatKey(43ccba78-f55d-4e86-af6c-e5ac7c6cb626+4d6b7994),1,AggregateGrouped(true),Some(c_50)),Child(CurrentMember(FlatHierarchy(d525ca44-1aa7-4c19-bfa7-ed6e69040b00+1298889108: "Order Date Month Hierarchy")),false),RawKey(FlatKey(43ccba78-f55d-4e86-af6c-e5ac7c6cb626+4d6b7994),1,AggregateGrouped(true),Some(c_50)),Some(c_51)),Some(c_54)),com.atscale.engine.core.plan.cube.JoinRight$@6c00a96f,Some(AggregateGrouped(true)),None)
),
JoinConstraints(
CubeDataConstraint(DerivedData(ModifiedData(RawKey(FlatKey(05952e75-0b33-4da9-b69c-cd95cf9a8ef7+4d6b7994),1,AggregateGrouped(true),Some(c_62)),Child(CurrentMember(FlatHierarchy(d525ca44-1aa7-4c19-bfa7-ed6e69040b00+1298889108: "Order Date Month Hierarchy")),false),RawKey(FlatKey(05952e75-0b33-4da9-b69c-cd95cf9a8ef7+4d6b7994),1,AggregateGrouped(true),Some(c_62)),Some(c_63)),com.atscale.engine.core.plan.cube.JoinLeft$@2fd8d02,None,None),None,DerivedData(RawKey(FlatKey(05952e75-0b33-4da9-b69c-cd95cf9a8ef7+4d6b7994),1,AggregateGrouped(true),Some(c_62)),com.atscale.engine.core.plan.cube.JoinRight$@6c00a96f,None,None),None,EqualsComparison)
),
InnerJoin
)
),
AggregatePlanned(
SelectedData(
ValueData(AggregatedValue(AttributeValue(FlatAttribute(ef1dd654-da9a-42bc-77ef-ea4431bdeb4e: "salesamount1")),Sum),NoAggregation,Set(RawAttribute(FlatAttribute(ef1dd654-da9a-42bc-77ef-ea4431bdeb4e: "salesamount1"),Sum,Some(c_36))),Some(c_37)),
RawKey(FlatKey(05952e75-0b33-4da9-b69c-cd95cf9a8ef7+4d6b7994),1,AggregateGrouped(true),Some(c_40)),
RawKey(FlatKey(43ccba78-f55d-4e86-af6c-e5ac7c6cb626+4d6b7994),1,AggregateGrouped(true),Some(c_41))
),
AuxiliaryData(),
RawCube(Cube(b89a2fb7-74f4-4828-706e-70f7186e10a0: "Internet Sales Cube"))
),
JoinSelectedData(
ValueData(AggregatedValue(AttributeValue(FlatAttribute(ef1dd654-da9a-42bc-77ef-ea4431bdeb4e: "salesamount1")),Sum),NoAggregation,Set(RawAttribute(FlatAttribute(ef1dd654-da9a-42bc-77ef-ea4431bdeb4e: "salesamount1"),Sum,Some(c_36))),Some(c_37)),
RawKey(FlatKey(05952e75-0b33-4da9-b69c-cd95cf9a8ef7+4d6b7994),1,AggregateGrouped(true),Some(c_40)),
RawKey(FlatKey(43ccba78-f55d-4e86-af6c-e5ac7c6cb626+4d6b7994),1,AggregateGrouped(true),Some(c_41))
),
JoinConstraints(
CubeDataConstraint(DerivedData(RawKey(FlatKey(05952e75-0b33-4da9-b69c-cd95cf9a8ef7+4d6b7994),1,AggregateGrouped(true),Some(c_40)),com.atscale.engine.core.plan.cube.JoinLeft$@2fd8d02,None,None),None,DerivedData(RawKey(FlatKey(05952e75-0b33-4da9-b69c-cd95cf9a8ef7+4d6b7994),1,AggregateGrouped(true),Some(c_40)),com.atscale.engine.core.plan.cube.JoinRight$@6c00a96f,None,None),None,EqualsComparison),
CubeDataConstraint(DerivedData(RawKey(FlatKey(43ccba78-f55d-4e86-af6c-e5ac7c6cb626+4d6b7994),1,AggregateGrouped(true),Some(c_41)),com.atscale.engine.core.plan.cube.JoinLeft$@2fd8d02,None,None),None,DerivedData(RawKey(FlatKey(43ccba78-f55d-4e86-af6c-e5ac7c6cb626+4d6b7994),1,AggregateGrouped(true),Some(c_41)),com.atscale.engine.core.plan.cube.JoinRight$@6c00a96f,None,None),None,EqualsComparison)
),
InnerJoin
)
)
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment