{"action":"created","comment":{"url":"https://api.github.com/repos/greenplum-db/gporca/pulls/comments/198696883","pull_request_review_id":132674355,"id":198696883,"node_id":"MDI0OlB1bGxSZXF1ZXN0UmV2aWV3Q29tbWVudDE5ODY5Njg4Mw==","diff_hunk":"@@ -14867,1651 +14867,1651 @@ with results as\n         </dxl:LogicalCTEAnchor>\n       </dxl:LogicalCTEAnchor>\n     </dxl:Query>\n-    <dxl:Plan Id=\"0\" SpaceSize=\"4330549304064\">\n-      <dxl:Result>\n-        <dxl:Properties>\n-          <dxl:Cost StartupCost=\"0\" TotalCost=\"21949.250066\" Rows=\"20.062500\" Width=\"36\"/>\n-        </dxl:Properties>\n-        <dxl:ProjList>\n-          <dxl:ProjElem ColId=\"842\" Alias=\"total_sum\">\n-            <dxl:Ident ColId=\"842\" ColName=\"sum\" TypeMdid=\"0.1700.1.0\"/>\n-          </dxl:ProjElem>\n-          <dxl:ProjElem ColId=\"843\" Alias=\"s_state\">\n-            <dxl:Ident ColId=\"843\" ColName=\"s_state\" TypeMdid=\"0.1042.1.0\"/>\n-          </dxl:ProjElem>\n-          <dxl:ProjElem ColId=\"844\" Alias=\"s_county\">\n-            <dxl:Ident ColId=\"844\" ColName=\"s_county\" TypeMdid=\"0.1043.1.0\"/>\n-          </dxl:ProjElem>\n-          <dxl:ProjElem ColId=\"847\" Alias=\"lochierarchy\">\n-            <dxl:Ident ColId=\"847\" ColName=\"lochierarchy\" TypeMdid=\"0.23.1.0\"/>\n-          </dxl:ProjElem>\n-          <dxl:ProjElem ColId=\"1478\" Alias=\"rank_within_parent\">\n-            <dxl:Ident ColId=\"1478\" ColName=\"rank\" TypeMdid=\"0.20.1.0\"/>\n-          </dxl:ProjElem>\n-        </dxl:ProjList>\n-        <dxl:Filter/>\n-        <dxl:OneTimeFilter/>\n-        <dxl:GatherMotion InputSegments=\"0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31\" OutputSegments=\"-1\">\n-          <dxl:Properties>\n-            <dxl:Cost StartupCost=\"0\" TotalCost=\"21949.250066\" Rows=\"20.062500\" Width=\"36\"/>\n-          </dxl:Properties>\n-          <dxl:ProjList>\n-            <dxl:ProjElem ColId=\"842\" Alias=\"sum\">\n-              <dxl:Ident ColId=\"842\" ColName=\"sum\" TypeMdid=\"0.1700.1.0\"/>\n-            </dxl:ProjElem>\n-            <dxl:ProjElem ColId=\"843\" Alias=\"s_state\">\n-              <dxl:Ident ColId=\"843\" ColName=\"s_state\" TypeMdid=\"0.1042.1.0\"/>\n-            </dxl:ProjElem>\n-            <dxl:ProjElem ColId=\"844\" Alias=\"s_county\">\n-              <dxl:Ident ColId=\"844\" ColName=\"s_county\" TypeMdid=\"0.1043.1.0\"/>\n-            </dxl:ProjElem>\n-            <dxl:ProjElem ColId=\"847\" Alias=\"lochierarchy\">\n-              <dxl:Ident ColId=\"847\" ColName=\"lochierarchy\" TypeMdid=\"0.23.1.0\"/>\n-            </dxl:ProjElem>\n-            <dxl:ProjElem ColId=\"1478\" Alias=\"rank\">\n-              <dxl:Ident ColId=\"1478\" ColName=\"rank\" TypeMdid=\"0.20.1.0\"/>\n-            </dxl:ProjElem>\n-            <dxl:ProjElem ColId=\"1479\" Alias=\"?column?\">\n-              <dxl:Ident ColId=\"1479\" ColName=\"?column?\" TypeMdid=\"0.1042.1.0\"/>\n-            </dxl:ProjElem>\n-          </dxl:ProjList>\n-          <dxl:Filter/>\n-          <dxl:SortingColumnList>\n-            <dxl:SortingColumn ColId=\"847\" SortOperatorMdid=\"0.521.1.0\" SortOperatorName=\"&gt;\" SortNullsFirst=\"false\"/>\n-            <dxl:SortingColumn ColId=\"1479\" SortOperatorMdid=\"0.1058.1.0\" SortOperatorName=\"&lt;\" SortNullsFirst=\"false\"/>\n-            <dxl:SortingColumn ColId=\"1478\" SortOperatorMdid=\"0.412.1.0\" SortOperatorName=\"&lt;\" SortNullsFirst=\"false\"/>\n-          </dxl:SortingColumnList>\n-          <dxl:Sort SortDiscardDuplicates=\"false\">\n-            <dxl:Properties>\n-              <dxl:Cost StartupCost=\"0\" TotalCost=\"21949.247997\" Rows=\"20.062500\" Width=\"44\"/>\n-            </dxl:Properties>\n-            <dxl:ProjList>\n-              <dxl:ProjElem ColId=\"842\" Alias=\"sum\">\n-                <dxl:Ident ColId=\"842\" ColName=\"sum\" TypeMdid=\"0.1700.1.0\"/>\n-              </dxl:ProjElem>\n-              <dxl:ProjElem ColId=\"843\" Alias=\"s_state\">\n-                <dxl:Ident ColId=\"843\" ColName=\"s_state\" TypeMdid=\"0.1042.1.0\"/>\n-              </dxl:ProjElem>\n-              <dxl:ProjElem ColId=\"844\" Alias=\"s_county\">\n-                <dxl:Ident ColId=\"844\" ColName=\"s_county\" TypeMdid=\"0.1043.1.0\"/>\n-              </dxl:ProjElem>\n-              <dxl:ProjElem ColId=\"847\" Alias=\"lochierarchy\">\n-                <dxl:Ident ColId=\"847\" ColName=\"lochierarchy\" TypeMdid=\"0.23.1.0\"/>\n-              </dxl:ProjElem>\n-              <dxl:ProjElem ColId=\"1478\" Alias=\"rank\">\n-                <dxl:Ident ColId=\"1478\" ColName=\"rank\" TypeMdid=\"0.20.1.0\"/>\n-              </dxl:ProjElem>\n-              <dxl:ProjElem ColId=\"1479\" Alias=\"?column?\">\n-                <dxl:Ident ColId=\"1479\" ColName=\"?column?\" TypeMdid=\"0.1042.1.0\"/>\n-              </dxl:ProjElem>\n-            </dxl:ProjList>\n-            <dxl:Filter/>\n-            <dxl:SortingColumnList>\n-              <dxl:SortingColumn ColId=\"847\" SortOperatorMdid=\"0.521.1.0\" SortOperatorName=\"&gt;\" SortNullsFirst=\"false\"/>\n-              <dxl:SortingColumn ColId=\"1479\" SortOperatorMdid=\"0.1058.1.0\" SortOperatorName=\"&lt;\" SortNullsFirst=\"false\"/>\n-              <dxl:SortingColumn ColId=\"1478\" SortOperatorMdid=\"0.412.1.0\" SortOperatorName=\"&lt;\" SortNullsFirst=\"false\"/>\n-            </dxl:SortingColumnList>\n-            <dxl:LimitCount/>\n-            <dxl:LimitOffset/>\n-            <dxl:Sequence>\n-              <dxl:Properties>\n-                <dxl:Cost StartupCost=\"0\" TotalCost=\"21949.247997\" Rows=\"20.062500\" Width=\"44\"/>\n-              </dxl:Properties>\n-              <dxl:ProjList>\n-                <dxl:ProjElem ColId=\"842\" Alias=\"sum\">\n-                  <dxl:Ident ColId=\"842\" ColName=\"sum\" TypeMdid=\"0.1700.1.0\"/>\n-                </dxl:ProjElem>\n-                <dxl:ProjElem ColId=\"843\" Alias=\"s_state\">\n-                  <dxl:Ident ColId=\"843\" ColName=\"s_state\" TypeMdid=\"0.1042.1.0\"/>\n-                </dxl:ProjElem>\n-                <dxl:ProjElem ColId=\"844\" Alias=\"s_county\">\n-                  <dxl:Ident ColId=\"844\" ColName=\"s_county\" TypeMdid=\"0.1043.1.0\"/>\n-                </dxl:ProjElem>\n-                <dxl:ProjElem ColId=\"847\" Alias=\"lochierarchy\">\n-                  <dxl:Ident ColId=\"847\" ColName=\"lochierarchy\" TypeMdid=\"0.23.1.0\"/>\n-                </dxl:ProjElem>\n-                <dxl:ProjElem ColId=\"1478\" Alias=\"rank\">\n-                  <dxl:Ident ColId=\"1478\" ColName=\"rank\" TypeMdid=\"0.20.1.0\"/>\n-                </dxl:ProjElem>\n-                <dxl:ProjElem ColId=\"1479\" Alias=\"?column?\">\n-                  <dxl:Ident ColId=\"1479\" ColName=\"?column?\" TypeMdid=\"0.1042.1.0\"/>\n-                </dxl:ProjElem>\n-              </dxl:ProjList>\n-              <dxl:CTEProducer CTEId=\"0\" Columns=\"204,89,88,205,206\">\n-                <dxl:Properties>\n-                  <dxl:Cost StartupCost=\"0\" TotalCost=\"20656.247418\" Rows=\"14.062500\" Width=\"1\"/>\n-                </dxl:Properties>\n-                <dxl:ProjList>\n-                  <dxl:ProjElem ColId=\"204\" Alias=\"sum\">\n-                    <dxl:Ident ColId=\"204\" ColName=\"sum\" TypeMdid=\"0.1700.1.0\"/>\n-                  </dxl:ProjElem>\n-                  <dxl:ProjElem ColId=\"89\" Alias=\"s_state\">\n-                    <dxl:Ident ColId=\"89\" ColName=\"s_state\" TypeMdid=\"0.1042.1.0\"/>\n-                  </dxl:ProjElem>\n-                  <dxl:ProjElem ColId=\"88\" Alias=\"s_county\">\n-                    <dxl:Ident ColId=\"88\" ColName=\"s_county\" TypeMdid=\"0.1043.1.0\"/>\n-                  </dxl:ProjElem>\n-                  <dxl:ProjElem ColId=\"205\" Alias=\"gstate\">\n-                    <dxl:Ident ColId=\"205\" ColName=\"gstate\" TypeMdid=\"0.23.1.0\"/>\n-                  </dxl:ProjElem>\n-                  <dxl:ProjElem ColId=\"206\" Alias=\"g_county\">\n-                    <dxl:Ident ColId=\"206\" ColName=\"g_county\" TypeMdid=\"0.23.1.0\"/>\n-                  </dxl:ProjElem>\n-                </dxl:ProjList>\n-                <dxl:Result>\n-                  <dxl:Properties>\n-                    <dxl:Cost StartupCost=\"0\" TotalCost=\"20656.247418\" Rows=\"14.062500\" Width=\"32\"/>\n-                  </dxl:Properties>\n-                  <dxl:ProjList>\n-                    <dxl:ProjElem ColId=\"204\" Alias=\"sum\">\n-                      <dxl:Ident ColId=\"204\" ColName=\"sum\" TypeMdid=\"0.1700.1.0\"/>\n-                    </dxl:ProjElem>\n-                    <dxl:ProjElem ColId=\"89\" Alias=\"s_state\">\n-                      <dxl:Ident ColId=\"89\" ColName=\"s_state\" TypeMdid=\"0.1042.1.0\"/>\n-                    </dxl:ProjElem>\n-                    <dxl:ProjElem ColId=\"88\" Alias=\"s_county\">\n-                      <dxl:Ident ColId=\"88\" ColName=\"s_county\" TypeMdid=\"0.1043.1.0\"/>\n-                    </dxl:ProjElem>\n-                    <dxl:ProjElem ColId=\"205\" Alias=\"gstate\">\n-                      <dxl:ConstValue TypeMdid=\"0.23.1.0\" IsNull=\"false\" IsByValue=\"true\" Value=\"0\"/>\n-                    </dxl:ProjElem>\n-                    <dxl:ProjElem ColId=\"206\" Alias=\"g_county\">\n-                      <dxl:ConstValue TypeMdid=\"0.23.1.0\" IsNull=\"false\" IsByValue=\"true\" Value=\"0\"/>\n-                    </dxl:ProjElem>\n-                  </dxl:ProjList>\n-                  <dxl:Filter/>\n-                  <dxl:OneTimeFilter/>\n-                  <dxl:Aggregate AggregationStrategy=\"Sorted\" StreamSafe=\"false\">\n-                    <dxl:Properties>\n-                      <dxl:Cost StartupCost=\"0\" TotalCost=\"20656.247404\" Rows=\"14.062500\" Width=\"26\"/>\n-                    </dxl:Properties>\n-                    <dxl:GroupingColumns>\n-                      <dxl:GroupingColumn ColId=\"89\"/>\n-                      <dxl:GroupingColumn ColId=\"88\"/>\n-                    </dxl:GroupingColumns>\n-                    <dxl:ProjList>\n-                      <dxl:ProjElem ColId=\"204\" Alias=\"sum\">\n-                        <dxl:AggFunc AggMdid=\"0.2114.1.0\" AggDistinct=\"false\" AggStage=\"Final\">\n-                          <dxl:Ident ColId=\"1503\" ColName=\"ColRef_1503\" TypeMdid=\"0.1700.1.0\"/>\n-                        </dxl:AggFunc>\n-                      </dxl:ProjElem>\n-                      <dxl:ProjElem ColId=\"88\" Alias=\"s_county\">\n-                        <dxl:Ident ColId=\"88\" ColName=\"s_county\" TypeMdid=\"0.1043.1.0\"/>\n-                      </dxl:ProjElem>\n-                      <dxl:ProjElem ColId=\"89\" Alias=\"s_state\">\n-                        <dxl:Ident ColId=\"89\" ColName=\"s_state\" TypeMdid=\"0.1042.1.0\"/>\n-                      </dxl:ProjElem>\n-                    </dxl:ProjList>\n-                    <dxl:Filter/>\n-                    <dxl:Sort SortDiscardDuplicates=\"false\">\n-                      <dxl:Properties>\n-                        <dxl:Cost StartupCost=\"0\" TotalCost=\"20656.247371\" Rows=\"14.062500\" Width=\"26\"/>\n-                      </dxl:Properties>\n-                      <dxl:ProjList>\n-                        <dxl:ProjElem ColId=\"88\" Alias=\"s_county\">\n-                          <dxl:Ident ColId=\"88\" ColName=\"s_county\" TypeMdid=\"0.1043.1.0\"/>\n-                        </dxl:ProjElem>\n-                        <dxl:ProjElem ColId=\"89\" Alias=\"s_state\">\n-                          <dxl:Ident ColId=\"89\" ColName=\"s_state\" TypeMdid=\"0.1042.1.0\"/>\n-                        </dxl:ProjElem>\n-                        <dxl:ProjElem ColId=\"1503\" Alias=\"ColRef_1503\">\n-                          <dxl:Ident ColId=\"1503\" ColName=\"ColRef_1503\" TypeMdid=\"0.1700.1.0\"/>\n-                        </dxl:ProjElem>\n-                      </dxl:ProjList>\n-                      <dxl:Filter/>\n-                      <dxl:SortingColumnList>\n-                        <dxl:SortingColumn ColId=\"89\" SortOperatorMdid=\"0.1058.1.0\" SortOperatorName=\"&lt;\" SortNullsFirst=\"false\"/>\n-                        <dxl:SortingColumn ColId=\"88\" SortOperatorMdid=\"0.664.1.0\" SortOperatorName=\"&lt;\" SortNullsFirst=\"false\"/>\n-                      </dxl:SortingColumnList>\n-                      <dxl:LimitCount/>\n-                      <dxl:LimitOffset/>\n-                      <dxl:RedistributeMotion InputSegments=\"0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31\" OutputSegments=\"0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31\">\n-                        <dxl:Properties>\n-                          <dxl:Cost StartupCost=\"0\" TotalCost=\"20656.247371\" Rows=\"14.062500\" Width=\"26\"/>\n-                        </dxl:Properties>\n-                        <dxl:ProjList>\n-                          <dxl:ProjElem ColId=\"88\" Alias=\"s_county\">\n-                            <dxl:Ident ColId=\"88\" ColName=\"s_county\" TypeMdid=\"0.1043.1.0\"/>\n-                          </dxl:ProjElem>\n-                          <dxl:ProjElem ColId=\"89\" Alias=\"s_state\">\n-                            <dxl:Ident ColId=\"89\" ColName=\"s_state\" TypeMdid=\"0.1042.1.0\"/>\n-                          </dxl:ProjElem>\n-                          <dxl:ProjElem ColId=\"1503\" Alias=\"ColRef_1503\">\n-                            <dxl:Ident ColId=\"1503\" ColName=\"ColRef_1503\" TypeMdid=\"0.1700.1.0\"/>\n-                          </dxl:ProjElem>\n-                        </dxl:ProjList>\n-                        <dxl:Filter/>\n-                        <dxl:SortingColumnList/>\n-                        <dxl:HashExprList>\n-                          <dxl:HashExpr TypeMdid=\"0.1042.1.0\">\n-                            <dxl:Ident ColId=\"89\" ColName=\"s_state\" TypeMdid=\"0.1042.1.0\"/>\n-                          </dxl:HashExpr>\n-                          <dxl:HashExpr TypeMdid=\"0.1043.1.0\">\n-                            <dxl:Ident ColId=\"88\" ColName=\"s_county\" TypeMdid=\"0.1043.1.0\"/>\n-                          </dxl:HashExpr>\n-                        </dxl:HashExprList>\n-                        <dxl:Result>\n-                          <dxl:Properties>\n-                            <dxl:Cost StartupCost=\"0\" TotalCost=\"20656.247324\" Rows=\"14.062500\" Width=\"26\"/>\n-                          </dxl:Properties>\n-                          <dxl:ProjList>\n-                            <dxl:ProjElem ColId=\"88\" Alias=\"s_county\">\n-                              <dxl:Ident ColId=\"88\" ColName=\"s_county\" TypeMdid=\"0.1043.1.0\"/>\n-                            </dxl:ProjElem>\n-                            <dxl:ProjElem ColId=\"89\" Alias=\"s_state\">\n-                              <dxl:Ident ColId=\"89\" ColName=\"s_state\" TypeMdid=\"0.1042.1.0\"/>\n-                            </dxl:ProjElem>\n-                            <dxl:ProjElem ColId=\"1503\" Alias=\"ColRef_1503\">\n-                              <dxl:Ident ColId=\"1503\" ColName=\"ColRef_1503\" TypeMdid=\"0.1700.1.0\"/>\n-                            </dxl:ProjElem>\n-                          </dxl:ProjList>\n-                          <dxl:Filter/>\n-                          <dxl:OneTimeFilter/>\n-                          <dxl:Aggregate AggregationStrategy=\"Hashed\" StreamSafe=\"true\">\n-                            <dxl:Properties>\n-                              <dxl:Cost StartupCost=\"0\" TotalCost=\"20656.247324\" Rows=\"14.062500\" Width=\"26\"/>\n-                            </dxl:Properties>\n-                            <dxl:GroupingColumns>\n-                              <dxl:GroupingColumn ColId=\"89\"/>\n-                              <dxl:GroupingColumn ColId=\"88\"/>\n-                            </dxl:GroupingColumns>\n-                            <dxl:ProjList>\n-                              <dxl:ProjElem ColId=\"1503\" Alias=\"ColRef_1503\">\n-                                <dxl:AggFunc AggMdid=\"0.2114.1.0\" AggDistinct=\"false\" AggStage=\"Partial\">\n-                                  <dxl:Ident ColId=\"22\" ColName=\"ss_net_profit\" TypeMdid=\"0.1700.1.0\"/>\n-                                </dxl:AggFunc>\n-                              </dxl:ProjElem>\n-                              <dxl:ProjElem ColId=\"88\" Alias=\"s_county\">\n-                                <dxl:Ident ColId=\"88\" ColName=\"s_county\" TypeMdid=\"0.1043.1.0\"/>\n-                              </dxl:ProjElem>\n-                              <dxl:ProjElem ColId=\"89\" Alias=\"s_state\">\n-                                <dxl:Ident ColId=\"89\" ColName=\"s_state\" TypeMdid=\"0.1042.1.0\"/>\n-                              </dxl:ProjElem>\n-                            </dxl:ProjList>\n-                            <dxl:Filter/>\n-                            <dxl:HashJoin JoinType=\"Inner\">\n-                              <dxl:Properties>\n-                                <dxl:Cost StartupCost=\"0\" TotalCost=\"20119.800634\" Rows=\"67819601.064540\" Width=\"26\"/>\n-                              </dxl:Properties>\n-                              <dxl:ProjList>\n-                                <dxl:ProjElem ColId=\"22\" Alias=\"ss_net_profit\">\n-                                  <dxl:Ident ColId=\"22\" ColName=\"ss_net_profit\" TypeMdid=\"0.1700.1.0\"/>\n-                                </dxl:ProjElem>\n-                                <dxl:ProjElem ColId=\"88\" Alias=\"s_county\">\n-                                  <dxl:Ident ColId=\"88\" ColName=\"s_county\" TypeMdid=\"0.1043.1.0\"/>\n-                                </dxl:ProjElem>\n-                                <dxl:ProjElem ColId=\"89\" Alias=\"s_state\">\n-                                  <dxl:Ident ColId=\"89\" ColName=\"s_state\" TypeMdid=\"0.1042.1.0\"/>\n-                                </dxl:ProjElem>\n-                              </dxl:ProjList>\n-                              <dxl:Filter/>\n-                              <dxl:JoinFilter/>\n-                              <dxl:HashCondList>\n-                                <dxl:Comparison ComparisonOperator=\"=\" OperatorMdid=\"0.96.1.0\">\n-                                  <dxl:Ident ColId=\"7\" ColName=\"ss_store_sk\" TypeMdid=\"0.23.1.0\"/>\n-                                  <dxl:Ident ColId=\"65\" ColName=\"s_store_sk\" TypeMdid=\"0.23.1.0\"/>\n-                                </dxl:Comparison>\n-                              </dxl:HashCondList>\n-                              <dxl:HashJoin JoinType=\"Inner\">\n-                                <dxl:Properties>\n-                                  <dxl:Cost StartupCost=\"0\" TotalCost=\"8141.454737\" Rows=\"169549002.661349\" Width=\"12\"/>\n-                                </dxl:Properties>\n-                                <dxl:ProjList>\n-                                  <dxl:ProjElem ColId=\"7\" Alias=\"ss_store_sk\">\n-                                    <dxl:Ident ColId=\"7\" ColName=\"ss_store_sk\" TypeMdid=\"0.23.1.0\"/>\n-                                  </dxl:ProjElem>\n-                                  <dxl:ProjElem ColId=\"22\" Alias=\"ss_net_profit\">\n-                                    <dxl:Ident ColId=\"22\" ColName=\"ss_net_profit\" TypeMdid=\"0.1700.1.0\"/>\n-                                  </dxl:ProjElem>\n-                                </dxl:ProjList>\n-                                <dxl:Filter/>\n-                                <dxl:JoinFilter/>\n-                                <dxl:HashCondList>\n-                                  <dxl:Comparison ComparisonOperator=\"=\" OperatorMdid=\"0.96.1.0\">\n-                                    <dxl:Ident ColId=\"0\" ColName=\"ss_sold_date_sk\" TypeMdid=\"0.23.1.0\"/>\n-                                    <dxl:Ident ColId=\"30\" ColName=\"d_date_sk\" TypeMdid=\"0.23.1.0\"/>\n-                                  </dxl:Comparison>\n-                                </dxl:HashCondList>\n-                                <dxl:TableScan>\n-                                  <dxl:Properties>\n-                                    <dxl:Cost StartupCost=\"0\" TotalCost=\"2572.718951\" Rows=\"737331968.000000\" Width=\"16\"/>\n-                                  </dxl:Properties>\n-                                  <dxl:ProjList>\n-                                    <dxl:ProjElem ColId=\"0\" Alias=\"ss_sold_date_sk\">\n-                                      <dxl:Ident ColId=\"0\" ColName=\"ss_sold_date_sk\" TypeMdid=\"0.23.1.0\"/>\n-                                    </dxl:ProjElem>\n-                                    <dxl:ProjElem ColId=\"7\" Alias=\"ss_store_sk\">\n-                                      <dxl:Ident ColId=\"7\" ColName=\"ss_store_sk\" TypeMdid=\"0.23.1.0\"/>\n-                                    </dxl:ProjElem>\n-                                    <dxl:ProjElem ColId=\"22\" Alias=\"ss_net_profit\">\n-                                      <dxl:Ident ColId=\"22\" ColName=\"ss_net_profit\" TypeMdid=\"0.1700.1.0\"/>\n-                                    </dxl:ProjElem>\n-                                  </dxl:ProjList>\n-                                  <dxl:Filter/>\n-                                  <dxl:TableDescriptor Mdid=\"0.8403512.1.1\" TableName=\"store_sales\">\n-                                    <dxl:Columns>\n-                                      <dxl:Column ColId=\"0\" Attno=\"1\" ColName=\"ss_sold_date_sk\" TypeMdid=\"0.23.1.0\"/>\n-                                      <dxl:Column ColId=\"1\" Attno=\"2\" ColName=\"ss_sold_time_sk\" TypeMdid=\"0.23.1.0\"/>\n-                                      <dxl:Column ColId=\"2\" Attno=\"3\" ColName=\"ss_item_sk\" TypeMdid=\"0.23.1.0\"/>\n-                                      <dxl:Column ColId=\"3\" Attno=\"4\" ColName=\"ss_customer_sk\" TypeMdid=\"0.23.1.0\"/>\n-                                      <dxl:Column ColId=\"4\" Attno=\"5\" ColName=\"ss_cdemo_sk\" TypeMdid=\"0.23.1.0\"/>\n-                                      <dxl:Column ColId=\"5\" Attno=\"6\" ColName=\"ss_hdemo_sk\" TypeMdid=\"0.23.1.0\"/>\n-                                      <dxl:Column ColId=\"6\" Attno=\"7\" ColName=\"ss_addr_sk\" TypeMdid=\"0.23.1.0\"/>\n-                                      <dxl:Column ColId=\"7\" Attno=\"8\" ColName=\"ss_store_sk\" TypeMdid=\"0.23.1.0\"/>\n-                                      <dxl:Column ColId=\"8\" Attno=\"9\" ColName=\"ss_promo_sk\" TypeMdid=\"0.23.1.0\"/>\n-                                      <dxl:Column ColId=\"9\" Attno=\"10\" ColName=\"ss_ticket_number\" TypeMdid=\"0.20.1.0\"/>\n-                                      <dxl:Column ColId=\"10\" Attno=\"11\" ColName=\"ss_quantity\" TypeMdid=\"0.23.1.0\"/>\n-                                      <dxl:Column ColId=\"11\" Attno=\"12\" ColName=\"ss_wholesale_cost\" TypeMdid=\"0.1700.1.0\"/>\n-                                      <dxl:Column ColId=\"12\" Attno=\"13\" ColName=\"ss_list_price\" TypeMdid=\"0.1700.1.0\"/>\n-                                      <dxl:Column ColId=\"13\" Attno=\"14\" ColName=\"ss_sales_price\" TypeMdid=\"0.1700.1.0\"/>\n-                                      <dxl:Column ColId=\"14\" Attno=\"15\" ColName=\"ss_ext_discount_amt\" TypeMdid=\"0.1700.1.0\"/>\n-                                      <dxl:Column ColId=\"15\" Attno=\"16\" ColName=\"ss_ext_sales_price\" TypeMdid=\"0.1700.1.0\"/>\n-                                      <dxl:Column ColId=\"16\" Attno=\"17\" ColName=\"ss_ext_wholesale_cost\" TypeMdid=\"0.1700.1.0\"/>\n-                                      <dxl:Column ColId=\"17\" Attno=\"18\" ColName=\"ss_ext_list_price\" TypeMdid=\"0.1700.1.0\"/>\n-                                      <dxl:Column ColId=\"18\" Attno=\"19\" ColName=\"ss_ext_tax\" TypeMdid=\"0.1700.1.0\"/>\n-                                      <dxl:Column ColId=\"19\" Attno=\"20\" ColName=\"ss_coupon_amt\" TypeMdid=\"0.1700.1.0\"/>\n-                                      <dxl:Column ColId=\"20\" Attno=\"21\" ColName=\"ss_net_paid\" TypeMdid=\"0.1700.1.0\"/>\n-                                      <dxl:Column ColId=\"21\" Attno=\"22\" ColName=\"ss_net_paid_inc_tax\" TypeMdid=\"0.1700.1.0\"/>\n-                                      <dxl:Column ColId=\"22\" Attno=\"23\" ColName=\"ss_net_profit\" TypeMdid=\"0.1700.1.0\"/>\n-                                      <dxl:Column ColId=\"23\" Attno=\"-1\" ColName=\"ctid\" TypeMdid=\"0.27.1.0\"/>\n-                                      <dxl:Column ColId=\"24\" Attno=\"-3\" ColName=\"xmin\" TypeMdid=\"0.28.1.0\"/>\n-                                      <dxl:Column ColId=\"25\" Attno=\"-4\" ColName=\"cmin\" TypeMdid=\"0.29.1.0\"/>\n-                                      <dxl:Column ColId=\"26\" Attno=\"-5\" ColName=\"xmax\" TypeMdid=\"0.28.1.0\"/>\n-                                      <dxl:Column ColId=\"27\" Attno=\"-6\" ColName=\"cmax\" TypeMdid=\"0.29.1.0\"/>\n-                                      <dxl:Column ColId=\"28\" Attno=\"-7\" ColName=\"tableoid\" TypeMdid=\"0.26.1.0\"/>\n-                                      <dxl:Column ColId=\"29\" Attno=\"-8\" ColName=\"gp_segment_id\" TypeMdid=\"0.23.1.0\"/>\n-                                    </dxl:Columns>\n-                                  </dxl:TableDescriptor>\n-                                </dxl:TableScan>\n-                                <dxl:BroadcastMotion InputSegments=\"0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31\" OutputSegments=\"0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31\">\n-                                  <dxl:Properties>\n-                                    <dxl:Cost StartupCost=\"0\" TotalCost=\"431.252171\" Rows=\"13414.324949\" Width=\"4\"/>\n-                                  </dxl:Properties>\n-                                  <dxl:ProjList>\n-                                    <dxl:ProjElem ColId=\"30\" Alias=\"d_date_sk\">\n-                                      <dxl:Ident ColId=\"30\" ColName=\"d_date_sk\" TypeMdid=\"0.23.1.0\"/>\n-                                    </dxl:ProjElem>\n-                                  </dxl:ProjList>\n-                                  <dxl:Filter/>\n-                                  <dxl:SortingColumnList/>\n-                                  <dxl:TableScan>\n-                                    <dxl:Properties>\n-                                      <dxl:Cost StartupCost=\"0\" TotalCost=\"431.247306\" Rows=\"419.197655\" Width=\"4\"/>\n-                                    </dxl:Properties>\n-                                    <dxl:ProjList>\n-                                      <dxl:ProjElem ColId=\"30\" Alias=\"d_date_sk\">\n-                                        <dxl:Ident ColId=\"30\" ColName=\"d_date_sk\" TypeMdid=\"0.23.1.0\"/>\n-                                      </dxl:ProjElem>\n-                                    </dxl:ProjList>\n-                                    <dxl:Filter>\n-                                      <dxl:Comparison ComparisonOperator=\"=\" OperatorMdid=\"0.96.1.0\">\n-                                        <dxl:Ident ColId=\"36\" ColName=\"d_year\" TypeMdid=\"0.23.1.0\"/>\n-                                        <dxl:ConstValue TypeMdid=\"0.23.1.0\" IsNull=\"false\" IsByValue=\"true\" Value=\"2000\"/>\n-                                      </dxl:Comparison>\n-                                    </dxl:Filter>\n-                                    <dxl:TableDescriptor Mdid=\"0.8402992.1.1\" TableName=\"date_dim\">\n-                                      <dxl:Columns>\n-                                        <dxl:Column ColId=\"30\" Attno=\"1\" ColName=\"d_date_sk\" TypeMdid=\"0.23.1.0\"/>\n-                                        <dxl:Column ColId=\"31\" Attno=\"2\" ColName=\"d_date_id\" TypeMdid=\"0.1042.1.0\" ColWidth=\"16\"/>\n-                                        <dxl:Column ColId=\"32\" Attno=\"3\" ColName=\"d_date\" TypeMdid=\"0.1082.1.0\"/>\n-                                        <dxl:Column ColId=\"33\" Attno=\"4\" ColName=\"d_month_seq\" TypeMdid=\"0.23.1.0\"/>\n-                                        <dxl:Column ColId=\"34\" Attno=\"5\" ColName=\"d_week_seq\" TypeMdid=\"0.23.1.0\"/>\n-                                        <dxl:Column ColId=\"35\" Attno=\"6\" ColName=\"d_quarter_seq\" TypeMdid=\"0.23.1.0\"/>\n-                                        <dxl:Column ColId=\"36\" Attno=\"7\" ColName=\"d_year\" TypeMdid=\"0.23.1.0\"/>\n-                                        <dxl:Column ColId=\"37\" Attno=\"8\" ColName=\"d_dow\" TypeMdid=\"0.23.1.0\"/>\n-                                        <dxl:Column ColId=\"38\" Attno=\"9\" ColName=\"d_moy\" TypeMdid=\"0.23.1.0\"/>\n-                                        <dxl:Column ColId=\"39\" Attno=\"10\" ColName=\"d_dom\" TypeMdid=\"0.23.1.0\"/>\n-                                        <dxl:Column ColId=\"40\" Attno=\"11\" ColName=\"d_qoy\" TypeMdid=\"0.23.1.0\"/>\n-                                        <dxl:Column ColId=\"41\" Attno=\"12\" ColName=\"d_fy_year\" TypeMdid=\"0.23.1.0\"/>\n-                                        <dxl:Column ColId=\"42\" Attno=\"13\" ColName=\"d_fy_quarter_seq\" TypeMdid=\"0.23.1.0\"/>\n-                                        <dxl:Column ColId=\"43\" Attno=\"14\" ColName=\"d_fy_week_seq\" TypeMdid=\"0.23.1.0\"/>\n-                                        <dxl:Column ColId=\"44\" Attno=\"15\" ColName=\"d_day_name\" TypeMdid=\"0.1042.1.0\" ColWidth=\"9\"/>\n-                                        <dxl:Column ColId=\"45\" Attno=\"16\" ColName=\"d_quarter_name\" TypeMdid=\"0.1042.1.0\" ColWidth=\"6\"/>\n-                                        <dxl:Column ColId=\"46\" Attno=\"17\" ColName=\"d_holiday\" TypeMdid=\"0.1042.1.0\" ColWidth=\"1\"/>\n-                                        <dxl:Column ColId=\"47\" Attno=\"18\" ColName=\"d_weekend\" TypeMdid=\"0.1042.1.0\" ColWidth=\"1\"/>\n-                                        <dxl:Column ColId=\"48\" Attno=\"19\" ColName=\"d_following_holiday\" TypeMdid=\"0.1042.1.0\" ColWidth=\"1\"/>\n-                                        <dxl:Column ColId=\"49\" Attno=\"20\" ColName=\"d_first_dom\" TypeMdid=\"0.23.1.0\"/>\n-                                        <dxl:Column ColId=\"50\" Attno=\"21\" ColName=\"d_last_dom\" TypeMdid=\"0.23.1.0\"/>\n-                                        <dxl:Column ColId=\"51\" Attno=\"22\" ColName=\"d_same_day_ly\" TypeMdid=\"0.23.1.0\"/>\n-                                        <dxl:Column ColId=\"52\" Attno=\"23\" ColName=\"d_same_day_lq\" TypeMdid=\"0.23.1.0\"/>\n-                                        <dxl:Column ColId=\"53\" Attno=\"24\" ColName=\"d_current_day\" TypeMdid=\"0.1042.1.0\" ColWidth=\"1\"/>\n-                                        <dxl:Column ColId=\"54\" Attno=\"25\" ColName=\"d_current_week\" TypeMdid=\"0.1042.1.0\" ColWidth=\"1\"/>\n-                                        <dxl:Column ColId=\"55\" Attno=\"26\" ColName=\"d_current_month\" TypeMdid=\"0.1042.1.0\" ColWidth=\"1\"/>\n-                                        <dxl:Column ColId=\"56\" Attno=\"27\" ColName=\"d_current_quarter\" TypeMdid=\"0.1042.1.0\" ColWidth=\"1\"/>\n-                                        <dxl:Column ColId=\"57\" Attno=\"28\" ColName=\"d_current_year\" TypeMdid=\"0.1042.1.0\" ColWidth=\"1\"/>\n-                                        <dxl:Column ColId=\"58\" Attno=\"-1\" ColName=\"ctid\" TypeMdid=\"0.27.1.0\"/>\n-                                        <dxl:Column ColId=\"59\" Attno=\"-3\" ColName=\"xmin\" TypeMdid=\"0.28.1.0\"/>\n-                                        <dxl:Column ColId=\"60\" Attno=\"-4\" ColName=\"cmin\" TypeMdid=\"0.29.1.0\"/>\n-                                        <dxl:Column ColId=\"61\" Attno=\"-5\" ColName=\"xmax\" TypeMdid=\"0.28.1.0\"/>\n-                                        <dxl:Column ColId=\"62\" Attno=\"-6\" ColName=\"cmax\" TypeMdid=\"0.29.1.0\"/>\n-                                        <dxl:Column ColId=\"63\" Attno=\"-7\" ColName=\"tableoid\" TypeMdid=\"0.26.1.0\"/>\n-                                        <dxl:Column ColId=\"64\" Attno=\"-8\" ColName=\"gp_segment_id\" TypeMdid=\"0.23.1.0\"/>\n-                                      </dxl:Columns>\n-                                    </dxl:TableDescriptor>\n-                                  </dxl:TableScan>\n-                                </dxl:BroadcastMotion>\n-                              </dxl:HashJoin>\n-                              <dxl:BroadcastMotion InputSegments=\"0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31\" OutputSegments=\"0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31\">\n-                                <dxl:Properties>\n-                                  <dxl:Cost StartupCost=\"0\" TotalCost=\"10825.822451\" Rows=\"4147.200000\" Width=\"22\"/>\n-                                </dxl:Properties>\n-                                <dxl:ProjList>\n-                                  <dxl:ProjElem ColId=\"65\" Alias=\"s_store_sk\">\n-                                    <dxl:Ident ColId=\"65\" ColName=\"s_store_sk\" TypeMdid=\"0.23.1.0\"/>\n-                                  </dxl:ProjElem>\n-                                  <dxl:ProjElem ColId=\"88\" Alias=\"s_county\">\n-                                    <dxl:Ident ColId=\"88\" ColName=\"s_county\" TypeMdid=\"0.1043.1.0\"/>\n-                                  </dxl:ProjElem>\n-                                  <dxl:ProjElem ColId=\"89\" Alias=\"s_state\">\n-                                    <dxl:Ident ColId=\"89\" ColName=\"s_state\" TypeMdid=\"0.1042.1.0\"/>\n-                                  </dxl:ProjElem>\n-                                </dxl:ProjList>\n-                                <dxl:Filter/>\n-                                <dxl:SortingColumnList/>\n-                                <dxl:HashJoin JoinType=\"In\">\n-                                  <dxl:Properties>\n-                                    <dxl:Cost StartupCost=\"0\" TotalCost=\"10825.814178\" Rows=\"129.600000\" Width=\"22\"/>\n-                                  </dxl:Properties>\n-                                  <dxl:ProjList>\n-                                    <dxl:ProjElem ColId=\"65\" Alias=\"s_store_sk\">\n-                                      <dxl:Ident ColId=\"65\" ColName=\"s_store_sk\" TypeMdid=\"0.23.1.0\"/>\n-                                    </dxl:ProjElem>\n-                                    <dxl:ProjElem ColId=\"88\" Alias=\"s_county\">\n-                                      <dxl:Ident ColId=\"88\" ColName=\"s_county\" TypeMdid=\"0.1043.1.0\"/>\n-                                    </dxl:ProjElem>\n-                                    <dxl:ProjElem ColId=\"89\" Alias=\"s_state\">\n-                                      <dxl:Ident ColId=\"89\" ColName=\"s_state\" TypeMdid=\"0.1042.1.0\"/>\n-                                    </dxl:ProjElem>\n-                                  </dxl:ProjList>\n-                                  <dxl:Filter/>\n-                                  <dxl:JoinFilter/>\n-                                  <dxl:HashCondList>\n-                                    <dxl:Comparison ComparisonOperator=\"=\" OperatorMdid=\"0.1054.1.0\">\n-                                      <dxl:Ident ColId=\"89\" ColName=\"s_state\" TypeMdid=\"0.1042.1.0\"/>\n-                                      <dxl:Ident ColId=\"155\" ColName=\"s_state\" TypeMdid=\"0.1042.1.0\"/>\n-                                    </dxl:Comparison>\n-                                  </dxl:HashCondList>\n-                                  <dxl:TableScan>\n-                                    <dxl:Properties>\n-                                      <dxl:Cost StartupCost=\"0\" TotalCost=\"431.004243\" Rows=\"324.000000\" Width=\"22\"/>\n-                                    </dxl:Properties>\n-                                    <dxl:ProjList>\n-                                      <dxl:ProjElem ColId=\"65\" Alias=\"s_store_sk\">\n-                                        <dxl:Ident ColId=\"65\" ColName=\"s_store_sk\" TypeMdid=\"0.23.1.0\"/>\n-                                      </dxl:ProjElem>\n-                                      <dxl:ProjElem ColId=\"88\" Alias=\"s_county\">\n-                                        <dxl:Ident ColId=\"88\" ColName=\"s_county\" TypeMdid=\"0.1043.1.0\"/>\n-                                      </dxl:ProjElem>\n-                                      <dxl:ProjElem ColId=\"89\" Alias=\"s_state\">\n-                                        <dxl:Ident ColId=\"89\" ColName=\"s_state\" TypeMdid=\"0.1042.1.0\"/>\n-                                      </dxl:ProjElem>\n-                                    </dxl:ProjList>\n-                                    <dxl:Filter/>\n-                                    <dxl:TableDescriptor Mdid=\"0.8403408.1.1\" TableName=\"store\">\n-                                      <dxl:Columns>\n-                                        <dxl:Column ColId=\"65\" Attno=\"1\" ColName=\"s_store_sk\" TypeMdid=\"0.23.1.0\"/>\n-                                        <dxl:Column ColId=\"66\" Attno=\"2\" ColName=\"s_store_id\" TypeMdid=\"0.1042.1.0\" ColWidth=\"16\"/>\n-                                        <dxl:Column ColId=\"67\" Attno=\"3\" ColName=\"s_rec_start_date\" TypeMdid=\"0.1082.1.0\"/>\n-                                        <dxl:Column ColId=\"68\" Attno=\"4\" ColName=\"s_rec_end_date\" TypeMdid=\"0.1082.1.0\"/>\n-                                        <dxl:Column ColId=\"69\" Attno=\"5\" ColName=\"s_closed_date_sk\" TypeMdid=\"0.23.1.0\"/>\n-                                        <dxl:Column ColId=\"70\" Attno=\"6\" ColName=\"s_store_name\" TypeMdid=\"0.1043.1.0\" ColWidth=\"50\"/>\n-                                        <dxl:Column ColId=\"71\" Attno=\"7\" ColName=\"s_number_employees\" TypeMdid=\"0.23.1.0\"/>\n-                                        <dxl:Column ColId=\"72\" Attno=\"8\" ColName=\"s_floor_space\" TypeMdid=\"0.23.1.0\"/>\n-                                        <dxl:Column ColId=\"73\" Attno=\"9\" ColName=\"s_hours\" TypeMdid=\"0.1042.1.0\" ColWidth=\"20\"/>\n-                                        <dxl:Column ColId=\"74\" Attno=\"10\" ColName=\"s_manager\" TypeMdid=\"0.1043.1.0\" ColWidth=\"40\"/>\n-                                        <dxl:Column ColId=\"75\" Attno=\"11\" ColName=\"s_market_id\" TypeMdid=\"0.23.1.0\"/>\n-                                        <dxl:Column ColId=\"76\" Attno=\"12\" ColName=\"s_geography_class\" TypeMdid=\"0.1043.1.0\" ColWidth=\"100\"/>\n-                                        <dxl:Column ColId=\"77\" Attno=\"13\" ColName=\"s_market_desc\" TypeMdid=\"0.1043.1.0\" ColWidth=\"100\"/>\n-                                        <dxl:Column ColId=\"78\" Attno=\"14\" ColName=\"s_market_manager\" TypeMdid=\"0.1043.1.0\" ColWidth=\"40\"/>\n-                                        <dxl:Column ColId=\"79\" Attno=\"15\" ColName=\"s_division_id\" TypeMdid=\"0.23.1.0\"/>\n-                                        <dxl:Column ColId=\"80\" Attno=\"16\" ColName=\"s_division_name\" TypeMdid=\"0.1043.1.0\" ColWidth=\"50\"/>\n-                                        <dxl:Column ColId=\"81\" Attno=\"17\" ColName=\"s_company_id\" TypeMdid=\"0.23.1.0\"/>\n-                                        <dxl:Column ColId=\"82\" Attno=\"18\" ColName=\"s_company_name\" TypeMdid=\"0.1043.1.0\" ColWidth=\"50\"/>\n-                                        <dxl:Column ColId=\"83\" Attno=\"19\" ColName=\"s_street_number\" TypeMdid=\"0.1043.1.0\" ColWidth=\"10\"/>\n-                                        <dxl:Column ColId=\"84\" Attno=\"20\" ColName=\"s_street_name\" TypeMdid=\"0.1043.1.0\" ColWidth=\"60\"/>\n-                                        <dxl:Column ColId=\"85\" Attno=\"21\" ColName=\"s_street_type\" TypeMdid=\"0.1042.1.0\" ColWidth=\"15\"/>\n-                                        <dxl:Column ColId=\"86\" Attno=\"22\" ColName=\"s_suite_number\" TypeMdid=\"0.1042.1.0\" ColWidth=\"10\"/>\n-                                        <dxl:Column ColId=\"87\" Attno=\"23\" ColName=\"s_city\" TypeMdid=\"0.1043.1.0\" ColWidth=\"60\"/>\n-                                        <dxl:Column ColId=\"88\" Attno=\"24\" ColName=\"s_county\" TypeMdid=\"0.1043.1.0\" ColWidth=\"30\"/>\n-                                        <dxl:Column ColId=\"89\" Attno=\"25\" ColName=\"s_state\" TypeMdid=\"0.1042.1.0\" ColWidth=\"2\"/>\n-                                        <dxl:Column ColId=\"90\" Attno=\"26\" ColName=\"s_zip\" TypeMdid=\"0.1042.1.0\" ColWidth=\"10\"/>\n-                                        <dxl:Column ColId=\"91\" Attno=\"27\" ColName=\"s_country\" TypeMdid=\"0.1043.1.0\" ColWidth=\"20\"/>\n-                                        <dxl:Column ColId=\"92\" Attno=\"28\" ColName=\"s_gmt_offset\" TypeMdid=\"0.1700.1.0\"/>\n-                                        <dxl:Column ColId=\"93\" Attno=\"29\" ColName=\"s_tax_precentage\" TypeMdid=\"0.1700.1.0\"/>\n-                                        <dxl:Column ColId=\"94\" Attno=\"-1\" ColName=\"ctid\" TypeMdid=\"0.27.1.0\"/>\n-                                        <dxl:Column ColId=\"95\" Attno=\"-3\" ColName=\"xmin\" TypeMdid=\"0.28.1.0\"/>\n-                                        <dxl:Column ColId=\"96\" Attno=\"-4\" ColName=\"cmin\" TypeMdid=\"0.29.1.0\"/>\n-                                        <dxl:Column ColId=\"97\" Attno=\"-5\" ColName=\"xmax\" TypeMdid=\"0.28.1.0\"/>\n-                                        <dxl:Column ColId=\"98\" Attno=\"-6\" ColName=\"cmax\" TypeMdid=\"0.29.1.0\"/>\n-                                        <dxl:Column ColId=\"99\" Attno=\"-7\" ColName=\"tableoid\" TypeMdid=\"0.26.1.0\"/>\n-                                        <dxl:Column ColId=\"100\" Attno=\"-8\" ColName=\"gp_segment_id\" TypeMdid=\"0.23.1.0\"/>\n-                                      </dxl:Columns>\n-                                    </dxl:TableDescriptor>\n-                                  </dxl:TableScan>\n-                                  <dxl:BroadcastMotion InputSegments=\"0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31\" OutputSegments=\"0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31\">\n-                                    <dxl:Properties>\n-                                      <dxl:Cost StartupCost=\"0\" TotalCost=\"10394.806977\" Rows=\"64.000000\" Width=\"3\"/>\n-                                    </dxl:Properties>\n-                                    <dxl:ProjList>\n-                                      <dxl:ProjElem ColId=\"155\" Alias=\"s_state\">\n-                                        <dxl:Ident ColId=\"155\" ColName=\"s_state\" TypeMdid=\"0.1042.1.0\"/>\n-                                      </dxl:ProjElem>\n-                                    </dxl:ProjList>\n-                                    <dxl:Filter/>\n-                                    <dxl:SortingColumnList/>\n-                                    <dxl:Result>\n-                                      <dxl:Properties>\n-                                        <dxl:Cost StartupCost=\"0\" TotalCost=\"10394.806698\" Rows=\"2.000000\" Width=\"3\"/>\n-                                      </dxl:Properties>\n-                                      <dxl:ProjList>\n-                                        <dxl:ProjElem ColId=\"155\" Alias=\"s_state\">\n-                                          <dxl:Ident ColId=\"155\" ColName=\"s_state\" TypeMdid=\"0.1042.1.0\"/>\n-                                        </dxl:ProjElem>\n-                                      </dxl:ProjList>\n-                                      <dxl:Filter>\n-                                        <dxl:Comparison ComparisonOperator=\"&lt;=\" OperatorMdid=\"0.420.1.0\">\n-                                          <dxl:Ident ColId=\"203\" ColName=\"ranking\" TypeMdid=\"0.20.1.0\"/>\n-                                          <dxl:ConstValue TypeMdid=\"0.23.1.0\" IsNull=\"false\" IsByValue=\"true\" Value=\"5\"/>\n-                                        </dxl:Comparison>\n-                                      </dxl:Filter>\n-                                      <dxl:OneTimeFilter/>\n-                                      <dxl:Window PartitionColumns=\"155\">\n-                                        <dxl:Properties>\n-                                          <dxl:Cost StartupCost=\"0\" TotalCost=\"10394.806665\" Rows=\"5.000000\" Width=\"11\"/>\n-                                        </dxl:Properties>\n-                                        <dxl:ProjList>\n-                                          <dxl:ProjElem ColId=\"203\" Alias=\"ranking\">\n-                                            <dxl:WindowFunc Mdid=\"0.7001.1.0\" TypeMdid=\"0.20.1.0\" Distinct=\"false\" WindowStarArg=\"false\" WindowSimpleAgg=\"false\" WindowStrategy=\"Immediate\" WinSpecPos=\"0\"/>\n-                                          </dxl:ProjElem>\n-                                          <dxl:ProjElem ColId=\"155\" Alias=\"s_state\">\n-                                            <dxl:Ident ColId=\"155\" ColName=\"s_state\" TypeMdid=\"0.1042.1.0\"/>\n-                                          </dxl:ProjElem>\n-                                          <dxl:ProjElem ColId=\"202\" Alias=\"att_2\">\n-                                            <dxl:Ident ColId=\"202\" ColName=\"att_2\" TypeMdid=\"0.1700.1.0\"/>\n-                                          </dxl:ProjElem>\n-                                        </dxl:ProjList>\n-                                        <dxl:Filter/>\n-                                        <dxl:Sort SortDiscardDuplicates=\"false\">\n-                                          <dxl:Properties>\n-                                            <dxl:Cost StartupCost=\"0\" TotalCost=\"10394.806654\" Rows=\"5.000000\" Width=\"11\"/>\n-                                          </dxl:Properties>\n-                                          <dxl:ProjList>\n-                                            <dxl:ProjElem ColId=\"202\" Alias=\"att_2\">\n-                                              <dxl:Ident ColId=\"202\" ColName=\"att_2\" TypeMdid=\"0.1700.1.0\"/>\n-                                            </dxl:ProjElem>\n-                                            <dxl:ProjElem ColId=\"155\" Alias=\"s_state\">\n-                                              <dxl:Ident ColId=\"155\" ColName=\"s_state\" TypeMdid=\"0.1042.1.0\"/>\n-                                            </dxl:ProjElem>\n-                                          </dxl:ProjList>\n-                                          <dxl:Filter/>\n-                                          <dxl:SortingColumnList>\n-                                            <dxl:SortingColumn ColId=\"155\" SortOperatorMdid=\"0.1058.1.0\" SortOperatorName=\"&lt;\" SortNullsFirst=\"false\"/>\n-                                            <dxl:SortingColumn ColId=\"202\" SortOperatorMdid=\"0.1756.1.0\" SortOperatorName=\"&gt;\" SortNullsFirst=\"false\"/>\n-                                          </dxl:SortingColumnList>\n-                                          <dxl:LimitCount/>\n-                                          <dxl:LimitOffset/>\n-                                          <dxl:Aggregate AggregationStrategy=\"Sorted\" StreamSafe=\"false\">\n-                                            <dxl:Properties>\n-                                              <dxl:Cost StartupCost=\"0\" TotalCost=\"10394.806654\" Rows=\"5.000000\" Width=\"11\"/>\n-                                            </dxl:Properties>\n-                                            <dxl:GroupingColumns>\n-                                              <dxl:GroupingColumn ColId=\"155\"/>\n-                                            </dxl:GroupingColumns>\n-                                            <dxl:ProjList>\n-                                              <dxl:ProjElem ColId=\"202\" Alias=\"att_2\">\n-                                                <dxl:AggFunc AggMdid=\"0.2114.1.0\" AggDistinct=\"false\" AggStage=\"Final\">\n-                                                  <dxl:Ident ColId=\"1486\" ColName=\"ColRef_1486\" TypeMdid=\"0.1700.1.0\"/>\n-                                                </dxl:AggFunc>\n-                                              </dxl:ProjElem>\n-                                              <dxl:ProjElem ColId=\"155\" Alias=\"s_state\">\n-                                                <dxl:Ident ColId=\"155\" ColName=\"s_state\" TypeMdid=\"0.1042.1.0\"/>\n-                                              </dxl:ProjElem>\n-                                            </dxl:ProjList>\n-                                            <dxl:Filter/>\n-                                            <dxl:Sort SortDiscardDuplicates=\"false\">\n-                                              <dxl:Properties>\n-                                                <dxl:Cost StartupCost=\"0\" TotalCost=\"10394.806637\" Rows=\"5.000000\" Width=\"11\"/>\n-                                              </dxl:Properties>\n-                                              <dxl:ProjList>\n-                                                <dxl:ProjElem ColId=\"155\" Alias=\"s_state\">\n-                                                  <dxl:Ident ColId=\"155\" ColName=\"s_state\" TypeMdid=\"0.1042.1.0\"/>\n-                                                </dxl:ProjElem>\n-                                                <dxl:ProjElem ColId=\"1486\" Alias=\"ColRef_1486\">\n-                                                  <dxl:Ident ColId=\"1486\" ColName=\"ColRef_1486\" TypeMdid=\"0.1700.1.0\"/>\n-                                                </dxl:ProjElem>\n-                                              </dxl:ProjList>\n-                                              <dxl:Filter/>\n-                                              <dxl:SortingColumnList>\n-                                                <dxl:SortingColumn ColId=\"155\" SortOperatorMdid=\"0.1058.1.0\" SortOperatorName=\"&lt;\" SortNullsFirst=\"false\"/>\n-                                              </dxl:SortingColumnList>\n-                                              <dxl:LimitCount/>\n-                                              <dxl:LimitOffset/>\n-                                              <dxl:RedistributeMotion InputSegments=\"0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31\" OutputSegments=\"0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31\">\n-                                                <dxl:Properties>\n-                                                  <dxl:Cost StartupCost=\"0\" TotalCost=\"10394.806637\" Rows=\"5.000000\" Width=\"11\"/>\n-                                                </dxl:Properties>\n-                                                <dxl:ProjList>\n-                                                  <dxl:ProjElem ColId=\"155\" Alias=\"s_state\">\n-                                                    <dxl:Ident ColId=\"155\" ColName=\"s_state\" TypeMdid=\"0.1042.1.0\"/>\n-                                                  </dxl:ProjElem>\n-                                                  <dxl:ProjElem ColId=\"1486\" Alias=\"ColRef_1486\">\n-                                                    <dxl:Ident ColId=\"1486\" ColName=\"ColRef_1486\" TypeMdid=\"0.1700.1.0\"/>\n-                                                  </dxl:ProjElem>\n-                                                </dxl:ProjList>\n-                                                <dxl:Filter/>\n-                                                <dxl:SortingColumnList/>\n-                                                <dxl:HashExprList>\n-                                                  <dxl:HashExpr TypeMdid=\"0.1042.1.0\">\n-                                                    <dxl:Ident ColId=\"155\" ColName=\"s_state\" TypeMdid=\"0.1042.1.0\"/>\n-                                                  </dxl:HashExpr>\n-                                                </dxl:HashExprList>\n-                                                <dxl:Result>\n-                                                  <dxl:Properties>\n-                                                    <dxl:Cost StartupCost=\"0\" TotalCost=\"10394.806624\" Rows=\"5.000000\" Width=\"11\"/>\n-                                                  </dxl:Properties>\n-                                                  <dxl:ProjList>\n-                                                    <dxl:ProjElem ColId=\"155\" Alias=\"s_state\">\n-                                                      <dxl:Ident ColId=\"155\" ColName=\"s_state\" TypeMdid=\"0.1042.1.0\"/>\n-                                                    </dxl:ProjElem>\n-                                                    <dxl:ProjElem ColId=\"1486\" Alias=\"ColRef_1486\">\n-                                                      <dxl:Ident ColId=\"1486\" ColName=\"ColRef_1486\" TypeMdid=\"0.1700.1.0\"/>\n-                                                    </dxl:ProjElem>\n-                                                  </dxl:ProjList>\n-                                                  <dxl:Filter/>\n-                                                  <dxl:OneTimeFilter/>\n-                                                  <dxl:Aggregate AggregationStrategy=\"Hashed\" StreamSafe=\"true\">\n-                                                    <dxl:Properties>\n-                                                      <dxl:Cost StartupCost=\"0\" TotalCost=\"10394.806624\" Rows=\"5.000000\" Width=\"11\"/>\n-                                                    </dxl:Properties>\n-                                                    <dxl:GroupingColumns>\n-                                                      <dxl:GroupingColumn ColId=\"155\"/>\n-                                                    </dxl:GroupingColumns>\n-                                                    <dxl:ProjList>\n-                                                      <dxl:ProjElem ColId=\"1486\" Alias=\"ColRef_1486\">\n-                                                        <dxl:AggFunc AggMdid=\"0.2114.1.0\" AggDistinct=\"false\" AggStage=\"Partial\">\n-                                                          <dxl:Ident ColId=\"123\" ColName=\"ss_net_profit\" TypeMdid=\"0.1700.1.0\"/>\n-                                                        </dxl:AggFunc>\n-                                                      </dxl:ProjElem>\n-                                                      <dxl:ProjElem ColId=\"155\" Alias=\"s_state\">\n-                                                        <dxl:Ident ColId=\"155\" ColName=\"s_state\" TypeMdid=\"0.1042.1.0\"/>\n-                                                      </dxl:ProjElem>\n-                                                    </dxl:ProjList>\n-                                                    <dxl:Filter/>\n-                                                    <dxl:HashJoin JoinType=\"Inner\">\n-                                                      <dxl:Properties>\n-                                                        <dxl:Cost StartupCost=\"0\" TotalCost=\"9736.121994\" Rows=\"169549002.661349\" Width=\"11\"/>\n-                                                      </dxl:Properties>\n-                                                      <dxl:ProjList>\n-                                                        <dxl:ProjElem ColId=\"123\" Alias=\"ss_net_profit\">\n-                                                          <dxl:Ident ColId=\"123\" ColName=\"ss_net_profit\" TypeMdid=\"0.1700.1.0\"/>\n-                                                        </dxl:ProjElem>\n-                                                        <dxl:ProjElem ColId=\"155\" Alias=\"s_state\">\n-                                                          <dxl:Ident ColId=\"155\" ColName=\"s_state\" TypeMdid=\"0.1042.1.0\"/>\n-                                                        </dxl:ProjElem>\n-                                                      </dxl:ProjList>\n-                                                      <dxl:Filter/>\n-                                                      <dxl:JoinFilter/>\n-                                                      <dxl:HashCondList>\n-                                                        <dxl:Comparison ComparisonOperator=\"=\" OperatorMdid=\"0.96.1.0\">\n-                                                          <dxl:Ident ColId=\"108\" ColName=\"ss_store_sk\" TypeMdid=\"0.23.1.0\"/>\n-                                                          <dxl:Ident ColId=\"131\" ColName=\"s_store_sk\" TypeMdid=\"0.23.1.0\"/>\n-                                                        </dxl:Comparison>\n-                                                      </dxl:HashCondList>\n-                                                      <dxl:HashJoin JoinType=\"Inner\">\n-                                                        <dxl:Properties>\n-                                                          <dxl:Cost StartupCost=\"0\" TotalCost=\"8141.454737\" Rows=\"169549002.661349\" Width=\"12\"/>\n-                                                        </dxl:Properties>\n-                                                        <dxl:ProjList>\n-                                                          <dxl:ProjElem ColId=\"108\" Alias=\"ss_store_sk\">\n-                                                            <dxl:Ident ColId=\"108\" ColName=\"ss_store_sk\" TypeMdid=\"0.23.1.0\"/>\n-                                                          </dxl:ProjElem>\n-                                                          <dxl:ProjElem ColId=\"123\" Alias=\"ss_net_profit\">\n-                                                            <dxl:Ident ColId=\"123\" ColName=\"ss_net_profit\" TypeMdid=\"0.1700.1.0\"/>\n-                                                          </dxl:ProjElem>\n-                                                        </dxl:ProjList>\n-                                                        <dxl:Filter/>\n-                                                        <dxl:JoinFilter/>\n-                                                        <dxl:HashCondList>\n-                                                          <dxl:Comparison ComparisonOperator=\"=\" OperatorMdid=\"0.96.1.0\">\n-                                                            <dxl:Ident ColId=\"101\" ColName=\"ss_sold_date_sk\" TypeMdid=\"0.23.1.0\"/>\n-                                                            <dxl:Ident ColId=\"167\" ColName=\"d_date_sk\" TypeMdid=\"0.23.1.0\"/>\n-                                                          </dxl:Comparison>\n-                                                        </dxl:HashCondList>\n-                                                        <dxl:TableScan>\n-                                                          <dxl:Properties>\n-                                                            <dxl:Cost StartupCost=\"0\" TotalCost=\"2572.718951\" Rows=\"737331968.000000\" Width=\"16\"/>\n-                                                          </dxl:Properties>\n-                                                          <dxl:ProjList>\n-                                                            <dxl:ProjElem ColId=\"101\" Alias=\"ss_sold_date_sk\">\n-                                                            <dxl:Ident ColId=\"101\" ColName=\"ss_sold_date_sk\" TypeMdid=\"0.23.1.0\"/>\n-                                                            </dxl:ProjElem>\n-                                                            <dxl:ProjElem ColId=\"108\" Alias=\"ss_store_sk\">\n-                                                            <dxl:Ident ColId=\"108\" ColName=\"ss_store_sk\" TypeMdid=\"0.23.1.0\"/>\n-                                                            </dxl:ProjElem>\n-                                                            <dxl:ProjElem ColId=\"123\" Alias=\"ss_net_profit\">\n-                                                            <dxl:Ident ColId=\"123\" ColName=\"ss_net_profit\" TypeMdid=\"0.1700.1.0\"/>\n-                                                            </dxl:ProjElem>\n-                                                          </dxl:ProjList>\n-                                                          <dxl:Filter/>\n-                                                          <dxl:TableDescriptor Mdid=\"0.8403512.1.1\" TableName=\"store_sales\">\n-                                                            <dxl:Columns>\n-                                                            <dxl:Column ColId=\"101\" Attno=\"1\" ColName=\"ss_sold_date_sk\" TypeMdid=\"0.23.1.0\"/>\n-                                                            <dxl:Column ColId=\"102\" Attno=\"2\" ColName=\"ss_sold_time_sk\" TypeMdid=\"0.23.1.0\"/>\n-                                                            <dxl:Column ColId=\"103\" Attno=\"3\" ColName=\"ss_item_sk\" TypeMdid=\"0.23.1.0\"/>\n-                                                            <dxl:Column ColId=\"104\" Attno=\"4\" ColName=\"ss_customer_sk\" TypeMdid=\"0.23.1.0\"/>\n-                                                            <dxl:Column ColId=\"105\" Attno=\"5\" ColName=\"ss_cdemo_sk\" TypeMdid=\"0.23.1.0\"/>\n-                                                            <dxl:Column ColId=\"106\" Attno=\"6\" ColName=\"ss_hdemo_sk\" TypeMdid=\"0.23.1.0\"/>\n-                                                            <dxl:Column ColId=\"107\" Attno=\"7\" ColName=\"ss_addr_sk\" TypeMdid=\"0.23.1.0\"/>\n-                                                            <dxl:Column ColId=\"108\" Attno=\"8\" ColName=\"ss_store_sk\" TypeMdid=\"0.23.1.0\"/>\n-                                                            <dxl:Column ColId=\"109\" Attno=\"9\" ColName=\"ss_promo_sk\" TypeMdid=\"0.23.1.0\"/>\n-                                                            <dxl:Column ColId=\"110\" Attno=\"10\" ColName=\"ss_ticket_number\" TypeMdid=\"0.20.1.0\"/>\n-                                                            <dxl:Column ColId=\"111\" Attno=\"11\" ColName=\"ss_quantity\" TypeMdid=\"0.23.1.0\"/>\n-                                                            <dxl:Column ColId=\"112\" Attno=\"12\" ColName=\"ss_wholesale_cost\" TypeMdid=\"0.1700.1.0\"/>\n-                                                            <dxl:Column ColId=\"113\" Attno=\"13\" ColName=\"ss_list_price\" TypeMdid=\"0.1700.1.0\"/>\n-                                                            <dxl:Column ColId=\"114\" Attno=\"14\" ColName=\"ss_sales_price\" TypeMdid=\"0.1700.1.0\"/>\n-                                                            <dxl:Column ColId=\"115\" Attno=\"15\" ColName=\"ss_ext_discount_amt\" TypeMdid=\"0.1700.1.0\"/>\n-                                                            <dxl:Column ColId=\"116\" Attno=\"16\" ColName=\"ss_ext_sales_price\" TypeMdid=\"0.1700.1.0\"/>\n-                                                            <dxl:Column ColId=\"117\" Attno=\"17\" ColName=\"ss_ext_wholesale_cost\" TypeMdid=\"0.1700.1.0\"/>\n-                                                            <dxl:Column ColId=\"118\" Attno=\"18\" ColName=\"ss_ext_list_price\" TypeMdid=\"0.1700.1.0\"/>\n-                                                            <dxl:Column ColId=\"119\" Attno=\"19\" ColName=\"ss_ext_tax\" TypeMdid=\"0.1700.1.0\"/>\n-                                                            <dxl:Column ColId=\"120\" Attno=\"20\" ColName=\"ss_coupon_amt\" TypeMdid=\"0.1700.1.0\"/>\n-                                                            <dxl:Column ColId=\"121\" Attno=\"21\" ColName=\"ss_net_paid\" TypeMdid=\"0.1700.1.0\"/>\n-                                                            <dxl:Column ColId=\"122\" Attno=\"22\" ColName=\"ss_net_paid_inc_tax\" TypeMdid=\"0.1700.1.0\"/>\n-                                                            <dxl:Column ColId=\"123\" Attno=\"23\" ColName=\"ss_net_profit\" TypeMdid=\"0.1700.1.0\"/>\n-                                                            <dxl:Column ColId=\"124\" Attno=\"-1\" ColName=\"ctid\" TypeMdid=\"0.27.1.0\"/>\n-                                                            <dxl:Column ColId=\"125\" Attno=\"-3\" ColName=\"xmin\" TypeMdid=\"0.28.1.0\"/>\n-                                                            <dxl:Column ColId=\"126\" Attno=\"-4\" ColName=\"cmin\" TypeMdid=\"0.29.1.0\"/>\n-                                                            <dxl:Column ColId=\"127\" Attno=\"-5\" ColName=\"xmax\" TypeMdid=\"0.28.1.0\"/>\n-                                                            <dxl:Column ColId=\"128\" Attno=\"-6\" ColName=\"cmax\" TypeMdid=\"0.29.1.0\"/>\n-                                                            <dxl:Column ColId=\"129\" Attno=\"-7\" ColName=\"tableoid\" TypeMdid=\"0.26.1.0\"/>\n-                                                            <dxl:Column ColId=\"130\" Attno=\"-8\" ColName=\"gp_segment_id\" TypeMdid=\"0.23.1.0\"/>\n-                                                            </dxl:Columns>\n-                                                          </dxl:TableDescriptor>\n-                                                        </dxl:TableScan>\n-                                                        <dxl:BroadcastMotion InputSegments=\"0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31\" OutputSegments=\"0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31\">\n-                                                          <dxl:Properties>\n-                                                            <dxl:Cost StartupCost=\"0\" TotalCost=\"431.252171\" Rows=\"13414.324949\" Width=\"4\"/>\n-                                                          </dxl:Properties>\n-                                                          <dxl:ProjList>\n-                                                            <dxl:ProjElem ColId=\"167\" Alias=\"d_date_sk\">\n-                                                            <dxl:Ident ColId=\"167\" ColName=\"d_date_sk\" TypeMdid=\"0.23.1.0\"/>\n-                                                            </dxl:ProjElem>\n-                                                          </dxl:ProjList>\n-                                                          <dxl:Filter/>\n-                                                          <dxl:SortingColumnList/>\n-                                                          <dxl:TableScan>\n-                                                            <dxl:Properties>\n-                                                            <dxl:Cost StartupCost=\"0\" TotalCost=\"431.247306\" Rows=\"419.197655\" Width=\"4\"/>\n-                                                            </dxl:Properties>\n-                                                            <dxl:ProjList>\n-                                                            <dxl:ProjElem ColId=\"167\" Alias=\"d_date_sk\">\n-                                                            <dxl:Ident ColId=\"167\" ColName=\"d_date_sk\" TypeMdid=\"0.23.1.0\"/>\n-                                                            </dxl:ProjElem>\n-                                                            </dxl:ProjList>\n-                                                            <dxl:Filter>\n-                                                            <dxl:Comparison ComparisonOperator=\"=\" OperatorMdid=\"0.96.1.0\">\n-                                                            <dxl:Ident ColId=\"173\" ColName=\"d_year\" TypeMdid=\"0.23.1.0\"/>\n-                                                            <dxl:ConstValue TypeMdid=\"0.23.1.0\" IsNull=\"false\" IsByValue=\"true\" Value=\"2000\"/>\n-                                                            </dxl:Comparison>\n-                                                            </dxl:Filter>\n-                                                            <dxl:TableDescriptor Mdid=\"0.8402992.1.1\" TableName=\"date_dim\">\n-                                                            <dxl:Columns>\n-                                                            <dxl:Column ColId=\"167\" Attno=\"1\" ColName=\"d_date_sk\" TypeMdid=\"0.23.1.0\"/>\n-                                                            <dxl:Column ColId=\"168\" Attno=\"2\" ColName=\"d_date_id\" TypeMdid=\"0.1042.1.0\" ColWidth=\"16\"/>\n-                                                            <dxl:Column ColId=\"169\" Attno=\"3\" ColName=\"d_date\" TypeMdid=\"0.1","path":"data/dxl/minidump/Tpcds-NonPart-Q70a.mdp","position":null,"original_position":3296,"commit_id":"d7cdade929f7016f32648713fad9a8b5e0f84b45","original_commit_id":"d7cdade929f7016f32648713fad9a8b5e0f84b45","user":{"login":"dhanashreek89","id":18387095,"node_id":"MDQ6VXNlcjE4Mzg3MDk1","avatar_url":"https://avatars0.githubusercontent.com/u/18387095?v=4","gravatar_id":"","url":"https://api.github.com/users/dhanashreek89","html_url":"https://github.com/dhanashreek89","followers_url":"https://api.github.com/users/dhanashreek89/followers","following_url":"https://api.github.com/users/dhanashreek89/following{/other_user}","gists_url":"https://api.github.com/users/dhanashreek89/gists{/gist_id}","starred_url":"https://api.github.com/users/dhanashreek89/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dhanashreek89/subscriptions","organizations_url":"https://api.github.com/users/dhanashreek89/orgs","repos_url":"https://api.github.com/users/dhanashreek89/repos","events_url":"https://api.github.com/users/dhanashreek89/events{/privacy}","received_events_url":"https://api.github.com/users/dhanashreek89/received_events","type":"User","site_admin":false},"body":"is there plan change here or just the indentation diff ?","created_at":"2018-06-28T03:07:25Z","updated_at":"2018-06-28T03:07:25Z","html_url":"https://github.com/greenplum-db/gporca/pull/381#discussion_r198696883","pull_request_url":"https://api.github.com/repos/greenplum-db/gporca/pulls/381","author_association":"CONTRIBUTOR","_links":{"self":{"href":"https://api.github.com/repos/greenplum-db/gporca/pulls/comments/198696883"},"html":{"href":"https://github.com/greenplum-db/gporca/pull/381#discussion_r198696883"},"pull_request":{"href":"https://api.github.com/repos/greenplum-db/gporca/pulls/381"}}},"pull_request":{"url":"https://api.github.com/repos/greenplum-db/gporca/pulls/381","id":197891548,"node_id":"MDExOlB1bGxSZXF1ZXN0MTk3ODkxNTQ4","html_url":"https://github.com/greenplum-db/gporca/pull/381","diff_url":"https://github.com/greenplum-db/gporca/pull/381.diff","patch_url":"https://github.com/greenplum-db/gporca/pull/381.patch","issue_url":"https://api.github.com/repos/greenplum-db/gporca/issues/381","number":381,"state":"open","locked":false,"title":"Fixing crash while deriving relation properties for index apply alter…","user":{"login":"bhuvnesh2703","id":10293569,"node_id":"MDQ6VXNlcjEwMjkzNTY5","avatar_url":"https://avatars1.githubusercontent.com/u/10293569?v=4","gravatar_id":"","url":"https://api.github.com/users/bhuvnesh2703","html_url":"https://github.com/bhuvnesh2703","followers_url":"https://api.github.com/users/bhuvnesh2703/followers","following_url":"https://api.github.com/users/bhuvnesh2703/following{/other_user}","gists_url":"https://api.github.com/users/bhuvnesh2703/gists{/gist_id}","starred_url":"https://api.github.com/users/bhuvnesh2703/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bhuvnesh2703/subscriptions","organizations_url":"https://api.github.com/users/bhuvnesh2703/orgs","repos_url":"https://api.github.com/users/bhuvnesh2703/repos","events_url":"https://api.github.com/users/bhuvnesh2703/events{/privacy}","received_events_url":"https://api.github.com/users/bhuvnesh2703/received_events","type":"User","site_admin":false},"body":"…natives\r\n\r\nFor Xform `CXformInnerJoin2DynamicBitmapIndexGetApply`, the pattern of the input expression\r\nwas expected to be:\r\n```\r\n+--CLogicalInnerJoin\r\n|--CPatternLeaf\r\n|--CLogicalDynamicGet\r\n+--CPatternTree\r\n```\r\n\r\nConsider an input expression of the form\r\n```\r\n+--CLogicalInnerJoin\r\n|--CLogicalInnerJoin\r\n|  |--CLogicalGet\r\n|  |--CLogicalGet\r\n|  +--CScalarCmp\r\n|--CLogicalDynamicGet \"foo_prt\"\r\n+--CScalarCmp (=)   origin: [Grp:4, GrpExpr:0]\r\n```\r\n\r\nIn PexprExtract, given the input pattern, it extracts the below expression\r\n```\r\n+--CLogicalInnerJoin\r\n|--CLogicalInnerJoin    (1) --> We did not extract children of this join\r\n|--CLogicalDynamicGet\r\n+--CScalarCmp (=)\r\n   |--CScalarIdent\r\n   +--CScalarIdent\r\n```\r\n\r\nNotice that for CLogicalInnerJoin (1), the above tree does not contain\r\ninformation of the child. However, CXformInnerJoin2DynamicBitmapIndexGetApply\r\ncreates a CTE Producer expression (for partial indexes) and performs expression\r\npreprocessing.  During expression preprocessing, while deriving the relational\r\nproperties of the CLogicalInnerJoin (1), it expects the entire tree. But since\r\nits not extracted, it fails assertion in debug build or crashes in retail build\r\n\r\nSince, CTE expression must be preprocessed, the entire tree must exist, and\r\ninstead of CPatternLeaf, the expected pattern should be CPatternTree. This\r\ncommit fixes the issue by updating the expected pattern to CPatternTree.\r\n\r\nHowever, for deep trees, PexprExtract may extract lot of expressions and could\r\nincrease the optimization time of the queries.  So, the xform should only be\r\napplied once. This commit marks the\r\n`CXformInnerJoin2DynamicBitmapIndexGetApply` as apply once and all the derived\r\nxforms of the base class `CXformJoin2IndexApply` as apply once.\r\nAdditionally, it also refactors the code to handle such apply once expression\r\nby making it a xform property instead of util function.","created_at":"2018-06-28T01:03:38Z","updated_at":"2018-06-28T03:07:25Z","closed_at":null,"merged_at":null,"merge_commit_sha":"aa04e1213d08bf735542fa92d648c822567b531b","assignee":null,"assignees":[],"requested_reviewers":[],"requested_teams":[],"labels":[],"milestone":null,"commits_url":"https://api.github.com/repos/greenplum-db/gporca/pulls/381/commits","review_comments_url":"https://api.github.com/repos/greenplum-db/gporca/pulls/381/comments","review_comment_url":"https://api.github.com/repos/greenplum-db/gporca/pulls/comments{/number}","comments_url":"https://api.github.com/repos/greenplum-db/gporca/issues/381/comments","statuses_url":"https://api.github.com/repos/greenplum-db/gporca/statuses/d7cdade929f7016f32648713fad9a8b5e0f84b45","head":{"label":"khannaekta:update_indexapply_pattern","ref":"update_indexapply_pattern","sha":"d7cdade929f7016f32648713fad9a8b5e0f84b45","user":{"login":"khannaekta","id":15749573,"node_id":"MDQ6VXNlcjE1NzQ5NTcz","avatar_url":"https://avatars0.githubusercontent.com/u/15749573?v=4","gravatar_id":"","url":"https://api.github.com/users/khannaekta","html_url":"https://github.com/khannaekta","followers_url":"https://api.github.com/users/khannaekta/followers","following_url":"https://api.github.com/users/khannaekta/following{/other_user}","gists_url":"https://api.github.com/users/khannaekta/gists{/gist_id}","starred_url":"https://api.github.com/users/khannaekta/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/khannaekta/subscriptions","organizations_url":"https://api.github.com/users/khannaekta/orgs","repos_url":"https://api.github.com/users/khannaekta/repos","events_url":"https://api.github.com/users/khannaekta/events{/privacy}","received_events_url":"https://api.github.com/users/khannaekta/received_events","type":"User","site_admin":false},"repo":{"id":85625879,"node_id":"MDEwOlJlcG9zaXRvcnk4NTYyNTg3OQ==","name":"gporca","full_name":"khannaekta/gporca","owner":{"login":"khannaekta","id":15749573,"node_id":"MDQ6VXNlcjE1NzQ5NTcz","avatar_url":"https://avatars0.githubusercontent.com/u/15749573?v=4","gravatar_id":"","url":"https://api.github.com/users/khannaekta","html_url":"https://github.com/khannaekta","followers_url":"https://api.github.com/users/khannaekta/followers","following_url":"https://api.github.com/users/khannaekta/following{/other_user}","gists_url":"https://api.github.com/users/khannaekta/gists{/gist_id}","starred_url":"https://api.github.com/users/khannaekta/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/khannaekta/subscriptions","organizations_url":"https://api.github.com/users/khannaekta/orgs","repos_url":"https://api.github.com/users/khannaekta/repos","events_url":"https://api.github.com/users/khannaekta/events{/privacy}","received_events_url":"https://api.github.com/users/khannaekta/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/khannaekta/gporca","description":"A modular query optimizer for big data","fork":true,"url":"https://api.github.com/repos/khannaekta/gporca","forks_url":"https://api.github.com/repos/khannaekta/gporca/forks","keys_url":"https://api.github.com/repos/khannaekta/gporca/keys{/key_id}","collaborators_url":"https://api.github.com/repos/khannaekta/gporca/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/khannaekta/gporca/teams","hooks_url":"https://api.github.com/repos/khannaekta/gporca/hooks","issue_events_url":"https://api.github.com/repos/khannaekta/gporca/issues/events{/number}","events_url":"https://api.github.com/repos/khannaekta/gporca/events","assignees_url":"https://api.github.com/repos/khannaekta/gporca/assignees{/user}","branches_url":"https://api.github.com/repos/khannaekta/gporca/branches{/branch}","tags_url":"https://api.github.com/repos/khannaekta/gporca/tags","blobs_url":"https://api.github.com/repos/khannaekta/gporca/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/khannaekta/gporca/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/khannaekta/gporca/git/refs{/sha}","trees_url":"https://api.github.com/repos/khannaekta/gporca/git/trees{/sha}","statuses_url":"https://api.github.com/repos/khannaekta/gporca/statuses/{sha}","languages_url":"https://api.github.com/repos/khannaekta/gporca/languages","stargazers_url":"https://api.github.com/repos/khannaekta/gporca/stargazers","contributors_url":"https://api.github.com/repos/khannaekta/gporca/contributors","subscribers_url":"https://api.github.com/repos/khannaekta/gporca/subscribers","subscription_url":"https://api.github.com/repos/khannaekta/gporca/subscription","commits_url":"https://api.github.com/repos/khannaekta/gporca/commits{/sha}","git_commits_url":"https://api.github.com/repos/khannaekta/gporca/git/commits{/sha}","comments_url":"https://api.github.com/repos/khannaekta/gporca/comments{/number}","issue_comment_url":"https://api.github.com/repos/khannaekta/gporca/issues/comments{/number}","contents_url":"https://api.github.com/repos/khannaekta/gporca/contents/{+path}","compare_url":"https://api.github.com/repos/khannaekta/gporca/compare/{base}...{head}","merges_url":"https://api.github.com/repos/khannaekta/gporca/merges","archive_url":"https://api.github.com/repos/khannaekta/gporca/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/khannaekta/gporca/downloads","issues_url":"https://api.github.com/repos/khannaekta/gporca/issues{/number}","pulls_url":"https://api.github.com/repos/khannaekta/gporca/pulls{/number}","milestones_url":"https://api.github.com/repos/khannaekta/gporca/milestones{/number}","notifications_url":"https://api.github.com/repos/khannaekta/gporca/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/khannaekta/gporca/labels{/name}","releases_url":"https://api.github.com/repos/khannaekta/gporca/releases{/id}","deployments_url":"https://api.github.com/repos/khannaekta/gporca/deployments","created_at":"2017-03-20T20:51:00Z","updated_at":"2017-03-20T20:51:17Z","pushed_at":"2018-06-28T00:06:13Z","git_url":"git://github.com/khannaekta/gporca.git","ssh_url":"git@github.com:khannaekta/gporca.git","clone_url":"https://github.com/khannaekta/gporca.git","svn_url":"https://github.com/khannaekta/gporca","homepage":"","size":43089,"stargazers_count":0,"watchers_count":0,"language":"C++","has_issues":false,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"archived":false,"open_issues_count":0,"license":{"key":"other","name":"Other","spdx_id":null,"url":null,"node_id":"MDc6TGljZW5zZTA="},"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"greenplum-db:master","ref":"master","sha":"22e0442576c7e9c578a2a7d6182007ca045baedd","user":{"login":"greenplum-db","id":14097842,"node_id":"MDEyOk9yZ2FuaXphdGlvbjE0MDk3ODQy","avatar_url":"https://avatars2.githubusercontent.com/u/14097842?v=4","gravatar_id":"","url":"https://api.github.com/users/greenplum-db","html_url":"https://github.com/greenplum-db","followers_url":"https://api.github.com/users/greenplum-db/followers","following_url":"https://api.github.com/users/greenplum-db/following{/other_user}","gists_url":"https://api.github.com/users/greenplum-db/gists{/gist_id}","starred_url":"https://api.github.com/users/greenplum-db/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/greenplum-db/subscriptions","organizations_url":"https://api.github.com/users/greenplum-db/orgs","repos_url":"https://api.github.com/users/greenplum-db/repos","events_url":"https://api.github.com/users/greenplum-db/events{/privacy}","received_events_url":"https://api.github.com/users/greenplum-db/received_events","type":"Organization","site_admin":false},"repo":{"id":47849203,"node_id":"MDEwOlJlcG9zaXRvcnk0Nzg0OTIwMw==","name":"gporca","full_name":"greenplum-db/gporca","owner":{"login":"greenplum-db","id":14097842,"node_id":"MDEyOk9yZ2FuaXphdGlvbjE0MDk3ODQy","avatar_url":"https://avatars2.githubusercontent.com/u/14097842?v=4","gravatar_id":"","url":"https://api.github.com/users/greenplum-db","html_url":"https://github.com/greenplum-db","followers_url":"https://api.github.com/users/greenplum-db/followers","following_url":"https://api.github.com/users/greenplum-db/following{/other_user}","gists_url":"https://api.github.com/users/greenplum-db/gists{/gist_id}","starred_url":"https://api.github.com/users/greenplum-db/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/greenplum-db/subscriptions","organizations_url":"https://api.github.com/users/greenplum-db/orgs","repos_url":"https://api.github.com/users/greenplum-db/repos","events_url":"https://api.github.com/users/greenplum-db/events{/privacy}","received_events_url":"https://api.github.com/users/greenplum-db/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/greenplum-db/gporca","description":"A modular query optimizer for big data","fork":false,"url":"https://api.github.com/repos/greenplum-db/gporca","forks_url":"https://api.github.com/repos/greenplum-db/gporca/forks","keys_url":"https://api.github.com/repos/greenplum-db/gporca/keys{/key_id}","collaborators_url":"https://api.github.com/repos/greenplum-db/gporca/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/greenplum-db/gporca/teams","hooks_url":"https://api.github.com/repos/greenplum-db/gporca/hooks","issue_events_url":"https://api.github.com/repos/greenplum-db/gporca/issues/events{/number}","events_url":"https://api.github.com/repos/greenplum-db/gporca/events","assignees_url":"https://api.github.com/repos/greenplum-db/gporca/assignees{/user}","branches_url":"https://api.github.com/repos/greenplum-db/gporca/branches{/branch}","tags_url":"https://api.github.com/repos/greenplum-db/gporca/tags","blobs_url":"https://api.github.com/repos/greenplum-db/gporca/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/greenplum-db/gporca/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/greenplum-db/gporca/git/refs{/sha}","trees_url":"https://api.github.com/repos/greenplum-db/gporca/git/trees{/sha}","statuses_url":"https://api.github.com/repos/greenplum-db/gporca/statuses/{sha}","languages_url":"https://api.github.com/repos/greenplum-db/gporca/languages","stargazers_url":"https://api.github.com/repos/greenplum-db/gporca/stargazers","contributors_url":"https://api.github.com/repos/greenplum-db/gporca/contributors","subscribers_url":"https://api.github.com/repos/greenplum-db/gporca/subscribers","subscription_url":"https://api.github.com/repos/greenplum-db/gporca/subscription","commits_url":"https://api.github.com/repos/greenplum-db/gporca/commits{/sha}","git_commits_url":"https://api.github.com/repos/greenplum-db/gporca/git/commits{/sha}","comments_url":"https://api.github.com/repos/greenplum-db/gporca/comments{/number}","issue_comment_url":"https://api.github.com/repos/greenplum-db/gporca/issues/comments{/number}","contents_url":"https://api.github.com/repos/greenplum-db/gporca/contents/{+path}","compare_url":"https://api.github.com/repos/greenplum-db/gporca/compare/{base}...{head}","merges_url":"https://api.github.com/repos/greenplum-db/gporca/merges","archive_url":"https://api.github.com/repos/greenplum-db/gporca/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/greenplum-db/gporca/downloads","issues_url":"https://api.github.com/repos/greenplum-db/gporca/issues{/number}","pulls_url":"https://api.github.com/repos/greenplum-db/gporca/pulls{/number}","milestones_url":"https://api.github.com/repos/greenplum-db/gporca/milestones{/number}","notifications_url":"https://api.github.com/repos/greenplum-db/gporca/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/greenplum-db/gporca/labels{/name}","releases_url":"https://api.github.com/repos/greenplum-db/gporca/releases{/id}","deployments_url":"https://api.github.com/repos/greenplum-db/gporca/deployments","created_at":"2015-12-11T20:24:47Z","updated_at":"2018-06-24T09:06:11Z","pushed_at":"2018-06-28T01:03:39Z","git_url":"git://github.com/greenplum-db/gporca.git","ssh_url":"git@github.com:greenplum-db/gporca.git","clone_url":"https://github.com/greenplum-db/gporca.git","svn_url":"https://github.com/greenplum-db/gporca","homepage":"","size":42513,"stargazers_count":141,"watchers_count":141,"language":"C++","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":83,"mirror_url":null,"archived":false,"open_issues_count":26,"license":{"key":"other","name":"Other","spdx_id":null,"url":null,"node_id":"MDc6TGljZW5zZTA="},"forks":83,"open_issues":26,"watchers":141,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/greenplum-db/gporca/pulls/381"},"html":{"href":"https://github.com/greenplum-db/gporca/pull/381"},"issue":{"href":"https://api.github.com/repos/greenplum-db/gporca/issues/381"},"comments":{"href":"https://api.github.com/repos/greenplum-db/gporca/issues/381/comments"},"review_comments":{"href":"https://api.github.com/repos/greenplum-db/gporca/pulls/381/comments"},"review_comment":{"href":"https://api.github.com/repos/greenplum-db/gporca/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/greenplum-db/gporca/pulls/381/commits"},"statuses":{"href":"https://api.github.com/repos/greenplum-db/gporca/statuses/d7cdade929f7016f32648713fad9a8b5e0f84b45"}},"author_association":"MEMBER"}}
{"actor":{"display_login":"dhanashreek89"}}