Tasks needing completion to be able to run TPC-H queries

[thisisnic]

In order to be able to run the TPC-H queries (R versions here), the following tasks need to be completed:

Function bindings

• Implement n() function (DuckDB) #143
• Implement n() function (Arrow) #219
• Implement binding for mean() #218
• Implement head() SubstraitCompiler objects #203
• Implement bindings to grepl() #193 (specifically grepl)
• Implement bindings to lubridate::year() #204 (specifically lubridate::year())
• Implement bindings to Substrait rounding functions #191
• Implement if_else() #156
• Implement sum() function for ArrowSubstraitCompiler #221
• Implement min() and max() #148
• Implement %in% (Arrow) #74
• Implement logical comparison functions #222
• Implement is.na() (Arrow) #93
• Add bindings to basic maths functions #237 (specifically abs)
• Implement n_distinct() #145
• Implement substr (DuckDB) #256
• Implement substr (Arrow)  #258 (no binding in Acero yet)
• Implement n_distinct() for the Arrow Substrait compiler #245 (no binding in Acero yet)

Verb bindings

• Implement dplyr::inner_join() #23
• Implement dplyr::left_join() #22
• Implement dplyr::anti_join() #27
• Implement dplyr::semi_join() #207
• Implement dplyr::distinct() #206
• Implement dplyr::count() #257

Data types

• Implement date type #124

Other

• Add additional extension URI to Arrow Substrait Compiler #202
• Complex expressions in summarise() body not supported #155
• Error when using summarise() with literal values #153
• [R] summarise() returns incorrect results when there are >1 fields to return (Arrow) #252

[thisisnic]

TPCH-1:

• Add additional extension URI to Arrow Substrait Compiler #202
• Implement date type #124
• Implement binding for mean() #218
• Implement n() function (DuckDB) #143
• Implement n() function (Arrow) #219
• Complex expressions in summarise() body not supported #155
• Implement sum() function for ArrowSubstraitCompiler #221

TPCH-2:

• Implement bindings to grepl() #193
• Implement dplyr::inner_join() #23
• Implement min() and max() #148
• Implement head() SubstraitCompiler objects #203

TPCH-3:

• Implement dplyr::inner_join() #23
• Implement date type #124
• Implement head() SubstraitCompiler objects #203

TPC-H 4:

• Implement date type #124
• Implement dplyr::inner_join() #23
• Implement n() function (Arrow) #219

TPC-H 5:

• Implement dplyr::inner_join() #23
• Implement sum() function for ArrowSubstraitCompiler #221

TPC-H 6:

• Implement date type #124
• Implement bindings to Substrait rounding functions #191
• Implement sum() function for ArrowSubstraitCompiler #221

TPC-H 7:

• Implement dplyr::inner_join() #23
• Implement %in% (Arrow) #74
• Implement date type #124
• Implement logical comparison functions #222
• Implement bindings to lubridate::year() #204
• Implement sum() function for ArrowSubstraitCompiler #221

TPC-H 8:

• Implement dplyr::inner_join() #23
• Implement logical comparison functions #222
• Implement date type #124
• Implement sum() function for ArrowSubstraitCompiler #221
• Implement if_else() #156

TPC-H 9:

• Implement bindings to grepl() #193
• Implement dplyr::inner_join() #23
• Implement sum() function for ArrowSubstraitCompiler #221

TPC-H 10:

• Implement logical comparison functions #222
• Implement date type #124
• Implement dplyr::inner_join() #23
• Implement sum() function for ArrowSubstraitCompiler #221
• Implement head() SubstraitCompiler objects #203

TPC-H 11:

• Implement logical comparison functions #222
• Implement dplyr::inner_join() #23
• Implement sum() function for ArrowSubstraitCompiler #221

TPC-H 12:

• Implement %in% (Arrow) #74
• Implement sum() function for ArrowSubstraitCompiler #221
• Implement if_else() #156
• Implement dplyr::inner_join() #23

TPC-H 13:

• Implement dplyr::left_join() #22
• Implement bindings to grepl() #193
• Implement sum() function for ArrowSubstraitCompiler #221
• Implement is.na() (Arrow) #93
• Implement n() function (Arrow) #219

TPC-H 14:

• Implement date type #124
• Implement dplyr::inner_join() #23
• Implement sum() function for ArrowSubstraitCompiler #221
• Implement if_else() #156

TPC-H 15:

• Implement date type #124
• Implement sum() function for ArrowSubstraitCompiler #221
• Implement min() and max() #148
• Implement dplyr::inner_join() #23
• Add bindings to basic maths functions #237

TPC-H 16:

• Implement bindings to grepl() #193
• Implement logical comparison functions #222
• Implement %in% (Arrow) #74
• Implement n_distinct() #145
• Implement dplyr::inner_join() #23

TPC-H 17:

• Implement logical comparison functions #222
• Implement binding for mean() #218
• Implement dplyr::inner_join() #23
• Implement sum() function for ArrowSubstraitCompiler #221

TPC-H 18:

• Implement sum() function for ArrowSubstraitCompiler #221
• Implement dplyr::inner_join() #23
• Implement head() SubstraitCompiler objects #203

TPC-H 19:

• Implement dplyr::inner_join() #23
• Implement logical comparison functions #222
• Implement %in% (Arrow) #74
• Implement sum() function for ArrowSubstraitCompiler #221

TPC-H 20:

• Implement dplyr::inner_join() #23
• Implement bindings to grepl() #193
• Implement dplyr::semi_join() #207
• Implement date type #124
• Implement sum() function for ArrowSubstraitCompiler #221

TPC-H 21:

• Implement n() function (Arrow) #219
• Implement dplyr::semi_join() #207
• Implement dplyr::inner_join() #23
• Implement logical comparison functions #222
• Implement sum() function for ArrowSubstraitCompiler #221
• Implement if_else() #156
• Implement head() SubstraitCompiler objects #203

TPC-H 22:

• Implement %in% (Arrow) #74
• Implement binding for mean() #218
• Implement bindings to grepl() #193 (substr)
• Implement dplyr::anti_join() #27
• Implement n() function (Arrow) #219

[thisisnic]

In the order of number of queries requiring those tickets to be completed:

• Implement sum() function for ArrowSubstraitCompiler #221 | 17
• Implement dplyr::inner_join() #23 | 17
• Implement date type #124 | 10
• Implement logical comparison functions #222 | 8
• Implement bindings to grepl() #193 | 5
• Implement head() SubstraitCompiler objects #203 | 5
• Implement n() function (Arrow) #219 | 5
• Implement %in% (Arrow) #74 | 5
• Implement if_else() #156 | 4
• Implement binding for mean() #218 | 3
• Implement min() and max() #148 | 2
• Implement dplyr::semi_join() #207 | 2
• Implement n() function (DuckDB) #143 | 1
• Implement n_distinct() #145 | 1
• Add bindings to basic maths functions #237 | 1
• Implement bindings to Substrait rounding functions #191 | 1
• Implement bindings to grepl() #193 (substr) | 1
• Implement bindings to lubridate::year() #204 | 1
• Implement dplyr::left_join() #22 | 1
• Implement dplyr::anti_join() #27 | 1
• Implement is.na() (Arrow) #93 | 1