Skip to content

daft.md

Latest commit

 

History

History
109 lines (89 loc) · 10.5 KB

daft.md

File metadata and controls

109 lines (89 loc) · 10.5 KB

Daft Benchmark Report

Auto-generated by the LakeBench integration test suite.
Last updated: 2026-02-25 00:35:03 UTC

TPC-H

⚠️ 21/22 queries passed (95.5%)

Failed queries

Querie Error
q21 DaftCoreException: DaftError::InternalError Outer reference columns cannot be bound: col(l1.l_suppkey)

TPC-DS

⚠️ 46/103 queries passed (44.7%)

Failed queries

Querie Error
q2 InvalidSQLException: Daft error: DaftError::External Unable to create logical plan node. Due to: DaftError::TypeError Cannot infer supertypes for divide on types: Decimal[precision: 38, scale: 2], Decimal[precision: 38, scale: 2] result precision: 77 exceed bounds of [1, 38]. scale: 41
q4 InvalidSQLException: Daft error: DaftError::External Unable to create logical plan node. Due to: DaftError::TypeError Cannot infer supertypes for divide on types: Decimal[precision: 38, scale: 13], Decimal[precision: 38, scale: 13] result precision: 77 exceed bounds of [1, 38]. scale: 52
q5 InvalidSQLException: Unsupported SQL: 'Function date_add not found'
q10 DaftCoreException: DaftError::ComputeError EXISTS should be optimized away before evaluation. This indicates a bug in the query optimizer.
q11 InvalidSQLException: Daft error: DaftError::External Unable to create logical plan node. Due to: DaftError::TypeError Cannot infer supertypes for divide on types: Decimal[precision: 38, scale: 2], Decimal[precision: 38, scale: 2] result precision: 77 exceed bounds of [1, 38]. scale: 41
q12 InvalidSQLException: Unsupported SQL: 'Function date_add not found'
q13 InvalidSQLException: Daft error: DaftError::External Unable to create logical plan node. Due to: DaftError::AmbiguousReference Column name "ss_ext_wholesale_cost" is ambiguous in schema: [Field { name: "ss_ext_wholesale_cost", dtype: Decimal128(38, 2), metadata: {} }, Field { name: "ss_ext_wholesale
q14a InvalidSQLException: Daft error: DaftError::External Unable to create logical plan node. Due to: DaftError::TypeError Cannot perform comparison on types: Decimal[precision: 38, scale: 2], Decimal[precision: 38, scale: 6] Details: DaftError::TypeError Cannot infer supertypes for comparison on types:
q14b InvalidSQLException: Daft error: DaftError::External Unable to create logical plan node. Due to: DaftError::TypeError Cannot perform comparison on types: Decimal[precision: 38, scale: 2], Decimal[precision: 38, scale: 6] Details: DaftError::TypeError Cannot infer supertypes for comparison on types:
q16 InvalidSQLException: Unsupported SQL: 'Function date_add not found'
q20 InvalidSQLException: Unsupported SQL: 'Function date_add not found'
q21 InvalidSQLException: Unsupported SQL: 'Function date_add not found'
q22 InvalidSQLException: Unsupported SQL: 'data type: Signed'
q27 InvalidSQLException: Unsupported SQL: 'Function grouping not found'
q28 InvalidSQLException: Unsupported SQL: 'Unsupported join type: CrossJoin(None)'
q31 InvalidSQLException: Daft error: DaftError::External Unable to create logical plan node. Due to: DaftError::TypeError Cannot infer supertypes for divide on types: Decimal[precision: 38, scale: 2], Decimal[precision: 38, scale: 2] result precision: 77 exceed bounds of [1, 38]. scale: 41
q32 InvalidSQLException: Unsupported SQL: 'Function date_add not found'
q35 InvalidSQLException: Daft error: DaftError::External Unable to create logical plan node. Due to: DaftError::AmbiguousReference Column name "cd_dep_count" is ambiguous in schema: [Field { name: "ca_state", dtype: Utf8, metadata: {} }, Field { name: "cd_gender", dtype: Utf8, metadata: {} }, Field { na
q36 InvalidSQLException: Unsupported SQL: 'Function grouping not found'
q37 InvalidSQLException: Unsupported SQL: 'Function date_add not found'
q39a InvalidSQLException: Unsupported SQL: 'CASE with operand not yet supported'
q39b InvalidSQLException: Unsupported SQL: 'CASE with operand not yet supported'
q40 InvalidSQLException: Unsupported SQL: 'Function date_add not found'
q41 DaftCoreException: DaftError::InternalError Outer reference columns cannot be bound: col(i1.i_manufact)
q45 DaftCoreException: DaftError::ComputeError IN should be optimized away before evaluation. This indicates a bug in the query optimizer.
q47 InvalidSQLException: Daft error: DaftError::ValueError Plan must not have duplicate aliases in the same scope, found: v1
q49 DaftCoreException: DaftError::External Unable to create logical plan node. Due to: DaftError::TypeError could not determine supertype of Decimal128(7, 2) and Int64
q51 DaftCoreException: DaftError::InternalError Outer reference columns cannot be bound: col(ws_sales_price)
q53 InvalidSQLException: Daft error: DaftError::External Unable to create logical plan node. Due to: DaftError::TypeError Cannot infer supertypes for subtraction on types: Decimal[precision: 38, scale: 2], Decimal[precision: 38, scale: 6] result precision: 43 exceed bounds of [1, 38]
q54 InvalidSQLException: Unsupported SQL: 'data type: Signed'
q57 InvalidSQLException: Daft error: DaftError::ValueError Plan must not have duplicate aliases in the same scope, found: v1
q58 InvalidSQLException: Daft error: DaftError::External Unable to create logical plan node. Due to: DaftError::TypeError Cannot infer supertypes for addition on types: Decimal[precision: 38, scale: 2], Decimal[precision: 38, scale: 2] result precision: 39 exceed bounds of [1, 38]
q59 InvalidSQLException: Daft error: DaftError::External Unable to create logical plan node. Due to: DaftError::TypeError Cannot infer supertypes for divide on types: Decimal[precision: 38, scale: 2], Decimal[precision: 38, scale: 2] result precision: 77 exceed bounds of [1, 38]. scale: 41
q61 InvalidSQLException: Unsupported SQL: 'Unsupported join type: CrossJoin(None)'
q63 InvalidSQLException: Daft error: DaftError::External Unable to create logical plan node. Due to: DaftError::TypeError Cannot infer supertypes for subtraction on types: Decimal[precision: 38, scale: 2], Decimal[precision: 38, scale: 6] result precision: 43 exceed bounds of [1, 38]
q64 InvalidSQLException: Daft error: DaftError::External Unable to create logical plan node. Due to: DaftError::TypeError Cannot infer supertypes for multiply on types: Decimal[precision: 20, scale: 0], Decimal[precision: 38, scale: 2] result precision: 58 exceed bounds of [1, 38]
q65 DaftCoreException: Not Yet Implemented: Execution of non-equality join
q66 InvalidSQLException: Daft error: DaftError::External Unable to create logical plan node. Due to: DaftError::TypeError Expected if_true and if_false arguments for if_else to be castable to the same supertype, but received ws_ext_sales_price#Decimal[precision: 27, scale: 2] and literal#Int64
q67 InvalidSQLException: Daft error: DaftError::External Unable to create logical plan node. Due to: DaftError::TypeError could not determine supertype of Decimal128(27, 2) and Int64
q70 InvalidSQLException: Unsupported SQL: 'Function grouping not found'
q72 InvalidSQLException: Unsupported SQL: 'Function date_add not found'
q74 InvalidSQLException: Daft error: DaftError::External Unable to create logical plan node. Due to: DaftError::TypeError Cannot infer supertypes for divide on types: Decimal[precision: 38, scale: 6], Decimal[precision: 38, scale: 6] result precision: 77 exceed bounds of [1, 38]. scale: 45
q75 InvalidSQLException: Daft error: DaftError::External Unable to create logical plan node. Due to: DaftError::TypeError could not determine supertype of Decimal128(7, 2) and Float64
q77 InvalidSQLException: Unsupported SQL: 'Function date_add not found'
q78 InvalidSQLException: Daft error: DaftError::External Unable to create logical plan node. Due to: DaftError::TypeError could not determine supertype of Decimal128(38, 2) and Int64
q80 InvalidSQLException: Unsupported SQL: 'Function date_add not found'
q82 InvalidSQLException: Unsupported SQL: 'Function date_add not found'
q86 InvalidSQLException: Unsupported SQL: 'Function grouping not found'
q87 InvalidSQLException: Unsupported SQL: 'Subqueries are not supported'
q88 InvalidSQLException: Unsupported SQL: 'Unsupported join type: CrossJoin(None)'
q89 InvalidSQLException: Daft error: DaftError::External Unable to create logical plan node. Due to: DaftError::TypeError Cannot infer supertypes for subtraction on types: Decimal[precision: 38, scale: 2], Decimal[precision: 38, scale: 6] result precision: 43 exceed bounds of [1, 38]
q90 InvalidSQLException: Unsupported SQL: 'Unsupported join type: CrossJoin(None)'
q92 InvalidSQLException: Unsupported SQL: 'Function date_add not found'
q94 InvalidSQLException: Unsupported SQL: 'Function date_add not found'
q95 InvalidSQLException: Unsupported SQL: 'Function date_add not found'
q97 InvalidSQLException: Table not found: ssci
q98 InvalidSQLException: Unsupported SQL: 'Function date_add not found'

ClickBench

⚠️ 37/43 queries passed (86.0%)

Failed queries

Querie Error
q7 InvalidSQLException: Daft error: DaftError::External Unable to create logical plan node. Due to: DaftError::AmbiguousReference Column name "EventDate" is ambiguous in schema: [Field { name: "EventDate", dtype: Date, metadata: {} }, Field { name: "EventDate", dtype: Date, metadata: {} }]
q28 InvalidSQLException: Unsupported SQL: 'Function char_length not found'
q29 InvalidSQLException: Unsupported SQL: 'Function char_length not found'
q30 InvalidSQLException: Daft error: DaftError::External Unable to create logical plan node. Due to: DaftError::AmbiguousReference Column name "ResolutionWidth" is ambiguous in schema: [Field { name: "ResolutionWidth", dtype: Int64, metadata: {} }, Field { name: "ResolutionWidth", dtype: Int64, metadata
q36 InvalidSQLException: Daft error: DaftError::External Unable to create logical plan node. Due to: DaftError::AmbiguousReference Column name "ClientIP" is ambiguous in schema: [Field { name: "ClientIP", dtype: Int32, metadata: {} }, Field { name: "ClientIP", dtype: Int64, metadata: {} }, Field { name:
q43 InvalidSQLException: Unsupported SQL: 'Function date_add not found'

ELTBench

✅ 12/12 tasks passed (100.0%)