sql>set optimizer='default_pipe'; operation successful (0.302ms) sql>select optimizer; +--------------+ | single_value | +==============+ | default_pipe | +--------------+ 1 tuple (0.385ms) sql>explain select median(base) from genomics.echoli group by pos; +-------------------------------------------------------------------+ | mal | +===================================================================+ | function user.s8_1{autoCommit=true}():void; | | X_2 := sql.mvc(); | | X_3:bat[:oid,:oid] := sql.tid(X_2,"genomics","echoli"); | | X_6 := sql.bind(X_2,"genomics","echoli","base",0); | | (X_9,r1_9) := sql.bind(X_2,"genomics","echoli","base",2); | | X_12 := sql.bind(X_2,"genomics","echoli","base",1); | | X_14 := sql.delta(X_6,X_9,r1_9,X_12); | | X_15 := algebra.leftfetchjoin(X_3,X_14); | | X_16 := batcalc.bte(X_15); | | X_17 := sql.bind(X_2,"genomics","echoli","pos",0); | | (X_19,r1_21) := sql.bind(X_2,"genomics","echoli","pos",2); | | X_21 := sql.bind(X_2,"genomics","echoli","pos",1); | | X_22 := sql.delta(X_17,X_19,r1_21,X_21); | | X_23 := algebra.leftfetchjoin(X_3,X_22); | | (X_24,r1_28,r2_28) := group.subgroupdone(X_23); | | X_27:bat[:oid,:bte] := aggr.submedian(X_16,X_24,r1_28,true); | | X_29 := sql.resultSet(1,1,X_27); | | sql.rsColumn(X_29,"genomics.","L1","tinyint",8,0,X_27); | | X_34 := io.stdout(); | | sql.exportResult(X_34,X_29); | | end s8_1; | +-------------------------------------------------------------------+ 21 tuples (0.757ms) sql>explain select simple_genotype(base) from genomics.echoli group by pos; +----------------------------------------------------------------------------------------------------+ | mal | +====================================================================================================+ | function user.s9_1{autoCommit=true}():void; | | X_2 := sql.mvc(); | | X_37:bat[:oid,:oid] := sql.tid(X_2,"genomics","echoli",0,2); | | X_40:bat[:oid,:str] := sql.bind(X_2,"genomics","echoli","base",0,0,2); | | (X_42:bat[:oid,:oid] ,X_43:bat[:oid,:str] ) := sql.bind(X_2,"genomics","echoli","base",2,0,2); | | X_52 := sql.delta(X_40,X_42,X_43); | | X_54 := algebra.leftfetchjoin(X_37,X_52); | | X_39:bat[:oid,:oid] := sql.tid(X_2,"genomics","echoli",1,2); | | X_41:bat[:oid,:str] := sql.bind(X_2,"genomics","echoli","base",0,1,2); | | (X_44:bat[:oid,:oid] ,X_45:bat[:oid,:str] ) := sql.bind(X_2,"genomics","echoli","base",2,1,2); | | X_8 := sql.bind(X_2,"genomics","echoli","base",1); | | X_53 := sql.delta(X_41,X_44,X_45,X_8); | | X_55 := algebra.leftfetchjoin(X_39,X_53); | | X_69 := mat.packIncrement(X_54,2); | | X_10 := mat.packIncrement(X_69,X_55); | | X_46:bat[:oid,:int] := sql.bind(X_2,"genomics","echoli","pos",0,0,2); | | (X_48:bat[:oid,:oid] ,X_49:bat[:oid,:int] ) := sql.bind(X_2,"genomics","echoli","pos",2,0,2); | | X_56 := sql.delta(X_46,X_48,X_49); | | X_58 := algebra.leftfetchjoin(X_37,X_56); | | (X_60,X_61,X_62) := group.subgroupdone(X_58); | | X_63 := algebra.leftfetchjoin(X_61,X_58); | | X_47:bat[:oid,:int] := sql.bind(X_2,"genomics","echoli","pos",0,1,2); | | (X_50:bat[:oid,:oid] ,X_51:bat[:oid,:int] ) := sql.bind(X_2,"genomics","echoli","pos",2,1,2); | | X_12 := sql.bind(X_2,"genomics","echoli","pos",1); | | X_57 := sql.delta(X_47,X_50,X_51,X_12); | | X_59 := algebra.leftfetchjoin(X_39,X_57); | | (X_64,X_65,X_66) := group.subgroupdone(X_59); | | X_67 := algebra.leftfetchjoin(X_65,X_59); | | X_72 := mat.packIncrement(X_63,2); | | X_13 := mat.packIncrement(X_72,X_67); | | (X_14,r1_27,X_68) := group.subgroupdone(X_13); | | X_16:bat[:any,:str] := genomics.subsimple_genotype(X_10,X_14,r1_27,true); | | X_18 := sql.resultSet(1,1,X_16); | | sql.rsColumn(X_18,"genomics.echoli","L1","clob",1,0,X_16); | | X_22 := io.stdout(); | | sql.exportResult(X_22,X_18); | | end s9_1; | +----------------------------------------------------------------------------------------------------+ 37 tuples (1.109ms) sql>set optimizer='no_mitosis_pipe'; operation successful (0.304ms) sql>select optimizer; +-----------------+ | single_value | +=================+ | no_mitosis_pipe | +-----------------+ 1 tuple (0.338ms) sql>explain select median(base) from genomics.echoli group by pos; +-------------------------------------------------------------------+ | mal | +===================================================================+ | function user.s11_1{autoCommit=true}():void; | | X_2 := sql.mvc(); | | X_3:bat[:oid,:oid] := sql.tid(X_2,"genomics","echoli"); | | X_6 := sql.bind(X_2,"genomics","echoli","base",0); | | (X_9,r1_9) := sql.bind(X_2,"genomics","echoli","base",2); | | X_12 := sql.bind(X_2,"genomics","echoli","base",1); | | X_14 := sql.delta(X_6,X_9,r1_9,X_12); | | X_15 := algebra.leftfetchjoin(X_3,X_14); | | X_16 := batcalc.bte(X_15); | | X_17 := sql.bind(X_2,"genomics","echoli","pos",0); | | (X_19,r1_21) := sql.bind(X_2,"genomics","echoli","pos",2); | | X_21 := sql.bind(X_2,"genomics","echoli","pos",1); | | X_22 := sql.delta(X_17,X_19,r1_21,X_21); | | X_23 := algebra.leftfetchjoin(X_3,X_22); | | (X_24,r1_28,r2_28) := group.subgroupdone(X_23); | | X_27:bat[:oid,:bte] := aggr.submedian(X_16,X_24,r1_28,true); | | X_29 := sql.resultSet(1,1,X_27); | | sql.rsColumn(X_29,"genomics.","L1","tinyint",8,0,X_27); | | X_34 := io.stdout(); | | sql.exportResult(X_34,X_29); | | end s11_1; | +-------------------------------------------------------------------+ 21 tuples (0.726ms) sql>explain select simple_genotype(base) from genomics.echoli group by pos; +--------------------------------------------------------------------------------+ | mal | +================================================================================+ | function user.s12_1{autoCommit=true}():void; | | X_2 := sql.mvc(); | | X_3:bat[:oid,:oid] := sql.tid(X_2,"genomics","echoli"); | | X_6 := sql.bind(X_2,"genomics","echoli","base",0); | | (X_9,r1_9) := sql.bind(X_2,"genomics","echoli","base",2); | | X_12 := sql.bind(X_2,"genomics","echoli","base",1); | | X_14 := sql.delta(X_6,X_9,r1_9,X_12); | | X_15 := algebra.leftfetchjoin(X_3,X_14); | | X_16 := sql.bind(X_2,"genomics","echoli","pos",0); | | (X_18,r1_20) := sql.bind(X_2,"genomics","echoli","pos",2); | | X_20 := sql.bind(X_2,"genomics","echoli","pos",1); | | X_21 := sql.delta(X_16,X_18,r1_20,X_20); | | X_22 := algebra.leftfetchjoin(X_3,X_21); | | (X_23,r1_27,r2_27) := group.subgroupdone(X_22); | | X_26:bat[:any,:str] := genomics.subsimple_genotype(X_15,X_23,r1_27,true); | | X_28 := sql.resultSet(1,1,X_26); | | sql.rsColumn(X_28,"genomics.echoli","L1","clob",1,0,X_26); | | X_32 := io.stdout(); | | sql.exportResult(X_32,X_28); | | end s12_1; | +--------------------------------------------------------------------------------+ 20 tuples (0.766ms)