Skip to content

NativeCte tests fail with unknown functions #26827

@czentgr

Description

@czentgr

TestPrestoNativeCteExecutionParquetSingleNode and TestPrestoNativeCteExecutionParquetDistributed fail with

Error:  Failures: 
Error:    TestPrestoNativeCteExecutionParquetDistributed>AbstractTestCteExecution.testCustomerOrderPatternAnalysis:657->AbstractTestCteExecution.verifyResults:1230->AbstractTestCteExecution.verifyResults:1237 ? Runtime  Scalar function name not registered: presto.default.$operator$hash_code, called with arguments: (BIGINT).
Error:    TestPrestoNativeCteExecutionParquetSingleNode>AbstractTestCteExecution.testComplexCommonFilterPushdown:177->AbstractTestCteExecution.verifyResults:1237 ? Runtime Sampling function: key_sampling_percent not cannot be resolved

This first function not found occurs if

optimizer.optimize-hash-generation

is set to true (default) in the coordinator. This should be set in the coordinator for the native runner.
The original PR seems to have had a green CI but now fails consistently.

Job log: https://github.com/prestodb/presto/actions/runs/20322083232/job/58380434784

I suspect PR #26794 to play a role because things started to fail afterwards but it might be a red herring. Velox code was updated two days prior. If this causes the issue then the PR was not rebased to the latest prior to the last CI run.

Your Environment

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

Expected Behavior

Current Behavior

Possible Solution

Steps to Reproduce

Screenshots (if appropriate)

Context

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

Status

🆕 Unprioritized

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions