embucket-labs icon indicating copy to clipboard operation
embucket-labs copied to clipboard

[BUG] Function 'replace' expects 3 arguments but received 2

Open osipovartem opened this issue 6 months ago • 0 comments

Valid dbt sql

SELECT DISTINCT
      REPLACE('test-'::VARCHAR, '-')

Query execution error: Query execution error: DataFusion error: Error during planning: Function 'replace' expects 3 arguments but received 2 No function matches the given name and argument types 'replace(Utf8, Utf8)'. You might need to add explicit type casts. Candidate functions: replace(Coercion(TypeSignatureClass::Native(LogicalType(Native(String), String))), Coercion(TypeSignatureClass::Native(LogicalType(Native(String), String))), Coercion(TypeSignatureClass::Native(LogicalType(Native(String), String)))) 0: <transparent> 1: Query execution error: Query execution error: DataFusion error: Error during planning: Function 'replace' expects 3 arguments but received 2 No function matches the given name and argument types 'replace(Utf8, Utf8)'. You might need to add explicit type casts. Candidate functions: replace(Coercion(TypeSignatureClass::Native(LogicalType(Native(String), String))), Coercion(TypeSignatureClass::Native(LogicalType(Native(String), String))), Coercion(TypeSignatureClass::Native(LogicalType(Native(String), String)))), at crates/api-ui/src/queries/handlers.rs:118:10 2: Query execution error: DataFusion error: Error during planning: Function 'replace' expects 3 arguments but received 2 No function matches the given name and argument types 'replace(Utf8, Utf8)'. You might need to add explicit type casts. Candidate functions: replace(Coercion(TypeSignatureClass::Native(LogicalType(Native(String), String))), Coercion(TypeSignatureClass::Native(LogicalType(Native(String), String))), Coercion(TypeSignatureClass::Native(LogicalType(Native(String), String)))), at crates/api-ui/src/queries/handlers.rs:117:10 3: DataFusion error: Error during planning: Function 'replace' expects 3 arguments but received 2 No function matches the given name and argument types 'replace(Utf8, Utf8)'. You might need to add explicit type casts. Candidate functions: replace(Coercion(TypeSignatureClass::Native(LogicalType(Native(String), String))), Coercion(TypeSignatureClass::Native(LogicalType(Native(String), String))), Coercion(TypeSignatureClass::Native(LogicalType(Native(String), String)))), at crates/core-executor/src/query.rs:1333:14 4: Plan("Function 'replace' expects 3 arguments but received 2 No function matches the given name and argument types 'replace(Utf8, Utf8)'. You might need to add explicit type casts.\n\tCandidate functions:\n\treplace(Coercion(TypeSignatureClass::Native(LogicalType(Native(String), String))), Coercion(TypeSignatureClass::Native(LogicalType(Native(String), String))), Coercion(TypeSignatureClass::Native(LogicalType(Native(String), String))))")

osipovartem avatar Jun 19 '25 10:06 osipovartem