TakeOrderedAndProject
+- Project
   +-  Window [COMET: WindowExec is not fully compatible with Spark (Native WindowExec has known correctness issues). To enable it anyway, set spark.comet.operator.WindowExec.allowIncompatible=true. For more information, refer to the Comet Compatibility Guide (https://datafusion.apache.org/comet/user-guide/compatibility.html).]
      +- CometNativeColumnarToRow
         +- CometSort
            +- CometColumnarExchange
               +- HashAggregate
                  +- Exchange
                     +- HashAggregate
                        +- Expand
                           +- Project
                              +- BroadcastHashJoin
                                 :- CometNativeColumnarToRow
                                 :  +- CometProject
                                 :     +- CometBroadcastHashJoin
                                 :        :- CometFilter
                                 :        :  +- CometNativeScan parquet spark_catalog.default.store_sales
                                 :        :        +- CometSubqueryBroadcast
                                 :        :           +- CometBroadcastExchange
                                 :        :              +- CometProject
                                 :        :                 +- CometFilter
                                 :        :                    +- CometNativeScan parquet spark_catalog.default.date_dim
                                 :        +- CometBroadcastExchange
                                 :           +- CometProject
                                 :              +- CometFilter
                                 :                 +- CometNativeScan parquet spark_catalog.default.date_dim
                                 +- BroadcastExchange
                                    +- Project
                                       +- BroadcastHashJoin
                                          :- CometNativeColumnarToRow
                                          :  +- CometFilter
                                          :     +- CometNativeScan parquet spark_catalog.default.store
                                          +- BroadcastExchange
                                             +- Project
                                                +- Filter
                                                   +-  Window [COMET: WindowExec is not fully compatible with Spark (Native WindowExec has known correctness issues). To enable it anyway, set spark.comet.operator.WindowExec.allowIncompatible=true. For more information, refer to the Comet Compatibility Guide (https://datafusion.apache.org/comet/user-guide/compatibility.html).]
                                                      +- CometNativeColumnarToRow
                                                         +- CometSort
                                                            +- CometHashAggregate
                                                               +- CometExchange
                                                                  +- CometHashAggregate
                                                                     +- CometProject
                                                                        +- CometBroadcastHashJoin
                                                                           :- CometProject
                                                                           :  +- CometBroadcastHashJoin
                                                                           :     :- CometFilter
                                                                           :     :  +- CometNativeScan parquet spark_catalog.default.store_sales
                                                                           :     :        +- ReusedSubquery
                                                                           :     +- CometBroadcastExchange
                                                                           :        +- CometProject
                                                                           :           +- CometFilter
                                                                           :              +- CometNativeScan parquet spark_catalog.default.store
                                                                           +- CometBroadcastExchange
                                                                              +- CometProject
                                                                                 +- CometFilter
                                                                                    +- CometNativeScan parquet spark_catalog.default.date_dim

Comet accelerated 34 out of 52 eligible operators (65%). Final plan contains 4 transitions between Spark and Comet.