Re: b and g must be aligned

12 Aug 2013


      And here's the explain:

sql>explain SELECT ts_day, hllagg(h_visitors_register) FROM 
wa_sapo_pt_audience.kpi_2013_07 WHERE ts>=1373410800000 AND 
ts<=1374706799000 GROUP BY ts_day;
+-------------------------------------------------------------------------------------------------------------------------------------+
| mal |
+=====================================================================================================================================+
| function user.s2_1{autoCommit=true}(A0:lng,A1:lng):void; |
|     X_18 := nil:bat[:oid,:lng]; |
|     X_27:bat[:oid,:str]  := nil:bat[:oid,:str]; |
| barrier X_157 := language.dataflow(); |
|     X_4 := sql.mvc(); |
|     X_63:bat[:oid,:lng]  := 
sql.bind(X_4,"wa_sapo_pt_audience","kpi_2013_07","ts",0,0,4); |
|     X_56:bat[:oid,:oid]  := 
sql.tid(X_4,"wa_sapo_pt_audience","kpi_2013_07",0,4); |
|     X_104 := algebra.subselect(X_63,X_56,A0,A1,true,true,false); |
|     (X_67:bat[:oid,:oid] ,X_68:bat[:oid,:lng] ) := 
sql.bind(X_4,"wa_sapo_pt_audience","kpi_2013_07","ts",2,0,4); |
|     X_108 := algebra.subselect(X_68,A0,A1,true,true,false); |
|     X_112 := sql.subdelta(X_104,X_56,X_67,X_108); |
|     X_75:bat[:oid,:lng]  := 
sql.bind(X_4,"wa_sapo_pt_audience","kpi_2013_07","ts_day",0,0,4); |
|     (X_79:bat[:oid,:oid] ,X_80:bat[:oid,:lng] ) := 
sql.bind(X_4,"wa_sapo_pt_audience","kpi_2013_07","ts_day",2,0,4); |
|     X_120 := sql.projectdelta(X_112,X_75,X_79,X_80); |
|     (X_124,X_125,X_126) := group.subgroupdone(X_120); |
|     X_127 := algebra.leftfetchjoin(X_125,X_120); |
|     X_64:bat[:oid,:lng]  := 
sql.bind(X_4,"wa_sapo_pt_audience","kpi_2013_07","ts",0,1,4); |
|     X_58:bat[:oid,:oid]  := 
sql.tid(X_4,"wa_sapo_pt_audience","kpi_2013_07",1,4); |
|     X_105 := algebra.subselect(X_64,X_58,A0,A1,true,true,false); |
|     (X_69:bat[:oid,:oid] ,X_70:bat[:oid,:lng] ) := 
sql.bind(X_4,"wa_sapo_pt_audience","kpi_2013_07","ts",2,1,4); |
|     X_109 := algebra.subselect(X_70,A0,A1,true,true,false); |
|     X_113 := sql.subdelta(X_105,X_58,X_69,X_109); |
|     X_76:bat[:oid,:lng]  := 
sql.bind(X_4,"wa_sapo_pt_audience","kpi_2013_07","ts_day",0,1,4); |
|     (X_81:bat[:oid,:oid] ,X_82:bat[:oid,:lng] ) := 
sql.bind(X_4,"wa_sapo_pt_audience","kpi_2013_07","ts_day",2,1,4); |
|     X_121 := sql.projectdelta(X_113,X_76,X_81,X_82); |
|     (X_128,X_129,X_130) := group.subgroupdone(X_121); |
|     X_131 := algebra.leftfetchjoin(X_129,X_121); |
|     X_65:bat[:oid,:lng]  := 
sql.bind(X_4,"wa_sapo_pt_audience","kpi_2013_07","ts",0,2,4); |
|     X_60:bat[:oid,:oid]  := 
sql.tid(X_4,"wa_sapo_pt_audience","kpi_2013_07",2,4); |
|     X_106 := algebra.subselect(X_65,X_60,A0,A1,true,true,false); |
|     (X_71:bat[:oid,:oid] ,X_72:bat[:oid,:lng] ) := 
sql.bind(X_4,"wa_sapo_pt_audience","kpi_2013_07","ts",2,2,4); |
|     X_110 := algebra.subselect(X_72,A0,A1,true,true,false); |
|     X_114 := sql.subdelta(X_106,X_60,X_71,X_110); |
|     X_77:bat[:oid,:lng]  := 
sql.bind(X_4,"wa_sapo_pt_audience","kpi_2013_07","ts_day",0,2,4); |
|     (X_83:bat[:oid,:oid] ,X_84:bat[:oid,:lng] ) := 
sql.bind(X_4,"wa_sapo_pt_audience","kpi_2013_07","ts_day",2,2,4); |
|     X_122 := sql.projectdelta(X_114,X_77,X_83,X_84); |
|     (X_132,X_133,X_134) := group.subgroupdone(X_122); |
|     X_135 := algebra.leftfetchjoin(X_133,X_122); |
|     X_66:bat[:oid,:lng]  := 
sql.bind(X_4,"wa_sapo_pt_audience","kpi_2013_07","ts",0,3,4); |
|     X_62:bat[:oid,:oid]  := 
sql.tid(X_4,"wa_sapo_pt_audience","kpi_2013_07",3,4); |
|     X_107 := algebra.subselect(X_66,X_62,A0,A1,true,true,false); |
|     (X_73:bat[:oid,:oid] ,X_74:bat[:oid,:lng] ) := 
sql.bind(X_4,"wa_sapo_pt_audience","kpi_2013_07","ts",2,3,4); |
|     X_111 := algebra.subselect(X_74,A0,A1,true,true,false); |
|     X_10 := sql.bind(X_4,"wa_sapo_pt_audience","kpi_2013_07","ts",1); |
|     X_53 := algebra.subselect(X_10,X_62,A0,A1,true,true,false); |
|     X_115 := sql.subdelta(X_107,X_62,X_73,X_111,X_53); |
|     X_78:bat[:oid,:lng]  := 
sql.bind(X_4,"wa_sapo_pt_audience","kpi_2013_07","ts_day",0,3,4); |
|     (X_85:bat[:oid,:oid] ,X_86:bat[:oid,:lng] ) := 
sql.bind(X_4,"wa_sapo_pt_audience","kpi_2013_07","ts_day",2,3,4); |
|     X_14 := 
sql.bind(X_4,"wa_sapo_pt_audience","kpi_2013_07","ts_day",1); |
|     X_123 := sql.projectdelta(X_115,X_78,X_85,X_86,X_14); |
|     (X_136,X_137,X_138) := group.subgroupdone(X_123); |
|     X_139 := algebra.leftfetchjoin(X_137,X_123); |
|     X_149 := mat.packIncrement(X_127,4); |
|     X_150 := mat.packIncrement(X_149,X_131); |
|     X_151 := mat.packIncrement(X_150,X_135); |
|     X_15 := mat.packIncrement(X_151,X_139); |
|     (X_16,r1_34,X_140) := group.subgroupdone(X_15); |
|     X_18 := algebra.leftfetchjoin(r1_34,X_15); |
|     X_89:bat[:oid,:str]  := 
sql.bind(X_4,"wa_sapo_pt_audience","kpi_2013_07","h_visitors_register",0,0,4); 
|
|     (X_96:bat[:oid,:oid] ,X_97:bat[:oid,:str] ) := 
sql.bind(X_4,"wa_sapo_pt_audience","kpi_2013_07","h_visitors_register",2,0,4); 
|
|     X_145 := sql.projectdelta(X_112,X_89,X_96,X_97); |
|     X_91:bat[:oid,:str]  := 
sql.bind(X_4,"wa_sapo_pt_audience","kpi_2013_07","h_visitors_register",0,1,4); 
|
|     (X_98:bat[:oid,:oid] ,X_99:bat[:oid,:str] ) := 
sql.bind(X_4,"wa_sapo_pt_audience","kpi_2013_07","h_visitors_register",2,1,4); 
|
|     X_146 := sql.projectdelta(X_113,X_91,X_98,X_99); |
|     X_93:bat[:oid,:str]  := 
sql.bind(X_4,"wa_sapo_pt_audience","kpi_2013_07","h_visitors_register",0,2,4); 
|
|     (X_100:bat[:oid,:oid] ,X_101:bat[:oid,:str] ) := 
sql.bind(X_4,"wa_sapo_pt_audience","kpi_2013_07","h_visitors_register",2,2,4); 
|
|     X_147 := sql.projectdelta(X_114,X_93,X_100,X_101); |
|     X_95:bat[:oid,:str]  := 
sql.bind(X_4,"wa_sapo_pt_audience","kpi_2013_07","h_visitors_register",0,3,4); 
|
|     (X_102:bat[:oid,:oid] ,X_103:bat[:oid,:str] ) := 
sql.bind(X_4,"wa_sapo_pt_audience","kpi_2013_07","h_visitors_register",2,3,4); 
|
|     X_24 := 
sql.bind(X_4,"wa_sapo_pt_audience","kpi_2013_07","h_visitors_register",1); |
|     X_148 := sql.projectdelta(X_115,X_95,X_102,X_103,X_24); |
|     X_153 := mat.packIncrement(X_145,4); |
|     X_154 := mat.packIncrement(X_153,X_146); |
|     X_155 := mat.packIncrement(X_154,X_147); |
|     X_26 := mat.packIncrement(X_155,X_148); |
|     X_27:bat[:oid,:str]  := batudf.subhllagg(X_26,X_16,r1_34,true); |
| language.pass(X_56); |
| language.pass(X_120); |
| language.pass(X_58); |
| language.pass(X_121); |
| language.pass(X_60); |
| language.pass(X_122); |
| language.pass(X_62); |
| language.pass(X_123); |
| language.pass(X_15); |
| language.pass(X_112); |
| language.pass(X_113); |
| language.pass(X_114); |
| language.pass(X_115); |
| language.pass(r1_34); |
| exit X_157; |
|     X_152:bat[:oid,:lng]  := nil:bat[:oid,:lng]; |
|     X_156:bat[:oid,:str]  := nil:bat[:oid,:str]; |
|     X_30 := sql.resultSet(2,1,X_18); |
| 
sql.rsColumn(X_30,"wa_sapo_pt_audience.kpi_2013_07","ts_day","bigint",64,0,X_18); 
|
| 
sql.rsColumn(X_30,"wa_sapo_pt_audience.kpi_2013_07","L1","clob",1881,0,X_27); 
|
|     X_39 := io.stdout(); |
| sql.exportResult(X_39,X_30); |
| end s2_1; |
+-------------------------------------------------------------------------------------------------------------------------------------+

Re: b and g must be aligned

Miguel Ping