TakeOrderedAndProject
+- HashAggregate
   +- Exchange
      +- HashAggregate
         +- Expand
            +- Project
               +-  BroadcastNestedLoopJoin [COMET: BroadcastNestedLoopJoin is not supported]
                  :- CometNativeColumnarToRow
                  :  +- CometProject
                  :     +- CometBroadcastHashJoin
                  :        :- CometProject
                  :        :  +- CometBroadcastHashJoin
                  :        :     :- CometFilter
                  :        :     :  +- CometScan [native_iceberg_compat] parquet spark_catalog.default.inventory
                  :        :     :        +- SubqueryBroadcast
                  :        :     :           +- BroadcastExchange
                  :        :     :              +- CometNativeColumnarToRow
                  :        :     :                 +- CometProject
                  :        :     :                    +- CometFilter
                  :        :     :                       +- CometScan [native_iceberg_compat] parquet spark_catalog.default.date_dim
                  :        :     +- CometBroadcastExchange
                  :        :        +- CometProject
                  :        :           +- CometFilter
                  :        :              +- CometScan [native_iceberg_compat] parquet spark_catalog.default.date_dim
                  :        +- CometBroadcastExchange
                  :           +- CometProject
                  :              +- CometFilter
                  :                 +- CometScan [native_iceberg_compat] parquet spark_catalog.default.item
                  +- BroadcastExchange
                     +- CometNativeColumnarToRow
                        +- CometScan [native_iceberg_compat] parquet spark_catalog.default.warehouse

Comet accelerated 18 out of 28 eligible operators (64%). Final plan contains 3 transitions between Spark and Comet.