[native] GROUP BY queries fail when session property prefilter_for_groupby_limit is enabled

[pramodsatya]

When session property prefilter_for_groupby_limit is enabled in Prestissimo, the following query with GROUP BY fails:

presto:tpch> select count(custkey), orderkey from orders where orderstatus='F' and orderkey < 50 group by orderkey limit 100;

Query 20250121_201500_00004_d38dh failed:  Scalar function name not registered: presto.default.$operator$hash_code, called with arguments: (BIGINT).

Your Environment

• Presto version used: Latest
• Storage (HDFS/S3/GCS..):
• Data source and connector used:
• Deployment (Cloud or On-prem):
• Pastebin link to the complete debug logs:

Expected Behavior

presto:tpch> set session prefilter_for_groupby_limit=false;
SET SESSION
presto:tpch> select count(custkey), orderkey from orders where orderstatus='F' and orderkey < 50 group by orderkey limit 100;
 _col0 | orderkey
-------+----------
     1 |        6
     1 |        3
(2 rows)

Current Behavior

presto:tpch> set session prefilter_for_groupby_limit=true;
SET SESSION
presto:tpch> set session optimize_hash_generation=false;
SET SESSION
presto:tpch> select count(custkey), orderkey from orders where orderstatus='F' and orderkey < 50 group by orderkey limit 100;


WARNING: Sampled the following columns/derived columns at 1.0 percent:
	orderkey from HiveTableHandle{schemaName=tpch, tableName=orders, analyzePartitionValues=Optional.empty}


Query 20250121_201500_00004_d38dh, FAILED, 1 node
Splits: 1 total, 0 done (0.00%)
[Latency: client-side: 0:01, server-side: 0:01] [0 rows, 0B] [0 rows/s, 0B/s]

Query 20250121_201500_00004_d38dh failed:  Scalar function name not registered: presto.default.$operator$hash_code, called with arguments: (BIGINT).