Marcel Weisgut

TPC-DS queries contain multiple, not nested INTERSECT operations. Example: TPC-DS query 38, netezza dialect: ```sql select count(*) from ( select distinct c_last_name, c_first_name, d_date from store_sales, date_dim, customer where store_sales.ss_sold_date_sk...

TPC-DS queries contain multiple, not nested UNION operations. Example: TPC-DS query 71, netezza dialect: ```sql select i_brand_id brand_id, i_brand brand,t_hour,t_minute, sum(ext_price) ext_price from item, (select ws_ext_sales_price as ext_price, ws_sold_date_sk as...

TPC-DS queries contain the OVER() clause. Using this clause, PARTITION BY is often used additionally. Example: TPC-DS query 12, natezza dialect: ```sql select i_item_id ,i_item_desc ,i_category ,i_class ,i_current_price ,sum(ws_ext_sales_price) as...

After merging #2448, chunk indexes are to be removed. This also requires: - [x] adapting the index scan to utilize partial hash indexes (#2553) - [ ] adapting the index...

Re-Evaluate Hash Maps

1

We use different hash maps, e.g., `tsl::robin_map` for the histogram and hash-based aggregate, the `ska::bytell_hash_map` for the hash join, and potentially another hash map introduced with #2448 for the partial...

In `src/plugins/CMakeLists.txt`, we can pass source files and libraries as SRCS and DEPS, respectively, to the `add_plugin` function. https://github.com/hyrise/hyrise/blob/78446e051474eb82b8d7ec1782a9c063966624b4/src/plugins/CMakeLists.txt#L1-L38 However, the function lacks a parameter to pass libraries that are...