mysql> set sql_mode = 'ONLY_FULL_GROUP_BY,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
Query OK, 0 rows affected (0.00 sec)
mysql> set tidb_enforce_mpp=on;set session tidb_max_tiflash_threads = 4;
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
mysql> set tiflash_query_spill_ratio=0.01;
Query OK, 0 rows affected (0.00 sec)
mysql> set tiflash_mem_quota_query_per_node=1000000000;
Query OK, 0 rows affected (0.00 sec)
mysql> SELECT
        o_custkey AS customer_id,
        o_orderpriority AS day_part,
        o_orderstatus AS be_type,
        l_partkey AS product_code,
        GROUP_CONCAT(DISTINCT l_shipmode) AS store_code,
        MAX(order_time) AS last_order_time,
        MAX(order_id) AS last_order_id
    FROM (
        SELECT
            o_custkey,
            o_orderpriority,
            o_orderstatus,
            l_partkey,
            l_shipmode,
            l_orderkey AS order_id,
            o_orderdate AS order_time
        FROM lineitem
        LEFT JOIN orders ON l_orderkey = o_orderkey
    ) order_detail
    GROUP BY customer_id, day_part, be_type, product_code;