Root: rel#316:Subset#4.ENUMERABLE.[]
Original rel:
LogicalSort(subset=[rel#316:Subset#4.ENUMERABLE.[]], fetch=[50000]): rowcount = 10.0, cumulative cost = {92.10340371976184 rows, 10.0 cpu, 0.0 io}, id = 310
  LogicalProject(subset=[rel#309:Subset#3.NONE.[]], TRANS_ID=[$1]): rowcount = 10.0, cumulative cost = {10.0 rows, 10.0 cpu, 0.0 io}, id = 308
    LogicalAggregate(subset=[rel#307:Subset#2.NONE.[]], group=[{0, 1}]): rowcount = 10.0, cumulative cost = {10.0 rows, 0.0 cpu, 0.0 io}, id = 306
      LogicalProject(subset=[rel#305:Subset#1.NONE.[]], $f0=[CAST(CASE(=('1030101', '1030101'), SUBSTRING(CASE(IS NOT NULL($9), $9, '999999999999'), 1, 1), =('1030101', '1030102'), SUBSTRING(CASE(IS NOT NULL($10), $10, '999999999999'), 1, 1), =('1030101', '1030103'), SUBSTRING(CASE(IS NOT NULL($2), $2, '999999999999'), 1, 1), =('1030101', '1030104'), SUBSTRING(CASE(IS NOT NULL($2), $2, '999999999999'), 1, 1), null)):VARCHAR(256) CHARACTER SET "UTF-16LE" COLLATE "UTF-16LE$en_US$primary"], TRANS_ID=[$0]): rowcount = 100.0, cumulative cost = {100.0 rows, 200.0 cpu, 0.0 io}, id = 304
        OLAPTableScan(subset=[rel#303:Subset#0.OLAP.[]], table=[[DEFAULT, KYLIN_SALES]], ctx=[], fields=[[0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13]]): rowcount = 100.0, cumulative cost = {5.0 rows, 5.050000000000001 cpu, 0.0 io}, id = 288

Sets:
Set#0, type: RecordType(BIGINT TRANS_ID, DATE PART_DT, VARCHAR(256) LSTG_FORMAT_NAME, BIGINT LEAF_CATEG_ID, INTEGER LSTG_SITE_ID, DECIMAL(19, 4) PRICE, BIGINT ITEM_COUNT, BIGINT SELLER_ID, BIGINT BUYER_ID, VARCHAR(256) OPS_USER_ID, VARCHAR(256) OPS_REGION, DECIMAL(19, 4) _KY_SUM_KYLIN_SALES_PRICE_, BIGINT _KY_COUNT__, ANY _KY_COUNT_DISTINCT_KYLIN_SALES_SELLER_ID_)
	rel#303:Subset#0.OLAP.[], best=rel#288, importance=0.5904900000000001
		rel#288:OLAPTableScan.OLAP.[](table=[DEFAULT, KYLIN_SALES],ctx=,fields=[0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13]), rowcount=100.0, cumulative cost={5.0 rows, 5.050000000000001 cpu, 0.0 io}
	rel#349:Subset#0.ENUMERABLE.[], best=rel#361, importance=0.6561
		rel#361:OLAPToEnumerableConverter.ENUMERABLE.[](input=rel#303:Subset#0.OLAP.[]), rowcount=100.0, cumulative cost={1.0000000005E10 rows, 5.050000000000001 cpu, 0.0 io}
Set#1, type: RecordType(VARCHAR(256) $f0, BIGINT TRANS_ID)
	rel#305:Subset#1.NONE.[], best=null, importance=0.6561
		rel#304:LogicalProject.NONE.[](input=rel#303:Subset#0.OLAP.[],$f0=CAST(CASE(=('1030101', '1030101'), SUBSTRING(CASE(IS NOT NULL($9), $9, '999999999999'), 1, 1), =('1030101', '1030102'), SUBSTRING(CASE(IS NOT NULL($10), $10, '999999999999'), 1, 1), =('1030101', '1030103'), SUBSTRING(CASE(IS NOT NULL($2), $2, '999999999999'), 1, 1), =('1030101', '1030104'), SUBSTRING(CASE(IS NOT NULL($2), $2, '999999999999'), 1, 1), null)):VARCHAR(256) CHARACTER SET "UTF-16LE" COLLATE "UTF-16LE$en_US$primary",TRANS_ID=$0), importance=0.0, rowcount=100.0, cumulative cost={inf}
		rel#342:LogicalProject.NONE.[](input=rel#303:Subset#0.OLAP.[],$f0=SUBSTRING(CASE(IS NOT NULL($9), $9, '999999999999'), 1, 1),TRANS_ID=$0), rowcount=100.0, cumulative cost={inf}
	rel#337:Subset#1.OLAP.[], best=rel#339, importance=0.6561
		rel#339:OLAPProjectRel.OLAP.[](input=rel#303:Subset#0.OLAP.[],$f0=CAST(CASE(=('1030101', '1030101'), SUBSTRING(CASE(IS NOT NULL($9), $9, '999999999999'), 1, 1), =('1030101', '1030102'), SUBSTRING(CASE(IS NOT NULL($10), $10, '999999999999'), 1, 1), =('1030101', '1030103'), SUBSTRING(CASE(IS NOT NULL($2), $2, '999999999999'), 1, 1), =('1030101', '1030104'), SUBSTRING(CASE(IS NOT NULL($2), $2, '999999999999'), 1, 1), null)):VARCHAR(256) CHARACTER SET "UTF-16LE" COLLATE "UTF-16LE$en_US$primary",TRANS_ID=$0,ctx=), rowcount=100.0, cumulative cost={15.0 rows, 25.05 cpu, 0.0 io}
		rel#348:OLAPProjectRel.OLAP.[](input=rel#303:Subset#0.OLAP.[],$f0=SUBSTRING(CASE(IS NOT NULL($9), $9, '999999999999'), 1, 1),TRANS_ID=$0,ctx=), rowcount=100.0, cumulative cost={15.0 rows, 25.05 cpu, 0.0 io}
	rel#346:Subset#1.ENUMERABLE.[], best=rel#358, importance=0.7290000000000001
		rel#350:EnumerableProject.ENUMERABLE.[](input=rel#349:Subset#0.ENUMERABLE.[],$f0=SUBSTRING(CASE(IS NOT NULL($9), $9, '999999999999'), 1, 1),TRANS_ID=$0), rowcount=1.0E10, cumulative cost={1.0000000105E10 rows, 205.05 cpu, 0.0 io}
		rel#358:OLAPToEnumerableConverter.ENUMERABLE.[](input=rel#337:Subset#1.OLAP.[]), rowcount=100.0, cumulative cost={1.0000000015E10 rows, 25.05 cpu, 0.0 io}
Set#2, type: RecordType(VARCHAR(256) $f0, BIGINT TRANS_ID)
	rel#307:Subset#2.NONE.[], best=null, importance=0.7290000000000001
		rel#306:LogicalAggregate.NONE.[](input=rel#305:Subset#1.NONE.[],group={0, 1}), rowcount=10.0, cumulative cost={inf}
	rel#334:Subset#2.OLAP.[], best=rel#338, importance=0.7290000000000001
		rel#338:OLAPAggregateRel.OLAP.[](input=rel#337:Subset#1.OLAP.[],group={0, 1},ctx=), rowcount=10.0, cumulative cost={15.5 rows, 25.05 cpu, 0.0 io}
	rel#343:Subset#2.ENUMERABLE.[], best=rel#356, importance=0.81
		rel#347:EnumerableAggregate.ENUMERABLE.[](input=rel#346:Subset#1.ENUMERABLE.[],group={0, 1}), rowcount=1.0E10, cumulative cost={2.0000000015E10 rows, 25.05 cpu, 0.0 io}
		rel#356:OLAPToEnumerableConverter.ENUMERABLE.[](input=rel#334:Subset#2.OLAP.[]), rowcount=10.0, cumulative cost={1.00000000155E10 rows, 25.05 cpu, 0.0 io}
Set#3, type: RecordType(BIGINT TRANS_ID)
	rel#309:Subset#3.NONE.[], best=null, importance=0.81
		rel#308:LogicalProject.NONE.[](input=rel#307:Subset#2.NONE.[],TRANS_ID=$1), rowcount=10.0, cumulative cost={inf}
	rel#318:Subset#3.OLAP.[], best=rel#335, importance=0.81
		rel#335:OLAPProjectRel.OLAP.[](input=rel#334:Subset#2.OLAP.[],TRANS_ID=$1,ctx=), rowcount=10.0, cumulative cost={16.0 rows, 25.55 cpu, 0.0 io}
	rel#340:Subset#3.ENUMERABLE.[], best=rel#352, importance=0.9
		rel#344:EnumerableProject.ENUMERABLE.[](input=rel#343:Subset#2.ENUMERABLE.[],TRANS_ID=$1), rowcount=1.0E10, cumulative cost={1.00000000255E10 rows, 35.05 cpu, 0.0 io}
		rel#352:OLAPToEnumerableConverter.ENUMERABLE.[](input=rel#318:Subset#3.OLAP.[]), rowcount=10.0, cumulative cost={1.0000000016E10 rows, 25.55 cpu, 0.0 io}
Set#4, type: RecordType(BIGINT TRANS_ID)
	rel#311:Subset#4.NONE.[], best=null, importance=0.9
		rel#310:LogicalSort.NONE.[](input=rel#309:Subset#3.NONE.[],fetch=50000), rowcount=10.0, cumulative cost={inf}
		rel#327:LogicalProject.NONE.[](input=rel#326:Subset#5.NONE.[],TRANS_ID=$1), rowcount=10.0, cumulative cost={inf}
	rel#316:Subset#4.ENUMERABLE.[], best=rel#321, importance=1.0
		rel#317:AbstractConverter.ENUMERABLE.[](input=rel#311:Subset#4.NONE.[],convention=ENUMERABLE,sort=[]), rowcount=10.0, cumulative cost={inf}
		rel#321:OLAPToEnumerableConverter.ENUMERABLE.[](input=rel#320:Subset#4.OLAP.[]), rowcount=10.0, cumulative cost={1.00000000165E10 rows, 26.05 cpu, 0.0 io}
		rel#329:EnumerableProject.ENUMERABLE.[](input=rel#328:Subset#5.ENUMERABLE.[],TRANS_ID=$1), rowcount=1.0E10, cumulative cost={1.0000000026E10 rows, 35.55 cpu, 0.0 io}
		rel#341:EnumerableLimit.ENUMERABLE.[](input=rel#340:Subset#3.ENUMERABLE.[],fetch=50000), rowcount=1.0E10, cumulative cost={2.0000000016E10 rows, 1.000000002555E10 cpu, 0.0 io}
	rel#320:Subset#4.OLAP.[], best=rel#319, importance=0.9
		rel#319:OLAPLimitRel.OLAP.[](input=rel#318:Subset#3.OLAP.[],ctx=,fetch=50000), rowcount=10.0, cumulative cost={16.5 rows, 26.05 cpu, 0.0 io}
		rel#331:OLAPProjectRel.OLAP.[](input=rel#330:Subset#5.OLAP.[],TRANS_ID=$1,ctx=), rowcount=10.0, cumulative cost={16.5 rows, 26.05 cpu, 0.0 io}
Set#5, type: RecordType(VARCHAR(256) $f0, BIGINT TRANS_ID)
	rel#326:Subset#5.NONE.[], best=null, importance=0.81
		rel#324:LogicalSort.NONE.[](input=rel#307:Subset#2.NONE.[],fetch=50000), rowcount=10.0, cumulative cost={inf}
	rel#328:Subset#5.ENUMERABLE.[], best=rel#354, importance=0.9
		rel#345:EnumerableLimit.ENUMERABLE.[](input=rel#343:Subset#2.ENUMERABLE.[],fetch=50000), rowcount=1.0E10, cumulative cost={2.00000000155E10 rows, 1.000000002505E10 cpu, 0.0 io}
		rel#354:OLAPToEnumerableConverter.ENUMERABLE.[](input=rel#330:Subset#5.OLAP.[]), rowcount=10.0, cumulative cost={1.0000000016E10 rows, 25.55 cpu, 0.0 io}
	rel#330:Subset#5.OLAP.[], best=rel#336, importance=0.81
		rel#336:OLAPLimitRel.OLAP.[](input=rel#334:Subset#2.OLAP.[],ctx=,fetch=50000), rowcount=10.0, cumulative cost={16.0 rows, 25.55 cpu, 0.0 io}